/// <summary> /// 删除数据 /// </summary> /// <returns>返回Json串</returns> public string Delete() { long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键 FindedResults <ExpenseCategoryModel> expenseCategorys = ExpenseCategoryService.Find(t => t.PhId == id); if (expenseCategorys != null && expenseCategorys.Data.Count > 0) { string dm = expenseCategorys.Data[0].Dm; FindedResults <ProjectMstModel> findedResults1 = ProjectMstService.FindProjectMst(dm); FindedResults <BudgetMstModel> findedResults2 = BudgetMstService.FindBudgetMst(dm); if (findedResults1 != null && findedResults1.Data.Count > 0) { findedResults1.Status = ResponseStatus.Error; findedResults1.Msg = "当前类别已被引用,无法删除!"; return(DataConverterHelper.SerializeObject(findedResults1)); } if (findedResults2 != null && findedResults2.Data.Count > 0) { findedResults2.Status = ResponseStatus.Error; findedResults2.Msg = "当前类别已被引用,无法删除!"; return(DataConverterHelper.SerializeObject(findedResults2)); } } var deletedresult = ExpenseCategoryService.Delete <System.Int64>(id); return(DataConverterHelper.SerializeObject(deletedresult)); }
/// <summary> /// 通过外键值获取PerformanceDtlTarImpl明细数据 /// </summary> /// <param name="id">外键值</param> /// <returns></returns> public FindedResults <PerformanceDtlTarImplModel> FindPerformanceDtlTarImplByForeignKey <TValType>(TValType id) { FindedResults <PerformanceDtlTarImplModel> results = PerformanceDtlTarImplFacade.FindByForeignKey(id); if (results != null) { var data = results.Data; for (int i = 0; i < data.Count; i++) { PerformanceDtlTarImplModel model = data[i]; string typeCode = model.FTargetTypeCode; string classCode = model.FTargetClassCode; Dictionary <string, object> dicWhere1 = new Dictionary <string, object>(); Dictionary <string, object> dicWhere2 = new Dictionary <string, object>(); new CreateCriteria(dicWhere1).Add(ORMRestrictions <string> .Eq("FCode", typeCode)); FindedResults <PerformEvalTargetTypeModel> typeModel = PerformEvalTargetTypeFacade.Find(dicWhere1); new CreateCriteria(dicWhere2).Add(ORMRestrictions <string> .Eq("FCode", classCode)); FindedResults <PerformEvalTargetClassModel> classModel = PerformEvalTargetClassFacade.Find(dicWhere2); if (typeModel != null && typeModel.Data.Count > 0) { model.FTargetTypeCode = typeModel.Data[0].FName; } if (classModel != null && classModel.Data.Count > 0) { model.FTargetClassCode = classModel.Data[0].FName; } } } return(results); }
/// <summary> /// 验证数据 /// </summary> /// <returns></returns> public FindedResults <PerformEvalTargetTypeModel> ExecuteDataCheck(ref List <PerformEvalTargetTypeModel> performEvalTargetType, string otype) { IList <string> dm = new List <string>(); FindedResults <PerformEvalTargetTypeModel> results = new FindedResults <PerformEvalTargetTypeModel>(); if (performEvalTargetType == null) { results.Status = ResponseStatus.Error; results.Msg = "保存失败,数据异常!"; } else { for (int i = 0; i < performEvalTargetType.Count; i++) { performEvalTargetType[i].FCode = performEvalTargetType[i].FCode.Replace(" ", ""); performEvalTargetType[i].FName = performEvalTargetType[i].FName.Replace(" ", ""); performEvalTargetType[i].FRemark.Trim(); dm.Add(performEvalTargetType[i].FCode); } var dicWhere1 = new Dictionary <string, object>(); new CreateCriteria(dicWhere1). Add(ORMRestrictions <IList <string> > .In("FCode", dm)); if (base.Find(dicWhere1) != null && base.Find(dicWhere1).Data.Count > 0 && otype != "edit") { results = base.Find(dicWhere1); results.Status = ResponseStatus.Error; results.Msg = "保存失败,代码重复!"; } } return(results); }
/// <summary> /// 获取最大项目库编码 /// </summary> /// <param name="year"></param> /// <returns></returns> public string CreateOrGetMaxProjCode(string year) { string projCode = ""; QtSysCodeSeqModel seqM = null; var dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FYear", year)) .Add(ORMRestrictions <string> .Eq("FCode", "ProjCode")).Add(ORMRestrictions <string> .Eq("FTname", "z_qtxmdistribute")); FindedResults <QtSysCodeSeqModel> sysCodeSeqResult = QtSysCodeSeqFacade.Find(dicWhere); // FindedResults<QtSysCodeSeqModel> sysCodeSeqResult = QtSysCodeSeqFacade.Find(t => t.FYear == year && t.FCode== "ProjCode" && t.FTname== "xm3_projectmst"); if (sysCodeSeqResult.Status == ResponseStatus.Success) { //插入或更新项目代码编码序号 if (sysCodeSeqResult.Data.Count > 0) { seqM = sysCodeSeqResult.Data[0]; if (string.IsNullOrWhiteSpace(seqM.FSeqNO)) { projCode = year + string.Format("{0:D8}", 1); } else { var max = Int64.Parse(seqM.FSeqNO.Substring(4)); max = max + 1; projCode = year + string.Format("{0:D8}", max); } seqM.FSeqNO = projCode; //更新代码,访问一次后就加1,后续不还原,一直累加 seqM.PersistentState = PersistentState.Modified; } else { //系统编码不存在 projCode = year + string.Format("{0:D8}", 1); seqM = new QtSysCodeSeqModel { FYear = year, FCode = "ProjCode", FName = "项目分发编码序号", FTname = "z_qtxmdistribute", FSeqNO = projCode, PersistentState = SUP.Common.Base.PersistentState.Added }; } SavedResult <Int64> saveResult = QtSysCodeSeqFacade.Save <Int64>(seqM); } else { projCode = year + string.Format("{0:D8}", 1); } return(projCode); }
/// <summary> /// 根据预算部门查找部门所在预算进度 /// </summary> /// <param name="deptCode"></param> /// <returns></returns> public FindedResults <BudgetProcessCtrlModel> FindBudgetProcessCtrlByList(List <string> deptCode, string FYear) { Dictionary <string, object> dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere).Add(ORMRestrictions <IList <String> > .In("FDeptCode", deptCode)).Add(ORMRestrictions <String> .Eq("FYear", FYear)); FindedResults <BudgetProcessCtrlModel> results = base.ServiceHelper.Find <BudgetProcessCtrlModel>(dicWhere); return(results); }
/// <summary> /// 通过外关联的单主键值,获取数据 /// </summary> /// <param name="id">外键值</param> /// <returns>实体</returns> public override FindedResults <PerformanceDtlBuDtlModel> FindByForeignKey <TValType>(TValType id, params string[] sorts) { FindedResults <PerformanceDtlBuDtlModel> findedResults = base.FindByForeignKey(id, sorts); #region 明细Grid代码转名称 RichHelpDac helpdac = new RichHelpDac(); //helpdac.CodeToName<PerformanceDtlBuDtlModel>(findedResults.Data, "属性名", "注册的帮助标识" //helpdac.CodeToName<PerformanceDtlBuDtlModel>(findedResults.Data, "Code属性名", "Name属性名", "注册的帮助标识", ""); helpdac.CodeToName <PerformanceDtlBuDtlModel>(findedResults.Data, "FSourceOfFunds", "FSourceOfFunds_EXName", "GHSourceOfFunds", ""); #endregion return(findedResults); }
/// <summary> /// 通过外关联的单主键值,获取数据 /// </summary> /// <param name="id">外键值</param> /// <returns>实体</returns> public override FindedResults <JxTrackingModel> FindByForeignKey <TValType>(TValType id, params string[] sorts) { FindedResults <JxTrackingModel> findedResults = base.FindByForeignKey(id, sorts); #region 明细Grid代码转名称 RichHelpDac helpdac = new RichHelpDac(); //helpdac.CodeToName<JxTrackingModel>(findedResults.Data, "属性名", "注册的帮助标识" //helpdac.CodeToName<JxTrackingModel>(findedResults.Data, "Code属性名", "Name属性名", "注册的帮助标识", ""); helpdac.CodeToName <JxTrackingModel>(findedResults.Data, "FDeclarationUnit", "FDeclarationUnit_EXName", "sb_orglist", ""); #endregion return(findedResults); }
/// <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> /// <param name="dicWhere"></param> /// <param name="sorts"></param> /// <returns></returns> public override FindedResults <QTProjectMstModel> Find(Dictionary <string, object> dicWhere, params string[] sorts) { FindedResults <QTProjectMstModel> Result = base.Find(dicWhere, sorts); #region 列表Grid代码转名称 RichHelpDac helpdac = new RichHelpDac(); helpdac.CodeToName <QTProjectMstModel>(Result.Data, "FDeclarationDept", "FDeclarationDept_EXName", "ys_orglist2", ""); helpdac.CodeToName <QTProjectMstModel>(Result.Data, "FBudgetDept", "FBudgetDept_EXName", "ys_orglist", ""); helpdac.CodeToName <QTProjectMstModel>(Result.Data, "FExpenseCategory", "FExpenseCategory_EXName", "GHExpenseCategory", ""); helpdac.CodeToName <QTProjectMstModel>(Result.Data, "FDtlstage", "FDtlstage_EXName", "gh_DtlStage", ""); //helpdac.CodeToName<QTProjectMstModel>(Result.Data, "FAccount", "FAccount_EXName", "gh_Account", ""); #endregion return(Result); }
/// <summary> /// 取列表数据 /// </summary> /// <returns>List</returns> public IList <BudgetProcessCtrlModel> FindBudgetProcessCtrlModelByList(List <BudgetProcessCtrlModel> list) { List <Int64> ids = new List <long>(); for (int i = 0; i < list.Count; i++) { ids.Add(list[i].PhId); } Dictionary <string, object> dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere).Add(ORMRestrictions <List <Int64> > .In("PhId", ids)); FindedResults <BudgetProcessCtrlModel> results = base.ServiceHelper.Find <BudgetProcessCtrlModel>(dicWhere); return(results.Data); }
/// <summary> /// SubjectMstBudgetDtl业务逻辑处理对象 /// </summary> //ISubjectMstBudgetDtlRule SubjectMstBudgetDtlRule { get; set; } #endregion #region 重载方法 /// <summary> /// 通过外关联的单主键值,获取数据 /// </summary> /// <param name="id">外键值</param> /// <returns>实体</returns> public override FindedResults <SubjectMstBudgetDtlModel> FindByForeignKey <TValType>(TValType id, params string[] sorts) { FindedResults <SubjectMstBudgetDtlModel> findedResults = base.FindByForeignKey(id, sorts); #region 明细Grid代码转名称 RichHelpDac helpdac = new RichHelpDac(); //helpdac.CodeToName<SubjectMstBudgetDtlModel>(findedResults.Data, "属性名", "注册的帮助标识" //helpdac.CodeToName<SubjectMstBudgetDtlModel>(findedResults.Data, "Code属性名", "Name属性名", "注册的帮助标识", ""); helpdac.CodeToName <SubjectMstBudgetDtlModel>(findedResults.Data, "FDeclarationUnit", "FDeclarationUnit_EXName", "sb_orglist", ""); helpdac.CodeToName <SubjectMstBudgetDtlModel>(findedResults.Data, "FExpensesChannel", "FExpensesChannel_EXName", "GHExpensesChannel", ""); helpdac.CodeToName <SubjectMstBudgetDtlModel>(findedResults.Data, "FBudgetDept", "FBudgetDept_EXName", "ys_orglist", ""); #endregion return(findedResults); }
/// <summary> /// 通过外关联的单主键值,获取数据 /// </summary> /// <param name="id">外键值</param> /// <returns>实体</returns> public override FindedResults <ProjectDtlPurchaseDtlModel> FindByForeignKey <TValType>(TValType id, params string[] sorts) { FindedResults <ProjectDtlPurchaseDtlModel> findedResults = base.FindByForeignKey(id, sorts); #region 明细Grid代码转名称 RichHelpDac helpdac = new RichHelpDac(); //helpdac.CodeToName<ProjectDtlPurchaseDtlModel>(findedResults.Data, "属性名", "注册的帮助标识" //helpdac.CodeToName<ProjectDtlPurchaseDtlModel>(findedResults.Data, "Code属性名", "Name属性名", "注册的帮助标识", ""); helpdac.CodeToName <ProjectDtlPurchaseDtlModel>(findedResults.Data, "FCatalogCode", "FCatalogCode_EXName", "GHProcurementCatalog", ""); helpdac.CodeToName <ProjectDtlPurchaseDtlModel>(findedResults.Data, "FTypeCode", "FTypeCode_EXName", "GHProcurementType", ""); helpdac.CodeToName <ProjectDtlPurchaseDtlModel>(findedResults.Data, "FProcedureCode", "FProcedureCode_EXName", "GHProcurementProcedures", ""); #endregion return(findedResults); }
/// <summary> /// 通过外关联的单主键值,获取数据 /// </summary> /// <param name="id">外键值</param> /// <returns>实体</returns> public override FindedResults <ExpenseDtlModel> FindByForeignKey <TValType>(TValType id, params string[] sorts) { FindedResults <ExpenseDtlModel> findedResults = base.FindByForeignKey(id, sorts); #region 明细Grid代码转名称 RichHelpDac helpdac = new RichHelpDac(); //helpdac.CodeToName<ExpenseDtlModel>(findedResults.Data, "属性名", "注册的帮助标识" //helpdac.CodeToName<ExpenseDtlModel>(findedResults.Data, "Code属性名", "Name属性名", "注册的帮助标识", ""); helpdac.CodeToName <ExpenseDtlModel>(findedResults.Data, "FSourceoffunds", "FSourceoffunds_EXName", "GHSourceOfFunds", ""); helpdac.CodeToName <ExpenseDtlModel>(findedResults.Data, "FBudgetaccounts", "FBudgetaccounts_EXName", "GHBudgetAccounts", ""); helpdac.CodeToName <ExpenseDtlModel>(findedResults.Data, "FPaymentmethod", "FPaymentmethod_EXName", "GHPaymentMethod", ""); helpdac.CodeToName <ExpenseDtlModel>(findedResults.Data, "FExpenseschannel", "FExpenseschannel_EXName", "GHExpensesChannel", ""); #endregion return(findedResults); }
/// <summary> /// 通过外关联的单主键值,获取数据 /// </summary> /// <param name="id">外键值</param> /// <returns>实体</returns> public override FindedResults<SubjectMstModel> FindByForeignKey<TValType>(TValType id, params string[] sorts) { FindedResults<SubjectMstModel> findedResults = base.FindByForeignKey(id, sorts); #region 明细Grid代码转名称 RichHelpDac helpdac = new RichHelpDac(); //helpdac.CodeToName<SubjectMstModel>(findedResults.Data, "属性名", "注册的帮助标识" //helpdac.CodeToName<SubjectMstModel>(findedResults.Data, "Code属性名", "Name属性名", "注册的帮助标识", ""); helpdac.CodeToName<SubjectMstModel>(findedResults.Data, "FDeclarationUnit", "FDeclarationUnit_EXName", "sb_orglist", ""); helpdac.CodeToName<SubjectMstModel>(findedResults.Data, "FBudgetDept", "FBudgetDept_EXName", "ys_orglist", ""); helpdac.CodeToName<SubjectMstModel>(findedResults.Data, "FFillDept", "FFillDept_EXName", "ys_orglist", ""); helpdac.CodeToName<SubjectMstModel>(findedResults.Data, "FSubjectCode", "FSubjectName", "GHBudgetAccounts", ""); helpdac.CodeToName<SubjectMstModel>(findedResults.Data, "FProjCode", "FProjName", "GHSubjectName", ""); #endregion return findedResults; }
/// <summary> /// 取列表数据 /// </summary> /// <returns>返回Json串</returns> public PagedResult <BudgetProcessCtrlModel> GetBudgetProcessCtrlDistinctList(DataStoreParam storeParam, string query, string userId) { Dictionary <string, object> dicWhere = new Dictionary <string, object>(); Dictionary <string, object> dicWhere1 = new Dictionary <string, object>(); Dictionary <string, object> dicWhere2 = new Dictionary <string, object>(); /*if (query != null && query != "") * { * new CreateCriteria(dicWhere1).Add(ORMRestrictions<string>.Eq("FOcode", query)); * new CreateCriteria(dicWhere2).Add(ORMRestrictions<string>.Eq("FOname", query)); * new CreateCriteria(dicWhere).Add(ORMRestrictions.Or(dicWhere1, dicWhere2)); * }*/ if (userId != null && userId != "") { //根据用户id查出所有组织 long userid = Convert.ToInt64(userId); new CreateCriteria(dicWhere1).Add(ORMRestrictions <Int64> .Eq("UserId", userid)); FindedResults <UserOrganize2Model> findedResult = UserOrgFacade.Find(dicWhere1); List <long> orgIds = new List <long>(); for (int i = 0; i < findedResult.Data.Count; i++) { orgIds.Add(findedResult.Data[i].OrgId); } //根据组织id,查出所有的组织code new CreateCriteria(dicWhere2) .Add(ORMRestrictions <List <Int64> > .In("PhId", orgIds)) .Add(ORMRestrictions <string> .Eq("IfCorp", "Y")); FindedResults <OrganizeModel> findedResult2 = OrganizationFacade.Find(dicWhere2); List <string> orgCodes = new List <string>(); for (int i = 0; i < findedResult2.Data.Count; i++) { orgCodes.Add(findedResult2.Data[i].OCode); } new CreateCriteria(dicWhere).Add(ORMRestrictions <List <string> > .In("FOcode", orgCodes)); } var result = base.ServiceHelper.LoadWithPageInfinity("GQT.QT.GetAllProcessSetting", dicWhere); IList <BudgetProcessCtrlModel> processCtrlModels = result.Results; List <BudgetProcessCtrlModel> distinctList = processCtrlModels.GroupBy(r => r.FOcode).Select(r => r.First()).ToList(); result.Results = distinctList; result.TotalItems = distinctList.Count; return(result); }
/// <summary> /// 获取审批流程明细 /// </summary> /// <param name="approvalTypeId">审批类型id</param> /// <param name="bType">单据类型</param> /// <param name="proc_code">审批流程编码</param> /// <param name="orgids">组织id集合</param> /// <returns></returns> public GAppvalProcModel GetProcDetail(long approvalTypeId, string bType, string proc_code, List <long> orgids) { //获取审批流程 List <GAppvalProcModel> procModels = GAppvalProcFacade.GetAppvalProc(orgids, bType, approvalTypeId); if (procModels == null || procModels.Count == 0) { throw new Exception("审批流程为空!"); } else { procModels = procModels.FindAll(t => t.FCode == proc_code); } List <Organize> organizes = new List <Organize>(); foreach (GAppvalProcModel model in procModels) { Organize organize = new Organize(); organize.OrgId = model.OrgPhid; organize.OrgCode = model.OrgCode; organize.OrgName = model.OrgName; organizes.Add(organize); } GAppvalProcModel procModel = procModels[0]; procModel.Organizes = organizes; //获取审批流程对应的审批岗位 List <GAppvalPostModel> postModels = GAppvalPostFacade.FindAppvalPostByProcID(procModel.PhId); procModel.PostModels = postModels; //获取审批流程的启用条件 FindedResults <GAppvalProcCondsModel> findedResults = GAppvalProcCondsFacade.Find(t => t.ProcPhid == procModel.PhId); if (findedResults != null && findedResults.Data != null && findedResults.Data.Count > 0) { List <GAppvalProcCondsModel> procCondsModels = findedResults.Data.ToList(); procModel.CondsModels = procCondsModels; } return(procModel); }
/// <summary> /// 删除数据 /// </summary> /// <returns>返回Json串</returns> public string Delete() { long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键 FindedResults <ProcurementTypeModel> procurementType = ProcurementTypeService.Find(t => t.PhId == id, ""); string FTypeCode = procurementType.Data[0].FCode; FindedResults <ProjectDtlPurchaseDtlModel> findedResults = ProjectMstService.FindProjectDtlPurchaseDtlByFTypeCode(FTypeCode); if (findedResults.Data.Count > 0) { findedResults.Status = "failure"; findedResults.Msg = "当前采购类型已被引用,无法删除!"; return(DataConverterHelper.SerializeObject(findedResults)); } var deletedresult = ProcurementTypeService.Delete <System.Int64>(id); return(DataConverterHelper.SerializeObject(deletedresult)); }
/// <summary> /// 验证数据 /// </summary> /// <returns></returns> public FindedResults <PaymentMethodModel> ExecuteDataCheck(ref List <PaymentMethodModel> paymentMethods, string otype) { FindedResults <PaymentMethodModel> results = new FindedResults <PaymentMethodModel>(); List <string> dm = new List <string>(); List <string> mc = new List <string>(); if (paymentMethods == null) { results.Status = ResponseStatus.Error; results.Msg = "保存失败,数据异常!"; } else { for (int i = 0; i < paymentMethods.Count; i++) { paymentMethods[i].Dm = paymentMethods[i].Dm.Replace(" ", ""); paymentMethods[i].Mc = paymentMethods[i].Mc.Replace(" ", ""); dm.Add(paymentMethods[i].Dm); mc.Add(paymentMethods[i].Mc); } Dictionary <string, object> dicWhere1 = new Dictionary <string, object>(); Dictionary <string, object> dicWhere2 = new Dictionary <string, object>(); new CreateCriteria(dicWhere1).Add(ORMRestrictions <IList <string> > .In("Dm", dm)); new CreateCriteria(dicWhere2).Add(ORMRestrictions <IList <string> > .In("Mc", mc)); results = base.Find(dicWhere1); if (results.Data.Count > 0 && results.Data[0] != null && otype != "edit") { results.Status = ResponseStatus.Error; results.Msg = "保存失败,代码重复!"; return(results); } results = base.Find(dicWhere2); if (results.Data.Count > 0 && results.Data[0] != null && otype != "edit") { results.Status = ResponseStatus.Error; results.Msg = "保存失败,名称重复!"; return(results); } } return(results); }
/// <summary> /// 删除数据 /// </summary> /// <returns>返回Json串</returns> public string Delete() { long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键 FindedResults <SourceOfFundsModel> sourceOfFunds = SourceOfFundsService.Find(t => t.PhId == id, ""); string DM = sourceOfFunds.Data[0].DM; FindedResults <BudgetDtlBudgetDtlModel> findedResults = BudgetMstService.FindBudgeAccountByZJDM(DM); FindedResults <ProjectDtlBudgetDtlModel> findedResults2 = ProjectMstService.FindProjectDtlBudgetDtlMstByZJDM(DM); if (findedResults.Data.Count > 0 || findedResults2.Data.Count > 0) { findedResults.Status = "failure"; findedResults.Msg = "当前资金来源已被引用,无法删除!"; return(DataConverterHelper.SerializeObject(findedResults)); } var deletedresult = SourceOfFundsService.Delete <System.Int64>(id); return(DataConverterHelper.SerializeObject(deletedresult)); }
/// <summary> /// BudgetDtlPerformTargetModel转换成PerformanceDtlTarImplModel /// </summary> /// <param name="list">预算绩效目标实现集合</param> /// <returns></returns> public IList <PerformanceDtlTarImplModel> ConvertData(IList <BudgetDtlPerformTargetModel> list) { IList <PerformanceDtlTarImplModel> result = new List <PerformanceDtlTarImplModel>(); if (list != null) { for (int i = 0; i < list.Count; i++) { BudgetDtlPerformTargetModel budgetModel = list[i]; PerformanceDtlTarImplModel performModel = new PerformanceDtlTarImplModel(); performModel.XmPhid = budgetModel.XmPhId; performModel.FTargetCode = budgetModel.FTargetCode; performModel.FTargetName = budgetModel.FTargetName; performModel.FTargetContent = budgetModel.FTargetContent; performModel.FTargetValue = budgetModel.FTargetValue; performModel.FTargetWeight = Convert.ToDecimal(budgetModel.FTargetWeight); performModel.FTargetDescribe = budgetModel.FTargetDescribe; //代码转名称 string typeCode = budgetModel.FTargetTypeCode; string classCode = budgetModel.FTargetClassCode; Dictionary <string, object> dicWhere1 = new Dictionary <string, object>(); Dictionary <string, object> dicWhere2 = new Dictionary <string, object>(); new CreateCriteria(dicWhere1).Add(ORMRestrictions <string> .Eq("FCode", typeCode)); FindedResults <PerformEvalTargetTypeModel> typeModel = PerformEvalTargetTypeFacade.Find(dicWhere1); new CreateCriteria(dicWhere2).Add(ORMRestrictions <string> .Eq("FCode", classCode)); FindedResults <PerformEvalTargetClassModel> classModel = PerformEvalTargetClassFacade.Find(dicWhere2); if (typeModel != null && typeModel.Data.Count > 0) { performModel.FTargetTypeCode = typeModel.Data[0].FName; } if (classModel != null && classModel.Data.Count > 0) { performModel.FTargetClassCode = classModel.Data[0].FName; } performModel.FIfCustom = budgetModel.FIfCustom; result.Add(performModel); } } return(result); }
/// <summary> /// 指标类别转名称 /// </summary> /// <param name="result"></param> /// <returns></returns> public PagedResult <PerformEvalTargetModel> CodeToName(PagedResult <PerformEvalTargetModel> result) { if (result != null) { for (var i = 0; i < result.Results.Count; i++) { Dictionary <string, object> dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FCode", result.Results[i].FTargetClassCode)); FindedResults <PerformEvalTargetClassModel> PerformEvalTargetClassModel = PerformEvalTargetClassFacade.Find(dicWhere); if (PerformEvalTargetClassModel != null && PerformEvalTargetClassModel.Data.Count > 0) { result.Results[i].FTargetClassCode = PerformEvalTargetClassModel.Data[0].FName; } if (result.Results[i].FTargetWeight != null) { result.Results[i].FTargetWeight = result.Results[i].FTargetWeight + "%"; } } } return(result); }
/// <summary> /// 获取项目树数据 /// </summary> /// <param name="nodeid"></param> /// <returns></returns> public IList <TreeJSONBase> GetTreeData(string nodeid) { FindedResults <PerformEvalTargetTypeModel> results = null; if (string.IsNullOrEmpty(nodeid) || nodeid == "root") { results = PerformEvalTargetTypeService.Find(t => t.FParentCode == null || t.FParentCode == ""); } else { results = PerformEvalTargetTypeService.Find(t => t.FParentCode == nodeid); } if (results.Data.Count > 0) { DataTable dt = new DataTable(); dt.Columns.Add("PhId", typeof(System.String)); dt.Columns.Add("FCode", typeof(System.String)); dt.Columns.Add("FName", typeof(System.String)); dt.Columns.Add("FParentCode", typeof(System.String)); DataRow dr = null; foreach (var m in results.Data) { dr = dt.NewRow(); dr["PhId"] = m.PhId; dr["FCode"] = m.FCode; dr["FName"] = m.FName; dr["FParentCode"] = m.FParentCode; dt.Rows.Add(dr); } string filter = string.Empty; return(new PerformEvalTargetTypeTreeBuilder().GetExtTreeList(dt, "FParentCode", "FCode", filter, TreeDataLevelType.LazyLevel)); } return(null); }
/// <summary> /// 删除数据 /// </summary> /// <returns>返回Json串</returns> public string Delete() { long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键 FindedResults <BudgetAccountsModel> budgetAccounts = BudgetAccountsService.Find(t => t.PhId == id, ""); if (budgetAccounts != null && budgetAccounts.Data.Count > 0) { string kmdm = budgetAccounts.Data[0].KMDM; FindedResults <BudgetDtlBudgetDtlModel> findedResults = BudgetMstService.FindBudgeAccount(kmdm); if (findedResults != null && findedResults.Data.Count > 0) { findedResults.Status = ResponseStatus.Error; findedResults.Msg = "当前科目已被引用,无法删除!"; return(DataConverterHelper.SerializeObject(findedResults)); } } var deletedresult = BudgetAccountsService.Delete <System.Int64>(id); return(DataConverterHelper.SerializeObject(deletedresult)); }