//选择加工单
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));
}
