private void btnSave_Click(object sender, RoutedEventArgs e) { Guid operatorId = CommonHelper.GetOperatorId(); if (IsInsert) { Operator op = new Operator(); op.UserName = txtUserName.Text; op.RealName = txtRealName.Text; op.Password = pdxPassword.Password; OperatorDAL.Insert(op); T_OperationLogDAL.Insert(operatorId, "插入操作员" + op.UserName); } else { string password = pdxPassword.Password; string userName = txtUserName.Text; if (password.Length <= 0) { OperatorDAL.Update(EditId, txtUserName.Text, txtRealName.Text); //OperatorDAL.Update(EditId, null, txtRealName.Text); } else { //OperatorDAL.Update(EditId, txtUserName.Text, txtRealName.Text, pdxPassword.Password); OperatorDAL.Update(EditId, null, txtRealName.Text, pdxPassword.Password); } T_OperationLogDAL.Insert(operatorId, "修改操作员" + userName); } DialogResult = true; }
public static void Insert(Operator op) { SqlHelper.ExcuteNonQuery(@"insert into T_Operator(Id,UserName,Password,IsDelete,RealName,IsNocked) values(newid(),@UserName,@Password,0,@RealName,0)", new SqlParameter("@UserName", op.UserName), new SqlParameter("@Password", op.Password), new SqlParameter("@RealName",op.RealName)); }
public static Operator[] ListAll() { DataTable dt = SqlHelper.ExecuteDataTable("select * from T_Operator where IsDelete=0"); Operator[] operators = new Operator[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { operators[i] = ToOperator(dt.Rows[i]); } return operators; }
private static Operator ToOperator(DataRow row) { Operator op = new Operator(); op.UserName = (string)row["userName"]; op.Id = (Guid)row["Id"]; op.Password=(string)row["Password"]; op.IsDelete = (bool)row["IsDelete"]; op.RealName = (string)row["RealName"]; op.IsNocked = (bool)row["IsNocked"]; return op; }