/// <summary> /// 新增财务实收实付 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Add(FinancePayEntity entity) { using (TransactionScope ts = new TransactionScope()) { entity.SnNum = ConvertHelper.NewGuid(); entity.PayNum = new SequenceProvider(this.CompanyID).GetSequence(typeof(FinancePayEntity)); entity.CreateTime = DateTime.Now; entity.CompanyID = this.CompanyID; entity.IncludeAll(); int line = this.FinancePay.Add(entity); FinancePayEntity pay = new FinancePayEntity(); pay.IncludeAll(); pay.Where(a => a.BillSnNum == entity.BillSnNum) .And(a => a.IsDelete == (int)EIsDelete.NotDelete) .And(a => a.CompanyID == this.CompanyID) ; List <FinancePayEntity> listResult = this.FinancePay.GetList(pay); if (!listResult.IsNullOrEmpty()) { int RealPayCount = listResult.Count(); double TotalAmount = listResult.Sum(a => a.Amount); FinanceBillEntity bill = new FinanceBillEntity(); bill.IncludeAll(); bill.Where(a => a.SnNum == entity.BillSnNum) .And(a => a.CompanyID == this.CompanyID) ; bill = this.FinanceBill.GetSingle(bill); if (bill != null) { FinanceBillEntity finance = new FinanceBillEntity(); finance.RealPayCount = RealPayCount; finance.RealPayAmount = TotalAmount; if (TotalAmount == 0) { finance.Status = (int)EFinanceStatus.InProgress; } else if (TotalAmount > 0 && TotalAmount < bill.Amount) { finance.Status = (int)EFinanceStatus.PayPart; } else if (TotalAmount >= bill.Amount) { finance.Status = (int)EFinanceStatus.PayFull; } finance.Where(a => a.SnNum == bill.SnNum) .And(a => a.CompanyID == this.CompanyID) ; finance.Include(a => new { a.RealPayAmount, a.RealPayCount, a.Status }); line += this.FinanceBill.Update(finance); } } ts.Complete(); return(line); } }
/// <summary> /// 查询实收实付 /// </summary> /// <param name="SnNum"></param> /// <returns></returns> public FinancePayEntity GetSingle(string SnNum) { FinancePayEntity entity = new FinancePayEntity(); entity.IncludeAll(); entity.Where(a => a.SnNum == SnNum) .And(a => a.CompanyID == this.CompanyID) .And(a => a.IsDelete == (int)EIsDelete.NotDelete) ; entity = this.FinancePay.GetSingle(entity); return(entity); }
/// <summary> /// 查询应收应付对应的实收实付 /// </summary> /// <param name="BillSnNum"></param> /// <returns></returns> public List <FinancePayEntity> GetList(string BillSnNum) { FinancePayEntity entity = new FinancePayEntity(); entity.IncludeAll(); entity.Where(a => a.BillSnNum == BillSnNum) .And(a => a.IsDelete == (int)EIsDelete.NotDelete) .And(a => a.CompanyID == this.CompanyID) ; List <FinancePayEntity> listResult = this.FinancePay.GetList(entity); return(listResult); }
/// <summary> /// 查询财务实收实付 /// </summary> /// <returns></returns> public ActionResult GetSingle() { string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); string SnNum = WebUtil.GetFormValue <string>("SnNum"); FinancePayProvider provider = new FinancePayProvider(CompanyID); FinancePayEntity entity = provider.GetSingle(SnNum); DataResult <FinancePayEntity> result = new DataResult <FinancePayEntity>() { Code = (int)EResponseCode.Success, Message = "响应成功", Result = entity }; return(Content(JsonHelper.SerializeObject(result))); }
/// <summary> /// 查询流水记录 /// </summary> /// <returns></returns> public ActionResult GeAgencyBilltList() { string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1); int PageSize = WebUtil.GetFormValue <int>("PageSize", 10); string BillNum = WebUtil.GetFormValue <string>("BillNum"); string CateNum = WebUtil.GetFormValue <string>("CateNum"); string ToName = WebUtil.GetFormValue <string>("ToName"); string Title = WebUtil.GetFormValue <string>("Title"); int PayType = WebUtil.GetFormValue <int>("PayType"); string BankName = WebUtil.GetFormValue <string>("BankName"); string BeginTime = WebUtil.GetFormValue <string>("BeginTime"); string EndTime = WebUtil.GetFormValue <string>("EndTime"); string ContractNum = WebUtil.GetFormValue <string>("ContractNum"); string AgencyNum = WebUtil.GetFormValue <string>("AgencyNum"); FinancePayEntity entity = new FinancePayEntity(); entity.CompanyID = CompanyID; entity.PayType = PayType; entity.BankName = BankName; entity.BeginTime = BeginTime; entity.EndTime = EndTime; entity.PayNum = BillNum; entity.CateNum = CateNum; entity.ToName = ToName; entity.Title = Title; entity.ContractNum = ContractNum; PageInfo pageInfo = new PageInfo() { PageIndex = PageIndex, PageSize = PageSize }; FinancePayProvider provider = new FinancePayProvider(CompanyID); List <FinancePayEntity> listResult = provider.GeAgencyBilltList(entity, ref pageInfo); DataListResult <FinancePayEntity> result = new DataListResult <FinancePayEntity>() { Code = (int)EResponseCode.Success, Message = "响应成功", PageInfo = pageInfo, Result = listResult }; return(Content(JsonHelper.SerializeObject(result))); }
/// <summary> /// 编辑财务实收实付 /// </summary> /// <returns></returns> public ActionResult Edit() { string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); FinancePayEntity entity = WebUtil.GetFormObject <FinancePayEntity>("Entity"); FinancePayProvider provider = new FinancePayProvider(CompanyID); int line = provider.Edit(entity); DataResult result = new DataResult(); if (line > 0) { result.Code = (int)EResponseCode.Success; result.Message = "编辑成功"; } else { result.Code = (int)EResponseCode.Exception; result.Message = "编辑失败"; } return(Content(JsonHelper.SerializeObject(result))); }
public ActionResult AddPay() { string SnNum = WebUtil.GetFormValue <string>("SnNum"); string BillNum = WebUtil.GetFormValue <string>("BillNum"); string BillSnNum = WebUtil.GetFormValue <string>("BillSnNum"); int PayType = WebUtil.GetFormValue <int>("PayType"); string BankName = WebUtil.GetFormValue <string>("BankName"); double Amount = WebUtil.GetFormValue <double>("Amount"); DateTime PayTime = WebUtil.GetFormValue <DateTime>("PayTime", DateTime.Now); FinancePayEntity entity = new FinancePayEntity(); entity.SnNum = SnNum; entity.BillSnNum = BillSnNum; entity.PayType = PayType; entity.BankName = BankName; entity.Amount = Amount; entity.PayTime = PayTime; entity.CompanyID = this.CompanyID; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", this.CompanyID); dic.Add("Entity", JsonConvert.SerializeObject(entity)); ITopClient client = new TopClientDefault(); string ApiName = FinancePayApiName.FinancePayApiName_Add; if (!SnNum.IsEmpty()) { ApiName = FinancePayApiName.FinancePayApiName_Edit; } string result = client.Execute(ApiName, dic); return(Content(result)); }
/// <summary> /// 查询门店的流水记录 /// </summary> /// <param name="entity"></param> /// <param name="pageInfo"></param> /// <returns></returns> public List <FinancePayEntity> GeAgencyBilltList(FinancePayEntity entity, ref PageInfo pageInfo) { entity.IncludeAll(); entity.OrderBy(a => a.ID, EOrderBy.DESC); entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete) .And(a => a.CompanyID == this.CompanyID) ; FinanceBillEntity bill = new FinanceBillEntity(); bill.Include(a => new { Title = a.Title, FromName = a.FromName, ToName = a.ToName, TotalAmount = a.Amount, LastTime = a.LastTime, ContractSn = a.ContractSn, ContractNum = a.ContractNum, BillType = a.BillType, CateName = a.CateName, CateNum = a.CateNum, }); entity.Left <FinanceBillEntity>(bill, new Params <string, string>() { Item1 = "BillSnNum", Item2 = "SnNum" }); if (entity.PayType > 0) { entity.And(a => a.PayType == entity.PayType); } if (entity.BankName.IsNotEmpty()) { entity.Where("BankName", ECondition.Like, "%" + entity.BankName + "%"); } if (entity.PayNum.IsNotEmpty()) { entity.Where("PayNum", ECondition.Like, "%" + entity.PayNum + "%"); } if (entity.CateNum.IsNotEmpty()) { bill.And(a => a.CateNum == entity.CateNum); } if (entity.Title.IsNotEmpty()) { bill.And("Title", ECondition.Like, "%" + entity.Title + "%"); } if (entity.BeginTime.IsNotEmpty()) { DateTime time = ConvertHelper.ToType <DateTime>(entity.BeginTime, DateTime.Now.AddDays(-7)).Date; entity.And(a => a.PayTime >= time); } if (entity.EndTime.IsNotEmpty()) { DateTime time = ConvertHelper.ToType <DateTime>(entity.EndTime, DateTime.Now).AddDays(1).Date; entity.And(a => a.PayTime < time); } int rowCount = 0; List <FinancePayEntity> listResult = this.FinancePay.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount); pageInfo.RowCount = rowCount; return(listResult); }
/// <summary> /// 删除实收实付 /// </summary> /// <param name="SnNum"></param> /// <returns></returns> public int Delete(string SnNum) { using (TransactionScope ts = new TransactionScope()) { FinancePayEntity entity = new FinancePayEntity(); entity.SnNum = SnNum; entity.IncludeAll(); entity.Where(a => a.SnNum == SnNum) .And(a => a.CompanyID == this.CompanyID) ; entity = this.FinancePay.GetSingle(entity); FinancePayEntity finEntity = new FinancePayEntity(); finEntity.IsDelete = (int)EIsDelete.Deleted; finEntity.IncludeIsDelete(true); finEntity.Where(a => a.SnNum == SnNum) .And(a => a.CompanyID == this.CompanyID) ; int line = this.FinancePay.Update(finEntity); FinancePayEntity pay = new FinancePayEntity(); pay.IncludeAll(); pay.Where(a => a.BillSnNum == entity.BillSnNum) .And(a => a.IsDelete == (int)EIsDelete.NotDelete) .And(a => a.CompanyID == this.CompanyID) ; List <FinancePayEntity> listResult = this.FinancePay.GetList(pay); if (!listResult.IsNullOrEmpty()) { int RealPayCount = listResult.Count(); double TotalAmount = listResult.Sum(a => a.Amount); FinanceBillEntity bill = new FinanceBillEntity(); bill.IncludeAll(); bill.Where(a => a.SnNum == entity.BillSnNum) .And(a => a.CompanyID == this.CompanyID) ; bill = this.FinanceBill.GetSingle(bill); if (bill != null) { FinanceBillEntity finance = new FinanceBillEntity(); finance.RealPayCount = RealPayCount; if (TotalAmount == 0) { finance.Status = (int)EFinanceStatus.InProgress; } else if (TotalAmount > 0 && TotalAmount < bill.Amount) { finance.Status = (int)EFinanceStatus.PayPart; } else if (TotalAmount >= bill.Amount) { finance.Status = (int)EFinanceStatus.PayFull; } finance.Where(a => a.SnNum == bill.SnNum) .And(a => a.CompanyID == this.CompanyID) ; } } ts.Complete(); return(line); } }
public ActionResult AddPay() { string CompanyID = this.CompanyID; string SnNum = WebUtil.GetQueryStringValue <string>("SnNum", string.Empty); string BillSnNum = WebUtil.GetQueryStringValue <string>("BillSnNum", string.Empty); FinancePayEntity entity = null; if (!SnNum.IsEmpty()) { ITopClient client = new TopClientDefault(); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("SnNum", SnNum); string result = client.Execute(FinancePayApiName.FinancePayApiName_Single, dic); if (!result.IsEmpty()) { DataResult <FinancePayEntity> dataResult = JsonConvert.DeserializeObject <DataResult <FinancePayEntity> >(result); entity = dataResult.Result; } } if (entity.IsNull()) { entity = new FinancePayEntity(); entity.CreateTime = DateTime.Now; entity.CreateUser = this.LoginUser.UserNum; entity.CreateUserName = this.LoginUser.UserName; entity.PayTime = DateTime.Now; } ViewBag.PayTypeList = EnumHelper.GetOptions <EPayType>(entity.PayType); entity.BillSnNum = BillSnNum; ViewBag.Entity = entity; //加载应收数据项 FinanceBillEntity billEnity = null; if (!SnNum.IsEmpty()) { ITopClient client = new TopClientDefault(); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("SnNum", BillSnNum); string result = client.Execute(FinanceBillApiName.FinanceBillApiName_Single, dic); if (!result.IsEmpty()) { DataResult <FinanceBillEntity> dataResult = JsonConvert.DeserializeObject <DataResult <FinanceBillEntity> >(result); billEnity = dataResult.Result; } } if (billEnity.IsNull()) { billEnity = new FinanceBillEntity(); billEnity.CreateTime = DateTime.Now; billEnity.CreateUser = this.LoginUser.UserNum; billEnity.CreateUserName = this.LoginUser.UserName; billEnity.LastTime = DateTime.Now.AddMonths(2); } ViewBag.BillEntity = billEnity; return(View()); }