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