/// <summary> /// 修改岗位与操作员信息 /// </summary> /// <param name="gAppvalPostAndOpers">岗位以及操作员对象</param> /// <returns></returns> public SavedResult <long> UpdateSignle(GAppvalPostAndOpersModel gAppvalPostAndOpers) { GAppvalPostModel gAppvalPost = gAppvalPostAndOpers.GAppvalPost; IList <GAppvalPost4OperModel> gAppvalOpers = gAppvalPostAndOpers.GAppvalPost4Opers; SavedResult <long> savedResult = new SavedResult <long>(); if (gAppvalPost.PhId == 0 || gAppvalPost.OrgPhid == 0) { throw new Exception("所传的岗位信息有误!"); } Dictionary <string, object> dic = new Dictionary <string, object>(); new CreateCriteria(dic) .Add(ORMRestrictions <long> .Eq("PostPhid", gAppvalPost.PhId)); var record = this.GAppvalRecordFacade.Find(dic).Data; //if (record.Count > 0) //{ // throw new Exception("此岗位已被使用,无法进行修改!"); //} dic.Clear(); new CreateCriteria(dic) .Add(ORMRestrictions <string> .Eq("FCode", gAppvalPost.FCode)) .Add(ORMRestrictions <long> .Eq("OrgPhid", gAppvalPost.OrgPhid)) .Add(ORMRestrictions <long> .NotEq("PhId", gAppvalPost.PhId)); var result = this.GAppvalPostFacade.Find(dic).Data; if (result.Count > 0) { throw new Exception("岗位编码重复,请重新填写!"); } gAppvalPost.PersistentState = PersistentState.Modified; savedResult = this.GAppvalPostFacade.Save <long>(gAppvalPost); if (savedResult.KeyCodes.Count > 0) { dic.Clear(); new CreateCriteria(dic) .Add(ORMRestrictions <long> .Eq("PostPhid", gAppvalPost.PhId)); var operList = this.GAppvalPost4OperFacade.Find(dic).Data; if (operList.Count > 0) { var delete = this.GAppvalPost4OperFacade.Delete(dic); } var postPhid = savedResult.KeyCodes[0]; foreach (var oper in gAppvalOpers) { oper.PostPhid = postPhid; oper.PersistentState = PersistentState.Added; } savedResult = this.GAppvalPost4OperFacade.Save <long>(gAppvalOpers); } return(savedResult); }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public IList <AddinAssemblyModel> FindAddinAssemblyByMstPhid(long id) { var dic = new Dictionary <string, object>(); new CreateCriteria(dic) .Add(ORMRestrictions <Int64> .Eq("MstPhid", id)) .Add(ORMRestrictions <Int32> .Eq("AssemblyCatalog", (int)EnumCatalog.Extend)); var assemblyModels = assemblyRule.Find <AddinAssemblyModel>(dic, new string[] { "Phid asc" }); return(assemblyModels); }
/// <summary> /// 报表 /// </summary> public PagedResult <RWReportModel> GetList(long userId) { Dictionary <string, object> dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere) .Add(ORMRestrictions <string> .Eq("RepType", "2")) .Add(ORMRestrictions <string> .Eq("RepGenre", "1")) .Add(ORMRestrictions <string> .Eq("OCode", base.OrgID.ToString())); PagedResult <RWReportModel> result = RWReportFacade.FacadeHelper.LoadWithPageInfinity("GQT.QT.GetList", dicWhere); return(result); }
/// <summary> /// 根据组织获取岗位(2019.10.17改成岗位根据操作员对应组织权限取) /// </summary> /// <param name="userId">操作员id</param> /// <returns></returns> public IList <GAppvalPostModel> GetAppvalPostList(long userId) { List <Int64> orgs = OrganizationFacade.GetSBUnit(userId).ToList().Select(x => x.PhId).ToList(); Dictionary <string, object> dic = new Dictionary <string, object>(); new CreateCriteria(dic) .Add(ORMRestrictions <List <long> > .In("OrgPhid", orgs)) .Add(ORMRestrictions <byte> .Eq("FEnable", (byte)EnumYesNo.Yes)); var result = this.GAppvalPostFacade.Find(dic, new string[] { "IsSystem desc", "FCode Asc" }).Data; return(result); }
public IList <VCorrespondenceSetting2Model> GetVc2mList(String dwdm) { string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery);//查询条件转Dictionary CreateCriteria createCriteria = new CreateCriteria(dicWhere); createCriteria.Add(ORMRestrictions <string> .Eq("Dylx", "ZC")); createCriteria.Add(ORMRestrictions <string> .NotEq("Dydm", "NULL")); if (dwdm != null) { createCriteria.Add(ORMRestrictions <string> .Eq("Dwdm", dwdm)); } DataStoreParam storeparam = this.GetDataStoreParam(); var cr2s = this.CorrespondenceSettings2Service.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere).Results as List <CorrespondenceSettings2Model>; var ors = this.GetOrg(); IList <VCorrespondenceSetting2Model> vcr2s = new List <VCorrespondenceSetting2Model>(); foreach (CorrespondenceSettings2Model cr2 in cr2s) { VCorrespondenceSetting2Model vc2 = new VCorrespondenceSetting2Model(); vc2.PhId = cr2.PhId; vc2.DWDM = cr2.Dwdm; vc2.DYDM = cr2.Dydm; vc2.DYLX = cr2.Dylx; var or = from or1 in ors where or1.OCode.Equals(cr2.Dydm) select or1; if (or.Count() == 1) { vc2.Dymc = or.ToList()[0].OName; } else { vc2.Dymc = "未设置"; } or = from or1 in ors where or1.OCode.Equals(cr2.Dwdm) select or1; if (or.Count() == 1) { vc2.Dwmc = or.ToList()[0].OName; } else { vc2.Dymc = "未设置"; } vcr2s.Add(vc2); } return(vcr2s); }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public IList <AddinSqlModel> FindAddinSqlByMstPhid(long id) { var dic = new Dictionary <string, object>(); new CreateCriteria(dic) .Add(ORMRestrictions <Int64> .Eq("MstPhid", id)) .Add(ORMRestrictions <Int32> .Eq("SqlCatalog", (int)EnumCatalog.Interceptor)); var sqlModels = SqlRule.Find <AddinSqlModel>(dic, new string[] { "Phid asc" }); return(sqlModels); }
/// <summary> /// 根据主键获取数据 /// </summary> /// <returns>返回Json串</returns> public string GetProjectThresholdInfoToOrgcode() { string orgcode = System.Web.HttpContext.Current.Request.Params["orgcode"]; //组织号 Dictionary <string, object> dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere) .Add(ORMRestrictions <string> .Eq("Orgcode", orgcode)); var findedresult = ProjectThresholdService.Find(dicWhere); return(DataConverterHelper.ResponseResultToJson(findedresult)); }
/// <summary> /// 判断是否是末级组织 /// </summary> /// <param name="ParentOrg"></param> /// <returns></returns> public PagedResult <OrgRelatitem2Model> LoadWithPageIsend(string ParentOrg) { //CommonResult<OrgRelatitem2Model> result = new CommonResult<OrgRelatitem2Model>(); var dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere) .Add(ORMRestrictions <string> .Eq("ParentOrg", ParentOrg)); var result = OrgRelatitem2Facade.FacadeHelper.LoadWithPageInfinity("GQT.QT.GetAllorgrelatitem", dicWhere); return(result); }
/// <summary> /// 根据岗位主键集合删除岗位与岗位对应操作员信息 /// </summary> /// <param name="phidList">岗位主键集合</param> /// <param name="uCode">用户账号</param> /// <returns></returns> public DeletedResult DeletedPostOpers(List <long> phidList, string uCode) { DeletedResult deletedResult = new DeletedResult(); Dictionary <string, object> dic = new Dictionary <string, object>(); new CreateCriteria(dic) .Add(ORMRestrictions <List <long> > .In("PostPhid", phidList)); var record = this.GAppvalRecordFacade.Find(dic).Data; if (record.Count > 0) { throw new Exception("此岗位已被审批使用,无法进行删除!"); } dic.Clear(); new CreateCriteria(dic) .Add(ORMRestrictions <List <long> > .In("PostPhid", phidList)); var procPost = this.GAppvalProc4PostFacade.Find(dic).Data; if (procPost.Count > 0) { throw new Exception("此岗位已被流程使用,无法进行删除!"); } dic.Clear(); new CreateCriteria(dic) .Add(ORMRestrictions <List <long> > .In("PhId", phidList)) .Add(ORMRestrictions <byte> .Eq("IsSystem", (byte)1)); var sysPosts = this.GAppvalPostFacade.Find(dic).Data; if (sysPosts.Count > 0 && uCode != "Admin") { throw new Exception("内置岗位普通操作员不能进行删除!"); } dic.Clear(); new CreateCriteria(dic) .Add(ORMRestrictions <List <long> > .In("PhId", phidList)); var posts = this.GAppvalPostFacade.Find(dic).Data; if (posts.Count > 0) { deletedResult = this.GAppvalPostFacade.Delete(dic); dic.Clear(); new CreateCriteria(dic) .Add(ORMRestrictions <List <long> > .In("PostPhid", phidList)); var opers = this.GAppvalPost4OperFacade.Find(dic).Data; if (opers.Count > 0) { deletedResult = this.GAppvalPost4OperFacade.Delete(dic); } } return(deletedResult); }
/// <summary> /// 根据预算单位和预算部门查找部门所在预算进度 /// </summary> /// <param name="oCode"></param> /// <param name="deptCode"></param> /// <returns></returns> public string FindBudgetProcessCtrl(string oCode, string deptCode, string FYear) { Dictionary <string, object> dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FOcode", oCode)) .Add(ORMRestrictions <string> .Eq("FDeptCode", deptCode)).Add(ORMRestrictions <string> .Eq("FYear", FYear)); FindedResults <BudgetProcessCtrlModel> results = base.ServiceHelper.Find <BudgetProcessCtrlModel>(dicWhere); if (results.Data.Count() > 0) { return(results.Data[0].FProcessStatus); } return(""); }
/// <summary> /// 取列表数据 /// </summary> /// <returns>返回Json串</returns> public string GetQTMemoList() { string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"];//查询条件 long userId = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["userId"]); Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery);//查询条件转Dictionary new CreateCriteria(dicWhere) .Add(ORMRestrictions <System.Int64> .Eq("Creator", userId)); DataStoreParam storeparam = this.GetDataStoreParam(); var result = QTMemoService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere); return(DataConverterHelper.EntityListToJson <QTMemoModel>(result.Results, (Int32)result.TotalItems)); }
/// <summary> /// 取列表数据 /// </summary> /// <returns>返回Json串</returns> public string GetQTEditMemoList() { string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件 Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary var Memophid = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["Memophid"]); new CreateCriteria(dicWhere) .Add(ORMRestrictions <Int64> .Eq("Memophid", Memophid)); DataStoreParam storeparam = this.GetDataStoreParam(); var result = QTEditMemoService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, new string[] { "NgInsertDt Desc", "NgUpdateDt Desc" }); return(DataConverterHelper.EntityListToJson <QTEditMemoModel>(result.Results, (Int32)result.TotalItems)); }
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)); } }
/// <summary> /// 取列表数据 /// </summary> /// <returns>返回Json串</returns> public string GetQtBaseProjectSelect() { //long Fphid = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["Fphid"]); string userCode = System.Web.HttpContext.Current.Request.Params["userCode"]; string FKMLB = System.Web.HttpContext.Current.Request.Params["FKMLB"]; string FType = System.Web.HttpContext.Current.Request.Params["FType"]; string FYear = System.Web.HttpContext.Current.Request.Params["FYear"]; Dictionary <string, object> dicWhere = new Dictionary <string, object>(); var DeptList = CorrespondenceSettingsService.GetRelationYSBMRightList(userCode).Results.ToList().Select(x => x.OCode).Distinct().ToList(); new CreateCriteria(dicWhere) .Add(ORMRestrictions <string> .Eq("FKMLB", FKMLB)) .Add(ORMRestrictions <string> .NotEq("FProjCode", "")) .Add(ORMRestrictions <List <string> > .In("FFillDept", DeptList)); if (!string.IsNullOrEmpty(FYear)) { new CreateCriteria(dicWhere) .Add(ORMRestrictions <string> .Eq("FYear", FYear)); } DataStoreParam storeparam = this.GetDataStoreParam(); //var result = QtBaseProjectService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, new string[] { "FKmdm", "NgInsertDt" }); var result = new PagedResult <QtBaseProjectModel>(); if (FType == "c") { result = QtBaseProjectService.ServiceHelper.LoadWithPageInfinity("GQT.QT.TBJD.c", dicWhere); } else { result = QtBaseProjectService.ServiceHelper.LoadWithPageInfinity("GQT.QT.TBJD.z", dicWhere); foreach (QtBaseProjectModel a in result.Results) { if (a.FType == "c") { a.FProjName = a.FProjName + "(年初新增)"; } if (a.FType == "z") { a.FProjName = a.FProjName + "(年中新增)"; } if (a.FType == "tz") { a.FProjName = a.FProjName + "(年中调整)"; } } } //var result = QtBaseProjectService.ServiceHelper.LoadWithPageInfinity("GQT.QT.TBJD", dicWhere); return(DataConverterHelper.EntityListToJson <QtBaseProjectModel>(result.Results, (Int32)result.TotalItems)); }
/// <summary> /// 保存 /// </summary> /// <param name="expenseCategory"></param> /// <param name="edittype"></param> /// <returns></returns> public SavedResult <Int64> Save2(ExpenseCategoryModel expenseCategory, string edittype) { SavedResult <Int64> result = new SavedResult <Int64>(); if (edittype == "edit") { ExpenseCategoryModel expenseCategory2 = base.Find(expenseCategory.PhId).Data; if (expenseCategory.Mc != expenseCategory2.Mc) { var dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere). Add(ORMRestrictions <string> .Eq("Mc", expenseCategory.Mc)); if (base.Find(dicWhere).Data.Count > 0) { result.Status = ResponseStatus.Error; result.Msg = "保存失败,名称重复!"; return(result); } } expenseCategory2.Mc = expenseCategory.Mc; expenseCategory2.Bz = expenseCategory.Bz; expenseCategory2.PersistentState = PersistentState.Modified; result = base.Save <Int64>(expenseCategory2, ""); } if (edittype == "add") { var dicWhere1 = new Dictionary <string, object>(); new CreateCriteria(dicWhere1). Add(ORMRestrictions <string> .Eq("Dm", expenseCategory.Dm)); if (base.Find(dicWhere1).Data.Count > 0) { result.Status = ResponseStatus.Error; result.Msg = "保存失败,代码重复!"; return(result); } var dicWhere2 = new Dictionary <string, object>(); new CreateCriteria(dicWhere2). Add(ORMRestrictions <string> .Eq("Mc", expenseCategory.Mc)); if (base.Find(dicWhere2).Data.Count > 0) { result.Status = ResponseStatus.Error; result.Msg = "保存失败,名称重复!"; return(result); } expenseCategory.PersistentState = PersistentState.Added; result = base.Save <Int64>(expenseCategory, ""); } return(result); }
/// <summary> /// 根据操作员取申报单位 /// </summary> /// <param name="USERID"></param> /// <returns></returns> public IList <OrganizeModel> GetSBUnit(long USERID) { //SELECT DISTINCT fg3_userorg.ORGID FROM fg3_userorg WHERE USERID=488181024000001 List <Int64> PHIDs1 = new List <Int64>(); List <Int64> PHIDs2 = new List <Int64>(); Dictionary <string, object> dic_userorg = new Dictionary <string, object>(); new CreateCriteria(dic_userorg) .Add(ORMRestrictions <Int64> .Eq("UserId", USERID)); IList <UserOrganize2Model> userOrganize2s = UserOrgRule.Find(dic_userorg); if (userOrganize2s.Count > 0) { for (var i = 0; i < userOrganize2s.Count; i++) { if (!PHIDs1.Contains(userOrganize2s[i].OrgId)) { PHIDs1.Add(userOrganize2s[i].OrgId); } } } Dictionary <string, object> dic_Corr2 = new Dictionary <string, object>(); new CreateCriteria(dic_Corr2) .Add(ORMRestrictions <String> .Eq("Dylx", "SB")); IList <CorrespondenceSettings2Model> correspondenceSettings2 = CorrespondenceSettings2Rule.Find(dic_Corr2); if (correspondenceSettings2.Count > 0) { for (var i = 0; i < correspondenceSettings2.Count; i++) { if (!PHIDs2.Contains(long.Parse(correspondenceSettings2[i].DefStr2))) { PHIDs2.Add(long.Parse(correspondenceSettings2[i].DefStr2)); } } } List <Int64> phid3 = PHIDs1.Intersect(PHIDs2).ToList(); Dictionary <string, object> dic_org = new Dictionary <string, object>(); new CreateCriteria(dic_org) .Add(ORMRestrictions <String> .Eq("IfCorp", "Y")) .Add(ORMRestrictions <String> .Eq("IsActive", "1")) .Add(ORMRestrictions <List <Int64> > .In("PhId", phid3)); IList <OrganizeModel> organizes = OrganizationRule.Find(dic_org, new string[] { "OCode" }); return(organizes); }
/// <summary> /// 得到子级(包括部门)(树) /// </summary> /// <param name="orgTree"></param> /// <returns></returns> public List <OrganizeModel> GetAllChild(OrganizeModel orgTree) { Dictionary <string, object> dic = new Dictionary <string, object>(); new CreateCriteria(dic) .Add(ORMRestrictions <String> .Eq("RelatId", "lg")) .Add(ORMRestrictions <Int64> .Eq("ParentOrgId", orgTree.PhId)); IList <OrgRelatitem2Model> orgRelatitems = OrgRelatitem2Rule.Find(dic); if (orgRelatitems.Count > 0) { for (var i = 0; i < orgRelatitems.Count; i++) { OrganizeModel Orgdata = OrganizationRule.Find(orgRelatitems[i].OrgId); if (Orgdata.IfCorp == "Y" && Orgdata.IsActive == "1")//筛选组织 { Orgdata.children = GetAllChild(Orgdata); if (orgTree.children == null) { orgTree.children = new List <OrganizeModel>(); } orgTree.children.Add(Orgdata); } } } Dictionary <string, object> dicDept = new Dictionary <string, object>(); new CreateCriteria(dicDept) .Add(ORMRestrictions <Int64> .Eq("ParentOrgId", orgTree.PhId)) .Add(ORMRestrictions <String> .Eq("IfCorp", "N")) .Add(ORMRestrictions <String> .Eq("IsActive", "1")); List <OrganizeModel> Depts = OrganizationRule.Find(dicDept).ToList(); if (Depts.Count > 0) { if (orgTree.children == null) { orgTree.children = new List <OrganizeModel>(); } for (var i = 0; i < Depts.Count; i++) { Depts[i].OName = orgTree.OName + "-" + Depts[i].OName;//部门名称变为 组织-部门 orgTree.children.Add(Depts[i]); } } return(orgTree.children); }
/// <summary> /// 取列表数据根据绩效项目评价指标类型 /// </summary> /// <returns>返回Json串</returns> public string GetPerformEvalTargetListByClassCode() { string TypeCode = System.Web.HttpContext.Current.Request.Params["TypeCode"];//查询条件 var dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere). Add(ORMRestrictions <string> .Eq("FTargetTypeCode", TypeCode)); DataStoreParam storeparam = this.GetDataStoreParam(); var result = PerformEvalTargetService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, new string[] { "FTargetCode" }); result = PerformEvalTargetService.CodeToName(result); return(DataConverterHelper.EntityListToJson <PerformEvalTargetModel>(result.Results, (Int32)result.TotalItems)); }
/// <summary> /// 取列表数据 /// </summary> /// <returns>返回Json串</returns> public string GetQTProductUserDygxList() { /*string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"];//查询条件 * Dictionary<string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery);//查询条件转Dictionary */ long Fg3userPhid = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["Fg3userPhid"]);//查询条件 Dictionary <string, object> dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere).Add(ORMRestrictions <System.Int64> .Eq("Fg3userPhid", Fg3userPhid)); DataStoreParam storeparam = this.GetDataStoreParam(); var result = QTProductUserDygxService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere); return(DataConverterHelper.EntityListToJson <QTProductUserDygxModel>(result.Results, (Int32)result.TotalItems)); }
/// <summary> /// 根据组织取对应关系列表基础数据详细(得到的PhId为对应关系的主键) /// </summary> /// <returns>返回Json串</returns> public string GetExpenseCategoryListDYGXdtl() { string Dwdm = System.Web.HttpContext.Current.Request.Params["Dwdm"];//查询条件 Dictionary <string, object> dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Dylx", "08")); if (Dwdm != null) { new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Dwdm", Dwdm)); } var result = ExpenseCategoryService.ServiceHelper.LoadWithPageInfinity("GQT.QT.DYGX2-ZCLB", dicWhere); return(DataConverterHelper.EntityListToJson <ExpenseCategoryModel>(result.Results, (Int32)result.TotalItems)); }
/// <summary> /// 不删除设置对应关系 /// </summary> /// <param name="ProductBZ"></param> /// <returns></returns> public CommonResult SaveByProductNoDelete(string ProductBZ) { CommonResult result = new CommonResult(); try { Dictionary <string, object> dic = new Dictionary <string, object>(); new CreateCriteria(dic).Add(ORMRestrictions <EnumUserStatus> .Eq("Status", EnumUserStatus.Activate)); //var Users = UserFacade.FacadeHelper.LoadWithPageInfinity("GQT.QT.GetAllUsers", dic2); var Users = UserFacade.Find(dic).Data; for (var i = 0; i < Users.Count; i++) { User2Model user = Users[i]; Dictionary <string, object> dic2 = new Dictionary <string, object>(); new CreateCriteria(dic2).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ)) .Add(ORMRestrictions <string> .Eq("Fg3userno", user.UserNo)); var IfDYGX = base.Find(dic2).Data; Dictionary <string, object> dic3 = new Dictionary <string, object>(); new CreateCriteria(dic3).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ)) .Add(ORMRestrictions <string> .Eq("ProductUserCode", user.UserNo)); var IfUser = QTProductUserFacade.Find(dic3).Data; if (IfDYGX.Count == 0 && IfUser.Count > 0) { QTProductUserModel qTProductUserModel = IfUser[0]; QTProductUserDygxModel qTProductUserDygxModel = new QTProductUserDygxModel { ProductBZ = ProductBZ, ProductUserCode = user.UserNo, ProductPhid = qTProductUserModel.ProductPhid, ProductUserPhid = qTProductUserModel.PhId, ProductUserName = qTProductUserModel.ProductUserName, ProductUserPwd = qTProductUserModel.ProductUserPwd, Fg3userPhid = user.PhId, Fg3userno = user.UserNo, Fg3username = user.UserName, PersistentState = PersistentState.Added }; base.Save <Int64>(qTProductUserDygxModel, ""); } } } catch (Exception e) { result.Status = ResponseStatus.Error; result.Msg = "同步失败!"; } return(result); }
/// <summary> /// 取列表数据 /// </summary> /// <returns>返回Json串</returns> public string GetQTProductUserList() { /*string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"];//查询条件 * Dictionary<string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery);//查询条件转Dictionary*/ string ProductBZ = System.Web.HttpContext.Current.Request.Params["ProductBZ"]; Dictionary <string, object> dicWhere = new Dictionary <string, object>(); if (ProductBZ != null && ProductBZ.Length > 0) { new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ)); } DataStoreParam storeparam = this.GetDataStoreParam(); var result = QTProductUserService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere); return(DataConverterHelper.EntityListToJson <QTProductUserModel>(result.Results, (Int32)result.TotalItems)); }
/// <summary> /// 判断是否有明细 /// </summary> /// <param name="id"></param> /// <returns></returns> public Boolean JudgeHaveDtl(long id) { QtBaseProjectModel qtBaseProjectModel = base.Find(id).Data; var dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere). Add(ORMRestrictions <string> .Eq("FProjCode", qtBaseProjectModel.FProjCode)); if (SubjectMstBudgetDtlFacade.Find(dicWhere).Data.Count > 0) { return(true); } else { return(false); } }
/// <summary> /// 根据组织代码串得到组织(非) /// </summary> /// <param name="OrgStr"></param> /// <returns></returns> public IList <OrganizeModel> GetNoUseOrg(string OrgStr) { var dicWhere = new Dictionary <string, object>(); if (!string.IsNullOrEmpty(OrgStr)) { var OrgCodeList = OrgStr.Split(',').ToList(); new CreateCriteria(dicWhere) .Add(ORMRestrictions <List <string> > .NotIn("OCode", OrgCodeList)); } new CreateCriteria(dicWhere) .Add(ORMRestrictions <string> .Eq("IfCorp", "Y")); var result = OrganizationFacade.Find(dicWhere, new string[] { "OCode Asc" }).Data; return(result); }
///// <summary> ///// 方法实例 ///// </summary> ///// <returns></returns> //public IList<PerformEvalTargetTypeModel> ExampleMethod<PerformEvalTargetTypeModel>(string param) //{ // //编写代码 //} /// <summary> /// 通过代码找名称 /// </summary> /// <param name="Dm"></param> /// <returns></returns> public string FindMcByDm(string Dm) { var dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere) .Add(ORMRestrictions <string> .Eq("FCode", Dm)); IList <PerformEvalTargetTypeModel> performEvalTargetTypes = PerformEvalTargetTypeRule.Find(dicWhere); if (performEvalTargetTypes.Count > 0) { return(performEvalTargetTypes[0].FName); } else { return(""); } }
/// <summary> /// 通过代码找名称 /// </summary> /// <param name="Dm"></param> /// <returns></returns> public string FindMcByDm(string Dm) { var dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere) .Add(ORMRestrictions <string> .Eq("OCode", Dm)); IList <OrganizeModel> organizes = OrganizationRule.Find(dicWhere); if (organizes.Count > 0) { return(organizes[0].OName); } else { return(""); } }
///// <summary> ///// 方法实例 ///// </summary> ///// <returns></returns> //public IList<BudgetAccountsModel> ExampleMethod<BudgetAccountsModel>(string param) //{ // //编写代码 //} /// <summary> /// 通过代码找名称 /// </summary> /// <param name="Dm"></param> /// <returns></returns> public string FindMcByDm(string Dm) { var dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere) .Add(ORMRestrictions <string> .Eq("KMDM", Dm)); IList <BudgetAccountsModel> budgetAccounts = BudgetAccountsRule.Find(dicWhere); if (budgetAccounts.Count > 0) { return(budgetAccounts[0].KMMC); } else { return(""); } }
/// <summary> /// 根据多个单据号删除多条单据以及单据明细 /// </summary> /// <param name="fCodes">多个单据号</param> /// <returns></returns> public int DeleteSignle(List <long> fCodes) { int deletedResult = 0; Dictionary <string, object> dic = new Dictionary <string, object>(); new CreateCriteria(dic) .Add(ORMRestrictions <List <long> > .In("PhId", fCodes)); var result = this.PaymentMstRule.Find(dic); if (result != null && result.Count > 0) { //删除单据主表 deletedResult = this.PaymentMstRule.Delete(dic); var mstIdList = result.ToList().Select(t => t.PhId).ToList(); dic.Clear(); new CreateCriteria(dic) .Add(ORMRestrictions <List <long> > .In("MstPhid", mstIdList)); var result2 = this.PaymentXmRule.Find(dic); if (result2 != null && result2.Count > 0) { //删除单据集合对应的项目表 deletedResult = this.PaymentXmRule.Delete(dic); var xmIdList = result2.ToList().Select(t => t.PhId).ToList(); //删除明细 dic.Clear(); new CreateCriteria(dic) .Add(ORMRestrictions <List <long> > .In("PayXmPhid", xmIdList)); var result3 = this.PaymentDtlRule.Find(dic); if (result3 != null && result3.Count > 0) { deletedResult = this.PaymentDtlRule.Delete(dic); } //根据项目集合删除附件 dic.Clear(); new CreateCriteria(dic) .Add(ORMRestrictions <List <long> > .In("RelPhid", xmIdList)) .Add(ORMRestrictions <string> .Eq("BTable", "BK3_PAYMENT_XM")); var result4 = this.QtAttachmentRule.Find(dic); if (result4 != null && result4.Count > 0) { deletedResult = this.QtAttachmentRule.Delete(dic); } } } return(deletedResult); }
/// <summary> /// 根据项目代码取预计支出金额的和 /// </summary> /// <param name="FProjCode"></param> /// <returns></returns> public string SumFSurplusamount(string FProjCode) { var dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FProjcode", FProjCode)) .Add(ORMRestrictions <System.Int32> .Eq("FLifeCycle", 0)) .Add(ORMRestrictions <System.Int32> .NotEq("FIfpurchase", 1)); //是否额度返还 var findedresultmst = base.Find(dicWhere).Data; Decimal Sum = 0; for (var i = 0; i < findedresultmst.Count; i++) { Sum += findedresultmst[i].FSurplusamount; Sum -= findedresultmst[i].FReturnamount; } return(Sum.ToString()); }
///// <summary> ///// 方法实例 ///// </summary> ///// <returns></returns> //public IList<QtZcgnflModel> ExampleMethod<QtZcgnflModel>(string param) //{ // //编写代码 //} /// <summary> /// 通过代码找名称 /// </summary> /// <param name="Dm"></param> /// <returns></returns> public string FindMcByDm(string Dm) { var dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere) .Add(ORMRestrictions <string> .Eq("KMDM", Dm)); IList <QtZcgnflModel> qtZcgnfls = QtZcgnflRule.Find(dicWhere); if (qtZcgnfls.Count > 0) { return(qtZcgnfls[0].KMMC); } else { return(""); } }