/// <summary> /// 新增 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool AddNew(Models.ys_AssetsCategory model) { string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_AssetsCategory] ([Id] ,[ParentId] ,[CategoryName] ,[SortCode] ,[SimpleCode] ,[CreateTime] ,[IsRemoved]) VALUES (@Id ,@ParentId ,@CategoryName ,@SortCode ,@SimpleCode ,@CreateTime ,@IsRemoved)"; SqlParameter s1 = new SqlParameter("@Id", model.Id); SqlParameter s2 = new SqlParameter("@ParentId", model.ParentId); SqlParameter s3 = new SqlParameter("@CategoryName", model.CategoryName); SqlParameter s4 = new SqlParameter("@SortCode", model.SortCode); SqlParameter s6 = new SqlParameter("@SimpleCode", model.SimpleCode); SqlParameter s7 = new SqlParameter("@CreateTime", model.CreateTime); SqlParameter s8 = new SqlParameter("@IsRemoved", model.IsRemoved); SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4, s6, s7, s8 }; return(Models.SqlHelper.ExecuteNoQuery(sqlText, cmdPara) > 0 ? true : false); }
public override void AddNew() { IsAddNew = true; tlParentID.EditValue = null; txtFullName.Text = txtSimpleCode.Text = txtSortCode.Text = ""; model = new Models.ys_AssetsCategory(); model.Id = Guid.NewGuid(); }
private void tlType_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) { TreeListNode node = tlType.FocusedNode; if (node != null) { if (node.ParentNode == null) { return; } IsAddNew = false; Guid Id = (Guid)node.GetValue("Id"); model = dbList.Find(s => s.Id == Id); tlParentID.EditValue = model.ParentId; txtFullName.Text = model.CategoryName; txtSimpleCode.Text = model.SimpleCode; txtSortCode.Text = model.SortCode; } }
/// <summary> /// 修改 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool Modify(Models.ys_AssetsCategory model) { string sqlText = @"UPDATE [AssetsSys].[dbo].[ys_AssetsCategory] SET [ParentId] = @ParentId ,[CategoryName] = @CategoryName ,[SortCode] = @SortCode ,[SimpleCode] = @SimpleCode ,[CreateTime] = @CreateTime ,[IsRemoved] = @IsRemoved WHERE [Id] = @Id"; SqlParameter s1 = new SqlParameter("@Id", model.Id); SqlParameter s2 = new SqlParameter("@ParentId", model.ParentId); SqlParameter s3 = new SqlParameter("@CategoryName", model.CategoryName); SqlParameter s4 = new SqlParameter("@SortCode", model.SortCode); SqlParameter s6 = new SqlParameter("@SimpleCode", model.SimpleCode); SqlParameter s7 = new SqlParameter("@CreateTime", model.CreateTime); SqlParameter s8 = new SqlParameter("@IsRemoved", model.IsRemoved); SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4, s6, s7, s8 }; return(Models.SqlHelper.ExecuteNoQuery(sqlText, cmdPara) > 0 ? true : false); }
/// <summary> /// 修改 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool Modify(Models.ys_AssetsCategory model) { return(dal.Modify(model)); }
/// <summary> /// 新增 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool AddNew(Models.ys_AssetsCategory model) { return(dal.AddNew(model)); }