public bool AddNew(Models.ACL_User model)
{
SqlParameter[] Param = new SqlParameter[] {
new SqlParameter("@Id", model.Id),
new SqlParameter("@LoginName", model.LoginName),
new SqlParameter("@LoginPwd", model.LoginPwd),
new SqlParameter("@DepartmentId", model.DepartmentId),
new SqlParameter("@SimpleCode", model.SimpleCode),
new SqlParameter("@FullName", model.FullName),
new SqlParameter("@CreateTime", model.CreateTime),
new SqlParameter("@IsRemoved", model.IsRemoved)
};
return(Models.SqlHelper.ExecuteNoQuery(@"INSERT INTO [dbo].[ACL_User]
([Id]
,[LoginName]
,[LoginPwd]
,[DepartmentId]
,[SimpleCode]
,[FullName]
,[CreateTime]
,[IsRemoved])
VALUES
(@Id
,@LoginName
,@LoginPwd
,@DepartmentId
,@SimpleCode
,@FullName
,@CreateTime
,@IsRemoved)", Param) > 0 ? true : false);
}
public bool Modify(Models.ACL_User model)
{
SqlParameter[] Param = new SqlParameter[] {
new SqlParameter("@Id", model.Id),
new SqlParameter("@LoginName", model.LoginName),
new SqlParameter("@LoginPwd", model.LoginPwd),
new SqlParameter("@DepartmentId", model.DepartmentId),
new SqlParameter("@SimpleCode", model.SimpleCode),
new SqlParameter("@FullName", model.FullName),
new SqlParameter("@CreateTime", model.CreateTime),
new SqlParameter("@IsRemoved", model.IsRemoved)
};
// Models.SqlHelper.AddNewOperatorLog("修改用户信息", "ACL_User", "修改");
return(Models.SqlHelper.ExecuteNoQuery(@"UPDATE [dbo].[ACL_User]
SET [LoginName] = @LoginName
,[LoginPwd] = @LoginPwd
,[DepartmentId] = @DepartmentId
,[SimpleCode] = @SimpleCode
,[FullName] = @FullName
,[CreateTime] = @CreateTime
,[IsRemoved] = @IsRemoved
WHERE [Id] = @Id", Param) > 0 ? true : false);
}
private void EditInitial(Guid UserId)
{
AddInitial();
model = userMg.GetOneById(UserId);
sbtnAdd.Visible = false;
if (model != null)
{
txtLoginName.Text = model.LoginName;
txtFullName.Text = model.FullName;
tlDepartment.EditValue = model.DepartmentId;
txtHandNo.Text = model.SimpleCode;
}
}
public bool Modify(Models.ACL_User model)
{
return(Sev.Modify(model));
}
public bool AddNew(Models.ACL_User model)
{
return(Sev.AddNew(model));
}
private void AddInitial()
{
model = new Models.ACL_User();
tlDepartment.Properties.DataSource = deptMg.GetAllList();
}
