/// <summary> /// 新增类别方法 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddNewCategory(Models.ys_JobCategory model) { string sqlText = @" INSERT INTO [RightingSys].[dbo].[ys_JobCategory] ([Id] ,[JobCategoryName] ,[ParentId] ,[CreateTime] ,[IsRemoved]) VALUES (@Id ,@JobCategoryName ,@ParentId ,@CreateTime ,@IsRemoved)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@JobCategoryName", model.JobCategoryName), new SqlParameter("@ParentId", model.ParentId), new SqlParameter("@CreateTime", model.CreateTime), new SqlParameter("@IsRemoved", model.IsRemoved), new SqlParameter("@Id", model.Id) }; return(Models.SqlHelper.ExecuteNoQuery(sqlText, param) > 0); }
/// <summary> ///类别树焦点改变事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tl_Type_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) { if (e.Node != null) { IsNewAdd = false; model = Datalist.Find(s => s.Id == (Guid)e.Node.GetValue("Id")); tl_PID.EditValue = model.ParentId; txtFullName.Text = model.JobCategoryName; } }
/// <summary> /// 修改类别 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool ModifyCategory(Models.ys_JobCategory model) { string sqlText = @" UPDATE [RightingSys].[dbo].[ys_JobCategory] SET [JobCategoryName] = @JobCategoryName ,[ParentId] = @ParentId ,[CreateTime] = @CreateTime ,[IsRemoved] = @IsRemoved WHERE [Id] = @Id"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@JobCategoryName", model.JobCategoryName), new SqlParameter("@ParentId", model.ParentId), new SqlParameter("@CreateTime", model.CreateTime), new SqlParameter("@IsRemoved", model.IsRemoved), new SqlParameter("@Id", model.Id) }; return(Models.SqlHelper.ExecuteNoQuery(sqlText, parameters) > 0); }
/// <summary> /// 新增功能 /// </summary> public override void AddNew() { IsNewAdd = true; txtFullName.Text = ""; model = new Models.ys_JobCategory(); }
/// <summary> /// 修改类别 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool ModifyCategory(Models.ys_JobCategory model) { return(sev.ModifyCategory(model)); }
/// <summary> /// 新增类别方法 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddNewCategory(Models.ys_JobCategory model) { return(sev.AddNewCategory(model)); }