//选择加工单 private void btn_PronoteHeader_Click(object sender, EventArgs e) { PronoteHeader.ChoosePronoteHeaderDetailsForm f = new Book.UI.produceManager.PronoteHeader.ChoosePronoteHeaderDetailsForm(); if (f.ShowDialog(this) == DialogResult.OK) { if (f.SelectItems != null) { foreach (var item in f.SelectItems) { Model.PCEarplugsResilienceCheckDetail detail = new Book.Model.PCEarplugsResilienceCheckDetail(); detail.PCEarplugsResilienceCheckDetailId = Guid.NewGuid().ToString(); detail.Number = (this._pCEarplugsResilienceCheck.Details.Count + 1).ToString(); detail.FromId = item.PronoteHeaderID; detail.Product = item.Product; detail.ProductId = item.ProductId; detail.ProductUnit = item.ProductUnit; detail.InvoiceXOId = item.InvoiceXOId; detail.InvoiceXOQuantity = item.InvoiceXODetailQuantity; Model.InvoiceXO xo = invoiceXOManager.Get(detail.InvoiceXOId); if (xo != null) { detail.InvoiceXO = xo; } this._pCEarplugsResilienceCheck.Details.Add(detail); } this.gridControl1.RefreshDataSource(); } } }
private void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { if (e.ListSourceRowIndex < 0) { return; } IList <Model.DepotInDetail> details = this.bindingSourceDetail.DataSource as IList <Model.DepotInDetail>; if (details == null || details.Count < 1) { return; } Model.DepotInDetail detail = details[e.ListSourceRowIndex]; switch (e.Column.Name) { case "gridColumnCusXOId": Model.PronoteHeader pronoteHeader = this.pronoteHeaderManager.Get(detail.PronoteHeaderId); if (pronoteHeader == null) { return; } Model.InvoiceXO invoiceXO = this.invoiceXOManager.Get(pronoteHeader.InvoiceXOId); e.DisplayText = invoiceXO == null ? string.Empty : invoiceXO.CustomerInvoiceXOId; break; } }
//選取委外合同 private void btn_SelectProduceOther_Click(object sender, EventArgs e) { ProduceOtherCompact.ChooseOutContract f = new Book.UI.produceManager.ProduceOtherCompact.ChooseOutContract(); if (f.ShowDialog(this) == DialogResult.OK) { foreach (var item in f.key) { Model.PCFlameRetardantDetail detail = new Book.Model.PCFlameRetardantDetail(); detail.PCFlameRetardantDetailId = Guid.NewGuid().ToString(); detail.Number = this._pCFlameRetardant.Details.Count + 1; detail.Product = item.Product; detail.ProductId = item.ProductId; detail.EmployeeId = BL.V.ActiveOperator.EmployeeId; detail.InvoiceXOId = item.ProduceOtherCompact.InvoiceXOId; detail.ProduceOtherCompactId = item.ProduceOtherCompactId; if (string.IsNullOrEmpty(this.Pihao)) { Model.InvoiceXO xo = invoiceXOManager.Get(detail.InvoiceXOId); if (xo != null) { detail.Pihao = xo.CustomerLotNumber; } } else { detail.Pihao = this.Pihao; } this._pCFlameRetardant.Details.Add(detail); } this.gridControl1.RefreshDataSource(); } }
private void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { if (e.ListSourceRowIndex < 0) { return; } IList <Model.InvoiceXO> details = this.bindingSource1.DataSource as IList <Model.InvoiceXO>; if (details == null || details.Count < 1) { return; } Model.InvoiceXO detail = details[e.ListSourceRowIndex] as Model.InvoiceXO; if (e.Column.Name == "gridXSCustomer") { if (detail == null) { return; } if (detail.xocustomer != null) { e.DisplayText = string.IsNullOrEmpty(detail.xocustomer.CustomerShortName) ? detail.Customer.CustomerShortName : detail.xocustomer.CustomerShortName; } } }
public void UpdateInvoiceFlag(Model.InvoiceXO invoiceXO) { int flag = 0; IList <Model.InvoiceXODetail> list = invoiceXODetailAccessor.Select(invoiceXO, false); foreach (Model.InvoiceXODetail detail in list) { flag += detail.DetailsFlag.Value; } if (flag == 0) { invoiceXO.InvoiceFlag = 0; invoiceXO.IsClose = false; invoiceXO.JieAnDate = null; } else if (flag < list.Count * 2) { invoiceXO.InvoiceFlag = 1; invoiceXO.IsClose = false; invoiceXO.JieAnDate = null; } else if (flag == list.Count * 2) { invoiceXO.InvoiceFlag = 2; invoiceXO.IsClose = true; invoiceXO.JieAnDate = DateTime.Now; invoiceXO.IsNotAutoClose = false; new BL.PronoteHeaderManager().UpdateHeaderIsClseByXOId(invoiceXO.InvoiceId, true); } accessor.Update(invoiceXO); }
public ROList(IList <Model.InvoiceCO> mInvoiceCOList) { InitializeComponent(); if (mInvoiceCOList == null || mInvoiceCOList.Count == 0) { return; } foreach (var item in mInvoiceCOList) { if (!string.IsNullOrEmpty(item.InvoiceXOId)) { Model.InvoiceXO xo = this.invoiceXoManager.Get(item.InvoiceXOId); if (xo != null) { item.InvoiceCustomXOId = xo.CustomerInvoiceXOId; } } } this.DataSource = mInvoiceCOList; this.mBand(); }
public Model.InvoiceXO Get(string invoiceId) { Model.InvoiceXO invoice = accessor.Get(invoiceId); if (invoice != null) { invoice.Details = invoiceXODetailAccessor.Select(invoice, false); } return(invoice); }
protected override Form GetViewForm() { Model.InvoiceXO invoice = this.SelectedItem as Model.InvoiceXO; if (invoice != null) return new EditForm(invoice.InvoiceId); // return new ViewForm(invoice.InvoiceId); return null; }
public ViewForm(string invoiceId) : this() { this.invoice = this.invoiceManager.Get(invoiceId); if (this.invoice == null) { throw new ArithmeticException(""); } }
public RO_New(string invoiceid) { InitializeComponent(); this.invoice = this.invoiceXOManager.Get(invoiceid); if (this.invoice == null) { return; } this.invoice.Details = this.invoiceXODetailManager.Select(this.invoice, false); this.DataSource = this.invoice.Details; //CompanyInfo this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName; this.xrLabelData.Text = Properties.Resources.InvoiceXO; this.lbl_PrintDate.Text = DateTime.Now.ToString("yyyy-MM-dd"); this.xrLabelCustomName.Text = this.invoice.Customer.CustomerShortName; this.lbl_Customer_Id.Text = this.invoice.Customer.Id; this.xrLabelInvoiceDate.Text = this.invoice.InvoiceDate.Value.ToString("yyyy-MM-dd"); this.xrLabelInvoiceId.Text = this.invoice.InvoiceId; this.xrLabelEmp.Text += this.invoice.Employee0 == null ? "" : this.invoice.Employee0.EmployeeName; this.xrLabel25.Text += this.invoice.AuditEmp == null ? "" : this.invoice.AuditEmp.EmployeeName; this.xrLabelNote.Text = this.invoice.InvoiceNote; this.xrLabelCustomerXOId.Text = this.invoice.CustomerInvoiceXOId; this.xrLabelUnit.Text = this.invoice.Details[0].InvoiceProductUnit; this.lbl_Bibie.Text = this.invoice.Currency; this.xrLabelCount.Summary.FormatString = "{0:0}"; this.xrLabelCount.Summary.Func = SummaryFunc.Sum; this.xrLabelCount.Summary.IgnoreNullValues = true; this.xrLabelCount.Summary.Running = SummaryRunning.Report; this.xrLabelCount.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity, "{0:0}"); this.lblTotalJine.Summary.FormatString = "{0:0.##$}"; this.lblTotalJine.Summary.Func = SummaryFunc.Sum; this.lblTotalJine.Summary.IgnoreNullValues = true; this.lblTotalJine.Summary.Running = SummaryRunning.Report; this.lblTotalJine.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailMoney, "{0:0}"); //detail this.xrTableCellProductId.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_Inumber); this.TCProductId.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_Id); this.xrTableCellCustomerProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_CustomerProductName); this.TCPrice.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailPrice, "{0:0.##}"); this.TCUnit.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceProductUnit, "{0:0}"); this.TCJinE.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailMoney, "{0:0.##$}"); this.xrTableCellQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity); this.TCYujiaoriqi.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_YuJiaoRiqi, "{0:yyyy-MM-dd}"); this.lbl_ProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); this.lbl_ProductInternalDesc.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_InternalDescription); //this.lblRemark.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_Remark); this.lblRemark.DataBindings.Add("Rtf", this.DataSource, "Product." + Model.Product.PRO_ProductDescription); this.lbl_Note.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_Remark); }
private void addUpdateDtail(Model.InvoiceXO invoice) { foreach (Model.InvoiceXODetail detail in invoice.Details) { //if (detail.PrimaryKey == null || string.IsNullOrEmpty(detail.PrimaryKey.PrimaryKeyId)) if (string.IsNullOrEmpty(detail.ProductId)) { continue; } detail.InvoiceId = invoice.InvoiceId; detail.InvoiceXTDetailQuantity = detail.InvoiceXTDetailQuantity == null ? 0 : detail.InvoiceXTDetailQuantity; //修改已出货记录等 detail.InvoiceXODetailBeenQuantity = detail.InvoiceXODetailBeenQuantity == null ? 0 : detail.InvoiceXODetailBeenQuantity; detail.InvoiceXODetailQuantity0 = detail.InvoiceXODetailQuantity - detail.InvoiceXODetailBeenQuantity + detail.InvoiceXTDetailQuantity; if (detail.InvoiceXODetailQuantity0 < 0) { detail.InvoiceXODetailQuantity0 = 0; } if (detail.InvoiceXODetailQuantity0 == 0) { detail.DetailsFlag = Convert.ToInt32(Helper.DetailsFlag.AllArrived); } else { detail.DetailsFlag = Convert.ToInt32(Helper.DetailsFlag.OnTheWay); } //修改已排单记录 detail.InvoiceMPSQuantity = detail.InvoiceMPSQuantity == null ? 0 : detail.InvoiceMPSQuantity; if (detail.InvoiceXODetailQuantity <= detail.InvoiceMPSQuantity) { detail.DetailMPSState = Convert.ToInt32(Helper.DetailsFlag.AllArrived); } else { detail.DetailMPSState = Convert.ToInt32(Helper.DetailsFlag.OnTheWay); } invoiceXODetailAccessor.Insert(detail); //修改手册已定出量 if (!string.IsNullOrEmpty(detail.HandbookProductId) && !string.IsNullOrEmpty(detail.HandbookId)) { bGHandbookDetail1Manager.UpdateYDWC(detail, detail.InvoiceXODetailQuantity0.Value); } // Model.CustomerProducts cusproduct = detail.PrimaryKey; //if (cusproduct.OrderQuantity == null) // cusproduct.OrderQuantity = 0; //cusproduct.OrderQuantity += detail.InvoiceXODetailQuantity; //customerProductsAccessor.Update(cusproduct); //产品表已定未出量 //Model.Product product = productAccessor.Get(detail.ProductId); //product.OrderOnWayQuantity -= detail.OrderQuantity; //productAccessor.Update(product); } }
public R0ch_New(string invoiceid) { InitializeComponent(); this.invoice = this.invoiceCGManager.Get(invoiceid); if (this.invoice == null) { return; } this.DataSource = this.invoice.Details; this.xrBarCode1.Text = this.invoice.InvoiceId; this.xrLabelData.Text = Properties.Resources.InvoiceCO; //客户信息 this.xrLabelCustomName.Text = this.invoice.Supplier.SupplierShortName; this.xrLabelLianluoName.Text = this.invoice.Supplier.SupplierContact; this.xrLabelCustomFax.Text = this.invoice.Supplier.SupplierFax; this.xrLabelCustomTel.Text = string.IsNullOrEmpty(this.invoice.Supplier.SupplierPhone1) ? this.invoice.Supplier.SupplierPhone2 : this.invoice.Supplier.SupplierPhone1; //单据信息 this.xrLabelInvoiceDate.Text = this.invoice.InvoiceDate.Value.ToString("yyyy-MM-dd"); this.xrLabelYJDate.Text = this.invoice.InvoiceYjrq == null ? "" : this.invoice.InvoiceYjrq.Value.ToString("yyyy-MM-dd"); this.xrLabel25.Text += this.invoice.AuditEmp == null ? "" : this.invoice.AuditEmp.EmployeeName; this.xrLabelYeWuName.Text = this.invoice.Employee0 == null ? "" : this.invoice.Employee0.EmployeeName; this.lblTaxrate.Text = this.invoice.InvoiceTaxrate.HasValue ? this.invoice.InvoiceTaxrate.ToString() : ""; this.lblTax.Text = this.invoice.PrintTax; //this.lbl_Total.Text = this.invoice.InvoiceTotal.HasValue ? this.invoice.InvoiceTotal.Value.ToString() : "0"; this.lbl_Total.Text = this.invoice.PrintAmount; this.lblNote.Text = this.invoice.InvoiceNote; Model.InvoiceXO temp = this.invoiceXoManager.Get(this.invoice.InvoiceXOId); if (temp != null) { this.xrLabelInvoiceXOId.Text = temp.CustomerInvoiceXOId; this.lbl_Pihao.Text = temp.CustomerLotNumber; } //明细信息 this.xrTableCellProductId.DataBindings.Add("Text", this.DataSource, Model.InvoiceCODetail.PRO_Inumber); this.xrTableCellProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); //this.xrTableCellProductGuige.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductSpecification); this.xrTableCellQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceCODetail.PRO_InvoiceProductUnit); this.xrTableCellProductUnit.DataBindings.Add("Text", this.DataSource, Model.InvoiceCODetail.PRO_OrderQuantity); this.xrTableCellUintPrice.DataBindings.Add("Text", this.DataSource, Model.InvoiceCODetail.PRO_InvoiceCODetailPrice, "{0:N2}"); //this.xrTableCellUintPrice.DataBindings.Add("Text", this.DataSource, Model.InvoiceCODetail.PRO_PrintPrice); this.xrTableCellMoney.DataBindings.Add("Text", this.DataSource, Model.InvoiceCODetail.PRO_InvoiceCODetailMoney, "{0:N2}"); //this.xrTableCellMoney.DataBindings.Add("Text", this.DataSource, Model.InvoiceCODetail.PRO_PrintMoney); this.xrTableCellNextWorkHouse.DataBindings.Add("Text", this.DataSource, "NextWorkHouse." + Model.WorkHouse.PROPERTY_WORKHOUSENAME); this.xrRichTextProductDescription.DataBindings.Add("Rtf", this.DataSource, "Product." + Model.Product.PRO_ProductDescription); //this.TCProductID.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_Id); }
public R0en(string invoiceid) { InitializeComponent(); this.invoice = this.invoiceCGManager.Get(invoiceid); if (this.invoice == null) { return; } this.DataSource = this.invoice.Details; this.xrBarCode1.Text = this.invoice.InvoiceId; this.xrLabelData.Text = "Purchase Order"; this.xrLabelCustomName.Text = this.invoice.Supplier.SupplierShortName; this.xrLabelLianluoName.Text = this.invoice.Supplier.SupplierContact; //this.xrLabelCustomTel.Text = string.IsNullOrEmpty(this.invoice.Supplier.SupplierPhone1) ? this.invoice.Supplier.SupplierPhone2 : this.invoice.Supplier.SupplierPhone1; this.xrLabelCustomTel.Text = this.invoice.Supplier.Email; //改Email this.lblAddress.Text = this.invoice.Supplier.CompanyAddress; //单据信息 this.xrLabelInvoiceDate.Text = this.invoice.InvoiceDate.Value.ToString("yyyy-MM-dd"); this.xrLabelYJDate.Text = this.invoice.InvoiceYjrq == null ? "" : this.invoice.InvoiceYjrq.Value.ToString("yyyy-MM-dd"); this.xrLabel25.Text += this.invoice.AuditEmp == null ? "" : this.invoice.AuditEmp.EmployeeName; this.xrLabelYeWuName.Text = this.invoice.Employee0 == null ? "" : this.invoice.Employee0.EmployeeName; Model.InvoiceXO temp = this.invoiceXoManager.Get(this.invoice.InvoiceXOId); if (temp != null) { this.xrLabelInvoiceXOId.Text = temp.CustomerInvoiceXOId; } this.lblTaxrate.Text = this.invoice.InvoiceTaxrate.HasValue ? this.invoice.InvoiceTaxrate.ToString() : ""; this.lblTax.Text = this.invoice.PrintTax; //this.lbl_Total.Text = this.invoice.InvoiceTotal.HasValue ? this.invoice.InvoiceTotal.Value.ToString() : "0"; this.lbl_Total.Text = this.invoice.PrintAmount; this.lblNote.Text = this.invoice.InvoiceNote; this.lblShipAddress.Text = BL.Settings.CompanyAddress3; //明细信息 this.xrTableCellProductId.DataBindings.Add("Text", this.DataSource, Model.InvoiceCODetail.PRO_Inumber); this.xrTableCellProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); //this.xrTableCellProductGuige.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductSpecification); this.xrTableCellQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceCODetail.PRO_InvoiceProductUnit); this.xrTableCellProductUnit.DataBindings.Add("Text", this.DataSource, Model.InvoiceCODetail.PRO_OrderQuantity); //this.xrTableCellUintPrice.DataBindings.Add("Text", this.DataSource, Model.InvoiceCODetail.PRO_InvoiceCODetailPrice, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.CGDJXiao.Value)); this.xrTableCellUintPrice.DataBindings.Add("Text", this.DataSource, Model.InvoiceCODetail.PRO_PrintPrice); //this.xrTableCellMoney.DataBindings.Add("Text", this.DataSource, Model.InvoiceCODetail.PRO_InvoiceCODetailMoney, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.CGJEXiao.Value)); this.xrTableCellMoney.DataBindings.Add("Text", this.DataSource, Model.InvoiceCODetail.PRO_PrintMoney); this.xrRichTextProductDescription.DataBindings.Add("Rtf", this.DataSource, "Product." + Model.Product.PRO_ProductDescription); }
private void _Insert(Model.InvoiceXO invoice) { invoice.InsertTime = DateTime.Now; invoice.UpdateTime = DateTime.Now; invoice.Employee0Id = invoice.Employee0.EmployeeId; invoice.CustomerId = invoice.Customer.CustomerId; if (invoice.xocustomer != null) { invoice.xocustomerId = invoice.xocustomer.CustomerId; } invoice.Employee1Id = null; //invoice.Employee1.EmployeeId; invoice.InvoiceFlag = Convert.ToInt32(Helper.InvoiceFlag.WaitingForProcess); //过账人 invoice.Employee2Id = null;// invoice.Employee2.EmployeeId; //过账时间 invoice.InvoiceGZTime = DateTime.Now; invoice.IsClose = false; invoice.InvoiceMPSState = 0; accessor.Insert(invoice); foreach (Model.InvoiceXODetail detail in invoice.Details) { //if (detail.PrimaryKey == null || string.IsNullOrEmpty(detail.PrimaryKey.PrimaryKeyId)) if (string.IsNullOrEmpty(detail.ProductId)) { continue; } detail.InvoiceId = invoice.InvoiceId; detail.DetailsFlag = Convert.ToInt32(Helper.DetailsFlag.OnTheWay); detail.InvoiceXODetailQuantity0 = detail.InvoiceXODetailQuantity; detail.InvoiceXTDetailQuantity = 0; detail.InvoiceXODetailBeenQuantity = 0; detail.DetailMPSState = 0; invoiceXODetailAccessor.Insert(detail); // Model.CustomerProducts cusproduct = detail.PrimaryKey; //if (cusproduct.OrderQuantity == null) // cusproduct.OrderQuantity = 0; //cusproduct.OrderQuantity += detail.InvoiceXODetailQuantity; //customerProductsAccessor.Update(cusproduct); //产品表已定未出量 //Model.Product product = productAccessor.Get(detail.ProductId); //product.OrderOnWayQuantity -= detail.OrderQuantity; //productAccessor.Update(product); } //客户基本资料 最后交易日期 string sql = "update Customer set LastTransactionDate='" + DateTime.Now.ToString("yyyy-MM-dd") + "' where CustomerId='" + invoice.CustomerId + "'"; accessor.UpdateSql(sql); }
public ROAgreement(Model.InvoiceXO invoice) : this() { this.lbl_Supplier.Text = BL.Settings.CompanyChineseName; this.lbl_Customer.Text = invoice.xocustomer == null?invoice.Customer.ToString() : invoice.xocustomer.ToString(); this.lbl_AgreementId.Text = invoice.CustomerInvoiceXOId; this.lbl_Date.Text = invoice.InvoiceDate.Value.Year + "Äê" + invoice.InvoiceDate.Value.Month + "ÔÂ" + invoice.InvoiceDate.Value.Day + "ÈÕ"; this.DataSource = invoice.Details; foreach (Model.InvoiceXODetail detail in invoice.Details) { detail.BGProduct = manager.SelectBGProduct(detail.HandbookId, detail.HandbookProductId); } this.TCId.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_Inumber); this.TCName.DataBindings.Add("Text", this.DataSource, "BGProduct." + Model.BGHandbookDetail1.PRO_ProName); this.TCFormat.DataBindings.Add("Text", this.DataSource, "BGProduct." + Model.BGHandbookDetail1.PRO_ProGuiGe); this.TCQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity, "{0:0.##}"); this.TCQuantityUnit.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceProductUnit); this.TCPrice.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailPrice, "{0:0.####}"); //this.TCPriceUnit.DataBindings.Add("Text",this.DataSource); this.TCAmount.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailMoney, "{0:0.##}"); this.TCTotalQuantity.Summary.FormatString = "{0:0.##}"; this.TCTotalQuantity.Summary.Func = SummaryFunc.Sum; this.TCTotalQuantity.Summary.IgnoreNullValues = true; this.TCTotalQuantity.Summary.Running = SummaryRunning.Report; this.TCTotalQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity, "{0:0.##}"); this.TCTotalMoney.Summary.FormatString = "{0:0.##}"; this.TCTotalMoney.Summary.Func = SummaryFunc.Sum; this.TCTotalMoney.Summary.IgnoreNullValues = true; this.TCTotalMoney.Summary.Running = SummaryRunning.Report; this.TCTotalMoney.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailMoney, "{0:0.##}"); this.lblAddress.Text = invoice.DeliveryAddress; this.lblPaymentWay.Text = invoice.PaymentWay; this.lblAccountNumber.Text = invoice.AccountNumber; this.lblPayee.Text = invoice.Payee; this.lblDepositBank.Text = invoice.DepositBank; this.lblDelivTime.Text = invoice.DeliveryDate; this.lblCheckRule.Text = invoice.CheckRule; this.lblOtherAppoint.Text = invoice.OtherAppoint; this.lblSupplierName.Text = BL.Settings.CompanyChineseName; this.lblSupplierAddress.Text = BL.Settings.CompanyAddress1; this.lblSupplierTel.Text = "TEL:" + BL.Settings.CompanyPhone + " " + "FAX" + BL.Settings.CompanyFax; this.lblCustomerName.Text = invoice.xocustomer == null ? invoice.Customer.CustomerShortName : invoice.xocustomer.CustomerShortName; this.lblCustomerAddress.Text = invoice.xocustomer == null ? invoice.Customer.CustomerAddress : invoice.xocustomer.CustomerAddress; }
public R01(string invoiceid) { InitializeComponent(); this.invoice = this.invoiceXOManager.Get(invoiceid); if (this.invoice == null) { return; } //this.invoice.Details = this.invoiceXODetailManager.Select(this.invoice, false); this.DataSource = this.invoice.Details; //CompanyInfo this.xrLabelCompanyInfoName.Text = "ALAN SAFETY CO., LTD"; this.xrLabelData.Text = "客戶訂單通知"; this.xrLabelPrintDate.Text += DateTime.Now.ToShortDateString(); //供應商信息 if (invoice.Supplier != null) { this.lbl_SupplierName.Text = this.invoice.Supplier.SupplierFullName; this.lbl_SupplierFax.Text = this.invoice.Supplier.SupplierFax; } //单据信息 this.xrLabelInvoiceDate.Text = this.invoice.InvoiceDate.Value.ToString("yyyy-MM-dd"); this.xrLabelInvoiceId.Text = this.invoice.InvoiceId; this.xrLabelEmp.Text += this.invoice.Employee0 == null ? "" : this.invoice.Employee0.EmployeeName; this.xrLabel25.Text += this.invoice.AuditEmp == null ? "" : this.invoice.AuditEmp.EmployeeName; this.xrLabelNote.Text = this.invoice.InvoiceNote; this.xrLabelCustomerXOId.Text = this.invoice.CustomerInvoiceXOId; this.xrLabelXScustomer.Text = this.invoice.xocustomer == null ? "" : this.invoice.xocustomer.CustomerFullName; this.xrLabelYJRQ.Text = this.invoice.InvoiceYjrq.Value.ToString("yyyy-MM-dd"); this.xrLabelUnit.Text = this.invoice.Details[0].InvoiceProductUnit; this.xrLabelCount.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity, "{0:0.##}"); //明细信息 this.xrTableCellProductId.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_Inumber); //this.xrTableCellProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); this.xrTableCellProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_Id); this.xrTableCellProductUnit.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceProductUnit); this.xrTableCellQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_InvoiceXODetailQuantity, "{0:0.##}"); //this.TCProductRemark.DataBindings.Add("Text", this.DataSource, Model.InvoiceXODetail.PRO_Remark); this.xrRichText1.DataBindings.Add("Rtf", this.DataSource, "Product." + Model.Product.PRO_ProductDescription); }
//采购单 private void btn_invoiceCO_Click(object sender, EventArgs e) { Invoices.CG.CGForm f = new Book.UI.Invoices.CG.CGForm(); if (f.ShowDialog(this) == DialogResult.OK) { //this._pcpgoc.Details.Clear(); foreach (var SelectModel in f.key) { if (SelectModel != null) { this._pcpgoc.PCPGOnlineCheckType = 0; Model.InvoiceXO xo = null; if (SelectModel.Invoice.InvoiceXOId != null) { xo = new BL.InvoiceXOManager().Get(SelectModel.Invoice.InvoiceXOId); this._pcpgoc.Customer = xo == null ? null : xo.xocustomer; this._pcpgoc.InvoiceCusXOId = xo == null ? "" : xo.CustomerInvoiceXOId; } this.txtInvoiceCusXOId.Text = this._pcpgoc.InvoiceCusXOId; //Detail Model.PCPGOnlineCheckDetail d = new Book.Model.PCPGOnlineCheckDetail(); d.PCPGOnlineCheckDetailId = Guid.NewGuid().ToString(); d.PCPGOnlineCheckId = this._pcpgoc.PCPGOnlineCheckId; if (SelectModel.Invoice.InvoiceXOId != null) { d.InvoiceCusXOId = xo == null ? "" : xo.CustomerInvoiceXOId; } d.PCPGOnlineCheckDetailDate = DateTime.Now; //d.PCPGOnlineCheckDetailTime = DateTime.Now; d.ProductId = SelectModel.ProductId; d.Product = SelectModel.Product; d.CheckQuantity = Convert.ToInt32(SelectModel.OrderQuantity); d.FromInvoiceId = SelectModel.InvoiceId; if (this._pcpgoc.Customer != null) { d.CheckedStandard = this._pcpgoc.Customer.CheckedStandard; } this._pcpgoc.Details.Add(d); } } this.gridControl1.RefreshDataSource(); } f.Dispose(); GC.Collect(); }
private void gridControl1_DoubleClick(object sender, EventArgs e) { _invoice = this.bindingSource1.Current as Model.InvoiceXO; XSDetailForm f = new XSDetailForm(_invoice); if (_invoice != null) { if (f.ShowDialog() == DialogResult.OK) { this.DialogResult = DialogResult.OK; } } else { MessageBox.Show(Properties.Resources.RequireDataForCJ, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
//选择采购单 private void btn_SelectCO_Click(object sender, EventArgs e) { Invoices.CG.CGForm form = new Book.UI.Invoices.CG.CGForm(); if (form.ShowDialog() == DialogResult.OK) { if (form.key.Count == 0) { return; } foreach (var item in form.key) { Model.PCFlameRetardantDetail detail = new Book.Model.PCFlameRetardantDetail(); detail.PCFlameRetardantDetailId = Guid.NewGuid().ToString(); detail.Number = this._pCFlameRetardant.Details.Count + 1; detail.Product = item.Product; detail.ProductId = item.ProductId; detail.EmployeeId = BL.V.ActiveOperator.EmployeeId; detail.InvoiceXOId = item.Invoice.InvoiceXOId; detail.InvoiceCOId = item.InvoiceId; if (string.IsNullOrEmpty(this.Pihao)) { Model.InvoiceXO xo = invoiceXOManager.Get(detail.InvoiceXOId); if (xo != null) { detail.Pihao = xo.CustomerLotNumber; } } else { detail.Pihao = this.Pihao; } this._pCFlameRetardant.Details.Add(detail); } this.gridControl1.RefreshDataSource(); } form.Dispose(); GC.Collect(); }
public IList <Model.InvoiceXODetail> SelectByHeaderProRang(Model.InvoiceXO invoicexo, Model.Product product1, Model.Product product2, bool isclose) { if (invoicexo == null) { return(null); } StringBuilder str = new StringBuilder(); str.Append(" where invoiceid='" + invoicexo.InvoiceId + "'"); if (product1 != null && product2 != null) { str.Append(" and productid in (select productid from product where productname between '" + product1.ProductName + "' and '" + product2.ProductName + "')"); } if (isclose) { str.Append(" and detailsflag !=2 "); } return(sqlmapper.QueryForList <Model.InvoiceXODetail>("InvoiceXODetail.SelectBywhere", str.ToString())); }
//委外加工單 private void btn_SelectOtherCompact_Click(object sender, EventArgs e) { ProduceOtherCompact.ChooseOutContract f = new Book.UI.produceManager.ProduceOtherCompact.ChooseOutContract(); if (f.ShowDialog(this) == DialogResult.OK) { if (f.key != null) { foreach (var item in f.key) { Model.PCEarplugsStayWireCheckDetail detail = new Book.Model.PCEarplugsStayWireCheckDetail(); detail.PCEarplugsStayWireCheckDetailId = Guid.NewGuid().ToString(); detail.Number = (this._pCEarplugsStayWireCheck.Details.Count + 1).ToString(); detail.FromId = item.ProduceOtherCompactId; detail.Product = item.Product; detail.ProductId = item.ProductId; detail.ProductUnit = item.ProductUnit; if (!string.IsNullOrEmpty(item.ProduceOtherCompactId)) { Model.ProduceOtherCompact model = new BL.ProduceOtherCompactManager().Get(item.ProduceOtherCompactId); if (model != null) { detail.InvoiceXOId = model.InvoiceXOId; } } detail.InvoiceXOQuantity = item.OtherCompactCount.HasValue ? item.OtherCompactCount.Value : 0; Model.InvoiceXO xo = invoiceXOManager.Get(detail.InvoiceXOId); if (xo != null) { detail.InvoiceXO = xo; } this._pCEarplugsStayWireCheck.Details.Add(detail); } this.gridControl1.RefreshDataSource(); } f.Dispose(); GC.Collect(); } }
public void EvaInvoiceMPSFlag(Model.InvoiceXO invoiceXO) { int flag = 0; foreach (Model.InvoiceXODetail detail in invoiceXO.Details) { flag += detail.DetailMPSState == null ? 0 : detail.DetailMPSState.Value; } if (flag == 0) { invoiceXO.InvoiceMPSState = 0; } else if (flag < invoiceXO.Details.Count * 2) { invoiceXO.InvoiceMPSState = 1; } else if (flag == invoiceXO.Details.Count * 2) { invoiceXO.InvoiceMPSState = 2; } }
public void Delete(string id) { #region 编号递减 Model.InvoiceXO model = this.Get(id); string invoiceKind = "XO".ToLower(); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, model.InvoiceDate.Value.Year, model.InvoiceDate.Value.Month); Model.Sequence sequence = new SequenceAccessor().Get(sequencekey_m); if (sequence != null) { if (Convert.ToInt32(id.Substring(4)) >= sequence.Val) { sequence.Val--; sequence.Val = sequence.Val < 0 ? 0 : sequence.Val; new SequenceAccessor().Update(sequence); } } #endregion this.Delete <Model.InvoiceXO>(id); }
//選擇採購單 private void btn_SelectInvoiceCO_Click(object sender, EventArgs e) { Invoices.CG.CGForm form = new Book.UI.Invoices.CG.CGForm(); if (form.ShowDialog() == DialogResult.OK) { if (form.key != null && form.key.Count > 0) { //this._PCIC.Details.Clear(); Model.PCEarplugsResilienceCheckDetail detail; foreach (var item in form.key) { detail = new Book.Model.PCEarplugsResilienceCheckDetail(); detail.PCEarplugsResilienceCheckDetailId = Guid.NewGuid().ToString(); detail.Number = (this._pCEarplugsResilienceCheck.Details.Count + 1).ToString(); detail.FromId = item.InvoiceId; detail.Product = item.Product; detail.ProductId = item.ProductId; detail.ProductUnit = item.InvoiceProductUnit; if (!string.IsNullOrEmpty(item.Invoice.InvoiceXOId)) { detail.InvoiceXOId = item.Invoice.InvoiceXOId; } detail.InvoiceXOQuantity = item.OrderQuantity; Model.InvoiceXO xo = invoiceXOManager.Get(detail.InvoiceXOId); if (xo != null) { detail.InvoiceXO = xo; } this._pCEarplugsResilienceCheck.Details.Add(detail); } } } this.gridControl1.RefreshDataSource(); form.Dispose(); GC.Collect(); }
public void EvaInvoiceFlag(Model.InvoiceXO invoiceXO) { int flag = 0; foreach (Model.InvoiceXODetail detail in invoiceXO.Details) { flag += detail.DetailsFlag.HasValue ? detail.DetailsFlag.Value : 0; } if (flag == 0) { invoiceXO.InvoiceFlag = 0; } else if (flag < invoiceXO.Details.Count * 2) { invoiceXO.InvoiceFlag = 1; } else if (flag == invoiceXO.Details.Count * 2) { invoiceXO.InvoiceFlag = 2; invoiceXO.IsClose = true; } }
public void UpdateInvoiceMPSFlag(Model.InvoiceXO invoiceXO) { int flag = 0; IList <Model.InvoiceXODetail> list = invoiceXODetailAccessor.Select(invoiceXO, false); foreach (Model.InvoiceXODetail detail in list) { flag += detail.DetailMPSState == null ? 0 : detail.DetailMPSState.Value; } if (flag == 0) { invoiceXO.InvoiceMPSState = 0; } else if (flag < list.Count * 2) { invoiceXO.InvoiceMPSState = 1; } else if (flag == list.Count * 2) { invoiceXO.InvoiceMPSState = 2; } accessor.Update(invoiceXO); }
private void _TurnNormal(Model.InvoiceXO invoice) { invoice.InvoiceStatus = (int)Helper.InvoiceStatus.Normal; _Update(invoice); }
private void _Update(Model.InvoiceXO invoice) { _ValidateForUpdate(invoice); invoice.UpdateTime = DateTime.Now; invoice.Employee0Id = invoice.Employee0.EmployeeId; invoice.CustomerId = invoice.Customer.CustomerId; Model.InvoiceXO invoiceOriginal = this.Get(invoice.InvoiceId); Helper.InvoiceStatus invoiceStatus = (Helper.InvoiceStatus)invoice.InvoiceStatus.Value; switch ((Helper.InvoiceStatus)invoiceOriginal.InvoiceStatus) { case Helper.InvoiceStatus.Draft: switch (invoiceStatus) { case Helper.InvoiceStatus.Draft: break; case Helper.InvoiceStatus.Normal: accessor.Update(invoice); invoiceXODetailAccessor.Delete(invoice); foreach (Model.InvoiceXODetail detail in invoice.Details) { // if (detail.PrimaryKey == null || string.IsNullOrEmpty(detail.PrimaryKey.PrimaryKeyId)) continue; if (detail.Product == null || string.IsNullOrEmpty(detail.Product.ProductId)) { continue; } detail.InvoiceXODetailId = Guid.NewGuid().ToString(); detail.InvoiceId = invoice.InvoiceId; invoiceXODetailAccessor.Insert(detail); } invoice.InvoiceGZTime = DateTime.Now; invoice.Employee2Id = invoice.Employee2.EmployeeId; break; case Helper.InvoiceStatus.Null: throw new InvalidOperationException(); default: break; } break; case Helper.InvoiceStatus.Normal: switch (invoiceStatus) { case Helper.InvoiceStatus.Draft: throw new InvalidOperationException(); case Helper.InvoiceStatus.Normal: //foreach (Model.InvoiceXODetail detail in invoice.Details) //{ // if (detail.IsConfirmed != true) // throw new Helper.RequireValueException("Customer"); //} invoiceOriginal.InvoiceStatus = (int)Helper.InvoiceStatus.Null; _TurnNull(invoiceOriginal); invoiceXODetailAccessor.Delete(invoice); this.addUpdateDtail(invoice); EvaInvoiceFlag(invoice); //修改头状态 EvaInvoiceMPSFlag(invoice); //修改头计划状态 accessor.Update(invoice); //invoice.InsertTime = invoiceOriginal.InsertTime; //invoice.UpdateTime = DateTime.Now; //_Insert(invoice); break; case Helper.InvoiceStatus.Null: //foreach (Model.InvoiceXODetail detail in invoice.Details) //{ // //暂时隐藏 修改产品表中 产品的数量 // //Model.CustomerProducts cusproduct = detail.PrimaryKey; // //if (cusproduct.OrderQuantity == null) // // cusproduct.OrderQuantity = 0; // //cusproduct.OrderQuantity -= detail.InvoiceXODetailQuantity; // //customerProductsAccessor.Update(cusproduct); //} break; } break; case Helper.InvoiceStatus.Null: throw new InvalidOperationException(); } }
private void simpleButtonOther_Click(object sender, EventArgs e) { ProduceOtherCompact.ChooseOutContract f = new ProduceOtherCompact.ChooseOutContract(); if (f.ShowDialog(this) != DialogResult.OK) { return; } Model.ProduceOtherCompact OtherCompact = f.SelectItem as Model.ProduceOtherCompact; if (OtherCompact == null) { return; } if (this._produceOtherMaterial.Details.Count > 0 && string.IsNullOrEmpty(this._produceOtherMaterial.Details[0].ProductId)) { this._produceOtherMaterial.Details.RemoveAt(0); } this._produceOtherMaterial.Details.Clear(); this.textEditOtherCompact.Text = OtherCompact.ProduceOtherCompactId; this.newChooseContorlSipu.EditValue = OtherCompact.Supplier; this.textEditCusXOId.Text = string.Empty; if (!string.IsNullOrEmpty(OtherCompact.MRSHeaderId)) { Model.MRSHeader mrsHeader = this.mRSHeaderManager.Get(OtherCompact.MRSHeaderId); if (mrsHeader != null) { Model.MPSheader mPSheader = this.mPSheaderManager.Get(mrsHeader.MPSheaderId); if (mPSheader != null) { Model.InvoiceXO invoiceXO = this.invoiceXOManager.Get(mPSheader.InvoiceXOId); this.textEditCusXOId.Text = invoiceXO == null ? string.Empty : invoiceXO.CustomerInvoiceXOId; } } } //if (ProduceOtherCompact.ChooseOutContract._OtherCompactDetailList.Count == 0) return; //if (this._produceOtherInDepot.Details.Count > 0 && string.IsNullOrEmpty(this._produceOtherInDepot.Details[0].ProductId)) // this._produceOtherInDepot.Details.RemoveAt(0); //this._produceOtherInDepot.Details.Clear(); //this.textEditOtherCompact.Text = ProduceOtherCompact.ChooseOutContract._OtherCompactDetailList[0].ProduceOtherCompactId; //this._produceOtherMaterial.Details = (from p in this.OtherCompactMaterialManager.Select(OtherCompact) // group p by new { p.ProductId, p.ProductUnit } into b // select new Model.ProduceOtherMaterialDetail() // { // ProduceOtherMaterialDetailId = Guid.NewGuid().ToString(), // ProduceOtherCompactMaterialId = (from p in b select p.ProduceOtherCompactMaterialId).ToString(), // ProductId = b.Key.ProductId, // Product = new BL.ProductManager().Get(b.Key.ProductId), // ProductUnit =b.Key.ProductUnit, // OtherMaterialQuantity = (from p in b select p.ProduceQuantity).Sum(), // Description = (from p in b select p.Description).ToString(), // }).ToList(); foreach (Model.ProduceOtherCompactMaterial item in this.OtherCompactMaterialManager.Select(OtherCompact)) { Model.ProduceOtherMaterialDetail detail = new Model.ProduceOtherMaterialDetail(); detail.ProduceOtherMaterialDetailId = Guid.NewGuid().ToString(); detail.ProduceOtherCompactMaterialId = item.ProduceOtherCompactMaterialId; detail.Product = this.productManager.Get(item.ProductId); detail.ProductId = item.ProductId; detail.ProductUnit = item.ProductUnit; detail.OtherMaterialQuantity = item.ProduceQuantity;// - (item.AlreadyOutQuantity == null ? 0 : item.AlreadyOutQuantity); if (detail.OtherMaterialQuantity < 0) { detail.OtherMaterialQuantity = 0; } // detail.ProcessPrice = 0; detail.Description = item.Description; detail.ParentProductId = item.ParentProductId; detail.ParentProduct = item.ParentProduct; detail.ProductStock = detail.Product.StocksQuantity; if (!detail.Product.ProduceMaterialDistributioned.HasValue) { detail.Product.ProduceMaterialDistributioned = 0; } if (!detail.Product.OtherMaterialDistributioned.HasValue) { detail.Product.OtherMaterialDistributioned = 0; } detail.Distributioned = detail.Product.OtherMaterialDistributioned + detail.Product.ProduceMaterialDistributioned; detail.Inumber = this._produceOtherMaterial.Details.Count + 1; this._produceOtherMaterial.Details.Add(detail); } this.gridControl1.RefreshDataSource(); }
public IList <Book.Model.InvoiceXSDetail> Select(Model.InvoiceXO invoiceXO) { return(sqlmapper.QueryForList <Model.InvoiceXSDetail>("InvoiceXSDetail.select_count", invoiceXO.InvoiceId)); }