/// <summary>
/// 根据主键获取数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetQTModifyInfo()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
string tabtype = System.Web.HttpContext.Current.Request.Params["tabtype"]; //Tab类型
var findedresult = QTModifyService.Find(id);
return DataConverterHelper.ResponseResultToJson(findedresult);
}
/// <summary>
/// 根据主键获取数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetPerformEvalTargetTypeInfo()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
string tabtype = System.Web.HttpContext.Current.Request.Params["tabtype"]; //Tab类型
var findedresult = PerformEvalTargetTypeService.Find(id);
return(DataConverterHelper.ResponseResultToJson(findedresult));
}
/// <summary>
/// 获取产品用户通过产品标识和G6账号
/// </summary>
/// <returns></returns>
public string getUserByProduct()
{
string ProductBZ = System.Web.HttpContext.Current.Request.Params["ProductBZ"];
string UserNo = System.Web.HttpContext.Current.Request.Params["UserNo"];
QTProductUserModel qTProductUser = QTProductUserService.getUserByProduct(ProductBZ, UserNo);
return(DataConverterHelper.ResponseResultToJson(qTProductUser));
}
/// <summary>
/// 根据标志获取产品详细
/// </summary>
/// <returns></returns>
public string GetQTProductByBZ()
{
string ProductBZ = System.Web.HttpContext.Current.Request.Params["ProductBZ"];
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ));
var findedresult = QTProductService.Find(dic).Data[0];
return(DataConverterHelper.ResponseResultToJson(findedresult));
}
/// <summary>
/// 根据主键获取数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetMethodAroundMstInfo()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
string tabtype = System.Web.HttpContext.Current.Request.Params["tabtype"]; //Tab类型
//var findedresult = MethodAroundMstService.Find<Int64>(id);
var findedresult = MethodAroundMstService.GetMethodAroundMst(id);
return(DataConverterHelper.ResponseResultToJson(findedresult));
}
/// <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>
/// <returns>返回Json串</returns>
public string GetQTProjectMstInfo()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
string tabtype = System.Web.HttpContext.Current.Request.Params["tabtype"]; //Tab类型
switch (tabtype)
{
case "qtprojectmst":
var findedresultqtprojectmst = QTProjectMstService.Find(id);
return(DataConverterHelper.ResponseResultToJson(findedresultqtprojectmst));
case "qtprojectdtlbudgetdtl":
var findedresultqtprojectdtlbudgetdtl = QTProjectMstService.FindQTProjectDtlBudgetDtlByForeignKey(id);
return(DataConverterHelper.EntityListToJson(findedresultqtprojectdtlbudgetdtl.Data, findedresultqtprojectdtlbudgetdtl.Data.Count));
case "qtprojectdtlfundappl":
var findedresultqtprojectdtlfundappl = QTProjectMstService.FindQTProjectDtlFundApplByForeignKey(id);
return(DataConverterHelper.EntityListToJson(findedresultqtprojectdtlfundappl.Data, findedresultqtprojectdtlfundappl.Data.Count));
case "qtprojectdtlimplplan":
var findedresultqtprojectdtlimplplan = QTProjectMstService.FindQTProjectDtlImplPlanByForeignKey(id);
return(DataConverterHelper.EntityListToJson(findedresultqtprojectdtlimplplan.Data, findedresultqtprojectdtlimplplan.Data.Count));
case "qtprojectdtlperformtarget":
var findedresultqtprojectdtlperformtarget = QTProjectMstService.FindQTProjectDtlPerformTargetByForeignKey(id);
return(DataConverterHelper.EntityListToJson(findedresultqtprojectdtlperformtarget.Data, findedresultqtprojectdtlperformtarget.Data.Count));
case "qtprojectdtlpurchasedtl":
var findedresultqtprojectdtlpurchasedtl = QTProjectMstService.FindQTProjectDtlPurchaseDtlByForeignKey(id);
return(DataConverterHelper.EntityListToJson(findedresultqtprojectdtlpurchasedtl.Data, findedresultqtprojectdtlpurchasedtl.Data.Count));
case "qtprojectdtlpurdtl4sof":
var findedresultqtprojectdtlpurdtl4sof = QTProjectMstService.FindQTProjectDtlPurDtl4SOFByForeignKey(id);
return(DataConverterHelper.EntityListToJson(findedresultqtprojectdtlpurdtl4sof.Data, findedresultqtprojectdtlpurdtl4sof.Data.Count));
case "qtprojectdtltextcontent":
var findedresultqtprojectdtltextcontent = QTProjectMstService.FindQTProjectDtlTextContentByForeignKey(id);
return(DataConverterHelper.EntityListToJson(findedresultqtprojectdtltextcontent.Data, findedresultqtprojectdtltextcontent.Data.Count));
default:
FindedResult findedresultother = new FindedResult();
return(DataConverterHelper.ResponseResultToJson(findedresultother));
}
}
/// <summary>
/// 根据主键获取数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetPerformanceMstInfo()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
string tabtype = System.Web.HttpContext.Current.Request.Params["tabtype"]; //Tab类型
switch (tabtype)
{
case "performancemst":
var findedresultperformancemst = PerformanceMstService.Find2(id);
return(DataConverterHelper.ResponseResultToJson(findedresultperformancemst));
case "performancedtleval":
var findedresultsperformancedtleval = PerformanceMstService.FindPerformanceDtlEvalByForeignKey(id);
return(DataConverterHelper.EntityListToJson(findedresultsperformancedtleval.Data, findedresultsperformancedtleval.Data.Count));
case "performancedtltextcont":
var findedresultsperformancedtltextcont = PerformanceMstService.FindPerformanceDtlTextContByForeignKey(id);
PerformanceDtlTextContModel textModel = new PerformanceDtlTextContModel();
if (findedresultsperformancedtltextcont.Data.Count > 0)
{
textModel = findedresultsperformancedtltextcont.Data[0];
}
return(DataConverterHelper.ResponseResultToJson(textModel));
case "performancedtlbudtl":
var findedresultperformancedtlbudtl = PerformanceMstService.FindPerformanceDtlBuDtlByForeignKey(id);
return(DataConverterHelper.EntityListToJson(findedresultperformancedtlbudtl.Data, findedresultperformancedtlbudtl.Data.Count));
case "performancedtltarimpl":
var findedresultperformancedtltarimpl = PerformanceMstService.FindPerformanceDtlTarImplByForeignKey(id);
return(DataConverterHelper.EntityListToJson(findedresultperformancedtltarimpl.Data, findedresultperformancedtltarimpl.Data.Count));
case "thirdattachment":
var findedresultthirdattachment = PerformanceMstService.FindThirdAttachmentByForeignKey(id);
return(DataConverterHelper.EntityListToJson(findedresultthirdattachment.Data, findedresultthirdattachment.Data.Count));
default:
FindedResult findedresultother = new FindedResult();
return(DataConverterHelper.ResponseResultToJson(findedresultother));
}
}
/// <summary>
/// 根据主键获取数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetGKPaymentMstInfo()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
string tabtype = System.Web.HttpContext.Current.Request.Params["tabtype"]; //Tab类型
switch (tabtype)
{
case "gkpaymentmst":
var findedresultgkpaymentmst = GKPaymentMstService.Find(id);
return(DataConverterHelper.ResponseResultToJson(findedresultgkpaymentmst));
case "gkpaymentdtl":
var findedresultgkpaymentdtl = GKPaymentMstService.FindGKPaymentDtlByForeignKey(id);
return(DataConverterHelper.EntityListToJson(findedresultgkpaymentdtl.Data, findedresultgkpaymentdtl.Data.Count));
default:
FindedResult findedresultother = new FindedResult();
return(DataConverterHelper.ResponseResultToJson(findedresultother));
}
}
/// <summary>
/// 根据组织和项目类型取阈值
/// </summary>
/// <returns></returns>
public string GetProjectThresholdByOrgAndZCLB()
{
string Orgcode = System.Web.HttpContext.Current.Request.Params["Orgcode"];
string FExpenseCategoryCode = System.Web.HttpContext.Current.Request.Params["FExpenseCategoryCode"];
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Orgcode", Orgcode));
IList <ProjectThresholdModel> projectThresholds = ProjectThresholdService.Find(dicWhere).Data;
if (projectThresholds.Count > 0)
{
foreach (var projectThreshold in projectThresholds)
{
IList <String> useCodeList = (projectThreshold.ProjTypeId ?? "").Split(',').ToList <String>();
if (useCodeList.Contains(FExpenseCategoryCode))
{
return(DataConverterHelper.ResponseResultToJson(projectThreshold));
}
}
}
return(DataConverterHelper.ResponseResultToJson(new ProjectThresholdModel()));
}
/// <summary>
/// 根据主键 预算数据数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetBudgetMstInfo()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
string tabtype = System.Web.HttpContext.Current.Request.Params["tabtype"]; //Tab类型
switch (tabtype)
{
case "budgetmst":
var findedresultmst = BudgetMstService.Find(id);
FindedResult <PerformanceMstModel> resultmst = new FindedResult <PerformanceMstModel>();
PerformanceMstModel modelmst = new PerformanceMstModel();
if (findedresultmst.Data != null)
{
modelmst.YSMstPhId = findedresultmst.Data.PhId;
modelmst.FProjCode = findedresultmst.Data.FProjCode;
modelmst.FProjName = findedresultmst.Data.FProjName;
modelmst.FDeclarationUnit = findedresultmst.Data.FDeclarationUnit;
modelmst.FDeclarationUnit_EXName = findedresultmst.Data.FDeclarationUnit_EXName;
modelmst.FDeclarationDept = findedresultmst.Data.FDeclarationDept;
modelmst.FBudgetDept = findedresultmst.Data.FBudgetDept;
modelmst.FBudgetDept_EXName = findedresultmst.Data.FBudgetDept_EXName;
modelmst.FProjAttr = findedresultmst.Data.FProjAttr;
modelmst.FDuration = findedresultmst.Data.FDuration;
modelmst.FStartDate = findedresultmst.Data.FStartDate;
modelmst.FEndDate = findedresultmst.Data.FEndDate;
modelmst.FProjAmount = findedresultmst.Data.FBudgetAmount;
modelmst.FIfPerformanceAppraisal = (int)findedresultmst.Data.FIfPerformanceAppraisal;
modelmst.FIfKeyEvaluation = (int)findedresultmst.Data.FIfKeyEvaluation;
modelmst.FMeetingTime = findedresultmst.Data.FMeetingTime;
modelmst.FMeetiingSummaryNo = findedresultmst.Data.FMeetiingSummaryNo;
modelmst.FExpenseCategory = findedresultmst.Data.FExpenseCategory;
modelmst.FPerformType = findedresultmst.Data.FPerformType;
}
;
if (string.IsNullOrEmpty(findedresultmst.Data.FAccount))
{
modelmst.FActualAmount = decimal.Round(0, 2);;
}
else
{
modelmst.FActualAmount = decimal.Round(decimal.Parse(BudgetMstService.GetSJFSSbyXMCode(findedresultmst.Data.FAccount, modelmst.FProjCode)), 2);
}
//modelmst.FActualAmount = decimal.Round(decimal.Parse(BudgetMstService.GetSJFSSbyXMCode(findedresultmst.Data.FAccount, modelmst.FProjCode)),2);
modelmst.FBalanceAmount = decimal.Round(modelmst.FProjAmount - modelmst.FActualAmount, 2);
modelmst.FImplRate = decimal.Round(modelmst.FActualAmount * 100 / modelmst.FProjAmount, 2);
resultmst.Data = modelmst;
resultmst.Status = findedresultmst.Status;
resultmst.Msg = findedresultmst.Msg;
return(DataConverterHelper.ResponseResultToJson(resultmst));
case "budgetdtlbudgetdtl":
var mst = BudgetMstService.Find(id);
var findedresultbudgetdtlbudgetdtl = BudgetMstService.FindBudgetDtlBudgetDtlByForeignKey(id);
var listDtl = findedresultbudgetdtlbudgetdtl.Data;
//组装model
List <PerformanceDtlBuDtlModel> dtlList = new List <PerformanceDtlBuDtlModel>();
if (findedresultbudgetdtlbudgetdtl.Data.Count > 0)
{
foreach (var item in listDtl)
{
var index = dtlList.FindIndex(t => t.FDtlCode == item.FDtlCode);
if (index != -1)
{
dtlList[index].FBudgetAmount += item.FAmount;
}
else
{
decimal FActualAmount = 0;
if (string.IsNullOrEmpty(mst.Data.FAccount))
{
FActualAmount = decimal.Round(0, 2);;
}
else
{
FActualAmount = decimal.Round(decimal.Parse(BudgetMstService.GetSJFSSbyMXCode(mst.Data.FAccount, item.FDtlCode)), 2);
}
//var FActualAmount = decimal.Round(decimal.Parse(BudgetMstService.GetSJFSSbyMXCode(mst.Data.FAccount, item.FDtlCode)),2);
//((parseFloat(upDate.FActualAmount) / parseFloat(upDate.FBudgetAmount)) * 100).toFixed(2)
var FImplRate = decimal.Round(FActualAmount * 100 / item.FBudgetAmount, 2);
PerformanceDtlBuDtlModel model = new PerformanceDtlBuDtlModel()
{
DelPhid = item.PhId,
FDtlCode = item.FDtlCode,
FName = item.FName,
FSourceOfFunds = item.FSourceOfFunds,
FSourceOfFunds_EXName = item.FSourceOfFunds_EXName,
FExpensesChannel_EXName = item.FExpensesChannel_EXName,
FBudgetAmount = item.FBudgetAmount,
FActualAmount = FActualAmount,
FBalanceAmount = decimal.Round(item.FBudgetAmount - FActualAmount, 2),
FImplRate = FImplRate
};
dtlList.Add(model);
}
}
}
return(DataConverterHelper.EntityListToJson((IList <PerformanceDtlBuDtlModel>)dtlList, dtlList.Count));
case "performancedtltarimpl":
var results = BudgetMstService.FindBudgetDtlPerformTargetByForeignKey(id);
IList <PerformanceDtlTarImplModel> tarImplList = PerformanceMstService.ConvertData(results.Data);
return(DataConverterHelper.EntityListToJson(tarImplList, tarImplList.Count));
default:
FindedResult findedresultother = new FindedResult();
return(DataConverterHelper.ResponseResultToJson(findedresultother));
}
}
