新增销售订单保存接口,销售退货通知单保存接口,销售发货通知单保存接口
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi |
| | | { |
| | | public class ErpSalesDeliveryNotice |
| | | { |
| | | public string? Id { get; set; } |
| | | public string? type { get; set; } |
| | | public string? erpID { get; set; } |
| | | public string? fBillTypeID { get; set; } |
| | | public string? fBillNo { get; set; } |
| | | public string? fDate { get; set; } |
| | | public string? fSettleCurrld { get; set; } |
| | | public string? fSaleDeptId { get; set; } |
| | | public string? fCustomerID { get; set; } |
| | | public string? fHeadDeliveryWay { get; set; } |
| | | public string? fHeadLocId { get; set; } |
| | | public string? fCarrierID { get; set; } |
| | | public string? fCarriageNO { get; set; } |
| | | public string? fDeliveryDeptID { get; set; } |
| | | public string? fStockerGroupId { get; set; } |
| | | public string? fStockerId { get; set; } |
| | | public string? fSaleGroupId { get; set; } |
| | | public string? fSalesManId { get; set; } |
| | | public string? fReceiveCusId { get; set; } |
| | | public string? fReceiveCusContact { get; set; } |
| | | public string? fReceiveAddress { get; set; } |
| | | public string? fLinkMan { get; set; } |
| | | public string? fLinkPhone { get; set; } |
| | | public string? fSettleID { get; set; } |
| | | public string? fPayerID { get; set; } |
| | | public string? fCreatorId { get; set; } |
| | | public string? fCreateDate { get; set; } |
| | | public string? fModifierId { get; set; } |
| | | public string? fModifyDate { get; set; } |
| | | public string? fApproverId { get; set; } |
| | | public string? fApproveDate { get; set; } |
| | | public string? fCloserId { get; set; } |
| | | public string? fCloseReason { get; set; } |
| | | public string? fBillCloseStatus { get; set; } |
| | | public string? fCancelStatus { get; set; } |
| | | public string? fCancellerId { get; set; } |
| | | public string? fCancelDate { get; set; } |
| | | public string? fDocumentStatus { get; set; } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi |
| | | { |
| | | public class ErpSalesDeliveryNoticeDetail |
| | | { |
| | | public string? Id { get; set; } |
| | | public string? type { get; set; } |
| | | public string? erpID { get; set; } |
| | | public string? ehid { get; set; } |
| | | public string? fMaterialId { get; set; } |
| | | public string? fUnitID { get; set; } |
| | | public string? fQty { get; set; } |
| | | public string? fIsFree { get; set; } |
| | | public string? fDeliverydate { get; set; } |
| | | public string? fStockId { get; set; } |
| | | public string? fMtoNo { get; set; } |
| | | public string? fLot { get; set; } |
| | | public string? fStockUnitID { get; set; } |
| | | public string? fStockQty { get; set; } |
| | | public string? fOwnerTypeID { get; set; } |
| | | public string? fOwnerId { get; set; } |
| | | public string? fSrcType { get; set; } |
| | | public string? fSrcBillNo { get; set; } |
| | | public string? fOrderNo { get; set; } |
| | | public string? fPriceUnitQty { get; set; } |
| | | public string? fOwnerIdHead { get; set; } |
| | | public string? fPlanDeliveryDate { get; set; } |
| | | public string? fOutLmtUnit { get; set; } |
| | | public string? fOutMaxQty { get; set; } |
| | | public string? fOutMinQty { get; set; } |
| | | public string? fDeliveryLoc { get; set; } |
| | | public string? fDeliveryLAddress { get; set; } |
| | | public string? fTerminationStatus { get; set; } |
| | | public string? fTerminateDate { get; set; } |
| | | public string? fSumOutQty { get; set; } |
| | | public string? fRemainOutQty { get; set; } |
| | | public string? FNoteEntry { get; set; } |
| | | |
| | | |
| | | |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi |
| | | { |
| | | public class ErpSalesOrder |
| | | { |
| | | public string? Id { get; set; } |
| | | public string? Type { get; set; } |
| | | public string? ErpID { get; set; } |
| | | public string? FBillNo { get; set; } |
| | | public string? FBillTypeID { get; set; } |
| | | public string? FDocumentStatus { get; set; } |
| | | public string? FDate { get; set; } |
| | | public string? FBusinessType { get; set; } |
| | | public string? FHeadDeliveryWay { get; set; } |
| | | public string? FHEADLOCID { get; set; } |
| | | public string? FCustId { get; set; } |
| | | public string? FCloseStatus { get; set; } |
| | | public string? FSaleDeptId { get; set; } |
| | | public string? FSalerId { get; set; } |
| | | public string? FChangeReason { get; set; } |
| | | public string? FNote { get; set; } |
| | | public string? FSettleId { get; set; } |
| | | public string? FApproverId { get; set; } |
| | | public string? FLinkMan { get; set; } |
| | | public string? FChargeId { get; set; } |
| | | public string? FLinkPhone { get; set; } |
| | | public string? FCreatorId { get; set; } |
| | | public string? FCreateDate { get; set; } |
| | | public string? FModifierId { get; set; } |
| | | public string? FModifyDate { get; set; } |
| | | public string? FApproveDate { get; set; } |
| | | public string? FCloserId { get; set; } |
| | | public string? FCloseDate { get; set; } |
| | | public string? FChangeDate { get; set; } |
| | | public string? FCancelStatus { get; set; } |
| | | public string? FCancellerId { get; set; } |
| | | public string? FVersionNo { get; set; } |
| | | public string? FChangerId { get; set; } |
| | | public string? FEntryNote { get; set; } |
| | | |
| | | |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi |
| | | { |
| | | public class ErpSalesOrderDetail |
| | | { |
| | | public string? Id { get; set; } |
| | | public string? Type { get; set; } |
| | | public string? FMaterialId { get; set; } |
| | | public string? FUnitID { get; set; } |
| | | public string? FQty { get; set; } |
| | | public string? FPriceUnitId { get; set; } |
| | | public string? FPriceUnitQty { get; set; } |
| | | public string? FDeliveryDate { get; set; } |
| | | public string? FIsFree { get; set; } |
| | | public string? FOwnerTypeId { get; set; } |
| | | public string? FOwnerId { get; set; } |
| | | public string? FEntryNote { get; set; } |
| | | public string? FMtoNo { get; set; } |
| | | public string? FLot { get; set; } |
| | | public string? FDeliveryMaxQty { get; set; } |
| | | public string? FDeliveryMinQty { get; set; } |
| | | public string? FOutLmtUnitID { get; set; } |
| | | public string? FMrpCloseStatus { get; set; } |
| | | public string? FMrpTerminateStatus { get; set; } |
| | | public string? FTerminateDate { get; set; } |
| | | public string? FTerminaterId { get; set; } |
| | | public string? FSrcType { get; set; } |
| | | public string? FSrcBillNo { get; set; } |
| | | public string? FDeliQty { get; set; } |
| | | public string? FStockOutQty { get; set; } |
| | | public string? FBaseRetNoticeQty { get; set; } |
| | | public string? FBaseReturnQty { get; set; } |
| | | public string? FBaseRemainOutQty { get; set; } |
| | | public string? FBASEARQTY { get; set; } |
| | | public string? ErpID { get; set; } |
| | | public string? EHID { get; set; } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi |
| | | { |
| | | public class ErpSalesReturnNotice |
| | | { |
| | | public string? Id { get; set; } |
| | | public string? type { get; set; } |
| | | public string? erpID { get; set; } |
| | | public string? fBillTypeID { get; set; } |
| | | public string? fBillNo { get; set; } |
| | | public string? fDate { get; set; } |
| | | public string? fSettleCurrld { get; set; } |
| | | public string? fSaleDeptId { get; set; } |
| | | public string? fRetcustId { get; set; } |
| | | public string? fRetcustReason { get; set; } |
| | | public string? fHeadLocId { get; set; } |
| | | public string? fRetDeptId { get; set; } |
| | | public string? fStockerGroupId { get; set; } |
| | | public string? fStockerId { get; set; } |
| | | public string? fSaleGroupId { get; set; } |
| | | public string? fSalesManId { get; set; } |
| | | public string? fReceiveCusId { get; set; } |
| | | public string? fReceiveCusContact { get; set; } |
| | | public string? fReceiveAddress { get; set; } |
| | | public string? fLinkMan { get; set; } |
| | | public string? fSettleCusId { get; set; } |
| | | public string? fCreatorId { get; set; } |
| | | public string? fCreateDate { get; set; } |
| | | public string? fModifierId { get; set; } |
| | | public string? fModifyDate { get; set; } |
| | | public string? fCloserId { get; set; } |
| | | public string? fCloseReason { get; set; } |
| | | public string? fCloseDate { get; set; } |
| | | public string? fApproverId { get; set; } |
| | | public string? fApproveDate { get; set; } |
| | | public string? fCancelStatus { get; set; } |
| | | public string? fCancellerId { get; set; } |
| | | public string? fCancelDate { get; set; } |
| | | public string? fBillCloseStatus { get; set; } |
| | | public string? fDocumentStatus { get; set; } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi |
| | | { |
| | | public class ErpSalesReturnNoticeDetail |
| | | { |
| | | public string? Id { get; set; } |
| | | public string? type { get; set; } |
| | | public string? erpID { get; set; } |
| | | public string? ehid { get; set; } |
| | | public string? fMaterialId { get; set; } |
| | | public string? fMaterialName { get; set; } |
| | | public string? fMaterialModel { get; set; } |
| | | public string? fUnitID { get; set; } |
| | | public string? fQty { get; set; } |
| | | public string? fIsFree { get; set; } |
| | | public string? fDeliverydate { get; set; } |
| | | public string? fStockId { get; set; } |
| | | public string? fMtoNo { get; set; } |
| | | public string? fLot { get; set; } |
| | | public string? fEntryDescription { get; set; } |
| | | public string? fRmType { get; set; } |
| | | public string? fStockUnitID { get; set; } |
| | | public string? fStockQty { get; set; } |
| | | public string? fMaterialType { get; set; } |
| | | public string? fOwnerTypeID { get; set; } |
| | | public string? fOwnerId { get; set; } |
| | | public string? fSrcType { get; set; } |
| | | public string? fSrcBillNo { get; set; } |
| | | public string? fOrderNo { get; set; } |
| | | |
| | | |
| | | |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Text; |
| | | using System.Threading.Tasks; |
| | | |
| | | namespace MES.Service.Dto.webApi |
| | | { |
| | | public class SaleDeliveryNotice |
| | | { |
| | | public ErpSalesDeliveryNotice ErpSalesDeliveryNotice { get; set; } |
| | | public List<ErpSalesDeliveryNoticeDetail> ErpSalesDeliveryNoticeDetails { get; set; } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi |
| | | { |
| | | public class SaleReturnNotice |
| | | { |
| | | public ErpSalesReturnNotice erpSalesReturnNotice { get; set; } |
| | | |
| | | public List<ErpSalesReturnNoticeDetail> erpSalesReturnNoticeDetail { get; set; } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi |
| | | { |
| | | public class SalesOrders |
| | | { |
| | | public ErpSalesOrder ErpSalesOrder { get; set; } |
| | | public List<ErpSalesOrderDetail> ErpSalesOrderDetails { get; set; } |
| | | |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using SqlSugar; |
| | | |
| | | namespace MES.Service.Modes; |
| | | |
| | | /// <summary> |
| | | /// éå®åè´§éç¥å表 |
| | | /// </summary> |
| | | [SugarTable("SALES_DELIVERY_NOTICE")] |
| | | public class SalesDeliveryNotice |
| | | { |
| | | /// <summary> |
| | | /// SEQ_salesåºå |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales", |
| | | IsPrimaryKey = true)] |
| | | public decimal Id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæ®ç±»å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BILL_TYPE")] |
| | | public string? BillType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæ®ç¼å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BILL_NO")] |
| | | public string? BillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "F_DATE")] |
| | | public DateTime? FDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç»ç®å¸å« |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CURRENCY")] |
| | | public string? Currency { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®ç»ç» |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_ORG")] |
| | | public string? SalesOrg { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®é¨é¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_DEPT")] |
| | | public string? SalesDept { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客æ·è®¢å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CUSTOMER_ORDER_NO")] |
| | | public string? CustomerOrderNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å®¢æ· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CUSTOMER")] |
| | | public string? Customer { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ·å®å®¢æ·å¤æ³¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "TAOBAO_REMARK")] |
| | | public string? TaobaoRemark { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 交货æ¹å¼ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DELIVERY_METHOD")] |
| | | public string? DeliveryMethod { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 交货å°ç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DELIVERY_LOCATION")] |
| | | public string? DeliveryLocation { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¿è¿å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CARRIER")] |
| | | public string? Carrier { get; set; } |
| | | |
| | | /// <summary> |
| | | /// è¿è¾åå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "TRANSPORT_NO")] |
| | | public string? TransportNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæ®ç¶æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BILL_NO_TYPE")] |
| | | public string? BillNoType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åè´§ç»ç» |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DELIVERY_ORG")] |
| | | public string? DeliveryOrg { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åè´§é¨é¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DELIVERY_DEPT")] |
| | | public string? DeliveryDept { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åºåç» |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "INVENTORY_GROUP")] |
| | | public string? InventoryGroup { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä»ç®¡å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "WAREHOUSE_MANAGER")] |
| | | public string? WarehouseManager { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®ç» |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_GROUP")] |
| | | public string? SalesGroup { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_PERSON")] |
| | | public string? SalesPerson { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¶è´§æ¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "RECEIVER")] |
| | | public string? Receiver { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¶è´§æ¹è系人 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "RECEIVER_CONTACT")] |
| | | public string? ReceiverContact { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¶è´§æ¹å°å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "RECEIVER_ADDRESS")] |
| | | public string? ReceiverAddress { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¶è´§æ¹å§å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "RECEIVER_NAME")] |
| | | public string? ReceiverName { get; set; } |
| | | |
| | | /// <summary> |
| | | /// èç³»çµè¯ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LINK_PHONE")] |
| | | public string? LinkPhone { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç»ç®æ¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SETTLE_PARTY")] |
| | | public string? SettleParty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 仿¬¾æ¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PAYER_PARTY")] |
| | | public string? PayerParty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å建人 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CREATED_BY")] |
| | | public string? CreatedBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å建æ¶é´ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CREATED_DATE")] |
| | | public DateTime? CreatedDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä¿®æ¹äºº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MODIFIED_BY")] |
| | | public string? ModifiedBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä¿®æ¹æ¶é´ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MODIFIED_DATE")] |
| | | public DateTime? ModifiedDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å
³é人 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CLOSED_BY")] |
| | | public string? ClosedBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å
³éåå |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CLOSE_REASON")] |
| | | public string? CloseReason { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å
³éæ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CLOSE_DATE")] |
| | | public DateTime? CloseDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å®¡æ ¸äºº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "APPROVED_BY")] |
| | | public string? ApprovedBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å®¡æ ¸æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "APPROVED_DATE")] |
| | | public DateTime? ApprovedDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä½åºç¶æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CANCEL_STATUS")] |
| | | public string? CancelStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä½åºäºº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CANCELLED_BY")] |
| | | public string? CancelledBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä½åºæ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CANCEL_DATE")] |
| | | public DateTime? CancelDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å
³éç¶æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CLOSE_STATUS")] |
| | | public string? CloseStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¯å¦æå¨å
³é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MANUAL_CLOSE_FLAG")] |
| | | public string? ManualCloseFlag { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERP头ID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ERP_ID")] |
| | | public string? ErpId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæ®ç¶æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BILL_STATUS")] |
| | | public string? BillStatus { get; set; } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using SqlSugar; |
| | | |
| | | namespace MES.Service.Modes; |
| | | |
| | | /// <summary> |
| | | /// éå®åè´§éç¥åæç»è¡¨ |
| | | /// </summary> |
| | | [SugarTable("SALES_DELIVERY_NOTICE_DETAIL")] |
| | | public class SalesDeliveryNoticeDetail |
| | | { |
| | | /// <summary> |
| | | /// SEQ_salesåºå |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales", |
| | | IsPrimaryKey = true)] |
| | | public decimal Id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®è®¢åå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_ORDER_ID")] |
| | | public string? SalesOrderId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç©æç¼ç |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MATERIAL_ID")] |
| | | public string? MaterialId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç©æåç§° |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MATERIAL_NAME")] |
| | | public string? MaterialName { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç©æè§æ ¼ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MATERIAL_SPECIFICATION")] |
| | | public string? MaterialSpecification { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®åä½ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_UNIT_ID")] |
| | | public string? SalesUnitId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// é宿°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_QUANTITY")] |
| | | public decimal? SalesQuantity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¯å¦èµ å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "IS_FREE")] |
| | | public string? IsFree { get; set; } |
| | | |
| | | /// <summary> |
| | | /// è¦è´§æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DELIVERY_DATE")] |
| | | public DateTime? DeliveryDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åºè´§ä»åº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "WAREHOUSE")] |
| | | public string? WareHouse { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计åè·è¸ªå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PLAN_TRACKING_NUMBER")] |
| | | public string? PlanTrackingNumber { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¹å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LOT_NUMBER")] |
| | | public string? LotNumber { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æºåç¼å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SRC_BILL_NO")] |
| | | public string? SrcBillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计价æ°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PRICE_QTY")] |
| | | public decimal? PriceQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 货主 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "OWNER_ID")] |
| | | public string? OwnerId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åºååä½ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "INVENTORY_UNIT")] |
| | | public string? InventoryUnit { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åºåæ°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "INVENTORY_QUANTITY")] |
| | | public decimal? InventoryQuantity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç©æç±»å« |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MATERIAL_CATEGORY")] |
| | | public string? MaterialCategory { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计ååè´§æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PLAN_DELIVERY_DATE")] |
| | | public DateTime? PlanDeliveryDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// è¶
åæ§å¶åä½ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "OUT_LMT_UNIT")] |
| | | public string? OutLmtUnit { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åºåºä¸é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "OUT_MAX_QTY")] |
| | | public decimal? OutMaxQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åºåºä¸é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "OUT_MIN_QTY")] |
| | | public decimal? OutMinQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 交货å°ç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DELIVERY_LOC")] |
| | | public string? DeliveryLoc { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 交货å°å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DELIVERYL_ADDRESS")] |
| | | public string? DeliveryAddress { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æºååå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SOURCE_BILL_NO")] |
| | | public string? SourceBillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 订ååå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ORDER_BILL_NO")] |
| | | public string? OrderBillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç»æ¢ç¶æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "TERMINATION_STATUS")] |
| | | public string? TerminationStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç»æ¢æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "TERMINATION_DATE")] |
| | | public DateTime? TerminationDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 累计åºåºæ°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SUM_OUT_QTY")] |
| | | public decimal? SumOutQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æªåºåºæ°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMAIN_OUT_QTY")] |
| | | public decimal? RemainOutQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERPID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ERP_LINE_ID")] |
| | | public string ErpLineId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERP头ID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ERP_HEAD_ID")] |
| | | public string ErpHeadId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FENTRYNOTE")] |
| | | public string FentryNote { get; set; } |
| | | |
| | | } |
| | | |
| | |
| | | public decimal Id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 订ååå· |
| | | /// ERP头ID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ORDER_ID")] |
| | | public string OrderId { get; set; } |
| | | [SugarColumn(ColumnName = "ERP_ID")] |
| | | public decimal? ErpId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 订ååå« |
| | | /// åæ®ç¼å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ORDER_TYPE")] |
| | | public string OrderType { get; set; } |
| | | [SugarColumn(ColumnName = "BILL_NO")] |
| | | public string? BillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åè®¢æ¥æ |
| | | /// åæ®ç±»å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ORDER_DATE")] |
| | | public DateTime? OrderDate { get; set; } |
| | | [SugarColumn(ColumnName = "BILL_TYPE_ID")] |
| | | public string? BillTypeId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæ®çæ¬ |
| | | /// åæ®ç¶æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DOCUMENT_VERSION")] |
| | | public long? DocumentVersion { get; set; } |
| | | [SugarColumn(ColumnName = "DOCUMENT_STATUS")] |
| | | public string? DocumentStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæ®æ¥æ |
| | | /// æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DOCUMENT_DATE")] |
| | | public DateTime? DocumentDate { get; set; } |
| | | [SugarColumn(ColumnName = "F_DATE")] |
| | | public DateTime? FDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å·¥åç¼å· |
| | | /// ä¸å¡ç±»å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FACTORY_ID")] |
| | | public string FactoryId { get; set; } |
| | | [SugarColumn(ColumnName = "BUSINESS_TYPE")] |
| | | public string? BusinessType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å·¥åç®ç§° |
| | | /// 交货æ¹å¼ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FACTORY_NAME")] |
| | | public string FactoryName { get; set; } |
| | | [SugarColumn(ColumnName = "HEAD_DELIVERY_WAY")] |
| | | public string? HeadDeliveryWay { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客æ·ç¼å· |
| | | /// 交货å°ç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CUSTOMER_ID")] |
| | | public string CustomerId { get; set; } |
| | | [SugarColumn(ColumnName = "HEAD_LOC_ID")] |
| | | public string? HeadLocId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客æ·ç®ç§° |
| | | /// å®¢æ· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CUSTOMER_NAME")] |
| | | public string CustomerName { get; set; } |
| | | [SugarColumn(ColumnName = "CUST_ID")] |
| | | public string? CustId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客æ·åå· |
| | | /// å
³éç¶æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CUSTOMER_ORDER_ID")] |
| | | public string CustomerOrderId { get; set; } |
| | | [SugarColumn(ColumnName = "CLOSE_STATUS")] |
| | | public string? CloseStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// é¨é¨ç¼å· |
| | | /// éå®é¨é¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DEPARTMENT_ID")] |
| | | public string DepartmentId { get; set; } |
| | | [SugarColumn(ColumnName = "SALE_DEPT_ID")] |
| | | public string? SaleDeptId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ»æ°é |
| | | /// éå®å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "TOTAL_QUANTITY")] |
| | | public decimal? TotalQuantity { get; set; } |
| | | [SugarColumn(ColumnName = "SALER_ID")] |
| | | public string? SalerId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæ´åå |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CHANGE_REASON")] |
| | | public string? ChangeReason { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARKS")] |
| | | public string Remarks { get; set; } |
| | | [SugarColumn(ColumnName = "NOTE")] |
| | | public string? Note { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç»ç®æ¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SETTLE_ID")] |
| | | public string? SettleId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// erpå®¡æ ¸äºº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "APPROVER_ID")] |
| | | public string? ApproverId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¶è´§äººå§å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LINK_MAN")] |
| | | public string? LinkMan { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 仿¬¾æ¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CHARGE_ID")] |
| | | public string? ChargeId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// èç³»çµè¯ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LINK_PHONE")] |
| | | public string? LinkPhone { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å建人 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CREATOR_ID")] |
| | | public string? CreatorId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åå»ºæ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CREATE_DATE")] |
| | | public DateTime? CreateDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æåä¿®æ¹äºº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MODIFIER_ID")] |
| | | public string? ModifierId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æåä¿®æ¹æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MODIFY_DATE")] |
| | | public DateTime? ModifyDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// erpå®¡æ ¸æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "APPROVAL_DATE")] |
| | | public DateTime? ApprovalDate { get; set; } |
| | | [SugarColumn(ColumnName = "APPROVE_DATE")] |
| | | public DateTime? ApproveDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// erpå®¡æ ¸è
|
| | | /// å
³é人 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "APPROVER")] |
| | | public string Approver { get; set; } |
| | | [SugarColumn(ColumnName = "CLOSER_ID")] |
| | | public string? CloserId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERPID |
| | | /// å
³éæ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ERP_ID")] |
| | | public string ErpId { get; set; } |
| | | [SugarColumn(ColumnName = "CLOSE_DATE")] |
| | | public DateTime? CloseDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæ´æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CHANGE_DATE")] |
| | | public DateTime? ChangeDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä½åºç¶æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CANCEL_STATUS")] |
| | | public string? CancelStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä½åºäºº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CANCELLER_ID")] |
| | | public string? CancellerId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// çæ¬å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "VERSION_NO")] |
| | | public decimal? VersionNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæ´äºº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CHANGER_ID")] |
| | | public string? ChangerId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ENTRY_NOTE")] |
| | | public string? EntryNote { get; set; } |
| | | |
| | | } |
| | |
| | | public decimal Id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 订ååå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ORDER_ID")] |
| | | public string OrderId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åºå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LINE_NUMBER")] |
| | | public long? LineNumber { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 产åç¼ç |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PRODUCT_CODE")] |
| | | public string ProductCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 产ååç§° |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PRODUCT_NAME")] |
| | | public string ProductName { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 产åè§æ ¼ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PRODUCT_SPEC")] |
| | | public string ProductSpec { get; set; } |
| | | |
| | | /// <summary> |
| | | /// é¢äº¤è´§æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SCHEDULED_DELIVERY_DATE")] |
| | | public DateTime? ScheduledDeliveryDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// è®¢åæ°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ORDER_QUANTITY")] |
| | | public decimal? OrderQuantity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åä½ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "UNIT")] |
| | | public string Unit { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åä»· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "UNIT_PRICE")] |
| | | public decimal? UnitPrice { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éé¢ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "AMOUNT")] |
| | | public decimal? Amount { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客æ·äº§åç¼ç |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CUSTOMER_PRODUCT_CODE")] |
| | | public string CustomerProductCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å·²äº¤è´§æ° |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DELIVERED_QUANTITY")] |
| | | public decimal? DeliveredQuantity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç»æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "IS_CLOSED")] |
| | | public string IsClosed { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARKS")] |
| | | public string Remarks { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERPID |
| | | /// ERPè¡ID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ERP_ID")] |
| | | public string ErpId { get; set; } |
| | | public decimal? ErpId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERP头ID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ERP_HEAD_ID")] |
| | | public string ErpHeadId { get; set; } |
| | | [SugarColumn(ColumnName = "E_HID")] |
| | | public decimal? EHid { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç©æç¼ç |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MATERIAL_ID")] |
| | | public string? MaterialIDd{ get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®åä½ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "UNIT_ID")] |
| | | public string? UnitId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// é宿°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "QTY")] |
| | | public decimal? Qty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计价åä½ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PRICE_UNIT_ID")] |
| | | public string? PriceUnitId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计价æ°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PRICE_UNIT_QTY")] |
| | | public decimal? PriceUnitQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// è¦è´§æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DELIVERY_DATE")] |
| | | public DateTime? DeliveryDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¯å¦èµ å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "IS_FREE")] |
| | | public string? IsFree { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 货主类å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "OWNER_TYPE_ID")] |
| | | public string? OwnerTypeId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 货主 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "OWNER_ID")] |
| | | public string? OwnerId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ENTRY_NOTE")] |
| | | public string? EntryNote { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计åè·è¸ªå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MTO_NO")] |
| | | public string? MtoNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¹å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LOT")] |
| | | public string? Lot { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åè´§ä¸é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DELIVERY_MAX_QTY")] |
| | | public decimal? DeliveryMaxQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åè´§ä¸é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DELIVERY_MIN_QTY")] |
| | | public decimal? DeliveryMinQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// è¶
åæ§å¶åä½ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "OUT_LMT_UNIT_ID")] |
| | | public string? OutLmtUnitId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä¸å¡å
³é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MRP_CLOSE_STATUS")] |
| | | public string? MrpCloseStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä¸å¡ç»æ¢ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MRP_TERMINATE_STATUS")] |
| | | public string? MrpTerminateStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç»æ¢æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "TERMINATE_DATE")] |
| | | public DateTime? TerminateDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç»æ¢äºº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "TERMINATER_ID")] |
| | | public string? TerminaterId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æºåç±»å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SRC_TYPE")] |
| | | public string? SrcType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æºååå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SRC_BILL_NO")] |
| | | public string? SrcBillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 累计åè´§éç¥æ°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DELI_QTY")] |
| | | public decimal? DeliQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 累计åºåºæ°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "STOCK_OUT_QTY")] |
| | | public decimal? StockOutQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 累计éè´§éç¥æ°éï¼éå®åºæ¬ï¼ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BASE_RET_NOTICE_QTY")] |
| | | public decimal? BaseRetNoticeQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 累计éè´§æ°éï¼éå®åºæ¬ï¼ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BASE_RETURN_QTY")] |
| | | public decimal? BaseReturnQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å©ä½æªåºæ°éï¼éå®åºæ¬ï¼ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BASE_REMAIN_OUT_QTY")] |
| | | public decimal? BaseRemainOutQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç´¯è®¡åºæ¶æ°éï¼éå®åºæ¬ï¼ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BASEARQTY")] |
| | | public decimal? BaseArQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客æ·ç©æç¼ç |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CUST_INO")] |
| | | public string? CustIno { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客æ·ç©æåç§° |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CUST_INM")] |
| | | public string? CustInm { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客æ·ç©æè§æ ¼ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CUST_IMD")] |
| | | public string? CustImd { get; set; } |
| | | |
| | | } |
| | |
| | | public decimal Id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å¶å人 |
| | | /// åæ®ç±»å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CREATED_BY")] |
| | | public string CreatedBy { get; set; } |
| | | [SugarColumn(ColumnName = "BILL_TYPE")] |
| | | public string? BillType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæ®ç¼å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DOCUMENT_ID")] |
| | | public string DocumentId { get; set; } |
| | | [SugarColumn(ColumnName = "BILL_NO")] |
| | | public string? BillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å®¡æ ¸äººåç§° |
| | | /// æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "F_DATE")] |
| | | public DateTime? FDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç»ç®å¸å« |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CURRENCY")] |
| | | public string? Currency { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®ç»ç» |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_ORG")] |
| | | public string? SalesOrg { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®é¨é¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_DEPT")] |
| | | public string? SalesDept { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客æ·è®¢å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CUSTOMER_ORDER_NO")] |
| | | public string? CustomerOrderNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éè´§å®¢æ· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "RETURN_CUSTOMER")] |
| | | public string? ReturnCustomer { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ·å®å®¢æ·å¤æ³¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "TAOBAO_REMARK")] |
| | | public string? TaobaoRemark { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éè´§åå |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "RETURN_REASON")] |
| | | public string? ReturnReason { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 交货å°ç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DELIVERY_LOCATION")] |
| | | public string? DeliveryLocation { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åºåç»ç» |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "INVENTORY_ORG")] |
| | | public string? InventoryOrg { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åºåé¨é¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "INVENTORY_DEPT")] |
| | | public string? InventoryDept { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åºåç» |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "INVENTORY_GROUP")] |
| | | public string? InventoryGroup { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä»ç®¡å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "WAREHOUSE_MANAGER")] |
| | | public string? WarehouseManager { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®ç» |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_GROUP")] |
| | | public string? SalesGroup { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_PERSON")] |
| | | public string? SalesPerson { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å¿«éåå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "EXPRESS_NO")] |
| | | public string? ExpressNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¶è´§æ¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "RECEIVER")] |
| | | public string? Receiver { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¶è´§æ¹è系人 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "RECEIVER_CONTACT")] |
| | | public string? ReceiverContact { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¶è´§æ¹å°å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "RECEIVER_ADDRESS")] |
| | | public string? ReceiverAddress { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¶è´§æ¹å§å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "RECEIVER_NAME")] |
| | | public string? ReceiverName { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç»ç®æ¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SETTLE_PARTY")] |
| | | public string? SettleParty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å建人 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CREATED_BY")] |
| | | public string? CreatedBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å建æ¶é´ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CREATED_DATE")] |
| | | public DateTime? CreatedDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä¿®æ¹äºº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MODIFIED_BY")] |
| | | public string? ModifiedBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä¿®æ¹æ¶é´ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MODIFIED_DATE")] |
| | | public DateTime? ModifiedDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å
³é人 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CLOSED_BY")] |
| | | public string? ClosedBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å
³éåå |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CLOSE_REASON")] |
| | | public string? CloseReason { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å
³éæ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CLOSE_DATE")] |
| | | public DateTime? CloseDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å®¡æ ¸äºº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "APPROVED_BY")] |
| | | public string ApprovedBy { get; set; } |
| | | public string? ApprovedBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å¶å/å®¡æ ¸æ¥æ |
| | | /// å®¡æ ¸æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CREATED_OR_APPROVED_DATE")] |
| | | public DateTime? CreatedOrApprovedDate { get; set; } |
| | | [SugarColumn(ColumnName = "APPROVED_DATE")] |
| | | public DateTime? ApprovedDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// é¨é¨ä»£ç |
| | | /// ä½åºç¶æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DEPARTMENT_CODE")] |
| | | public string DepartmentCode { get; set; } |
| | | [SugarColumn(ColumnName = "CANCEL_STATUS")] |
| | | public string? CancelStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// é¨é¨åç§° |
| | | /// ä½åºäºº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DEPARTMENT_NAME")] |
| | | public string DepartmentName { get; set; } |
| | | [SugarColumn(ColumnName = "CANCELLED_BY")] |
| | | public string? CancelledBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// è´è´§åä½ä»£ç |
| | | /// ä½åºæ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PURCHASER_CODE")] |
| | | public string PurchaserCode { get; set; } |
| | | [SugarColumn(ColumnName = "CANCEL_DATE")] |
| | | public DateTime? CancelDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// è´è´§åä½åç§° |
| | | /// å
³éç¶æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PURCHASER_NAME")] |
| | | public string PurchaserName { get; set; } |
| | | [SugarColumn(ColumnName = "CLOSE_STATUS")] |
| | | public string? CloseStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä¸å¡å代ç |
| | | /// æ¯å¦æå¨å
³é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALESPERSON_CODE")] |
| | | public string SalespersonCode { get; set; } |
| | | [SugarColumn(ColumnName = "MANUAL_CLOSE_FLAG")] |
| | | public string? ManualCloseFlag { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä¸å¡ååç§° |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALESPERSON_NAME")] |
| | | public string SalespersonName { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERPID |
| | | /// ERP头ID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ERP_ID")] |
| | | public string ErpId { get; set; } |
| | | public string? ErpId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæ®ç¶æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BILL_STATUS")] |
| | | public string? BillStatus { get; set; } |
| | | |
| | | |
| | | /// <summary> |
| | | /// éè´§åå |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FUNWTEXTTHYY")] |
| | | public string? Funwtextthyy { get; set; } |
| | | } |
| | |
| | | public decimal Id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæ®è¡å· |
| | | /// éå®è®¢åå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LINE_NUMBER")] |
| | | public long? LineNumber { get; set; } |
| | | [SugarColumn(ColumnName = "SALES_ORDER_ID")] |
| | | public string? SalesOrderId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 产å代ç |
| | | /// ç©æç¼ç |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PRODUCT_CODE")] |
| | | public string ProductCode { get; set; } |
| | | [SugarColumn(ColumnName = "MATERIAL_ID")] |
| | | public string? MaterialId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 产ååç§° |
| | | /// ç©æåç§° |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PRODUCT_NAME")] |
| | | public string ProductName { get; set; } |
| | | [SugarColumn(ColumnName = "MATERIAL_NAME")] |
| | | public string? MaterialName { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 产åè§æ ¼ |
| | | /// ç©æè§æ ¼ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PRODUCT_SPEC")] |
| | | public string ProductSpec { get; set; } |
| | | [SugarColumn(ColumnName = "MATERIAL_SPECIFICATION")] |
| | | public string? MaterialSpecification { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éé¢ |
| | | /// éå®åä½ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "AMOUNT")] |
| | | public decimal? Amount { get; set; } |
| | | [SugarColumn(ColumnName = "SALES_UNIT_ID")] |
| | | public string? SalesUnitId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åä»· |
| | | /// é宿°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "UNIT_PRICE")] |
| | | public decimal? UnitPrice { get; set; } |
| | | [SugarColumn(ColumnName = "SALES_QUANTITY")] |
| | | public decimal? SalesQuantity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ°é |
| | | /// æ¯å¦èµ å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "QUANTITY")] |
| | | public decimal? Quantity { get; set; } |
| | | [SugarColumn(ColumnName = "IS_FREE")] |
| | | public string? IsFree { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åºåºæ°é |
| | | /// éè´§æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "OUT_QUANTITY")] |
| | | public decimal? OutQuantity { get; set; } |
| | | [SugarColumn(ColumnName = "RETURN_DATE")] |
| | | public DateTime? ReturnDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä»åº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "WAREHOUSE")] |
| | | public string? WareHouse { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计åè·è¸ªå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PLAN_TRACKING_NUMBER")] |
| | | public string? PlanTrackingNumber { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¹å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BATCH_NUMBER")] |
| | | public string BatchNumber { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éè´§æ°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "RETURN_QUANTITY")] |
| | | public decimal? ReturnQuantity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åè´§æ°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DELIVERY_QUANTITY")] |
| | | public decimal? DeliveryQuantity { get; set; } |
| | | [SugarColumn(ColumnName = "LOT_NUMBER")] |
| | | public string? LotNumber { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARKS")] |
| | | public string Remarks { get; set; } |
| | | [SugarColumn(ColumnName = "NOTE")] |
| | | public string? Note { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®è®¢ååå· |
| | | /// éè´§ç±»å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_ORDER_ID")] |
| | | public string SalesOrderId { get; set; } |
| | | [SugarColumn(ColumnName = "RETURN_TYPE")] |
| | | public string? ReturnType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®è®¢ååå½ |
| | | /// è·åå |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_ORDER_ENTRY")] |
| | | public string SalesOrderEntry { get; set; } |
| | | [SugarColumn(ColumnName = "SALES_CLERK")] |
| | | public string? SalesClerk { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®è®¢åID |
| | | /// åºååä½ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_ORDER_DETAIL_ID")] |
| | | public string SalesOrderDetailId { get; set; } |
| | | [SugarColumn(ColumnName = "INVENTORY_UNIT")] |
| | | public string? InventoryUnit { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åºæ¬åä»· |
| | | /// åºåæ°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BASE_UNIT_PRICE")] |
| | | public decimal? BaseUnitPrice { get; set; } |
| | | [SugarColumn(ColumnName = "INVENTORY_QUANTITY")] |
| | | public decimal? InventoryQuantity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åºæ¬å使°é |
| | | /// ç©æç±»å« |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BASE_UNIT_QUANTITY")] |
| | | public decimal? BaseUnitQuantity { get; set; } |
| | | [SugarColumn(ColumnName = "MATERIAL_CATEGORY")] |
| | | public string? MaterialCategory { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä»åºä»£ç |
| | | /// 货主类å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "WAREHOUSE_CODE")] |
| | | public string WarehouseCode { get; set; } |
| | | [SugarColumn(ColumnName = "OWNER_TYPE_ID")] |
| | | public string? OwnerTypeId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä»åºåç§° |
| | | /// 货主 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "WAREHOUSE_NAME")] |
| | | public string WarehouseName { get; set; } |
| | | [SugarColumn(ColumnName = "OWNER_ID")] |
| | | public string? OwnerId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åºæ¬åä½åºåºæ°é |
| | | /// æºåç±»å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BASE_UNIT_OUT_QUANTITY")] |
| | | public decimal? BaseUnitOutQuantity { get; set; } |
| | | [SugarColumn(ColumnName = "SOURCE_BILL_TYPE")] |
| | | public string? SourceBillType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åä½ |
| | | /// æºååå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "UNIT")] |
| | | public string Unit { get; set; } |
| | | [SugarColumn(ColumnName = "SOURCE_BILL_NO")] |
| | | public string? SourceBillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 订ååå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ORDER_BILL_NO")] |
| | | public string? OrderBillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERPID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ERP_ID")] |
| | | public string ErpId { get; set; } |
| | | [SugarColumn(ColumnName = "ERP_LINE_ID")] |
| | | public string ErpLineId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERP头ID |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using MES.Service.DB; |
| | | using MES.Service.Modes; |
| | | using SqlSugar; |
| | | |
| | | namespace MES.Service.service.BasicData; |
| | | |
| | | public class SalesDeliveryNoticeDetailManager : Repository<SalesDeliveryNoticeDetail> |
| | | { |
| | | //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ |
| | | |
| | | //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,妿è¦éæ°çæè¯·å é¤ SalesReturnNoticeDetailManager.cs |
| | | |
| | | |
| | | #region æå¦æ¹æ³ |
| | | |
| | | /// <summary> |
| | | /// ä»å¨æ¹æ³æ»¡è¶³ä¸äºå¤æä¸å¡éæ±ï¼ä¸å¡ä»£ç 请å¨è¿éé¢å®ä¹æ¹æ³ |
| | | /// </summary> |
| | | public void Study() |
| | | { |
| | | /*********æ¥è¯¢*********/ |
| | | |
| | | var data1 = base.GetById(1); //æ ¹æ®IDæ¥è¯¢ |
| | | var data2 = base.GetList(); //æ¥è¯¢ææ |
| | | var data3 = base.GetList(it => 1 == 1); //æ ¹æ®æ¡ä»¶æ¥è¯¢ |
| | | //var data4 = base.GetSingle(it => 1 == 1);//æ ¹æ®æ¡ä»¶æ¥è¯¢ä¸æ¡,妿è¶
è¿ä¸æ¡ä¼æ¥é |
| | | |
| | | var p = new PageModel { PageIndex = 1, PageSize = 2 }; // å页æ¥è¯¢ |
| | | var data5 = base.GetPageList(it => 1 == 1, p); |
| | | Console.Write(p.TotalCount); //è¿åæ»æ° |
| | | |
| | | var data6 = |
| | | base.GetPageList(it => 1 == 1, p, |
| | | it => SqlFunc.GetRandom()); // å页æ¥è¯¢å æåº |
| | | Console.Write(p.TotalCount); //è¿åæ»æ° |
| | | |
| | | var conModels = new List<IConditionalModel>(); //ç»è£
æ¡ä»¶æ¥è¯¢ä½ä¸ºæ¡ä»¶å®ç° å页æ¥è¯¢å æåº |
| | | conModels.Add(new ConditionalModel |
| | | { |
| | | FieldName = typeof(SalesReturnNoticeDetail).GetProperties()[0].Name, |
| | | ConditionalType = ConditionalType.Equal, |
| | | FieldValue = "1" |
| | | }); //id=1 |
| | | var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom()); |
| | | |
| | | AsQueryable().Where(x => 1 == 1) |
| | | .ToList(); //æ¯æäºè½¬æ¢æqueryable,æä»¬å¯ä»¥ç¨queryableå®ç°å¤æåè½ |
| | | |
| | | |
| | | /*********æå
¥*********/ |
| | | var insertData = new SalesDeliveryNoticeDetail(); //æµè¯åæ° |
| | | var insertArray = new[] { insertData }; |
| | | base.Insert(insertData); //æå
¥ |
| | | base.InsertRange(insertArray); //æ¹éæå
¥ |
| | | var id = base.InsertReturnIdentity(insertData); //æå
¥è¿åèªå¢å |
| | | AsInsertable(insertData).ExecuteCommand(); //æä»¬å¯ä»¥è½¬æ Insertableå®ç°å¤ææå
¥ |
| | | |
| | | |
| | | /*********æ´æ°*********/ |
| | | var updateData = new SalesDeliveryNoticeDetail(); //æµè¯åæ° |
| | | var updateArray = new[] { updateData }; //æµè¯åæ° |
| | | base.Update(updateData); //æ ¹æ®å®ä½æ´æ° |
| | | base.UpdateRange(updateArray); //æ¹éæ´æ° |
| | | //base.Update(it => new SalesReturnNoticeDetail() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ´æ°ClassNameååCreateTimeåï¼å
¶å®å䏿´æ°ï¼æ¡ä»¶id=1 |
| | | AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå
¥ |
| | | |
| | | |
| | | /*********å é¤*********/ |
| | | var deldata = new SalesDeliveryNoticeDetail(); //æµè¯åæ° |
| | | base.Delete(deldata); //æ ¹æ®å®ä½å é¤ |
| | | base.DeleteById(1); //æ ¹æ®ä¸»é®å é¤ |
| | | base.DeleteById(new[] { 1, 2 }); //æ ¹æ®ä¸»é®æ°ç»å é¤ |
| | | base.Delete(it => 1 == 2); //æ ¹æ®æ¡ä»¶å é¤ |
| | | AsDeleteable().Where(it => 1 == 2) |
| | | .ExecuteCommand(); //转æDeleteableå®ç°å¤æçæä½ |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using MES.Service.DB; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using SqlSugar; |
| | | |
| | | namespace MES.Service.service.BasicData; |
| | | |
| | | public class SalesDeliveryNoticeManager : Repository<SalesDeliveryNotice> |
| | | { |
| | | //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ |
| | | |
| | | //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,妿è¦éæ°çæè¯·å é¤ SalesReturnNoticeManager.cs |
| | | |
| | | |
| | | #region æå¦æ¹æ³ |
| | | |
| | | /// <summary> |
| | | /// ä»å¨æ¹æ³æ»¡è¶³ä¸äºå¤æä¸å¡éæ±ï¼ä¸å¡ä»£ç 请å¨è¿éé¢å®ä¹æ¹æ³ |
| | | /// </summary> |
| | | public void Study() |
| | | { |
| | | /*********æ¥è¯¢*********/ |
| | | |
| | | var data1 = base.GetById(1); //æ ¹æ®IDæ¥è¯¢ |
| | | var data2 = base.GetList(); //æ¥è¯¢ææ |
| | | var data3 = base.GetList(it => 1 == 1); //æ ¹æ®æ¡ä»¶æ¥è¯¢ |
| | | //var data4 = base.GetSingle(it => 1 == 1);//æ ¹æ®æ¡ä»¶æ¥è¯¢ä¸æ¡,妿è¶
è¿ä¸æ¡ä¼æ¥é |
| | | |
| | | var p = new PageModel { PageIndex = 1, PageSize = 2 }; // å页æ¥è¯¢ |
| | | var data5 = base.GetPageList(it => 1 == 1, p); |
| | | Console.Write(p.TotalCount); //è¿åæ»æ° |
| | | |
| | | var data6 = |
| | | base.GetPageList(it => 1 == 1, p, |
| | | it => SqlFunc.GetRandom()); // å页æ¥è¯¢å æåº |
| | | Console.Write(p.TotalCount); //è¿åæ»æ° |
| | | |
| | | var conModels = new List<IConditionalModel>(); //ç»è£
æ¡ä»¶æ¥è¯¢ä½ä¸ºæ¡ä»¶å®ç° å页æ¥è¯¢å æåº |
| | | conModels.Add(new ConditionalModel |
| | | { |
| | | FieldName = typeof(SalesReturnNotice).GetProperties()[0].Name, |
| | | ConditionalType = ConditionalType.Equal, |
| | | FieldValue = "1" |
| | | }); //id=1 |
| | | var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom()); |
| | | |
| | | AsQueryable().Where(x => 1 == 1) |
| | | .ToList(); //æ¯æäºè½¬æ¢æqueryable,æä»¬å¯ä»¥ç¨queryableå®ç°å¤æåè½ |
| | | |
| | | |
| | | /*********æå
¥*********/ |
| | | var insertData = new SalesDeliveryNotice(); //æµè¯åæ° |
| | | var insertArray = new[] { insertData }; |
| | | base.Insert(insertData); //æå
¥ |
| | | base.InsertRange(insertArray); //æ¹éæå
¥ |
| | | var id = base.InsertReturnIdentity(insertData); //æå
¥è¿åèªå¢å |
| | | AsInsertable(insertData).ExecuteCommand(); //æä»¬å¯ä»¥è½¬æ Insertableå®ç°å¤ææå
¥ |
| | | |
| | | |
| | | /*********æ´æ°*********/ |
| | | var updateData = new SalesDeliveryNotice(); //æµè¯åæ° |
| | | var updateArray = new[] { updateData }; //æµè¯åæ° |
| | | base.Update(updateData); //æ ¹æ®å®ä½æ´æ° |
| | | base.UpdateRange(updateArray); //æ¹éæ´æ° |
| | | //base.Update(it => new SalesReturnNotice() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ´æ°ClassNameååCreateTimeåï¼å
¶å®å䏿´æ°ï¼æ¡ä»¶id=1 |
| | | AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå
¥ |
| | | |
| | | |
| | | /*********å é¤*********/ |
| | | var deldata = new SalesDeliveryNotice(); //æµè¯åæ° |
| | | base.Delete(deldata); //æ ¹æ®å®ä½å é¤ |
| | | base.DeleteById(1); //æ ¹æ®ä¸»é®å é¤ |
| | | base.DeleteById(new[] { 1, 2 }); //æ ¹æ®ä¸»é®æ°ç»å é¤ |
| | | base.Delete(it => 1 == 2); //æ ¹æ®æ¡ä»¶å é¤ |
| | | AsDeleteable().Where(it => 1 == 2) |
| | | .ExecuteCommand(); //转æDeleteableå®ç°å¤æçæä½ |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | private readonly SalesDeliveryNoticeDetailManager salesDeliveryNoticeDetailManager = new(); |
| | | |
| | | // Save æ¹æ³ç¨äºä¿åå个 éå®è®¢å(SalesOrder) è®°å½ï¼æ ¹æ®ç±»åæ§è¡ä¸åçæä½ |
| | | public bool Save(SaleDeliveryNotice saleDeliveryNotice) |
| | | { |
| | | var salesDeliveryNoticeErpSalesDeliveryNotice = saleDeliveryNotice.ErpSalesDeliveryNotice; |
| | | var mesSalesDeliveryNotice = GetSalesDeliveryNotice(salesDeliveryNoticeErpSalesDeliveryNotice); |
| | | var mesSalesDeliveryNoticeDetails = GetErpSalesDeliveryNoticeDetail(saleDeliveryNotice.ErpSalesDeliveryNoticeDetails, salesDeliveryNoticeErpSalesDeliveryNotice.type); |
| | | |
| | | return UseTransaction(db => |
| | | { |
| | | switch (salesDeliveryNoticeErpSalesDeliveryNotice.type) |
| | | { |
| | | case "3": |
| | | return UpdateData(db, mesSalesDeliveryNotice, mesSalesDeliveryNoticeDetails) ? 1 : 0; |
| | | case "2": |
| | | case "4": |
| | | case "5": |
| | | case "6": |
| | | return SaveOrUpdateData(db, mesSalesDeliveryNotice, mesSalesDeliveryNoticeDetails) |
| | | ? 1 |
| | | : 0; |
| | | default: |
| | | throw new NotImplementedException( |
| | | $"type没æ{salesDeliveryNoticeErpSalesDeliveryNotice.type}è¿ä¸ªç±»å"); |
| | | } |
| | | }) > 0; |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | // æ´æ°æ°æ®çæ¹æ³(å纯çå é¤) |
| | | private bool UpdateData(SqlSugarScope db, SalesDeliveryNotice salesDeliveryNotice, |
| | | List<SalesDeliveryNoticeDetail> salesDeliveryNoticeDetails) |
| | | { |
| | | var decimals = salesDeliveryNoticeDetails.Select(s => s.Id).ToArray(); |
| | | var update = base.DeleteById(salesDeliveryNotice.Id); |
| | | var insertOrUpdate = db |
| | | .Deleteable<SalesOrderDetail>().In(decimals) |
| | | .ExecuteCommand() > 0; |
| | | |
| | | if (update && insertOrUpdate) return true; |
| | | throw new NotImplementedException("å é¤å¤±è´¥"); |
| | | } |
| | | |
| | | // æå
¥ææ´æ°æ°æ®çæ¹æ³ |
| | | private bool SaveOrUpdateData(SqlSugarScope db, SalesDeliveryNotice salesDeliveryNotice, |
| | | List<SalesDeliveryNoticeDetail> salesDeliveryNoticeDetails) |
| | | { |
| | | if (salesDeliveryNotice.Id != null) base.DeleteById(salesDeliveryNotice.Id); |
| | | |
| | | if (salesDeliveryNoticeDetails.Count > 0) |
| | | db.Deleteable<SalesOrderDetail>() |
| | | .Where(s => s.ErpId == salesDeliveryNotice.Id).ExecuteCommand(); |
| | | |
| | | var orUpdate = base.Insert(salesDeliveryNotice); |
| | | var baOrUpdate = salesDeliveryNoticeDetailManager.InsertRange(salesDeliveryNoticeDetails); |
| | | if (orUpdate && baOrUpdate) return true; |
| | | throw new NotImplementedException("æå
¥ææ´æ°å¤±è´¥"); |
| | | } |
| | | |
| | | // æ¹éä¿åè®°å½çæ¹æ³ |
| | | public bool SaveList(List<SaleDeliveryNotice> saleDeliveryNotices) |
| | | { |
| | | var result = saleDeliveryNotices.Select(Save).ToList(); |
| | | return result.All(b => b); |
| | | } |
| | | |
| | | |
| | | // å° erpSalesDeliveryNotice 对象转æ¢ä¸º SalesReturnNotice å¯¹è±¡çæ¹æ³ |
| | | public SalesDeliveryNotice GetSalesDeliveryNotice(ErpSalesDeliveryNotice erpSalesDeliveryNotice) |
| | | { |
| | | |
| | | var eid = Convert.ToDecimal(erpSalesDeliveryNotice.Id); |
| | | var MesSalesDeliveryNotice = new SalesDeliveryNotice(); |
| | | |
| | | var single = base.GetSingle(it => it.Id == eid); |
| | | if (single != null) MesSalesDeliveryNotice.Id = single.Id; |
| | | |
| | | MesSalesDeliveryNotice.ErpId = erpSalesDeliveryNotice.erpID; |
| | | MesSalesDeliveryNotice.BillType = erpSalesDeliveryNotice.fBillTypeID; |
| | | MesSalesDeliveryNotice.BillNo = erpSalesDeliveryNotice.fBillNo; |
| | | |
| | | if (erpSalesDeliveryNotice.fDate != null) |
| | | MesSalesDeliveryNotice.FDate = DateTime.ParseExact(erpSalesDeliveryNotice.fDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | MesSalesDeliveryNotice.Currency = erpSalesDeliveryNotice.fSettleCurrld; |
| | | MesSalesDeliveryNotice.SalesDept = erpSalesDeliveryNotice.fSaleDeptId; |
| | | MesSalesDeliveryNotice.Customer = erpSalesDeliveryNotice.fCustomerID; |
| | | MesSalesDeliveryNotice.DeliveryMethod = erpSalesDeliveryNotice.fHeadDeliveryWay; |
| | | MesSalesDeliveryNotice.DeliveryLocation = erpSalesDeliveryNotice.fHeadLocId; |
| | | MesSalesDeliveryNotice.Carrier = erpSalesDeliveryNotice.fCarrierID; |
| | | MesSalesDeliveryNotice.SettleParty = erpSalesDeliveryNotice.fCarriageNO; |
| | | MesSalesDeliveryNotice.SettleParty = erpSalesDeliveryNotice.fDeliveryDeptID; |
| | | MesSalesDeliveryNotice.InventoryGroup = erpSalesDeliveryNotice.fStockerGroupId; |
| | | MesSalesDeliveryNotice.WarehouseManager = erpSalesDeliveryNotice.fStockerId; |
| | | MesSalesDeliveryNotice.SalesGroup = erpSalesDeliveryNotice.fSaleGroupId; |
| | | MesSalesDeliveryNotice.SalesPerson = erpSalesDeliveryNotice.fSalesManId; |
| | | MesSalesDeliveryNotice.Receiver = erpSalesDeliveryNotice.fReceiveCusId; |
| | | MesSalesDeliveryNotice.ReceiverContact = erpSalesDeliveryNotice.fReceiveCusContact; |
| | | MesSalesDeliveryNotice.ReceiverAddress = erpSalesDeliveryNotice.fReceiveAddress; |
| | | MesSalesDeliveryNotice.ReceiverName = erpSalesDeliveryNotice.fLinkMan; |
| | | MesSalesDeliveryNotice.ReceiverName = erpSalesDeliveryNotice.fLinkPhone; |
| | | MesSalesDeliveryNotice.SettleParty = erpSalesDeliveryNotice.fSettleID; |
| | | MesSalesDeliveryNotice.PayerParty = erpSalesDeliveryNotice.fPayerID; |
| | | MesSalesDeliveryNotice.CreatedBy = erpSalesDeliveryNotice.fCreatorId; |
| | | |
| | | if (erpSalesDeliveryNotice.fCreateDate != null) |
| | | MesSalesDeliveryNotice.CreatedDate = DateTime.ParseExact(erpSalesDeliveryNotice.fCreateDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | MesSalesDeliveryNotice.ModifiedBy = erpSalesDeliveryNotice.fModifierId; |
| | | |
| | | if (erpSalesDeliveryNotice.fModifyDate != null) |
| | | MesSalesDeliveryNotice.ModifiedDate = DateTime.ParseExact(erpSalesDeliveryNotice.fModifyDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | MesSalesDeliveryNotice.ApprovedBy = erpSalesDeliveryNotice.fApproverId; |
| | | |
| | | if (erpSalesDeliveryNotice.fApproveDate != null) |
| | | MesSalesDeliveryNotice.ApprovedDate = DateTime.ParseExact(erpSalesDeliveryNotice.fApproveDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | MesSalesDeliveryNotice.ClosedBy = erpSalesDeliveryNotice.fCloserId; |
| | | MesSalesDeliveryNotice.CloseReason = erpSalesDeliveryNotice.fCloseReason; |
| | | MesSalesDeliveryNotice.CloseStatus = erpSalesDeliveryNotice.fBillCloseStatus; |
| | | MesSalesDeliveryNotice.CancelStatus = erpSalesDeliveryNotice.fCancelStatus; |
| | | MesSalesDeliveryNotice.CancelledBy = erpSalesDeliveryNotice.fCancellerId; |
| | | |
| | | if (erpSalesDeliveryNotice.fCancelDate != null) |
| | | MesSalesDeliveryNotice.CancelDate = DateTime.ParseExact(erpSalesDeliveryNotice.fCancelDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | MesSalesDeliveryNotice.BillStatus = erpSalesDeliveryNotice.fDocumentStatus; |
| | | |
| | | return MesSalesDeliveryNotice; |
| | | } |
| | | |
| | | // å° erpSalesDeliveryNoticeDetail 对象转æ¢ä¸º SalesReturnNoticeDetail å¯¹è±¡çæ¹æ³ |
| | | public List<SalesDeliveryNoticeDetail> GetErpSalesDeliveryNoticeDetail( |
| | | List<ErpSalesDeliveryNoticeDetail> erpSalesDeliveryNoticeDetails, string type) |
| | | { |
| | | return erpSalesDeliveryNoticeDetails.Select(s => |
| | | { |
| | | var entity = new SalesDeliveryNoticeDetail |
| | | { |
| | | Id = Convert.ToDecimal(s.Id), |
| | | ErpLineId = s.erpID, |
| | | ErpHeadId = s.ehid, |
| | | MaterialId = s.fMaterialId, |
| | | MaterialName = s.fUnitID, |
| | | SalesQuantity = Convert.ToDecimal(s.fQty), |
| | | IsFree = s.fIsFree, |
| | | DeliveryDate = s.fDeliverydate != null ? DateTime.ParseExact(s.fDeliverydate, "yyyy-MM-dd HH:mm:ss", null) : null, |
| | | WareHouse = s.fStockId, |
| | | PlanTrackingNumber = s.fMtoNo, |
| | | LotNumber = s.fLot, |
| | | PriceQty = Convert.ToDecimal(s.fPriceUnitQty), |
| | | OwnerId = s.fOwnerIdHead, |
| | | InventoryUnit = s.fStockUnitID, |
| | | InventoryQuantity = Convert.ToDecimal(s.fStockQty), |
| | | PlanDeliveryDate = s.fPlanDeliveryDate != null ? DateTime.ParseExact(s.fPlanDeliveryDate, "yyyy-MM-dd HH:mm:ss", null) : null, |
| | | OutLmtUnit = s.fOutLmtUnit, |
| | | OutMaxQty = Convert.ToDecimal(s.fOutMaxQty), |
| | | OutMinQty = Convert.ToDecimal(s.fOutMinQty), |
| | | DeliveryLoc = s.fDeliveryLoc, |
| | | DeliveryAddress = s.fDeliveryLAddress, |
| | | SourceBillNo = s.fSrcBillNo, |
| | | OrderBillNo = s.fOrderNo, |
| | | TerminationStatus = s.fTerminationStatus, |
| | | TerminationDate = s.fTerminateDate != null ? DateTime.ParseExact(s.fTerminateDate, "yyyy-MM-dd HH:mm:ss", null) : null, |
| | | SumOutQty = Convert.ToDecimal(s.fSumOutQty), |
| | | RemainOutQty = Convert.ToDecimal(s.fRemainOutQty), |
| | | FentryNote = s.FNoteEntry, |
| | | |
| | | }; |
| | | |
| | | var single = salesDeliveryNoticeDetailManager.GetSingle(it => |
| | | it.Id == entity.Id); |
| | | if (single != null) entity.Id = single.Id; |
| | | |
| | | return entity; |
| | | }).ToList(); |
| | | } |
| | | } |
| | |
| | | using MES.Service.DB; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using SqlSugar; |
| | | |
| | |
| | | conModels.Add(new ConditionalModel |
| | | { |
| | | FieldName = typeof(SalesOrder).GetProperties()[0].Name, |
| | | ConditionalType = ConditionalType.Equal, FieldValue = "1" |
| | | ConditionalType = ConditionalType.Equal, |
| | | FieldValue = "1" |
| | | }); //id=1 |
| | | var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom()); |
| | | |
| | |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | |
| | | private readonly SalesOrderDetailManager salesOrderDetailManager = new(); |
| | | |
| | | // Save æ¹æ³ç¨äºä¿åå个 éå®è®¢å(SalesOrder) è®°å½ï¼æ ¹æ®ç±»åæ§è¡ä¸åçæä½ |
| | | public bool Save(SalesOrders salesOrders) |
| | | { |
| | | var salesOrdersErpSalesOrder = salesOrders.ErpSalesOrder; |
| | | var mesSalesOrders = GetMesSalesOrder(salesOrdersErpSalesOrder); |
| | | var mesSalesOrderDetail = GetErpSalesOrderDetail(salesOrders.ErpSalesOrderDetails,salesOrdersErpSalesOrder.Type); |
| | | |
| | | return UseTransaction(db => |
| | | { |
| | | switch (salesOrdersErpSalesOrder.Type) |
| | | { |
| | | case "3": |
| | | return UpdateData(db, mesSalesOrders, mesSalesOrderDetail) ? 1 : 0; |
| | | case "2": |
| | | case "4": |
| | | case "5": |
| | | case "B": |
| | | return SaveOrUpdateData(db, mesSalesOrders, mesSalesOrderDetail) |
| | | ? 1 |
| | | : 0; |
| | | default: |
| | | throw new NotImplementedException( |
| | | $"type没æ{salesOrdersErpSalesOrder.Type}è¿ä¸ªç±»å"); |
| | | } |
| | | }) > 0; |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | // æ´æ°æ°æ®çæ¹æ³(å纯çå é¤) |
| | | private bool UpdateData(SqlSugarScope db, SalesOrder salesOrder, |
| | | List<SalesOrderDetail> salesOrderDetails) |
| | | { |
| | | var decimals = salesOrderDetails.Select(s => s.Id).ToArray(); |
| | | var update = base.DeleteById(salesOrder.Id); |
| | | var insertOrUpdate = db |
| | | .Deleteable<SalesOrderDetail>().In(decimals) |
| | | .ExecuteCommand() > 0; |
| | | |
| | | if (update && insertOrUpdate) return true; |
| | | throw new NotImplementedException("å é¤å¤±è´¥"); |
| | | } |
| | | |
| | | // æå
¥ææ´æ°æ°æ®çæ¹æ³ |
| | | private bool SaveOrUpdateData(SqlSugarScope db, SalesOrder salesOrder, |
| | | List<SalesOrderDetail> salesOrderDetails) |
| | | { |
| | | if (salesOrder.Id != null) base.DeleteById(salesOrder.Id); |
| | | |
| | | if (salesOrderDetails.Count > 0) |
| | | db.Deleteable<SalesOrderDetail>() |
| | | .Where(s => s.ErpId == salesOrder.Id).ExecuteCommand(); |
| | | |
| | | var orUpdate = base.Insert(salesOrder); |
| | | var baOrUpdate = salesOrderDetailManager.InsertRange(salesOrderDetails); |
| | | if (orUpdate && baOrUpdate) return true; |
| | | throw new NotImplementedException("æå
¥ææ´æ°å¤±è´¥"); |
| | | } |
| | | |
| | | // æ¹éä¿åè®°å½çæ¹æ³ |
| | | public bool SaveList(List<SalesOrders> salesOrders) |
| | | { |
| | | var result = salesOrders.Select(Save).ToList(); |
| | | return result.All(b => b); |
| | | } |
| | | |
| | | |
| | | // å° ErpSalesOrder 对象转æ¢ä¸º SalesOrder å¯¹è±¡çæ¹æ³ |
| | | public SalesOrder GetMesSalesOrder(ErpSalesOrder erpSalesOrder) |
| | | { |
| | | |
| | | var eid = Convert.ToDecimal(erpSalesOrder.Id); |
| | | var MesSalesOrder = new SalesOrder(); |
| | | |
| | | var single = base.GetSingle(it => it.Id == eid); |
| | | if (single != null) MesSalesOrder.Id = single.Id; |
| | | |
| | | MesSalesOrder.ErpId = Convert.ToDecimal(erpSalesOrder.ErpID); |
| | | MesSalesOrder.BillNo = erpSalesOrder.FBillNo; |
| | | MesSalesOrder.BillTypeId = erpSalesOrder.FBillTypeID; |
| | | MesSalesOrder.DocumentStatus = erpSalesOrder.FDocumentStatus; |
| | | |
| | | if (erpSalesOrder.FDate != null) |
| | | MesSalesOrder.FDate = DateTime.ParseExact(erpSalesOrder.FDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | MesSalesOrder.BusinessType = erpSalesOrder.FBusinessType; |
| | | MesSalesOrder.HeadDeliveryWay = erpSalesOrder.FHeadDeliveryWay; |
| | | MesSalesOrder.CloseStatus = erpSalesOrder.FCloseStatus; |
| | | MesSalesOrder.HeadLocId = erpSalesOrder.FHEADLOCID; |
| | | MesSalesOrder.CustId = erpSalesOrder.FCustId; |
| | | MesSalesOrder.CloseStatus = erpSalesOrder.FCloseStatus; |
| | | MesSalesOrder.SaleDeptId = erpSalesOrder.FSaleDeptId; |
| | | MesSalesOrder.SalerId = erpSalesOrder.FSalerId; |
| | | MesSalesOrder.ChangeReason = erpSalesOrder.FChangeReason; |
| | | MesSalesOrder.Note = erpSalesOrder.FNote; |
| | | MesSalesOrder.SettleId = erpSalesOrder.FSettleId; |
| | | MesSalesOrder.LinkMan = erpSalesOrder.FLinkMan; |
| | | MesSalesOrder.ChargeId = erpSalesOrder.FChargeId; |
| | | MesSalesOrder.LinkPhone = erpSalesOrder.FLinkPhone; |
| | | MesSalesOrder.CreatorId = erpSalesOrder.FCreatorId; |
| | | |
| | | if (erpSalesOrder.FCreateDate != null) |
| | | MesSalesOrder.CreateDate = DateTime.ParseExact(erpSalesOrder.FCreateDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | MesSalesOrder.ModifierId = erpSalesOrder.FModifierId; |
| | | |
| | | if (erpSalesOrder.FModifyDate != null) |
| | | MesSalesOrder.ModifyDate = DateTime.ParseExact(erpSalesOrder.FModifyDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | if (erpSalesOrder.FApproveDate != null) |
| | | MesSalesOrder.ApproveDate = DateTime.ParseExact(erpSalesOrder.FApproveDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | MesSalesOrder.CloserId = erpSalesOrder.FCloserId; |
| | | |
| | | if (erpSalesOrder.FCloseDate != null) |
| | | MesSalesOrder.CloseDate = DateTime.ParseExact(erpSalesOrder.FCloseDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | if (erpSalesOrder.FChangeDate != null) |
| | | MesSalesOrder.ChangeDate = DateTime.ParseExact(erpSalesOrder.FChangeDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | MesSalesOrder.CancelStatus = erpSalesOrder.FCancelStatus; |
| | | MesSalesOrder.CancellerId = erpSalesOrder.FCancellerId; |
| | | MesSalesOrder.VersionNo = Convert.ToDecimal(erpSalesOrder.FVersionNo); |
| | | MesSalesOrder.ChangerId = erpSalesOrder.FChangerId; |
| | | MesSalesOrder.EntryNote = erpSalesOrder.FEntryNote; |
| | | |
| | | return MesSalesOrder; |
| | | } |
| | | |
| | | // å° ErpSalesOrderDetail 对象转æ¢ä¸º SalesOrderDetail å¯¹è±¡çæ¹æ³ |
| | | public List<SalesOrderDetail> GetErpSalesOrderDetail( |
| | | List<ErpSalesOrderDetail> erpSalesOrderDetails, string type) |
| | | { |
| | | return erpSalesOrderDetails.Select(s => |
| | | { |
| | | var entity = new SalesOrderDetail |
| | | { |
| | | Id = Convert.ToDecimal(s.Id), |
| | | ErpId = Convert.ToDecimal(s.ErpID), |
| | | EHid = Convert.ToDecimal(s.EHID), |
| | | MaterialIDd = s.FMaterialId, |
| | | UnitId = s.FUnitID, |
| | | Qty = Convert.ToDecimal(s.FQty), |
| | | PriceUnitId = s.FPriceUnitId, |
| | | PriceUnitQty = Convert.ToDecimal(s.FPriceUnitQty), |
| | | DeliveryDate = s.FDeliveryDate != null ? DateTime.ParseExact(s.FDeliveryDate, "yyyy-MM-dd HH:mm:ss", null) : null, |
| | | IsFree = s.FIsFree, |
| | | OwnerTypeId = s.FOwnerTypeId, |
| | | OwnerId = s.FOwnerId, |
| | | EntryNote = s.FEntryNote, |
| | | MtoNo = s.FMtoNo, |
| | | Lot = s.FLot, |
| | | DeliveryMaxQty = Convert.ToDecimal(s.FDeliveryMaxQty), |
| | | DeliveryMinQty = Convert.ToDecimal(s.FDeliveryMinQty), |
| | | OutLmtUnitId = s.FOutLmtUnitID, |
| | | MrpCloseStatus = s.FMrpCloseStatus, |
| | | MrpTerminateStatus = s.FMrpTerminateStatus, |
| | | TerminateDate = s.FTerminateDate != null ? DateTime.ParseExact(s.FTerminateDate, "yyyy-MM-dd HH:mm:ss", null) : null, |
| | | TerminaterId = s.FTerminaterId, |
| | | SrcType = s.FSrcType, |
| | | SrcBillNo = s.FSrcBillNo, |
| | | DeliQty = Convert.ToDecimal(s.FDeliQty), |
| | | StockOutQty = Convert.ToDecimal(s.FStockOutQty), |
| | | BaseRetNoticeQty = Convert.ToDecimal(s.FBaseRetNoticeQty), |
| | | BaseReturnQty = Convert.ToDecimal(s.FBaseReturnQty), |
| | | BaseRemainOutQty = Convert.ToDecimal(s.FBaseRemainOutQty), |
| | | BaseArQty = Convert.ToDecimal(s.FBASEARQTY), |
| | | |
| | | |
| | | |
| | | }; |
| | | |
| | | var single = salesOrderDetailManager.GetSingle(it => |
| | | it.Id == entity.Id); |
| | | if (single != null) entity.Id = single.Id; |
| | | |
| | | return entity; |
| | | }).ToList(); |
| | | } |
| | | } |
| | |
| | | using MES.Service.DB; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using SqlSugar; |
| | | |
| | |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | private readonly SalesReturnNoticeDetailManager salesReturnNoticeDetailManager = new(); |
| | | |
| | | // Save æ¹æ³ç¨äºä¿åå个 éå®è®¢å(SalesOrder) è®°å½ï¼æ ¹æ®ç±»åæ§è¡ä¸åçæä½ |
| | | public bool Save(SaleReturnNotice saleReturnNotice) |
| | | { |
| | | var salesReturnNoticeErpSalesReturnNotice = saleReturnNotice.erpSalesReturnNotice; |
| | | var mesSalesReturnNotice = GetSalesReturnNotice(salesReturnNoticeErpSalesReturnNotice); |
| | | var mesSalesReturnNoticeDetails = GetErpSalesOrderDetail(saleReturnNotice.erpSalesReturnNoticeDetail, salesReturnNoticeErpSalesReturnNotice.type); |
| | | |
| | | return UseTransaction(db => |
| | | { |
| | | switch (salesReturnNoticeErpSalesReturnNotice.type) |
| | | { |
| | | case "3": |
| | | return UpdateData(db, mesSalesReturnNotice, mesSalesReturnNoticeDetails) ? 1 : 0; |
| | | case "2": |
| | | case "4": |
| | | case "5": |
| | | case "6": |
| | | return SaveOrUpdateData(db, mesSalesReturnNotice, mesSalesReturnNoticeDetails) |
| | | ? 1 |
| | | : 0; |
| | | default: |
| | | throw new NotImplementedException( |
| | | $"type没æ{salesReturnNoticeErpSalesReturnNotice.type}è¿ä¸ªç±»å"); |
| | | } |
| | | }) > 0; |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | // æ´æ°æ°æ®çæ¹æ³(å纯çå é¤) |
| | | private bool UpdateData(SqlSugarScope db, SalesReturnNotice salesReturnNotice, |
| | | List<SalesReturnNoticeDetail> salesReturnNoticeDetails) |
| | | { |
| | | var decimals = salesReturnNoticeDetails.Select(s => s.Id).ToArray(); |
| | | var update = base.DeleteById(salesReturnNotice.Id); |
| | | var insertOrUpdate = db |
| | | .Deleteable<SalesOrderDetail>().In(decimals) |
| | | .ExecuteCommand() > 0; |
| | | |
| | | if (update && insertOrUpdate) return true; |
| | | throw new NotImplementedException("å é¤å¤±è´¥"); |
| | | } |
| | | |
| | | // æå
¥ææ´æ°æ°æ®çæ¹æ³ |
| | | private bool SaveOrUpdateData(SqlSugarScope db, SalesReturnNotice salesReturnNotice, |
| | | List<SalesReturnNoticeDetail> salesReturnNoticeDetails) |
| | | { |
| | | if (salesReturnNotice.Id != null) base.DeleteById(salesReturnNotice.Id); |
| | | |
| | | if (salesReturnNoticeDetails.Count > 0) |
| | | db.Deleteable<SalesOrderDetail>() |
| | | .Where(s => s.ErpId == salesReturnNotice.Id).ExecuteCommand(); |
| | | |
| | | var orUpdate = base.Insert(salesReturnNotice); |
| | | var baOrUpdate = salesReturnNoticeDetailManager.InsertRange(salesReturnNoticeDetails); |
| | | if (orUpdate && baOrUpdate) return true; |
| | | throw new NotImplementedException("æå
¥ææ´æ°å¤±è´¥"); |
| | | } |
| | | |
| | | // æ¹éä¿åè®°å½çæ¹æ³ |
| | | public bool SaveList(List<SaleReturnNotice> saleReturnNotices) |
| | | { |
| | | var result = saleReturnNotices.Select(Save).ToList(); |
| | | return result.All(b => b); |
| | | } |
| | | |
| | | |
| | | // å° ErpSalesReturnNotice 对象转æ¢ä¸º SalesReturnNotice å¯¹è±¡çæ¹æ³ |
| | | public SalesReturnNotice GetSalesReturnNotice(ErpSalesReturnNotice erpSalesReturnNotice) |
| | | { |
| | | |
| | | var eid = Convert.ToDecimal(erpSalesReturnNotice.Id); |
| | | var MesSalesReturnNotice = new SalesReturnNotice(); |
| | | |
| | | var single = base.GetSingle(it => it.Id == eid); |
| | | if (single != null) MesSalesReturnNotice.Id = single.Id; |
| | | |
| | | MesSalesReturnNotice.ErpId = erpSalesReturnNotice.erpID; |
| | | MesSalesReturnNotice.BillType = erpSalesReturnNotice.fBillTypeID; |
| | | MesSalesReturnNotice.BillNo = erpSalesReturnNotice.fBillNo; |
| | | |
| | | if (erpSalesReturnNotice.fDate != null) |
| | | MesSalesReturnNotice.FDate = DateTime.ParseExact(erpSalesReturnNotice.fDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | MesSalesReturnNotice.Currency = erpSalesReturnNotice.fSettleCurrld; |
| | | MesSalesReturnNotice.SalesDept = erpSalesReturnNotice.fSaleDeptId; |
| | | MesSalesReturnNotice.ReturnCustomer = erpSalesReturnNotice.fRetcustId; |
| | | MesSalesReturnNotice.ReturnReason = erpSalesReturnNotice.fRetcustReason; |
| | | MesSalesReturnNotice.DeliveryLocation = erpSalesReturnNotice.fHeadLocId; |
| | | MesSalesReturnNotice.InventoryDept = erpSalesReturnNotice.fRetDeptId; |
| | | MesSalesReturnNotice.InventoryGroup = erpSalesReturnNotice.fStockerGroupId; |
| | | MesSalesReturnNotice.WarehouseManager = erpSalesReturnNotice.fStockerId; |
| | | MesSalesReturnNotice.SalesGroup = erpSalesReturnNotice.fSaleGroupId; |
| | | MesSalesReturnNotice.SalesPerson = erpSalesReturnNotice.fSalesManId; |
| | | MesSalesReturnNotice.Receiver = erpSalesReturnNotice.fReceiveCusId; |
| | | MesSalesReturnNotice.ReceiverContact = erpSalesReturnNotice.fReceiveCusContact; |
| | | MesSalesReturnNotice.ReceiverAddress = erpSalesReturnNotice.fReceiveAddress; |
| | | MesSalesReturnNotice.ReceiverName = erpSalesReturnNotice.fLinkMan; |
| | | MesSalesReturnNotice.SettleParty = erpSalesReturnNotice.fSettleCusId; |
| | | MesSalesReturnNotice.CreatedBy = erpSalesReturnNotice.fCreatorId; |
| | | |
| | | if (erpSalesReturnNotice.fCreateDate != null) |
| | | MesSalesReturnNotice.CreatedDate = DateTime.ParseExact(erpSalesReturnNotice.fCreateDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | MesSalesReturnNotice.ModifiedBy = erpSalesReturnNotice.fModifierId; |
| | | |
| | | if (erpSalesReturnNotice.fModifyDate != null) |
| | | MesSalesReturnNotice.ModifiedDate = DateTime.ParseExact(erpSalesReturnNotice.fModifyDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | MesSalesReturnNotice.ClosedBy = erpSalesReturnNotice.fCloserId; |
| | | MesSalesReturnNotice.CloseReason = erpSalesReturnNotice.fCloseReason; |
| | | |
| | | if (erpSalesReturnNotice.fCloseDate != null) |
| | | MesSalesReturnNotice.CloseDate = DateTime.ParseExact(erpSalesReturnNotice.fCloseDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | MesSalesReturnNotice.ApprovedBy = erpSalesReturnNotice.fApproverId; |
| | | |
| | | if (erpSalesReturnNotice.fApproveDate != null) |
| | | MesSalesReturnNotice.ApprovedDate = DateTime.ParseExact(erpSalesReturnNotice.fApproveDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | MesSalesReturnNotice.CancelStatus = erpSalesReturnNotice.fCancelStatus; |
| | | MesSalesReturnNotice.CancelledBy = erpSalesReturnNotice.fCancellerId; |
| | | |
| | | if (erpSalesReturnNotice.fCancelDate != null) |
| | | MesSalesReturnNotice.CancelDate = DateTime.ParseExact(erpSalesReturnNotice.fCancelDate, "yyyy-MM-dd HH:mm:ss", null); |
| | | |
| | | MesSalesReturnNotice.CloseStatus = erpSalesReturnNotice.fBillCloseStatus; |
| | | MesSalesReturnNotice.BillStatus = erpSalesReturnNotice.fDocumentStatus; |
| | | |
| | | return MesSalesReturnNotice; |
| | | } |
| | | |
| | | // å° ErpSalesReturnNoticeDetail 对象转æ¢ä¸º SalesReturnNoticeDetail å¯¹è±¡çæ¹æ³ |
| | | public List<SalesReturnNoticeDetail> GetErpSalesOrderDetail( |
| | | List<ErpSalesReturnNoticeDetail> erpSalesReturnNoticeDetails, string type) |
| | | { |
| | | return erpSalesReturnNoticeDetails.Select(s => |
| | | { |
| | | var entity = new SalesReturnNoticeDetail |
| | | { |
| | | Id = Convert.ToDecimal(s.Id), |
| | | ErpLineId = s.erpID, |
| | | ErpHeadId =s.ehid, |
| | | MaterialId = s.fMaterialId, |
| | | MaterialName = s.fMaterialName, |
| | | MaterialSpecification = s.fMaterialModel, |
| | | SalesUnitId = s.fUnitID, |
| | | SalesQuantity = Convert.ToDecimal(s.fQty), |
| | | IsFree = s.fIsFree, |
| | | ReturnDate = s.fDeliverydate != null ? DateTime.ParseExact(s.fDeliverydate, "yyyy-MM-dd HH:mm:ss", null) : null, |
| | | WareHouse = s.fStockId, |
| | | PlanTrackingNumber = s.fMtoNo, |
| | | LotNumber = s.fLot, |
| | | Note = s.fEntryDescription, |
| | | ReturnType = s.fRmType, |
| | | InventoryUnit = s.fStockUnitID, |
| | | InventoryQuantity = Convert.ToDecimal(s.fStockQty), |
| | | MaterialCategory = s.fMaterialType, |
| | | OwnerTypeId = s.fOwnerTypeID, |
| | | OwnerId = s.fOwnerId, |
| | | SourceBillType = s.fSrcType, |
| | | SourceBillNo = s.fSrcBillNo, |
| | | OrderBillNo = s.fOrderNo, |
| | | |
| | | }; |
| | | |
| | | var single = salesReturnNoticeDetailManager.GetSingle(it => |
| | | it.Id == entity.Id); |
| | | if (single != null) entity.Id = single.Id; |
| | | |
| | | return entity; |
| | | }).ToList(); |
| | | } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System.Dynamic; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using MES.Service.service; |
| | | using MES.Service.service.BasicData; |
| | | using MES.Service.util; |
| | | using Microsoft.AspNetCore.Mvc; |
| | | using Newtonsoft.Json; |
| | | |
| | | namespace MESApplication.Controllers.BasicData; |
| | | |
| | | [ApiController] |
| | | [Route("api/[controller]")] |
| | | public class SalesDeliveryNoticeController : ControllerBase |
| | | { |
| | | private readonly MessageCenterManager _manager = new(); |
| | | |
| | | private readonly SalesDeliveryNoticeManager m = new(); |
| | | |
| | | private readonly string METHOD = "POST"; |
| | | |
| | | private readonly string TableName = "SALES_DELIVERY_NOTICE"; |
| | | |
| | | private readonly string URL = "http://localhost:10054/api/SalesDeliveryNotice/"; |
| | | |
| | | /// <summary> |
| | | /// åæ¡ä¸»è¡¨æ°æ®ä¿åæä½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("Save")] |
| | | public ResponseResult Save(SaleDeliveryNotice saleDeliveryNotice) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "Save"; |
| | | entity.Method = METHOD; |
| | | entity.Data = JsonConvert.SerializeObject(saleDeliveryNotice); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.Save(saleDeliveryNotice); |
| | | |
| | | resultInfos.tbBillList = save; |
| | | |
| | | entity.Result = 0; |
| | | if (save) entity.Result = 1; |
| | | |
| | | entity.DealWith = 1; |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | entity.Result = 0; |
| | | |
| | | entity.DealWith = 0; |
| | | |
| | | entity.ResultData = ex.Message; |
| | | |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 1, |
| | | message = ex.Message, |
| | | data = ex.Message |
| | | }; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 夿¡ä¸»è¡¨æ°æ®ä¿åæä½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("SaveList")] |
| | | public ResponseResult SaveList(List<SaleDeliveryNotice> units) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "SaveList"; |
| | | entity.Method = METHOD; |
| | | entity.Data = JsonConvert.SerializeObject(units); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.SaveList(units); |
| | | resultInfos.tbBillList = save; |
| | | |
| | | entity.Result = 0; |
| | | if (save) entity.Result = 1; |
| | | |
| | | entity.DealWith = 1; |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | entity.Result = 0; |
| | | |
| | | entity.DealWith = 0; |
| | | |
| | | entity.ResultData = ex.Message; |
| | | |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 1, |
| | | message = ex.Message, |
| | | data = ex.Message |
| | | }; |
| | | } |
| | | } |
| | | |
| | | /***è¿å
¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ |
| | | |
| | | /// <summary> |
| | | /// è·åææ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("GetList")] |
| | | public ResponseResult GetList() |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.GetList(); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// æ ¹æ®ä¸»é®è·å |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("GetById")] |
| | | public ResponseResult GetById(int id) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.GetById(id); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ ¹æ®ä¸»é®å é¤ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("DeleteByIds")] |
| | | public ResponseResult DeleteByIds([FromBody] object[] ids) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.DeleteByIds(ids); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ·»å |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("Insert")] |
| | | public ResponseResult Add([FromBody] SalesDeliveryNotice data) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.Insert(data); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ·»å è¿åèªå¢ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("InsertReturnIdentity")] |
| | | public ResponseResult InsertReturnIdentity( |
| | | [FromBody] SalesDeliveryNotice data) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.InsertReturnIdentity(data); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// ä¿®æ¹ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("Update")] |
| | | public ResponseResult Update([FromBody] SalesDeliveryNotice data) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.Update(data); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System.Dynamic; |
| | | using MES.Service.Modes; |
| | | using MES.Service.service.BasicData; |
| | | using MES.Service.util; |
| | | using Microsoft.AspNetCore.Mvc; |
| | | |
| | | namespace MESApplication.Controllers.BasicData; |
| | | |
| | | [ApiController] |
| | | [Route("api/[controller]")] |
| | | public class SalesDeliveryNoticeDetailController : ControllerBase |
| | | { |
| | | private readonly SalesDeliveryNoticeDetailManager m = new(); |
| | | |
| | | |
| | | /***è¿å
¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ |
| | | |
| | | /// <summary> |
| | | /// è·åææ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("GetList")] |
| | | public ResponseResult GetList() |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.GetList(); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// æ ¹æ®ä¸»é®è·å |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("GetById")] |
| | | public ResponseResult GetById(int id) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.GetById(id); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ ¹æ®ä¸»é®å é¤ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("DeleteByIds")] |
| | | public ResponseResult DeleteByIds([FromBody] object[] ids) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.DeleteByIds(ids); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ·»å |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("Insert")] |
| | | public ResponseResult Add([FromBody] SalesDeliveryNoticeDetail data) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.Insert(data); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ·»å è¿åèªå¢ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("InsertReturnIdentity")] |
| | | public ResponseResult InsertReturnIdentity( |
| | | [FromBody] SalesDeliveryNoticeDetail data) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.InsertReturnIdentity(data); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// ä¿®æ¹ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("Update")] |
| | | public ResponseResult Update([FromBody] SalesDeliveryNoticeDetail data) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.Update(data); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | } |
| | |
| | | using System.Dynamic; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using MES.Service.service; |
| | | using MES.Service.service.BasicData; |
| | | using MES.Service.util; |
| | | using Microsoft.AspNetCore.Mvc; |
| | | using Newtonsoft.Json; |
| | | |
| | | namespace MESApplication.Controllers.BasicData; |
| | | |
| | |
| | | [Route("api/[controller]")] |
| | | public class SalesOrderController : ControllerBase |
| | | { |
| | | |
| | | private readonly MessageCenterManager _manager = new(); |
| | | private readonly SalesOrderManager m = new(); |
| | | |
| | | private readonly string METHOD = "POST"; |
| | | |
| | | private readonly string TableName = "SALES_ORDER"; |
| | | |
| | | private readonly string URL = "http://localhost:10054/api/SalesOrder/"; |
| | | |
| | | /// <summary> |
| | | /// åæ¡ä¸»è¡¨æ°æ®ä¿åæä½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("Save")] |
| | | public ResponseResult Save(SalesOrders salesOrders) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "Save"; |
| | | entity.Method = METHOD; |
| | | entity.Data = JsonConvert.SerializeObject(salesOrders); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.Save(salesOrders); |
| | | |
| | | resultInfos.tbBillList = save; |
| | | |
| | | entity.Result = 0; |
| | | if (save) entity.Result = 1; |
| | | |
| | | entity.DealWith = 1; |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | entity.Result = 0; |
| | | |
| | | entity.DealWith = 0; |
| | | |
| | | entity.ResultData = ex.Message; |
| | | |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 1, |
| | | message = ex.Message, |
| | | data = ex.Message |
| | | }; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 夿¡ä¸»è¡¨æ°æ®ä¿åæä½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("SaveList")] |
| | | public ResponseResult SaveList(List<SalesOrders> units) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "SaveList"; |
| | | entity.Method = METHOD; |
| | | entity.Data = JsonConvert.SerializeObject(units); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.SaveList(units); |
| | | resultInfos.tbBillList = save; |
| | | |
| | | entity.Result = 0; |
| | | if (save) entity.Result = 1; |
| | | |
| | | entity.DealWith = 1; |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | entity.Result = 0; |
| | | |
| | | entity.DealWith = 0; |
| | | |
| | | entity.ResultData = ex.Message; |
| | | |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 1, |
| | | message = ex.Message, |
| | | data = ex.Message |
| | | }; |
| | | } |
| | | } |
| | | |
| | | /***è¿å
¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ |
| | | |
| | |
| | | using System.Dynamic; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using MES.Service.service; |
| | | using MES.Service.service.BasicData; |
| | | using MES.Service.util; |
| | | using Microsoft.AspNetCore.Mvc; |
| | | using Newtonsoft.Json; |
| | | |
| | | namespace MESApplication.Controllers.BasicData; |
| | | |
| | |
| | | [Route("api/[controller]")] |
| | | public class SalesReturnNoticeController : ControllerBase |
| | | { |
| | | private readonly MessageCenterManager _manager = new(); |
| | | |
| | | private readonly SalesReturnNoticeManager m = new(); |
| | | |
| | | private readonly string METHOD = "POST"; |
| | | |
| | | private readonly string TableName = "SALES_RETURN_NOTICE"; |
| | | |
| | | private readonly string URL = "http://localhost:10054/api/SalesReturnNotice/"; |
| | | |
| | | /// <summary> |
| | | /// åæ¡ä¸»è¡¨æ°æ®ä¿åæä½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("Save")] |
| | | public ResponseResult Save(SaleReturnNotice saleReturnNotice) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "Save"; |
| | | entity.Method = METHOD; |
| | | entity.Data = JsonConvert.SerializeObject(saleReturnNotice); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.Save(saleReturnNotice); |
| | | |
| | | resultInfos.tbBillList = save; |
| | | |
| | | entity.Result = 0; |
| | | if (save) entity.Result = 1; |
| | | |
| | | entity.DealWith = 1; |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | entity.Result = 0; |
| | | |
| | | entity.DealWith = 0; |
| | | |
| | | entity.ResultData = ex.Message; |
| | | |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 1, |
| | | message = ex.Message, |
| | | data = ex.Message |
| | | }; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 夿¡ä¸»è¡¨æ°æ®ä¿åæä½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("SaveList")] |
| | | public ResponseResult SaveList(List<SaleReturnNotice> units) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "SaveList"; |
| | | entity.Method = METHOD; |
| | | entity.Data = JsonConvert.SerializeObject(units); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.SaveList(units); |
| | | resultInfos.tbBillList = save; |
| | | |
| | | entity.Result = 0; |
| | | if (save) entity.Result = 1; |
| | | |
| | | entity.DealWith = 1; |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | entity.Result = 0; |
| | | |
| | | entity.DealWith = 0; |
| | | |
| | | entity.ResultData = ex.Message; |
| | | |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 1, |
| | | message = ex.Message, |
| | | data = ex.Message |
| | | }; |
| | | } |
| | | } |
| | | |
| | | /***è¿å
¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ |
| | | |
| | |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.Save(MES.Service.Dto.webApi.SaleDeliveryNotice)"> |
| | | <summary> |
| | | åæ¡ä¸»è¡¨æ°æ®ä¿åæä½ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.SaveList(System.Collections.Generic.List{MES.Service.Dto.webApi.SaleDeliveryNotice})"> |
| | | <summary> |
| | | 夿¡ä¸»è¡¨æ°æ®ä¿åæä½ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.GetList"> |
| | | <summary> |
| | | è·åææ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.GetById(System.Int32)"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®è·å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.DeleteByIds(System.Object[])"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®å é¤ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.Add(MES.Service.Modes.SalesDeliveryNotice)"> |
| | | <summary> |
| | | æ·»å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.InsertReturnIdentity(MES.Service.Modes.SalesDeliveryNotice)"> |
| | | <summary> |
| | | æ·»å è¿åèªå¢ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.Update(MES.Service.Modes.SalesDeliveryNotice)"> |
| | | <summary> |
| | | ä¿®æ¹ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.GetList"> |
| | | <summary> |
| | | è·åææ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.GetById(System.Int32)"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®è·å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.DeleteByIds(System.Object[])"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®å é¤ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.Add(MES.Service.Modes.SalesDeliveryNoticeDetail)"> |
| | | <summary> |
| | | æ·»å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.InsertReturnIdentity(MES.Service.Modes.SalesDeliveryNoticeDetail)"> |
| | | <summary> |
| | | æ·»å è¿åèªå¢ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.Update(MES.Service.Modes.SalesDeliveryNoticeDetail)"> |
| | | <summary> |
| | | ä¿®æ¹ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesOrderController.Save(MES.Service.Dto.webApi.SalesOrders)"> |
| | | <summary> |
| | | åæ¡ä¸»è¡¨æ°æ®ä¿åæä½ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesOrderController.SaveList(System.Collections.Generic.List{MES.Service.Dto.webApi.SalesOrders})"> |
| | | <summary> |
| | | 夿¡ä¸»è¡¨æ°æ®ä¿åæä½ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesOrderController.GetList"> |
| | | <summary> |
| | | è·åææ |
| | |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesReturnNoticeController.Save(MES.Service.Dto.webApi.SaleReturnNotice)"> |
| | | <summary> |
| | | åæ¡ä¸»è¡¨æ°æ®ä¿åæä½ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesReturnNoticeController.SaveList(System.Collections.Generic.List{MES.Service.Dto.webApi.SaleReturnNotice})"> |
| | | <summary> |
| | | 夿¡ä¸»è¡¨æ°æ®ä¿åæä½ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.BasicData.SalesReturnNoticeController.GetList"> |
| | | <summary> |
| | | è·åææ |