public Response Execute(string request)
{
var req = JsonConvert.DeserializeObject <Request <OrganizationFilter> >(request);
var obj = req.Filter;
var cmd = CommandHelper.CreateProcedure <Organization>(FetchType.Fetch, "sp_GetOrgList");
cmd.CreateParamPager(obj);
var response = DbContext.GetInstance().Execute(cmd);
foreach (Organization item in response.Entities)
{
item.Level = OrgHelper.GetOrgLevel(item.TypeId);
}
return(response);
}
public Response Execute(string request)
{
var req = JsonConvert.DeserializeObject <Request <Organization> >(request);
var obj = req.FirstEntity();
Organization org = OrgHelper.GetOrg(obj.TypeId);
if (org.IsDefault)
{
return(ResultHelper.Fail("默认机构不能修改"));
}
var cmd = CommandHelper.CreateProcedure <Organization>(FetchType.Execute, "sp_DeleteOrg");
cmd.Params.Add("@typeId", obj.TypeId);
cmd.Params.Add("@parenetTypeId", obj.ParentTypeId);
return(DbContext.GetInstance().Execute(cmd));
}
public Response Execute(string request)
{
var req = JsonConvert.DeserializeObject <Request <Organization> >(request);
var obj = req.FirstEntity();
Organization org = OrgHelper.GetOrg(obj.TypeId);
if (org.IsDefault)
{
return(ResultHelper.Fail("默认机构不能修改"));
}
string sqlStr = @"UPDATE Organization SET Name=@name WHERE TypeId=@typeid";
//obj.RowState = Core.RowState.Modified;
//List<EntityBase> entities = new List<EntityBase>();
//entities.Add(obj);
//var cmd = CommandHelper.CreateSave(entities);
var cmd = CommandHelper.CreateText <Organization>(FetchType.Execute, sqlStr);
cmd.Params.Add("@name", obj.Name);
cmd.Params.Add("@typeid", obj.TypeId);
return(DbContext.GetInstance().Execute(cmd));
}
public Response Execute(string request)
{
var req = JsonConvert.DeserializeObject <Request <Organization> >(request);
var obj = req.FirstEntity();
if (string.IsNullOrEmpty(obj.ParentTypeId))
{
return(ResultHelper.Fail("上级机构TypeId不能为空"));
}
if (obj.ParentTypeId == "00000")
{
return(ResultHelper.Fail("不能添加顶级机构"));
}
string newTypeId = OrgHelper.GetNewOrgTypeid(obj.ParentTypeId, OrgHelper.GetSonCounter(obj.ParentTypeId));
var cmd = CommandHelper.CreateProcedure <Organization>(FetchType.Execute, "sp_SaveOrg");
cmd.Params.Add("@name", obj.Name);
cmd.Params.Add("@typeId", newTypeId);
cmd.Params.Add("@parenetTypeId", obj.ParentTypeId);
return(DbContext.GetInstance().Execute(cmd));
}
