毕业设计(论文)
txtName.Text = \ txtPwd.Text = \ }
#region 登录
private void button1_Click(object sender, EventArgs e) {
lblMessage.Text = \
string name = txtName.Text.Trim(); string pwd = txtPwd.Text.Trim();
DataTable dt = App_Code.DB.getDataTable(\* from manager where managername='\+ name + \and managerpwd='\+ pwd + \and grade=\+ ddlGrade.SelectedValue);
if (dt.Rows.Count > 0) {
//true
managename = name;
Main main = new Main(int.Parse(ddlGrade.SelectedValue.ToString()), name);
main.Show(); this.Hide(); } else {
//false
lblMessage.Text = \帐号或密码错误.\ } }
#endregion
5.3.2 用户信息管理
截图与部分代码:
26
毕业设计(论文)
//=========================== DataTable dt = new DataTable(); dt.Columns.Add(\dt.Columns.Add(\DataRow dr = dt.NewRow();
dr[\管理员\dr = dt.NewRow();
dr[\普通用户\ddlGrade.ValueMember = \
ddlGrade.DisplayMember = \ddlGrade.DataSource = dt; UserName = _username; id = _id;
if (mylist != null) infolist = mylist;
this.Text = \用户信息管理\
this.btnSubmit.Text = \保存信息\
DataTable dtinfo = App_Code.DB.getDataTable(\* from Manager where Managerid=\+ id);
if (dtinfo.Rows.Count > 0) {
txtName.ReadOnly = true;
txtName.Text = dtinfo.Rows[0][\txtPwd.Text = dtinfo.Rows[0][\txtTel.Text = dtinfo.Rows[0][\
txtAddress.Text = dtinfo.Rows[0][\
ddlGrade.SelectedValue = dtinfo.Rows[0][\
27
毕业设计(论文)
}
5.3.3 车辆信息管理
截图与部分代码:
DataTable dt = App_Code.DB.getDataTable(\if (dt.Rows.Count > 0) {
this.Text = \车辆登记\infoid = id;
kehuname.Text = dt.Rows[0][\qichename.Text = dt.Rows[0][\pinpai.Text = dt.Rows[0][\xinghao.Text = dt.Rows[0][\yanse.Text = dt.Rows[0][\
if (!string.IsNullOrEmpty(dt.Rows[0][\riqi.Value = Convert.ToDateTime(dt.Rows[0][\jiage.Text = dt.Rows[0][\state.Text = dt.Rows[0][\} else {
this.Text = \车辆登记\state.Text = \闲置\} }
28
毕业设计(论文)
///
///
///
private void btnSubmit_Click(object sender, EventArgs e) {
if (string.IsNullOrEmpty(qichename.Text.Trim())) {
qichename.Focus();
MessageBox.Show(\请输入车牌号!\提示\return; }
if (string.IsNullOrEmpty(kehuname.Text.Trim())) {
kehuname.Focus();
MessageBox.Show(\请输入负责人!\提示\return; }
5.3.4 车辆费用管理
截图与部分代码:
qichename.DataSource = App_Code.DB.getDataTable(\qichename.DisplayMember = \qichename.ValueMember = \
29
毕业设计(论文)
if (mylist != null) infolist = mylist; DataTable dt = App_Code.DB.getDataTable(\* from jiayou where jiayouid=\+ id); if (dt.Rows.Count > 0) {
this.Text = \加油登记\infoid = id;
qichename.Text = dt.Rows[0][\xingming.Text = dt.Rows[0][\price.Text = dt.Rows[0][\address.Text = dt.Rows[0][\liang.Text = dt.Rows[0][\total.Text = dt.Rows[0][\} else {
this.Text = \加油登记\
qichename.SelectedIndex = 0; getxingming(); } }
///
///
///
private void btnSubmit_Click(object sender, EventArgs e) {
if (string.IsNullOrEmpty(xingming.Text.Trim())) {
xingming.Focus();
MessageBox.Show(\请输入负责人!\提示\return; }
if (string.IsNullOrEmpty(price.Text.Trim())) {
price.Focus();
MessageBox.Show(\请输入油价!\提示\return; }
if (string.IsNullOrEmpty(liang.Text.Trim())) {
liang.Focus();
MessageBox.Show(\请输入加油量!\提示\
30