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;
}
