public int Dept_Add(Model.Models.NcManagerDept model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into nc_manager_dept(");
strSql.Append("Parent_ID,Class_List,Class_Layer,Sort_ID,Dept_Name,Dept_Desc,Created_ID,OStatus)");
strSql.Append(" values (");
strSql.Append("@Parent_ID,@Class_List,@Class_Layer,@Sort_ID,@Dept_Name,@Dept_Desc,@Created_ID,@OStatus)");
strSql.Append(";select @ReturnValue= @@IDENTITY ");
strSql.Append(@"if @@error<>0 begin rollback tran
select N'fail' as result
return
end");
string sql = @"
Begin Tran
declare @ReturnValue as int,@pClass_list as nvarchar(500),@pClass_layer as int
" + strSql.ToString() + @"
if @parent_id>0 begin
select @pClass_list=class_list,@pClass_layer=class_layer from nc_manager_dept where dept_id=@parent_id
set @pClass_list=@pClass_list+cast(@ReturnValue as nvarchar(max))+','
set @pClass_layer=@pClass_layer+1
end
else begin
set @pClass_list=','+cast(@ReturnValue as nvarchar(max))+','
set @pClass_layer=1
end
update nc_manager_dept set class_list=@pClass_list, class_layer=@pClass_layer where dept_id=@ReturnValue
if @@error<>0 begin rollback tran
select N'fail' as result
return
end
select N'success' as result
--select N'parent_id_error'+cast(@pClass_layer as nvarchar(max))+cast(@ReturnValue as nvarchar(max)) as result
Commit Tran
";
DbParameters p = new DbParameters();
p.Add("@parent_id", model.ParentId);
p.Add("@class_list", model.ClassList);
p.Add("@class_layer", model.ClassLayer);
p.Add("@Dept_Name", model.DeptName);
p.Add("@Dept_Desc", model.DeptDesc);
p.Add("@sort_id", model.SortId);
p.Add("@Created_ID", siteAdminInfo.Id);
p.Add("@OStatus", model.Ostatus);
string result = Utils.ObjectToStr(Dbl.ZZCMS.CreateSqlScalar(sql, p));
return(result == "success" ? 1 : 0);
}
public bool Dept_Update(Model.Models.NcManagerDept model)
{
dblEf.Update <NcManagerDept>(model);
return(dblEf.SaveChanges() > 0);
}
