/// <summary> /// 更新收款单 /// </summary> /// <param name="entity">收款单</param> /// <returns></returns> /// <remarks>2013-07-08 朱成果 创建</remarks> public override void Update(FnReceiptVoucher entity) { Context.Update("FnReceiptVoucher", entity) .AutoMap(x => x.SysNo) .Where("SysNo", entity.SysNo) .Execute(); }
/// <summary> /// 创建订单收款单 /// </summary> /// <param name="soOrder">订单</param> /// <returns>收款单实体</returns> /// <remarks>2013-07-08 朱成果 创建</remarks> public FnReceiptVoucher CreateReceiptVoucherByOrder(SoOrder soOrder) { var entity = Hyt.DataAccess.Finance.IFnReceiptVoucherDao.Instance.GetEntity(sourceFromOrder, soOrder.SysNo); if (entity != null) { return(null); } var payType = Hyt.BLL.Basic.PaymentTypeBo.Instance.GetEntity(soOrder.PayTypeSysNo); FnReceiptVoucher rv = new FnReceiptVoucher() { TransactionSysNo = soOrder.TransactionSysNo, Status = (int)FinanceStatus.收款单状态.待确认, Source = sourceFromOrder, CreatedBy = soOrder.OrderCreatorSysNo, CreatedDate = DateTime.Now, LastUpdateBy = soOrder.OrderCreatorSysNo, LastUpdateDate = DateTime.Now, IncomeAmount = soOrder.CashPay, IncomeType = payType == null?20:payType.PaymentType, SourceSysNo = soOrder.SysNo }; rv.SysNo = Hyt.DataAccess.Finance.IFnReceiptVoucherDao.Instance.Insert(rv); return(rv); }
/// <summary> /// 创建订单收款单 /// </summary> /// <param name="soOrder">订单</param> /// <returns>FnReceiptVoucher</returns> /// <remarks>2013-07-16 黄伟 创建</remarks> private FnReceiptVoucher CreateReceiptVoucherByOrder(SoOrder soOrder) { var entity = IFnReceiptVoucherDao.Instance.GetEntity((int)FinanceStatus.收款来源类型.销售单, soOrder.SysNo); if (entity != null) { return(null); } var payType = Hyt.BLL.Basic.PaymentTypeBo.Instance.GetEntity(soOrder.PayTypeSysNo); var rv = new FnReceiptVoucher() { TransactionSysNo = soOrder.TransactionSysNo, Status = (int)FinanceStatus.收款单状态.已确认, ConfirmedBy = soOrder.OrderCreatorSysNo, ConfirmedDate = DateTime.Now, Source = (int)FinanceStatus.收款来源类型.销售单, CreatedBy = soOrder.OrderCreatorSysNo, CreatedDate = DateTime.Now, IncomeAmount = soOrder.CashPay, IncomeType = payType.PaymentType, SourceSysNo = soOrder.SysNo }; rv.SysNo = IFnReceiptVoucherDao.Instance.Insert(rv); return(rv); }
/// <summary> /// 添加收款单 /// </summary> /// <param name="entity">收款单实体</param> /// <returns>收款单编号</returns> /// <remarks>2013-07-08 朱成果 创建</remarks> public override int Insert(FnReceiptVoucher entity) { if (entity.ConfirmedDate == DateTime.MinValue) { entity.ConfirmedDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue; } var sysNo = Context.Insert("FnReceiptVoucher", entity) .AutoMap(o => o.SysNo) .ExecuteReturnLastId <int>("SysNo"); return(sysNo); }
/// <summary> /// 作废出库单 /// </summary> /// <param name="sysNo">出库单系统编号</param> /// <param name="user">操作用户</param> /// <returns>成功返回true,失败返回false</returns> /// <remarks>2016-06-27 王耀发 创建</remarks> public bool InventoryOutCancel(int sysNo, SyUser user) { var model = GetWhInventoryOut(sysNo); if (null == model) { throw new HytException("出库单不存在!"); } if (!AdminAuthenticationBo.Instance.HasWareHousePrivilege(model.WarehouseSysNo)) { throw new HytException("用户没有作废该条出库单的权限!"); } FnReceiptVoucher ReceiptVoucher = null; if (model.SourceType != (int)WarehouseStatus.出库单来源.调货单) { //获取对应收款单 ReceiptVoucher = FnReceiptVoucherBo.Instance.GetEntity((int)Hyt.Model.WorkflowStatus.FinanceStatus.收款来源类型.采购退货单, model.SourceSysNO); if (ReceiptVoucher.Status == (int)FinanceStatus.收款单状态.已确认) { throw new HytException("该条出库单对应的收款单已确认,不能作废!"); } } model.Status = WarehouseStatus.采购退货出库单状态.作废.GetHashCode(); var id = UpdateWhInventoryOut(model); if (id <= 0) { return(false); } if (model.SourceType != (int)WarehouseStatus.出库单来源.调货单) { //更新采购退货单状态 Hyt.BLL.Purchase.PrPurchaseReturnBo.Instance.UpdateStatus(model.SourceSysNO, (int)PurchaseStatus.采购退货单状态.待审核); //更新收款单状态 ReceiptVoucher.Status = (int)FinanceStatus.收款单状态.作废; ReceiptVoucher.LastUpdateBy = user.SysNo; ReceiptVoucher.LastUpdateDate = DateTime.Now; FnReceiptVoucherBo.Instance.Update(ReceiptVoucher); } return(true); }
/// <summary> /// 二期业务数据1段 财务 /// </summary> /// <param name="listObject"></param> private void AddBaseTaskObject2ToList2(List <BaseTask> listObject) { BaseTask fninvoice = new FnInvoice(); BaseTask fnpv = new FnReceiptVoucher(); BaseTask fnReceiptVoucherItem = new FnReceiptVoucherItem(); BaseTask fnop = new FnOnlinePayment(); BaseTask fnPaymentVoucher = new FnPaymentVoucher(); BaseTask fnPaymentVoucherItem = new FnPaymentVoucherItem(); listObject.Add(fninvoice); listObject.Add(fnpv); listObject.Add(fnReceiptVoucherItem); listObject.Add(fnop); listObject.Add(fnPaymentVoucher); listObject.Add(fnPaymentVoucherItem); }
Hyt.Model.Icp.GZBaiYunJiChang.Order.OrderPaymentRel SetOrderPaymentRel(int OrderSysNo) { FnReceiptVoucher ReceiptVoucher = Hyt.BLL.Finance.FnReceiptVoucherBo.Instance.GetReceiptVoucherByOrder(OrderSysNo); List <CBFnReceiptVoucherItem> ReceiptVoucherItemList = Hyt.BLL.Finance.FnReceiptVoucherBo.Instance.GetReceiptVoucherItem(ReceiptVoucher.SysNo); string PayEntName = ""; string PayNo = ""; foreach (CBFnReceiptVoucherItem item in ReceiptVoucherItemList) { if (PayEntName == "") { PayEntName = item.PaymentTypeName; } else { PayEntName += "," + item.PaymentTypeName; } if (PayNo == "") { PayNo = item.VoucherNo; } else { PayNo += "," + item.VoucherNo; } } Hyt.Model.Icp.GZBaiYunJiChang.Order.OrderPaymentRel OrderPaymentRel = new Hyt.Model.Icp.GZBaiYunJiChang.Order.OrderPaymentRel(); //支付企业代码 OrderPaymentRel.PayEntNo = "C010000000677460"; //支付企业名称 OrderPaymentRel.PayEntName = PayEntName; //支付交易类型 OrderPaymentRel.PayType = "M"; //支付交易编号 OrderPaymentRel.PayNo = PayNo; //备注 OrderPaymentRel.Notes = ""; return(OrderPaymentRel); }
private void AddBaseTaskObjectToList(List <BaseTask> listObject) { BaseTask bsAT = new BsArea(); BaseTask bsDP = new BsDeliveryPayment(); BaseTask bsPT = new BsPaymentType(); BaseTask bsCode = new BsCode(); BaseTask bsOrganization = new BsOrganization(); BaseTask bsOrganizationWarehouse = new BsOrganizationWarehouse(); BaseTask crCustomer = new CrCustomer(); BaseTask crCL = new CrCustomerLevel(); BaseTask crCQ = new CrCustomerQuestion(); BaseTask crRA = new CrReceiveAddress(); BaseTask dsMallType = new DsMallType(); BaseTask dsDealerLevel = new DsDealerLevel(); BaseTask feArticle = new FeArticle(); BaseTask feAC = new FeArticleCategory(); BaseTask feCS = new FeCommentSupport(); BaseTask fepc = new FeProductComment(); BaseTask fePCI = new FeProductCommentImage(); BaseTask fePCR = new FeProductCommentReply(); BaseTask feSearchKeyword = new FeSearchKeyword(); BaseTask feadvertgroup = new FeAdvertGroup(); BaseTask feadvertitem = new FeAdvertItem(); BaseTask feproductgroup = new FeProductGroup(); BaseTask feproductitem = new FeProductItem(); BaseTask fnIT = new FnInvoiceType(); BaseTask fninvoice = new FnInvoice(); BaseTask fnpv = new FnReceiptVoucher(); BaseTask fnReceiptVoucherItem = new FnReceiptVoucherItem(); BaseTask fnop = new FnOnlinePayment(); BaseTask fnPaymentVoucher = new FnPaymentVoucher(); BaseTask fnPaymentVoucherItem = new FnPaymentVoucherItem(); BaseTask lgDelivery = new LgDelivery(); BaseTask lgDI = new LgDeliveryItem(); BaseTask lgDS = new LgDeliveryScope(); BaseTask lgDT = new LgDeliveryType(); BaseTask lgDUC = new LgDeliveryUserCredit(); BaseTask lgPT = new LgPickupType(); BaseTask lgsettlement = new LgSettlement(); BaseTask lgSI = new LgSettlementItem(); BaseTask lgDeliveryPrintTemplate = new LgDeliveryPrintTemplate(); BaseTask pdAttribute = new PdAttribute(); BaseTask pdAG = new PdAttributeGroup(); BaseTask pdAGA = new PdAttributeGroupAssociation(); BaseTask pdAO = new PdAttributeOption(); BaseTask pdBrand = new PdBrand(); BaseTask pdCGA = new PdCatAttributeGroupAso(); BaseTask pdCategory = new PdCategory(); BaseTask pdCA = new PdCategoryAssociation(); BaseTask pdPrice = new PdPrice(); BaseTask pdProduct = new PdProduct(); BaseTask pdPA = new PdProductAssociation(); BaseTask pdProductAttribute = new PdProductAttribute(); BaseTask pdPI = new PdProductImage(); BaseTask pdTemplate = new PdTemplate(); BaseTask pdProductStatistics = new PdProductStatistics(); BaseTask soOrder = new SoOrder(); BaseTask soOrderItem = new SoOrderItem(); BaseTask soRA = new SoReceiveAddress(); BaseTask SyUG = new SyUserGroup(); BaseTask syGU = new SyGroupUser(); BaseTask syMenu = new SyMenu(); BaseTask syMenuPrivilege = new SyMenuPrivilege(); BaseTask syPrivilege = new SyPrivilege(); BaseTask syRole = new SyRole(); BaseTask syRoleMenu = new SyRoleMenu(); BaseTask syRolePrivilege = new SyRolePrivilege(); BaseTask syPermission = new SyPermission(); BaseTask syUser = new SyUser(); BaseTask syUW = new SyUserWarehouse(); BaseTask syMyMenu = new SyMyMenu(); BaseTask spcombo = new SpCombo(); BaseTask spComboItem = new SpComboItem(); BaseTask spcopon = new spcoupon(); BaseTask sqpromotion = new SPpromotion(); BaseTask spromotiongift = new SPpromotiongift(); BaseTask sppromotionoverlay = new SPpromotionoverlay(); BaseTask sppromotionrule = new SPpromotionrule(); BaseTask sppromotionrulecondition = new SPpromotionrulecondition(); BaseTask sppromotionrulekeyvalue = new SPpromotionrulekeyvalue(); BaseTask syTaskConfig = new SyTaskConfig(); BaseTask whStockOut = new WhStockOut(); BaseTask whStockOutItem = new WhstockOutItem(); BaseTask whwarehouse = new WhWarehouse(); BaseTask whwa = new WHwarehousearea(); BaseTask whwdy = new WHwarehouseDeliveryType(); BaseTask whWPT = new WhWarehousePickupType(); BaseTask whstockin = new WhStockIn(); BaseTask whstockinItem = new WHStockinItem(); BaseTask rcReturn = new RCReturn(); BaseTask rcReturnItem = new RcReturnItem(); listObject.Add(bsAT); listObject.Add(bsDP); listObject.Add(bsPT); listObject.Add(bsCode); listObject.Add(bsOrganization); listObject.Add(bsOrganizationWarehouse); listObject.Add(crCustomer); listObject.Add(crCL); listObject.Add(crCQ); listObject.Add(crRA); listObject.Add(dsMallType); listObject.Add(dsDealerLevel); listObject.Add(feArticle); listObject.Add(feAC); listObject.Add(feCS); listObject.Add(fePCI); listObject.Add(fePCR); listObject.Add(fepc); listObject.Add(feSearchKeyword); listObject.Add(feadvertgroup); listObject.Add(feadvertitem); listObject.Add(feproductgroup); listObject.Add(feproductitem); listObject.Add(fnIT); listObject.Add(fnpv); listObject.Add(fnReceiptVoucherItem); listObject.Add(fnop); listObject.Add(fninvoice); listObject.Add(fnPaymentVoucher); listObject.Add(fnPaymentVoucherItem); listObject.Add(lgDelivery); listObject.Add(lgDI); listObject.Add(lgDS); listObject.Add(lgDT); listObject.Add(lgPT); listObject.Add(lgsettlement); listObject.Add(lgSI); listObject.Add(lgDeliveryPrintTemplate); listObject.Add(pdAttribute); listObject.Add(pdAG); listObject.Add(pdAGA); listObject.Add(pdAO); listObject.Add(pdBrand); listObject.Add(pdCGA); listObject.Add(pdCategory); listObject.Add(pdCA); listObject.Add(pdPrice); listObject.Add(pdProduct); listObject.Add(pdPA); listObject.Add(pdProductAttribute); listObject.Add(pdTemplate); listObject.Add(pdProductStatistics); listObject.Add(soOrder); listObject.Add(soOrderItem); listObject.Add(spcombo); listObject.Add(spComboItem); listObject.Add(spcopon); listObject.Add(sqpromotion); listObject.Add(spromotiongift); //listObject.Add(sppromotionoverlay); listObject.Add(sppromotionrule); listObject.Add(sppromotionrulecondition); listObject.Add(sppromotionrulekeyvalue); listObject.Add(syGU); listObject.Add(syUW); listObject.Add(SyUG); listObject.Add(syMenu); listObject.Add(syUser); listObject.Add(syPermission); listObject.Add(syMenuPrivilege); listObject.Add(syPrivilege); listObject.Add(syRole); listObject.Add(syRoleMenu); listObject.Add(syRolePrivilege); listObject.Add(syMyMenu); listObject.Add(syTaskConfig); listObject.Add(whStockOut); listObject.Add(whStockOutItem); listObject.Add(whwarehouse); listObject.Add(whwa); listObject.Add(whwdy); listObject.Add(whWPT); listObject.Add(whstockin); listObject.Add(whstockinItem); listObject.Add(rcReturn); listObject.Add(rcReturnItem); listObject.Add(lgDUC); listObject.Add(pdPI); listObject.Add(soRA); }
/// <summary> /// 审核采购退货单 /// </summary> /// <param name="sysNo">采购单编号</param> /// <remarks>2016-6-18 王耀发 创建</remarks> public bool AuditPurchaseReturn(int sysNo) { int CreatedBy = BLL.Authentication.AdminAuthenticationBo.Instance.Current.Base.SysNo; var purchaseReturn = IPrPurchaseReturnDao.Instance.GetPrPurchaseReturn(sysNo); if (UpdateStatus(sysNo, (int)PurchaseStatus.采购退货单状态.已审核)) { var receiptVoucherMod = new FnReceiptVoucher(); receiptVoucherMod.TransactionSysNo = ""; receiptVoucherMod.IncomeType = (int)Hyt.Model.WorkflowStatus.FinanceStatus.收款单收入类型.预付; receiptVoucherMod.Source = (int)Hyt.Model.WorkflowStatus.FinanceStatus.收款来源类型.采购退货单; receiptVoucherMod.SourceSysNo = sysNo; receiptVoucherMod.IncomeAmount = purchaseReturn.ReturnTotalMoney; receiptVoucherMod.ReceivedAmount = 0; receiptVoucherMod.Status = (int)Hyt.Model.WorkflowStatus.FinanceStatus.收款单状态.待确认; receiptVoucherMod.Remark = "采购退货收款单"; receiptVoucherMod.CreatedBy = CreatedBy; receiptVoucherMod.CreatedDate = DateTime.Now; receiptVoucherMod.ConfirmedBy = 0; receiptVoucherMod.ConfirmedDate = DateTime.Now; receiptVoucherMod.LastUpdateBy = CreatedBy; receiptVoucherMod.LastUpdateDate = DateTime.Now; receiptVoucherMod.PaymentType = null; FinanceBo.Instance.InsertReceiptVoucher(receiptVoucherMod); //创建出库单 WhInventoryOut outEntity = new WhInventoryOut { TransactionSysNo = ReceiptNumberBo.Instance.GetPurchaseOutNo(), WarehouseSysNo = purchaseReturn.WarehouseSysNo, SourceType = (int)WarehouseStatus.出库单来源.采购单, SourceSysNO = sysNo, DeliveryType = 0, Remarks = "采购退货出库", IsPrinted = 0, Status = (int)WarehouseStatus.采购退货出库单状态.待出库, CreatedBy = CreatedBy, CreatedDate = DateTime.Now, LastUpdateBy = CreatedBy, LastUpdateDate = DateTime.Now, Stamp = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue, }; outEntity.ItemList = new List <WhInventoryOutItem>(); var purchaseReturnDetails = BLL.Purchase.PrPurchaseReturnDetailsBo.Instance.GetPurchaseReturnDetailsList(sysNo); PrPurchase purMod = PrPurchaseBo.Instance.GetPrPurchaseInfo(purchaseReturn.PurchaseSysNo); //出库明细 foreach (var item in purchaseReturnDetails) { Hyt.Model.PdProduct Product = Hyt.BLL.Product.PdProductBo.Instance.GetProductBySysNo(item.ProductSysNo); outEntity.ItemList.Add(new WhInventoryOutItem { ProductSysNo = item.ProductSysNo, ProductName = Product.ProductName, StockOutQuantity = item.ReturnQuantity, RealStockOutQuantity = 0, SourceItemSysNo = item.SysNo,//记录出库单明细来源单号(采购退货单明细编号) Remarks = "", CreatedBy = CreatedBy, CreatedDate = DateTime.Now, LastUpdateBy = CreatedBy, LastUpdateDate = DateTime.Now }); } var inSysNo = WhInventoryOutBo.Instance.CreateWhInventoryOut(outEntity); //保存出库单数据 } return(true); }
/// <summary> /// 创建收款单 /// </summary> /// <param name="paymentVoucher"></param> /// <returns></returns> /// <remarks> /// 2016-6-24 王耀发 创建 /// </remarks> public int InsertReceiptVoucher(FnReceiptVoucher receiptVoucher) { var receiptVoucherSysNo = IFnReceiptVoucherDao.Instance.Insert(receiptVoucher); return(receiptVoucherSysNo); }
/// <summary> /// 更新收款单 /// </summary> /// <param name="entity">收款单</param> /// <returns></returns> /// <remarks>2013-07-08 朱成果 创建</remarks> public abstract void Update(FnReceiptVoucher entity);
/// <summary> /// 添加收款单 /// </summary> /// <param name="entity">收款单实体</param> /// <returns>收款单编号</returns> /// <remarks>2013-07-08 朱成果 创建</remarks> public abstract int Insert(FnReceiptVoucher entity);
/// <summary> /// 修改收款单 /// </summary> /// <param name="model">收款单实体</param> /// <returns></returns> ///<remarks>2013-07-08 朱成果 创建</remarks> public void Update(FnReceiptVoucher model) { Hyt.DataAccess.Finance.IFnReceiptVoucherDao.Instance.Update(model); }