//**************************************************************************************************** //员工登录 private void btnLogin_Click(object sender, EventArgs e) { if (txtUsername.Text == "") { Function.showMessage("用户名为空", txtUsername); return; } if (txtPassword.Text == "") { Function.showMessage("密码为空", txtPassword); return; } //if (cmbDepartmentId.SelectedValue.ToString() == "0") { // MessageBox.Show("请选择科室!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); // cmbDepartmentId.Focus(); // return; //} DataRow dr = new ModWorker().setWhere("(isPass = 1) and (username = '******') and (password = '******')").getFind(); if (dr == null) { Function.showMessage("用户名、密码错误或该账号禁用"); } else { Program.intWorkerId = int.Parse(dr["id"].ToString()); Program.strUsername = dr["username"].ToString(); Program.strRealname = dr["realname"].ToString(); FrmMain frmMain = new FrmMain(); frmMain.Show(); this.Hide(); } }
//**************************************************************************************************** //加载 private void FrmWorkerEdit_Load(object sender, EventArgs e) { if (intId == 0) { this.Text = "添加" + this.Text; ParseCombobox.setDepartment(cmbDepartmentId); ParseCombobox.setWorkerType(cmbWorkerTypeId); ParseCombobox.setSex(cmbSex); } else { this.Text = "修改" + this.Text; DataRow dr = new ModWorker().setWhere("id > 0", true).getFind(intId); if (dr == null) { Function.showMessage("记录为空"); this.Close(); } else { txtUsername.Enabled = false; chkIsPass.Checked = Convert.ToBoolean(dr["isPass"]); txtUsername.Text = dr["username"].ToString(); txtPassword.Text = dr["password"].ToString(); txtWorkerCode.Text = dr["workerCode"].ToString(); txtRealname.Text = dr["realname"].ToString(); txtTel.Text = dr["tel"].ToString(); txtSpell.Text = dr["spell"].ToString(); ParseCombobox.setDepartment(cmbDepartmentId, dr["departmentId"]); ParseCombobox.setWorkerType(cmbWorkerTypeId, dr["workerTypeId"]); ParseCombobox.setSex(cmbSex, dr["sex"].ToString()); } } }
//**************************************************************************************************** //员工 public static void setWorker(ComboBox cmb, Object value = null) { DataTable dt = new ModWorker().getSelect(); DataRow dr = dt.NewRow(); dr["id"] = 0; dr["realname"] = "--请选择员工--"; dt.Rows.InsertAt(dr, 0); cmb.DataSource = dt; cmb.ValueMember = "id"; cmb.DisplayMember = "realname"; if (value == null) { cmb.SelectedValue = 0; } else { cmb.SelectedValue = Convert.ToInt32(value); } }
//**************************************************************************************************** //显示数据 private void showData() { DataTable dt = new ModWorker().setWhere("id > 0", true).setRelation(true).getSelect(); if (dt == null) { btnUpdate.Enabled = false; } else { btnUpdate.Enabled = true; int intIndex = 0; if (grd.Rows.Count > 0) { intIndex = grd.CurrentRow.Index; } grd.AutoGenerateColumns = false; grd.DataSource = dt; grd.Rows[intIndex].Cells[1].Selected = true; } }