/// <summary>
/// 保存数据
/// </summary>
/// <returns>返回Json串</returns>
public string Save()
{
string expensemstformData = System.Web.HttpContext.Current.Request.Form["expensemstformData"];
string expensedtlgridData = System.Web.HttpContext.Current.Request.Form["expensedtlgridData"];
string NCmoney = System.Web.HttpContext.Current.Request.Params["NCmoney"]; //年初预算金额
string beforeSum = System.Web.HttpContext.Current.Request.Params["beforeSum"]; //本单据初始预计支出金额
string beforeFReturnamount = System.Web.HttpContext.Current.Request.Params["beforeFReturnamount"]; //本单据初始预计返还金额
string Ifreturn = System.Web.HttpContext.Current.Request.Params["Ifreturn"]; //是否额度返还
var expensemstforminfo = DataConverterHelper.JsonToEntity <ExpenseMstModel>(expensemstformData);
var expensedtlgridinfo = DataConverterHelper.JsonToEntity <ExpenseDtlModel>(expensedtlgridData);
SavedResult <Int64> savedresult = new SavedResult <Int64>();
try
{
savedresult = ExpenseMstService.SaveExpenseMst(expensemstforminfo.AllRow[0], expensedtlgridinfo.AllRow, NCmoney, beforeSum, beforeFReturnamount, Ifreturn);
}
catch (Exception ex)
{
savedresult.Status = ResponseStatus.Error;
savedresult.Msg = ex.Message.ToString();
}
return(DataConverterHelper.SerializeObject(savedresult));
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetExpenseMstList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
var userId = System.Web.HttpContext.Current.Request.Params["userId"];
var dicWhereDept = new Dictionary <string, object>();
new CreateCriteria(dicWhereDept)
.Add(ORMRestrictions <string> .Eq("Dwdm", 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("FBudgetDept", deptL));
DataStoreParam storeparam = this.GetDataStoreParam();
var result = ExpenseMstService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, new string[] { "FPerformevaltype Desc" });
return(DataConverterHelper.EntityListToJson <ExpenseMstModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 根据主表phid取明细剩余金额
/// </summary>
/// <returns></returns>
public string RestOfAmount()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]);
string code = System.Web.HttpContext.Current.Request.Params["code"];
var result = ExpenseMstService.RestOfAmount(id, code);
return(result);
}
/// <summary>
/// 删除额度返还单据（额度逆返还）
/// </summary>
/// <returns>返回Json串</returns>
public string DeleteReturn()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
var deletedresult = ExpenseMstService.DeleteReturn(id);
return(DataConverterHelper.SerializeObject(deletedresult));
}
/// <summary>
/// 根据项目代码取预计支出金额的和
/// </summary>
/// <returns></returns>
public string SumFSurplusamount()
{
string FProjCode = System.Web.HttpContext.Current.Request.Params["FProjCode"]; //项目代码
var result = ExpenseMstService.SumFSurplusamount(FProjCode);
return(result);
}
/// <summary>
/// 额度核销撤销
/// </summary>
/// <returns></returns>
public string SaveHXreturn()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]);
Decimal FPlayamount = Convert.ToDecimal(System.Web.HttpContext.Current.Request.Params["FPlayamount"]);
CommonResult savedresult = new CommonResult();
savedresult = ExpenseMstService.SaveHXreturn(id, FPlayamount);
return(DataConverterHelper.SerializeObject(savedresult));
}
/*/// <summary>
* /// 项目支出预算情况查询
* /// </summary>
* /// <returns></returns>
* public string GetXmZcYs()
* {
* string userID = System.Web.HttpContext.Current.Request.Params["userID"];
* DataStoreParam storeparam = this.GetDataStoreParam();
* var result = ExpenseMstService.GetXmZcYs(userID, storeparam.PageIndex, storeparam.PageSize);
* return DataConverterHelper.EntityListToJson<ExpenseMstModel>(result.Results, (Int32)result.TotalItems);
* }*/
/// <summary>
/// 通过项目代码和操作员获取财务实际发生数
/// </summary>
/// <returns></returns>
public string GetSJFSSbyCode()
{
string userID = System.Web.HttpContext.Current.Request.Params["userID"];
string code = System.Web.HttpContext.Current.Request.Params["code"];
var result = ExpenseMstService.GetSJFSSbyCode(userID, code);
if (result == "" || result == null)
{
result = "0.00";
}
return(result);
}
/// <summary>
/// 额度核销执行完毕确认
/// </summary>
/// <returns></returns>
public string SaveHXgo()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]);
Decimal FPlayamount = Convert.ToDecimal(System.Web.HttpContext.Current.Request.Params["FPlayamount"]);
Decimal FReturnamount = Convert.ToDecimal(System.Web.HttpContext.Current.Request.Params["FReturnamount"]);
string dtldata = System.Web.HttpContext.Current.Request.Params["dtldata"];
var dtls = JsonConvert.DeserializeObject <List <ExpenseDtlModel> >(dtldata);
CommonResult savedresult = new CommonResult();
savedresult = ExpenseMstService.SaveHXgo(id, FPlayamount, FReturnamount, dtls);
return(DataConverterHelper.SerializeObject(savedresult));
}
/// <summary>
/// 保存额度核销数据
/// </summary>
/// <returns>返回Json串</returns>
public string SaveHX()
{
string adddata = System.Web.HttpContext.Current.Request.Params["adddata"];
string updatedata = System.Web.HttpContext.Current.Request.Params["updatedata"];
string deletedata = System.Web.HttpContext.Current.Request.Params["deletedata"];
var addinfo = JsonConvert.DeserializeObject <List <ExpenseHxModel> >(adddata);
var updateinfo = JsonConvert.DeserializeObject <List <ExpenseHxModel> >(updatedata);
var deleteinfo = JsonConvert.DeserializeObject <List <string> >(deletedata);
CommonResult savedresult = new CommonResult();
savedresult = ExpenseMstService.SaveHX(addinfo, updateinfo, deleteinfo);
return(DataConverterHelper.SerializeObject(savedresult));
}
public string PostSave([FromBody] ExpenseAllRequestModel ExpenseAllData)
{
SavedResult <Int64> savedresult = new SavedResult <Int64>();
try
{
if (ExpenseAllData.ExpenseMst != null)
{
if (ExpenseAllData.ExpenseMst.PhId == 0)
{
ExpenseAllData.ExpenseMst.PersistentState = PersistentState.Added;
//ExpenseAllData.ExpenseMst.FSurplusamount += decimal.Parse(ExpenseMstService.SumFSurplusamount(ExpenseAllData.ExpenseMst.FProjcode));
}
else
{
if (ExpenseAllData.ExpenseMst.PersistentState != PersistentState.Deleted)
{
ExpenseAllData.ExpenseMst.PersistentState = PersistentState.Modified;
}
}
}
if (ExpenseAllData.ExpenseDtls != null && ExpenseAllData.ExpenseDtls.Count > 0)
{
foreach (var dtl in ExpenseAllData.ExpenseDtls)
{
if (dtl.PhId == 0)
{
dtl.PersistentState = PersistentState.Added;
}
else
{
if (dtl.PersistentState != PersistentState.Deleted)
{
dtl.PersistentState = PersistentState.Modified;
}
}
}
}
savedresult = ExpenseMstService.SaveExpenseMst(ExpenseAllData.ExpenseMst, ExpenseAllData.ExpenseDtls, ExpenseAllData.ExpenseMst.FProjAmount.ToString(), ExpenseAllData.beforeSum, ExpenseAllData.beforeFReturnamount, ExpenseAllData.Ifreturn);
}
catch (Exception ex)
{
savedresult.Status = ResponseStatus.Error;
savedresult.Msg = ex.Message.ToString();
}
return(DataConverterHelper.SerializeObject(savedresult));
}
public string GetExpenseMstInfo([FromUri] long id)
{
ExpenseAllModel ExpenseAll = new ExpenseAllModel();
ExpenseAll.ExpenseMst = ExpenseMstService.Find(id).Data;
ExpenseAll.ExpenseDtls = ExpenseMstService.FindExpenseDtlByForeignKey(id).Data.ToList();
ExpenseAll.ExpenseHxs = ExpenseMstService.FindExpenseHxByForeignKey(id).Data.ToList();
//用款计划对应的附件
var qtAttachments = this.QtAttachmentService.Find(t => t.RelPhid == id && t.BTable == "YS3_EXPENSEMST").Data;
if (qtAttachments != null && qtAttachments.Count > 0)
{
ExpenseAll.QtAttachments = qtAttachments.ToList();
}
return(DataConverterHelper.SerializeObject(ExpenseAll));
}
/// <summary>
/// 取消送审
/// </summary>
/// <returns></returns>
public string UnChecked()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
var Findresult = ExpenseMstService.Find <System.Int64>(id);
SavedResult <Int64> savedresult = new SavedResult <Int64>();
Findresult.Data.FApprovestatus = "1";
Findresult.Data.FApprover = 0;
Findresult.Data.FApprovedate = new Nullable <DateTime>();
Findresult.Data.PersistentState = PersistentState.Modified;
savedresult = ExpenseMstService.Save <Int64>(Findresult.Data, "");
return(DataConverterHelper.SerializeObject(savedresult));
}
public string SaveHXreturn([FromBody] ExpenseAllRequestModel ExpenseAllData)
{
if (ExpenseAllData.ExpenseMst == null || ExpenseAllData.ExpenseMst.PhId == 0)
{
return(DCHelper.ErrorMessage("参数传递有误！"));
}
try
{
CommonResult savedresult = new CommonResult();
savedresult = ExpenseMstService.SaveHXreturn(ExpenseAllData.ExpenseMst.PhId, ExpenseAllData.ExpenseMst.FPlayamount);
return(DataConverterHelper.SerializeObject(savedresult));
}
catch (Exception ex)
{
return(DCHelper.ErrorMessage(ex.Message));
}
}
public string PostSaveHX([FromBody] BaseInfoModel <List <ExpenseHxModel> > param)
{
if (param.infoData == null)
{
return(DCHelper.ErrorMessage("保存的数据不能为空！"));
}
try
{
var addinfo = new List <ExpenseHxModel>();
var updateinfo = new List <ExpenseHxModel>();
var deleteinfo = new List <string>();
foreach (ExpenseHxModel a in param.infoData)
{
if (a.PhId == 0)
{
a.PersistentState = PersistentState.Added;
addinfo.Add(a);
}
else
{
if (a.PersistentState == PersistentState.Deleted)
{
deleteinfo.Add(a.PhId.ToString());
}
else
{
a.PersistentState = PersistentState.Modified;
updateinfo.Add(a);
}
}
}
CommonResult savedresult = new CommonResult();
savedresult = ExpenseMstService.SaveHX(addinfo, updateinfo, deleteinfo);
return(DataConverterHelper.SerializeObject(savedresult));
}
catch (Exception ex)
{
return(DCHelper.ErrorMessage(ex.Message));
}
}
/// <summary>
/// 根据主键获取数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetExpenseMstInfo()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
string tabtype = System.Web.HttpContext.Current.Request.Params["tabtype"]; //Tab类型
switch (tabtype)
{
case "expensemst":
var findedresultexpensemst = ExpenseMstService.Find(id);
return(DataConverterHelper.ResponseResultToJson(findedresultexpensemst));
case "expensedtl":
var findedresultexpensedtl = ExpenseMstService.FindExpenseDtlByForeignKey(id);
return(DataConverterHelper.EntityListToJson(findedresultexpensedtl.Data, findedresultexpensedtl.Data.Count));
case "expensehx":
var findedresultexpensehx = ExpenseMstService.FindExpenseHxByForeignKey(id);
return(DataConverterHelper.EntityListToJson(findedresultexpensehx.Data, findedresultexpensehx.Data.Count));
default:
FindedResult findedresultother = new FindedResult();
return(DataConverterHelper.ResponseResultToJson(findedresultother));
}
}
public string GetExpenseMstList([FromUri] ExpenseListRequestModel param)
{
//string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"];//查询条件
//Dictionary<string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery);//查询条件转Dictionary
//var userId = System.Web.HttpContext.Current.Request.Params["userId"];
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
/*var dicWhereDept = new Dictionary<string, object>();
* new CreateCriteria(dicWhereDept)
* .Add(ORMRestrictions<string>.Eq("Dwdm", param.UserCode)).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("FBudgetDept", deptL));*/
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <string> .Eq("FDeclarationDept", param.FDeclarationDept));
if (param.FApprovestatus.Count > 0)
{
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <List <string> > .In("FApprovestatus", param.FApprovestatus));
}
if (param.FStartdate != null)
{
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <System.DateTime?> .Ge("FDateofdeclaration", param.FStartdate));
}
if (param.FEnddate != null)
{
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <System.DateTime?> .Le("FDateofdeclaration", param.FEnddate));
}
if (param.MinAmount != 0)
{
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <System.Decimal> .Ge("FSurplusamount", param.MinAmount));
}
if (param.MaxAmount != 0)
{
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <System.Decimal> .Le("FSurplusamount", param.MaxAmount));
}
if (!string.IsNullOrEmpty(param.searchValue))
{
var dic1 = new Dictionary <string, object>();
var dic2 = new Dictionary <string, object>();
new CreateCriteria(dic1)
.Add(ORMRestrictions <String> .Like("FPerformevaltype", param.searchValue));
new CreateCriteria(dic2)
.Add(ORMRestrictions <String> .Like("FProjname", param.searchValue));
new CreateCriteria(dicWhere)
.Add(ORMRestrictions.Or(dic1, dic2));
}
//根据单据号进行排序
var result = ExpenseMstService.LoadWithPage(param.PageIndex, param.PageSize, dicWhere, new string[] { "FPerformevaltype Desc" });
if (param.ProcPhid != 0)
{
var expenseList = ExpenseMstService.Find(dicWhere, new string[] { "FPerformevaltype Desc" }).Data;
if (expenseList != null && expenseList.Count > 0)
{
List <string> orgList = expenseList.ToList().Select(t => t.FBudgetDept).Distinct().ToList();
if (orgList != null && orgList.Count > 0)
{
var procList = this.GAppvalProcService.Find(t => orgList.Contains(t.OrgCode)).Data;
if (procList != null && procList.Count > 0)
{
//可以选取相同审批流的打上标记
foreach (var res in expenseList)
{
if (res.FApprovestatus == "1" && procList.ToList().Find(t => t.OrgCode == res.FBudgetDept && t.PhId == param.ProcPhid) != null)
{
res.BatchPracBz = 1;
}
else
{
continue;
}
}
expenseList = expenseList.ToList().FindAll(t => t.BatchPracBz == 1);
}
}
}
result.Results = expenseList.Skip((param.PageIndex - 1) * param.PageSize).Take(param.PageSize).ToList();
result.TotalItems = expenseList.Count;
}
return(DCHelper.ModelListToJson <ExpenseMstModel>(result.Results, (Int32)result.TotalItems));
}
public string GetinfoByDept([FromUri] BaseListModel param)
{
var result = ExpenseMstService.GetinfoByDept(param.orgCode, param.Year);
return(DataConverterHelper.SerializeObject(result));
}
public string GetinfoByProjCode([FromUri] long YsPhid)
{
var result = ExpenseMstService.GetinfoByProjCode(YsPhid);
return(DataConverterHelper.SerializeObject(result));
}
public string GetDeleteReturn([FromUri] long id)
{
var deletedresult = ExpenseMstService.DeleteReturn(id);
return(DataConverterHelper.SerializeObject(deletedresult));
}
/// <summary>
/// 根据项目代码获取额度核销总金额
/// </summary>
/// <returns></returns>
public string GetHXsumByCode()
{
string code = System.Web.HttpContext.Current.Request.Params["code"];
return(ExpenseMstService.GetHXsumByCode(code).ToString());
}
