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