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