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