public string PostUnChecked([FromBody] GHSubjectRequestModel param) { if (param.PhId == 0) { return(DCHelper.ErrorMessage("主键不能为空!")); } try { long id = param.PhId; //主表主键 var Findresult = GHSubjectService.Find <System.Int64>(id); Common.Model.Results.SavedResult <Int64> savedresult = new Common.Model.Results.SavedResult <Int64>(); Findresult.Data.FApproveStatus = "1"; Findresult.Data.FApprover = 0; Findresult.Data.FApproveDate = new Nullable <DateTime>(); Findresult.Data.PersistentState = PersistentState.Modified; savedresult = GHSubjectService.Save <Int64>(Findresult.Data, ""); return(DataConverterHelper.SerializeObject(savedresult)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }
public string PostDeleteGHSubject([FromBody] GHSubjectRequestModel param) { if (param.PhId == 0) { return(DCHelper.ErrorMessage("主键不能为空!")); } try { long id = param.PhId; //主表主键 var data = GHSubjectService.Find(id).Data; if (data.FType == "tz" && data.FApproveStatus != "5") //删除年中调整 未作废单据 恢复上一个年中调整单据 { Dictionary <string, object> dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FDeclarationDept", data.FDeclarationDept)) .Add(ORMRestrictions <string> .Eq("FYear", data.FYear)) .Add(ORMRestrictions <string> .Eq("FProjAttr", data.FProjAttr)) .Add(ORMRestrictions <string> .Eq("FApproveStatus", "5")) .Add(ORMRestrictions <string> .Eq("FType", data.FType)); IList <GHSubjectModel> gHSubjects = GHSubjectService.Find(dicWhere, new string[] { "NgUpdateDt Desc" }).Data; if (gHSubjects.Count > 0) { gHSubjects[0].FApproveStatus = "3"; gHSubjects[0].PersistentState = PersistentState.Modified; GHSubjectService.Save <long>(gHSubjects[0], ""); } else { //没有年中调整单据时将年初新增状态为调整中的变成已审批 Dictionary <string, object> dicWhere2 = new Dictionary <string, object>(); new CreateCriteria(dicWhere2).Add(ORMRestrictions <string> .Eq("FDeclarationDept", data.FDeclarationDept)) .Add(ORMRestrictions <string> .Eq("FYear", data.FYear)) .Add(ORMRestrictions <string> .Eq("FProjAttr", data.FProjAttr)) .Add(ORMRestrictions <string> .Eq("FApproveStatus", "6")) .Add(ORMRestrictions <string> .Eq("FType", "c")); IList <GHSubjectModel> gHSubjects2 = GHSubjectService.Find(dicWhere).Data; if (gHSubjects2.Count > 0) { foreach (var a in gHSubjects2) { a.FApproveStatus = "3"; a.PersistentState = PersistentState.Modified; } GHSubjectService.Save <long>(gHSubjects2, ""); } } } else { } var deletedresult = GHSubjectService.Delete <System.Int64>(id); return(DataConverterHelper.SerializeObject(deletedresult)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }
public string GetGHSubjectList([FromUri] GHSubjectRequestModel param) { if (string.IsNullOrEmpty(param.UserId)) { return(DCHelper.ErrorMessage("用户编码不能为空!")); } if (string.IsNullOrEmpty(param.Fkmlb)) { return(DCHelper.ErrorMessage("申报种类不能为空!")); } try { Dictionary <string, object> dicWhere = new Dictionary <string, object>();//查询条件转Dictionary new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FProjAttr", param.Fkmlb)); //增加搜索条件 if (!string.IsNullOrEmpty(param.FApproveStatus) && !"0".Equals(param.FApproveStatus)) { new CreateCriteria(dicWhere) .Add(ORMRestrictions <string> .Eq("FApproveStatus", param.FApproveStatus)); } if (!string.IsNullOrEmpty(param.Year)) { new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FYear", param.Year)); } //增加根据操作员对应预算部门的过滤 var dicWhereDept = new Dictionary <string, object>(); new CreateCriteria(dicWhereDept) .Add(ORMRestrictions <string> .Eq("Dwdm", param.UserId)).Add(ORMRestrictions <string> .Eq("Dylx", "97")); //闭区间 var deptList = CorrespondenceSettingsService.Find(dicWhereDept); List <string> deptL = new List <string>(); for (var i = 0; i < deptList.Data.Count; i++) { deptL.Add(deptList.Data[i].Dydm); } new CreateCriteria(dicWhere).Add(ORMRestrictions <IList <String> > .In("FDeclarationDept", deptL)) .Add(ORMRestrictions <string> .Eq("FYear", DateTime.Today.Year.ToString())); new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FType", "c")); var result = GHSubjectService.LoadWithPage(param.PageIndex, param.PageSize, dicWhere, new string[] { "NgInsertDt Desc", "NgUpdateDt Desc" }); //return DataConverterHelper.EntityListToJson<GHSubjectModel>(result.Results, (Int32)result.TotalItems); return(DCHelper.ModelListToJson <GHSubjectModel>(result.Results, (Int32)result.TotalItems)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }
public string GetGHSubjectInfo([FromUri] GHSubjectRequestModel param) { if (param.PhId == 0) { return(DCHelper.ErrorMessage("主键不能为空!")); } try { //主表主键 string tabtype = param.tabtype; //Tab类型 switch (tabtype) { case "ghsubject": var findedresultghsubject = GHSubjectService.Find(param.PhId); return(DataConverterHelper.SerializeObject(findedresultghsubject)); case "subjectmst": var findedresultsubjectmst = GHSubjectService.FindSubjectMstByForeignKey(param.PhId); foreach (var item in findedresultsubjectmst.Data) { if (!string.IsNullOrEmpty(item.FProjCode) || !string.IsNullOrEmpty(item.FProjName)) { item.FSubjectCode = ""; item.FSubjectName = ""; } } return(DCHelper.ModelListToJson <SubjectMstModel>(findedresultsubjectmst.Data, findedresultsubjectmst.Data.Count)); case "subjectmstbudgetdtl": var findedresultsubjectmstbudgetdtl = GHSubjectService.FindSubjectMstBudgetDtlByForeignKey(param.PhId); return(DCHelper.ModelListToJson <SubjectMstBudgetDtlModel>(findedresultsubjectmstbudgetdtl.Data, findedresultsubjectmstbudgetdtl.Data.Count)); default: Common.Model.Results.FindedResult findedresultother = new Common.Model.Results.FindedResult(); return(DataConverterHelper.SerializeObject(findedresultother)); } } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }