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