private void save_Click(object sender, EventArgs e)//保存更新 { string V, pasword; try { if (Pas.Text != "") { //pasword = db.Encrypt(Pas.Text); pasword = Pas.Text; } else { pasword = ""; } if (IsValid.Checked) { V = "1"; } else { V = "0"; } utype = comboBox1.SelectedIndex.ToString(); updateE(Account.Text, pasword, Position.Text, EName.Text, ECode.Text, V, FormEmployee.ID, utype); string str = "Delete from ManageLimit where DEmployeeID = " + FormEmployee.ID; db.GetPIVAsDB(str); if (LimitShow) { Limitstr = f.getLimitStr(); f.Dispose(); } if (Limitstr != "") { string[] l = Limitstr.Split(','); for (int i = 0; i < l.Length; i++) { str = "insert into ManageLimit values(" + FormEmployee.ID + ",'" + l[i] + "')"; db.SetPIVAsDB(str); } } this.DialogResult = DialogResult.OK; this.Close(); } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
private void Add_Click(object sender, EventArgs e)//增加数据库员工信息,同时界面刷新 { try { string Isvalid, pasword, type = ""; if (Pas.Text != "") { // pasword = db.Encrypt(Pas.Text); pasword = Pas.Text; } else { pasword = ""; } if (IsValid.Checked) { Isvalid = "1"; } else { Isvalid = "0"; } switch (comboBox1.SelectedIndex) { case 0: type = "0"; break; case 1: type = "1"; break; case 2: type = "2"; break; case 3: type = "3"; break; } //db.Decrypt string str = "insert into DEmployee values('" + Account.Text + "','" + pasword + "','" + Position.Text + "','" + ECode.Text + "','" + EName.Text + "','" + Isvalid + "'," + type + ")"; FormEmployee form = (FormEmployee)this.Owner; db.SetPIVAsDB(str); form.refresh(); if (LimitShow) { Limitstr = f.getLimitStr(); f.Dispose(); } str = "select DEmployeeID from DEmployee where AccountID = '" + Account.Text + "'"; DataSet ds = db.GetPIVAsDB(str); if (ds != null && ds.Tables[0].Rows.Count > 0) { string eid = ds.Tables[0].Rows[0]["DEmployeeID"].ToString(); if (Limitstr != "") { string[] l = Limitstr.Split(','); for (int i = 0; i < l.Length; i++) { str = "insert into ManageLimit values(" + eid + ",'" + l[i] + "')"; db.SetPIVAsDB(str); } } } this.DialogResult = DialogResult.OK; this.Close(); } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }