public async Task <string> PostRefreshAllPaymentsState() { //获取支付中且FSeqno不为空的数据 var dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere).Add(ORMRestrictions <byte> .Eq("FState", (byte)EnumPaymentState.DuringPayment)); new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Gt("FSeqno", " ")); var result = GKPaymentMstService.Find(dicWhere, new string[] { "NgInsertDt asc" }); //LoadWithPage(parameters.pageindex, parameters.pagesize, dicWhere, new string[] { "NgInsertDt asc" }); if (result.IsError == false && result.Data != null) { IList <GKPaymentMstModel> list = result.Data; string errMsg = string.Empty; foreach (var mst in list) { GKPaymentMstService.RefreshPaymentState(mst.PhId, out errMsg); } } return(DCHelper.SuccessMessage("批量刷新支付状态提交成功,后台处理中!")); }
/// <summary> /// 获取所有审批种类对应的审批单据的总数量 /// </summary> /// <returns>返回Json串</returns> public string GetRecordListNum() { long Uid = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["Uid"]); long Orgid = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["Orgid"]); string Year = System.Web.HttpContext.Current.Request.Params["Year"]; if (Uid == 0) { return(DCHelper.ErrorMessage("用户id为空!")); } if (Orgid == 0) { return(DCHelper.ErrorMessage("组织id为空!")); } if (string.IsNullOrEmpty(Year)) { return(DCHelper.ErrorMessage("年度为空!")); } //设置当前数据库连接信息 ConnectionInfoService.SetCallContextConnectString(NG3.AppInfoBase.UserConnectString); MultiDelegatingDbProvider.CurrentDbProviderName = NG3.AppInfoBase.DbName; BillRequestModel billRequest = new BillRequestModel(); billRequest.Uid = Uid; billRequest.Orgid = Orgid; billRequest.Year = Year; var YNum = 0; //已审数量 var NNum = 0; //待审数量 try { //获取审批所有类型 List <QTSysSetModel> procTypes = QTSysSetService.GetProcTypes(); if (procTypes != null && procTypes.Count > 0) { foreach (var sysSet in procTypes) { billRequest.BType = sysSet.Value; billRequest.Splx_Phid = sysSet.PhId; int total = 0; List <AppvalRecordVo> recordVos = GAppvalRecordService.GetDoneRecordList(billRequest, out total); int total2 = 0; List <AppvalRecordVo> recordVos2 = GAppvalRecordService.GetUnDoRecordList(billRequest, out total2); YNum += total; NNum += total2; } } var dic = new Dictionary <string, object>(); new CreateCriteria(dic).Add(ORMRestrictions <Int64> .NotEq("PhId", 0)); new CreateCriteria(dic).Add(ORMRestrictions <List <Int32> > .In("FState", new List <int>() { 2, 0 })); new CreateCriteria(dic).Add(ORMRestrictions <Int64> .Eq("OrgPhid", Orgid)); new CreateCriteria(dic).Add(ORMRestrictions <string> .Eq("FYear", Year)); //var Query = GKPaymentMstService.GetPaymentFailure(dic); var Query = GKPaymentMstService.Find(dic).Data; return(DataConverterHelper.SerializeObject(new { Status = "success", YNum = YNum, NNum = NNum, PaymentState = Query.Count//【待支付】信息提醒需求 })); } catch (Exception e) { return(DCHelper.ErrorMessage(e.Message)); } }
public string PostDelete([FromBody] BaseSingleModel parameter) { if (string.IsNullOrEmpty(parameter.id)) { return(DCHelper.ErrorMessage("单据主键Phid为空!")); } if (parameter == null || string.IsNullOrEmpty(parameter.uid)) { return(DCHelper.ErrorMessage("用户id为空!")); } if (string.IsNullOrEmpty(parameter.orgid)) { return(DCHelper.ErrorMessage("组织编码为空!")); } if (string.IsNullOrEmpty(parameter.Ryear)) { return(DCHelper.ErrorMessage("年度为空!")); } try { var result = GKPaymentMstService.Find <long>(long.Parse(parameter.id)); if (!result.IsError && result.Data != null) { //判断要删除的支付单的状态 if (result.Data.FApproval == (int)EnumBillApproval.Approved) { return(DCHelper.ErrorMessage("单据已审批,不能删除!")); } if (result.Data.FApproval == (int)EnumBillApproval.InApproval) { return(DCHelper.ErrorMessage("单据在审批中,不能删除!")); } if (result.Data.FApproval == (int)EnumBillApproval.Approved) { return(DCHelper.ErrorMessage("单据已审批通过,不能删除!")); } if (result.Data.FState == (int)EnumPaymentState.AbnormalPayment) { return(DCHelper.ErrorMessage("单据已审批通过,不能删除!")); } var result2 = GKPaymentMstService.Delete(long.Parse(parameter.id)); return(DataConverterHelper.SerializeObject(result2)); } else { result.Msg = "单据不存在或已被其他人删除!"; } return(DataConverterHelper.SerializeObject(result)); } catch (Exception e) { return(DCHelper.ErrorMessage(e.Message)); } }