/// <summary> /// Insert a MRSdetails. /// </summary> public void Insert(Model.MRSdetails mRSdetails) { // // todo:add other logic here // // mRSdetails.MRSdetailsId = Guid.NewGuid().ToString(); //Model.Product product = ProductAccessor.Get(mRSdetails.ProductId); //if (product.MRSStockQuantity == null) // product.MRSStockQuantity = 0; //if (mRSdetails.MRSdetailssum >= (mRSdetails.Product.StocksQuantity - product.MRSStockQuantity)) // product.MRSStockQuantity += mRSdetails.Product.StocksQuantity - product.MRSStockQuantity; //else { // product.MRSStockQuantity += mRSdetails.MRSdetailssum; //} // if (product.ProductImage == null) // product.ProductImage = pic; // if (product.ProductImage1 == null) // product.ProductImage1 = pic; // if (product.ProductImage2 == null) // product.ProductImage2 = pic; // if (product.ProductImage3 == null) // product.ProductImage3 = pic; // ProductAccessor.Update(product); accessor.Insert(mRSdetails); }
/// <summary> /// Update a MRSdetails. /// </summary> public void Update(Model.MRSdetails mRSdetails) { // // todo: add other logic here. // accessor.Update(mRSdetails); }
/// <summary> /// 自定义列显示 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> //private void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) //{ // if (e.ListSourceRowIndex < 0) return; // IList<Model.MRSdetails> details = this.bindingSource1.DataSource as IList<Model.MRSdetails>; // if (details == null || details.Count < 1) return; // Model.MRSHeader detail = details[e.ListSourceRowIndex].MRSHeader; // Model.Product products = details[e.ListSourceRowIndex].Product; // switch (e.Column.Name) // { // case "gridColumn7": // if (detail == null) return; // e.DisplayText = detail == null ? "" : detail.MPSheaderId; // break; // case "gridColumn1": // if (products == null) return; // e.DisplayText = string.IsNullOrEmpty(products.Id) ? "" : products.Id; // break; // case "gridColumn4": // if (products == null) return; // e.DisplayText = string.IsNullOrEmpty(products.ProductSpecification) ? "" : products.ProductSpecification; // break; // case "gridColumnCusPro": // if (products == null) return; // e.DisplayText = products.CustomerProductName; // break; // case "gridColumnCusXO": // if (!string.IsNullOrEmpty(detail.MPSheaderId)) // { // Model.MPSheader mpsHeader = this.mPSheaderManager.Get(detail.MPSheaderId); // if (mpsHeader != null) // { // if (!string.IsNullOrEmpty(mpsHeader.InvoiceXOId)) // { // Model.InvoiceXO invoiceXO = this.invoiceXOManager.Get(mpsHeader.InvoiceXOId); // e.DisplayText =invoiceXO==null?string.Empty: invoiceXO.CustomerInvoiceXOId; // } // } // } // break; // } //} private void repositoryItemCheckEdit1_Click(object sender, EventArgs e) { Model.MRSdetails mps = bindingSource1.Current as Model.MRSdetails; foreach (Model.MRSdetails item in list) { item.IsChecked = false; } mps.IsChecked = true; this.gridControl1.RefreshDataSource(); }
private void repositoryItemHyperLinkEdit1_Click(object sender, EventArgs e) { Model.MRSdetails mrsdetails = this.bindingSource1.Current as Model.MRSdetails; if (mrsdetails == null) { return; } EditForm f = new EditForm(); if (f.ShowDialog(this) != DialogResult.OK) { return; } }
private void gridView3_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column.Name == "gridColumnCheck") { Model.MRSdetails detail = this.gridView3.GetRow(e.RowHandle) as Model.MRSdetails; if ((bool)e.Value) { key.Add(detail.MRSdetailsId); // MrsDetails.Add(this.mRSdetailsManager.Get(detail.MRSdetailsId)); } if (!(bool)e.Value) { key.Remove(detail.MRSdetailsId); // MrsDetails.Remove(this.mRSdetailsManager.Get(detail.MRSdetailsId)); } } }
public void Update(Model.PronoteHeader pronoteHeader) { // // todo: add other logic here. // Validate(pronoteHeader); // mPSheader.UpdateTime = DateTime.Now; // accessor.Update(mPSheader); if (pronoteHeader != null) { try { BL.V.BeginTransaction(); //this.Delete(pronoteHeader); pronoteHeader.UpdateTime = DateTime.Now; //if (pronoteHeader.Employee0 != null) // pronoteHeader.Employee0Id = pronoteHeader.Employee0.EmployeeId; if (pronoteHeader.Employee1 != null) { pronoteHeader.Employee1Id = pronoteHeader.Employee1.EmployeeId; } if (pronoteHeader.Employee2 != null) { pronoteHeader.Employee2Id = pronoteHeader.Employee2.EmployeeId; } pronoteHeader.InvoiceStatus = 1; if (pronoteHeader.IsClose == null || !pronoteHeader.IsClose.Value) { pronoteHeader.InDepotQuantity = pronoteHeader.InDepotQuantity.HasValue ? pronoteHeader.InDepotQuantity : 0; if (pronoteHeader.InDepotQuantity >= pronoteHeader.DetailsSum) { pronoteHeader.IsClose = true; pronoteHeader.JieAnDate = DateTime.Now; } else { pronoteHeader.IsClose = false; } } accessor.Update(pronoteHeader); Model.MRSdetails mrsDal = mRSdetailsManager.Get(pronoteHeader.MRSdetailsId); if (mrsDal != null) { if (mrsDal.MRSHasSingleSum == null) { mrsDal.MRSHasSingleSum = 0; } mrsDal.MRSHasSingleSum += pronoteHeader.DetailsSum; if (mrsDal.MRSHasSingleSum >= mrsDal.MRSdetailssum) { mrsDal.DetailsFlag = 2; } else { if (mrsDal.MRSHasSingleSum > 0) { mrsDal.DetailsFlag = 1; } else { mrsDal.DetailsFlag = 0; } } //修改派单描述 if (mrsDal.DetailsFlag == 2) { mrsDal.ArrangeDesc = "已經排單"; } mRSdetailsManager.Update(mrsDal); UpdateMRSHeaderFlag(mrsDal.MRSHeader); } //foreach (Model.Pronotedetails pronotedetails in pronoteHeader.Details) //{ // if (pronotedetails.Product == null || string.IsNullOrEmpty(pronotedetails.Product.ProductId)) // throw new Exception("貨品不為空"); // pronotedetails.PronoteHeaderID = pronoteHeader.PronoteHeaderID; // Model.MRSdetails mrsDal = new BL.MRSdetailsManager().Get(pronotedetails.MRSdetailsId); // // double Sum = new BL.ProduceOtherCompactDetailManager().GetByMPSdetail(pronotedetails.MPSdetailId); // PronotedetailsAccessor.Insert(pronotedetails); // if (mrsDal != null) // { // if (mrsDal.MRSHasSingleSum == null) // mrsDal.MRSHasSingleSum = 0; // mrsDal.MRSHasSingleSum += pronotedetails.DetailsSum; // //if (mrsDal.MPSHasSingleSum == mpsDal.MPSdetailssum) // //{ // // mrsDal.MPSEndState = true; // //} // new BL.MRSdetailsManager().Update(mrsDal); // } //} PronotedetailsMaterialAccessor.DeleteByHeaderId(pronoteHeader.PronoteHeaderID); foreach (Model.PronotedetailsMaterial proMaterial in pronoteHeader.DetailsMaterial) { if (string.IsNullOrEmpty(proMaterial.ProductId)) { continue; } proMaterial.PronoteHeaderID = pronoteHeader.PronoteHeaderID; if (PronotedetailsMaterialAccessor.ExistsPrimary(proMaterial.PronotedetailsMaterialId)) { PronotedetailsMaterialAccessor.Update(proMaterial); } else { PronotedetailsMaterialAccessor.Insert(proMaterial); } } foreach (Model.PronoteProceduresDetail detailProcedures in pronoteHeader.DetailProcedures) { if (string.IsNullOrEmpty(detailProcedures.PronoteProceduresDetailId)) { continue; } detailProcedures.PronoteHeader = pronoteHeader; detailProcedures.PronoteHeaderID = pronoteHeader.PronoteHeaderID; if (PronoteProceduresDetailAccessor.ExistsPrimary(detailProcedures.PronoteProceduresDetailId)) { PronoteProceduresDetailAccessor.Update(detailProcedures); } else { PronoteProceduresDetailAccessor.Insert(detailProcedures); } } foreach (Model.ProceduresMachine item in pronoteHeader.ProceduresMachineDetail) { if (ProceduresMachineAccessor.ExistsPrimary(item.ProceduresMachineId)) { ProceduresMachineAccessor.Update(item); } else { ProceduresMachineAccessor.Insert(item); } } BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } } }
public void InsertWithOutTrans(Model.PronoteHeader pronoteHeader) { pronoteHeader.InsertTime = DateTime.Now; pronoteHeader.UpdateTime = DateTime.Now; TiGuiExists(pronoteHeader); if (pronoteHeader.Employee0 != null) { pronoteHeader.Employee0Id = pronoteHeader.Employee0.EmployeeId; } if (pronoteHeader.Employee1 != null) { pronoteHeader.Employee1Id = pronoteHeader.Employee1.EmployeeId; } if (pronoteHeader.Employee2 != null) { pronoteHeader.Employee2Id = pronoteHeader.Employee2.EmployeeId; } string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, pronoteHeader.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, pronoteHeader.InsertTime.Value.Year, pronoteHeader.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, pronoteHeader.InsertTime.Value.ToString("yyyy-MM-dd")); string sequencekey = string.Format(invoiceKind); SequenceManager.Increment(sequencekey_y); SequenceManager.Increment(sequencekey_m); SequenceManager.Increment(sequencekey_d); SequenceManager.Increment(sequencekey); pronoteHeader.InvoiceStatus = 1; pronoteHeader.InDepotQuantity = 0; pronoteHeader.IsClose = false; accessor.Insert(pronoteHeader); Model.MRSdetails mrsDal = mRSdetailsManager.Get(pronoteHeader.MRSdetailsId); if (mrsDal != null) { if (mrsDal.MRSHasSingleSum == null) { mrsDal.MRSHasSingleSum = 0; } mrsDal.MRSHasSingleSum += pronoteHeader.DetailsSum; if (mrsDal.MRSHasSingleSum >= mrsDal.MRSdetailssum) { mrsDal.DetailsFlag = 2; } else { if (mrsDal.MRSHasSingleSum > 0) { mrsDal.DetailsFlag = 1; } else { mrsDal.DetailsFlag = 0; } } mrsDal.ArrangeDesc = "已經排單"; mRSdetailsManager.Update(mrsDal); UpdateMRSHeaderFlag(mrsDal.MRSHeader); } foreach (Model.PronotedetailsMaterial proMaterial in pronoteHeader.DetailsMaterial) { if (string.IsNullOrEmpty(proMaterial.ProductId)) { continue; } proMaterial.PronoteHeaderID = pronoteHeader.PronoteHeaderID; PronotedetailsMaterialAccessor.Insert(proMaterial); } foreach (Model.PronoteProceduresDetail detailProcedures in pronoteHeader.DetailProcedures) { if (detailProcedures.PronoteProceduresDetailId == null) { continue; } detailProcedures.PronoteHeader = pronoteHeader; detailProcedures.PronoteHeaderID = pronoteHeader.PronoteHeaderID; if (PronoteProceduresDetailAccessor.ExistsPrimary(detailProcedures.PronoteProceduresDetailId)) { PronoteProceduresDetailAccessor.Update(detailProcedures); } else { PronoteProceduresDetailAccessor.Insert(detailProcedures); } } if (pronoteHeader.ProceduresMachineDetail != null) { foreach (Model.ProceduresMachine item in pronoteHeader.ProceduresMachineDetail) { if (ProceduresMachineAccessor.ExistsPrimary(item.ProceduresMachineId)) { ProceduresMachineAccessor.Update(item); } else { ProceduresMachineAccessor.Insert(item); } } } }
public RO(string pronoteHeaderId, int flag) { InitializeComponent(); this.pronoteHeader = this.pronoteHeaderManager.GetDetails(pronoteHeaderId); //CompanyInfo this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName; //this.xrLabelDataName.Text = Properties.Resources.Pronotedetails; if (flag == 5) { this.xrLabelDataName.Text = Properties.Resources.GZZhiShi; } else if (flag == 4) { this.xrLabelDataName.Text = Properties.Resources.ZZJiaGong; } this.xrLabelPrintDate.Text = this.xrLabelPrintDate.Text + DateTime.Now.ToShortDateString(); if (pronoteHeader.WorkHouse != null) { this.xrLabelWorkHouse.Text = this.pronoteHeader.WorkHouse.Workhousename; } Model.MRSdetails mrsdetail = this.mRSDetailsManager.Get(this.pronoteHeader.MRSdetailsId); if (mrsdetail != null) { this.xrLabelBeforepPackage.Text = mrsdetail.BeforePackageProduct == null ? string.Empty : (mrsdetail.BeforePackageProduct.IsCustomerProduct.HasValue && mrsdetail.BeforePackageProduct.IsCustomerProduct.Value ? mrsdetail.BeforePackageProduct.ProductName + "{" + mrsdetail.BeforePackageProduct.CustomerProductName + "}" : mrsdetail.BeforePackageProduct.ProductName); } else { this.xrLabelBeforepPackage.Text = string.Empty; } //生產通知 this.xrLabelPronoteHeaderID.Text = this.pronoteHeader.PronoteHeaderID; this.xrLabelPronoteDte.Text = this.pronoteHeader.PronoteDate.Value.ToString("yyyy-MM-dd"); this.xrLabelMRP.Text = this.pronoteHeader.MRSHeaderId; if (this.pronoteHeader.Employee0 != null && flag != 1) { this.xrLabelEmployee.Text = this.pronoteHeader.Employee0.EmployeeName; } this.xrLabel14.Text = this.pronoteHeader.AuditEmp == null ? "" : this.pronoteHeader.AuditEmp.EmployeeName; if (pronoteHeader.Product != null) { this.xrLabelProductName.Text = pronoteHeader.Product.ProductName; //this.xrLabelCustomerProductName.Text = pronoteHeader.Product.CustomerProductName; this.xrRichTextProDesc.Rtf = this.pronoteHeader.Product.ProductDescription; if (this.pronoteHeader.Product.AttrZhengMai != null) { this.RichTextZhengMai.Rtf = this.pronoteHeader.Product.AttrZhengMai; } if (this.pronoteHeader.Product.AttrCeMai != null) { this.RichTextCeMai.Rtf = this.pronoteHeader.Product.AttrCeMai; } } Model.InvoiceXO xo = new BL.InvoiceXOManager().Get(this.pronoteHeader.InvoiceXOId); if (xo != null) { //this.xrLabelCheckedStandard.Text = xo.xocustomer.CheckedStandard; this.xrLabelCustomer.Text = xo.xocustomer.CustomerShortName; this.xrLabelCustomerXOId.Text = xo.CustomerInvoiceXOId; //this.xrLabelPiHao.Text = xo.CustomerLotNumber; this.xrLabelXOJHDate.Text = xo.InvoiceYjrq.Value.ToString("yyyy-MM-dd"); this.lblCustomerId.Text = xo.Customer.Id; } this.xrLabelCount.Text = pronoteHeader.DetailsSum.ToString(); this.xrLabelUnit.Text = pronoteHeader.ProductUnit; this.xrLabelPronotedesc.Text = this.pronoteHeader.Pronotedesc; //if (this.pronoteHeader.DetailProcedures != null && this.pronoteHeader.DetailProcedures.Count > 0) //{ // this.pronoteHeader.DetailProcedures = this.pronoteHeader.DetailProcedures.OrderByDescending(p => p.PronoteProceduresDate).ToList(); // if (this.pronoteHeader.DetailProcedures.First().WorkHouse != null) // this.xrLabelhouseId.Text = this.pronoteHeader.DetailProcedures.First().WorkHouse.Workhousename; //} this.lblInvoiceXODetailQuantity.Text = this.pronoteHeader.InvoiceXODetailQuantity == null ? "0" : this.pronoteHeader.InvoiceXODetailQuantity.ToString(); this.xrSubreport1.ReportSource = new RO1(); this.xrSubreport2.ReportSource = new RO2(); }
public RO(string pronoteHeaderId, int flag) { InitializeComponent(); this.pronoteHeader = this.pronoteHeaderManager.GetDetails(pronoteHeaderId); //CompanyInfo this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName; //this.xrLabelDataName.Text = Properties.Resources.Pronotedetails; if (flag == 5) { this.xrLabelDataName.Text = Properties.Resources.GZZhiShi; } else if (flag == 4) { this.xrLabelDataName.Text = Properties.Resources.ZZJiaGong; this.lbl_PageSign.Text = "QR8-06-09-1"; } this.xrLabelPrintDate.Text = this.xrLabelPrintDate.Text + DateTime.Now.ToShortDateString(); if (pronoteHeader.WorkHouse != null) { this.xrLabelWorkHouse.Text = this.pronoteHeader.WorkHouse.Workhousename; } Model.MRSdetails mrsdetail = this.mRSDetailsManager.Get(this.pronoteHeader.MRSdetailsId); if (mrsdetail != null) { this.xrLabelBeforepPackage.Text = mrsdetail.BeforePackageProduct == null ? string.Empty : (mrsdetail.BeforePackageProduct.IsCustomerProduct.HasValue && mrsdetail.BeforePackageProduct.IsCustomerProduct.Value ? mrsdetail.BeforePackageProduct.ProductName + "{" + mrsdetail.BeforePackageProduct.CustomerProductName + "}" : mrsdetail.BeforePackageProduct.ProductName); } else { this.xrLabelBeforepPackage.Text = string.Empty; } //生產通知 this.xrLabelPronoteHeaderID.Text = this.pronoteHeader.PronoteHeaderID; this.xrLabelPronoteDte.Text = this.pronoteHeader.PronoteDate.Value.ToString("yyyy-MM-dd"); this.xrLabelMRP.Text = this.pronoteHeader.MRSHeaderId; if (this.pronoteHeader.Employee0 != null && flag != 1) { this.xrLabelEmployee.Text = this.pronoteHeader.Employee0.EmployeeName; } this.xrLabel14.Text = this.pronoteHeader.AuditEmp == null ? "" : this.pronoteHeader.AuditEmp.EmployeeName; if (pronoteHeader.Product != null) { this.xrLabelProductName.Text = pronoteHeader.Product.ProductName + " 版次:" + pronoteHeader.Product.ProductVersion; if (string.IsNullOrEmpty(pronoteHeader.Product.CustomerProductName)) { this.xrLabelCustomerProductName.Text = new Help().GetCustomerProductNameByPronoteHeaderId(pronoteHeader.PronoteHeaderID, pronoteHeader.ProductId); } else { this.xrLabelCustomerProductName.Text = pronoteHeader.Product.CustomerProductName; } this.xrRichTextProDesc.Rtf = this.pronoteHeader.Product.ProductDescription; //商品正侧唛单独划分出一张表 2021年7月18日20:28:12 //if (this.pronoteHeader.Product.AttrZhengMai != null) // this.RichTextZhengMai.Rtf = this.pronoteHeader.Product.AttrZhengMai; //if (this.pronoteHeader.Product.AttrCeMai != null) // this.RichTextCeMai.Rtf = this.pronoteHeader.Product.AttrCeMai; Model.ProductMark mark = new BL.ProductMarkManager().SelectByProductId(this.pronoteHeader.ProductId); if (mark != null) { if (!string.IsNullOrEmpty(mark.MainMark)) { this.RichTextZhengMai.Rtf = mark.MainMark; } if (!string.IsNullOrEmpty(mark.SideMark)) { this.RichTextCeMai.Rtf = mark.SideMark; } } } Model.InvoiceXO xo = new BL.InvoiceXOManager().Get(this.pronoteHeader.InvoiceXOId); if (xo != null) { this.xrLabelCheckedStandard.Text = xo.xocustomer.CheckedStandard; this.xrLabelCustomer.Text = xo.xocustomer.CustomerShortName; this.xrLabelCustomerXOId.Text = xo.CustomerInvoiceXOId; this.xrLabelPiHao.Text = xo.CustomerLotNumber; this.xrLabelXOJHDate.Text = xo.InvoiceYjrq.Value.ToString("yyyy-MM-dd"); if (xo.xocustomer != null && !string.IsNullOrEmpty(xo.xocustomer.CheckedStandard)) { if (xo.xocustomer.CheckedStandard.ToLower().Contains("jis") && xo.xocustomer.CustomerFullName.ToUpper().Contains("MIDORI")) { //CreateTagLable("JIS"); this.lbl_JIS.Text = "JIS"; } else if (xo.xocustomer.CheckedStandard.ToLower().Contains("as")) { //CreateTagLable("AS"); this.lbl_JIS.Text = "AS"; } } } this.xrLabelCount.Text = pronoteHeader.DetailsSum.ToString(); this.xrLabelUnit.Text = pronoteHeader.ProductUnit; this.xrLabelPronotedesc.Text = this.pronoteHeader.Pronotedesc; this.lbl_ProduceMaterial.Text = this.pronoteHeader.Materialprocessum == null ? "" : this.pronoteHeader.Materialprocessum.ToString(); //if (this.pronoteHeader.DetailProcedures != null && this.pronoteHeader.DetailProcedures.Count > 0) //{ // this.pronoteHeader.DetailProcedures = this.pronoteHeader.DetailProcedures.OrderByDescending(p => p.PronoteProceduresDate).ToList(); // if (this.pronoteHeader.DetailProcedures.First().WorkHouse != null) // this.xrLabelhouseId.Text = this.pronoteHeader.DetailProcedures.First().WorkHouse.Workhousename; //} this.lblInvoiceXODetailQuantity.Text = this.pronoteHeader.InvoiceXODetailQuantity == null ? "0" : this.pronoteHeader.InvoiceXODetailQuantity.ToString(); this.xrSubreport1.ReportSource = new RO1(); this.xrSubreport2.ReportSource = new RO2(); }
public RO3(string pronoteHeaderId, int flag) { InitializeComponent(); this.pronoteHeader = this.pronoteHeaderManager.Get(pronoteHeaderId); if (this.pronoteHeader == null) { return; } this.pronoteHeader.DetailProcedures = this.pronoteProceduresDetailManager.GetPronotedetailsMaterialByHeaderId(this.pronoteHeader); if (this.pronoteHeader.DetailProcedures != null) { foreach (Model.PronoteProceduresDetail detail in this.pronoteHeader.DetailProcedures) { this.machineList = this.pronoteMachineManager.GetPronoteMachineByPronoteProceduresDetailId(detail.PronoteProceduresDetailId); { foreach (Model.PronoteMachine machine in machineList) { if (machineList.IndexOf(machine) == machineList.Count - 1) { detail.Machine += machine.PronoteMachineName; } else { detail.Machine += machine.PronoteMachineName + ","; } //this.proceManager.Insert(promachine); } } } } this.DataSource = this.pronoteHeader.DetailProcedures; //CompanyInfo this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName; this.xrLabelDataName.Text = Properties.Resources.ProducePronoteName; if (flag == 1) { this.xrLabelDataName.Text = Properties.Resources.GZZhiShi; } else if (flag == 2) { this.xrLabelDataName.Text = Properties.Resources.ZZJiaGong; } this.xrLabelPrintDate.Text = this.xrLabelPrintDate.Text + DateTime.Now.ToString("yyyy-MM-dd"); //生產通知 this.xrLabelPronoteHeaderID.Text = this.pronoteHeader.PronoteHeaderID; this.xrLabelPronoteDte.Text = this.pronoteHeader.PronoteDate.Value.ToString("yyyy-MM-dd"); this.xrRichTextProDesc.Rtf = this.pronoteHeader.Product.ProductDescription; Model.MRSdetails mrsdetail = this.mRSDetailsManager.Get(this.pronoteHeader.MRSdetailsId); if (mrsdetail != null) { this.xrLabelBeforepPackage.Text = mrsdetail.BeforePackageProduct == null ? string.Empty : (mrsdetail.BeforePackageProduct.IsCustomerProduct.HasValue && mrsdetail.BeforePackageProduct.IsCustomerProduct.Value ? mrsdetail.BeforePackageProduct.ProductName + "{" + mrsdetail.BeforePackageProduct.CustomerProductName + "}" : mrsdetail.BeforePackageProduct.ProductName); } else { this.xrLabelBeforepPackage.Text = string.Empty; } if (pronoteHeader.WorkHouse != null) { this.xrLabelWorkHouse.Text = this.pronoteHeader.WorkHouse.Workhousename; } if (this.pronoteHeader.Employee0 != null) { this.xrLabelEmployee0.Text = this.pronoteHeader.Employee0.EmployeeName; } if (pronoteHeader.Product != null) { // this.xrLabelProductId.Text = pronoteHeader.Product.Id; this.xrLabelProductName.Text = pronoteHeader.Product.ProductName; this.xrLabelCustomerProductName.Text = pronoteHeader.Product.CustomerProductName; } Model.InvoiceXO xo = new BL.InvoiceXOManager().Get(this.pronoteHeader.InvoiceXOId); if (xo != null) { this.xrLabelCustomer.Text = xo.xocustomer.CustomerShortName; this.xrLabelCheckedStandard.Text = xo.xocustomer.CheckedStandard; this.xrLabelCustomerXOId.Text = xo.CustomerInvoiceXOId; this.xrLabelXOJHDate.Text = xo.InvoiceYjrq.Value.ToString("yyyy-MM-dd"); } this.xrLabelCount.Text = pronoteHeader.DetailsSum.ToString(); this.xrLabelUnit.Text = pronoteHeader.ProductUnit; this.xrLabelPronotedesc.Text = this.pronoteHeader.Pronotedesc; //this.xrLabelMachine.Text= //明细 this.xrTableCellPronoteProceduresDate.DataBindings.Add("Text", this.DataSource, Model.PronoteProceduresDetail.PRO_PronoteProceduresDate, "{0:yyyy-MM-dd}"); //this.xrTableCellProceduresNo.DataBindings.Add("Text", this.DataSource,Model.PronoteProceduresDetail.PRO_ProceduresNo); this.xrTableCellWorkHouseId.DataBindings.Add("Text", this.DataSource, "WorkHouse." + Model.WorkHouse.PROPERTY_WORKHOUSENAME); this.xrTableCellSupplierId.DataBindings.Add("Text", this.DataSource, "Supplier." + Model.Supplier.PROPERTY_SUPPLIERSHORTNAME); this.xrTableCellPronoteYingQuantity.DataBindings.Add("Text", this.DataSource, Model.PronoteProceduresDetail.PRO_PronoteYingQuantity); //this.xrTableCellFulfillQuantity.DataBindings.Add("Text", this.DataSource, Model.PronoteProceduresDetail.PRO_FulfillQuantity); //this.xrTableCellDeposeQuantity.DataBindings.Add("Text", this.DataSource, Model.PronoteProceduresDetail.PRO_DeposeQuantity); //this.xrTableCellcheckQuantity.DataBindings.Add("Text", this.DataSource, Model.PronoteProceduresDetail.PRO_checkQuantity); //this.xrTableCellLossQuantity.DataBindings.Add("Text", this.DataSource, Model.PronoteProceduresDetail.PRO_LossQuantity); this.xrRichText1.DataBindings.Add("Rtf", this.DataSource, "Procedures." + Model.Procedures.PRO_Procedurename); this.xrTableCell12.DataBindings.Add("Text", this.DataSource, "Procedures." + Model.Procedures.PRO_Proceduredescription); this.xrTableCellNO.DataBindings.Add("Text", this.DataSource, Model.PronoteProceduresDetail.PRO_ProceduresNo); this.xrTableCellMachine.DataBindings.Add("Text", this.DataSource, Model.PronoteProceduresDetail.PRO_Machine); }
public RO(string pronoteHeaderId, int flag) { InitializeComponent(); this.pronoteHeader = this.pronoteHeaderManager.GetDetails(pronoteHeaderId); //CompanyInfo this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName; //this.xrLabelDataName.Text = Properties.Resources.Pronotedetails; if (flag == 5) { this.xrLabelDataName.Text = Properties.Resources.GZZhiShi; } else if (flag == 4) { this.xrLabelDataName.Text = Properties.Resources.ZZJiaGong; this.lbl_PageSign.Text = "QR8-06-09-1"; } this.xrLabelPrintDate.Text = this.xrLabelPrintDate.Text + DateTime.Now.ToString("yyyy-MM-dd"); if (pronoteHeader.WorkHouse != null) { this.xrLabelWorkHouse.Text = this.pronoteHeader.WorkHouse.Workhousename; } Model.MRSdetails mrsdetail = this.mRSDetailsManager.Get(this.pronoteHeader.MRSdetailsId); if (mrsdetail != null) { this.xrLabelBeforepPackage.Text = mrsdetail.BeforePackageProduct == null ? string.Empty : (mrsdetail.BeforePackageProduct.IsCustomerProduct.HasValue && mrsdetail.BeforePackageProduct.IsCustomerProduct.Value ? mrsdetail.BeforePackageProduct.ProductName + "{" + mrsdetail.BeforePackageProduct.CustomerProductName + "}" : mrsdetail.BeforePackageProduct.ProductName); //this.lblPlanNum.Text = mrsdetail.MRSdetailsQuantity.ToString(); } else { this.xrLabelBeforepPackage.Text = string.Empty; } //生產通知 this.xrLabelPronoteHeaderID.Text = this.pronoteHeader.PronoteHeaderID; this.xrLabelPronoteDte.Text = this.pronoteHeader.PronoteDate.Value.ToString("yyyy-MM-dd"); this.xrLabelMRP.Text = this.pronoteHeader.MRSHeaderId; this.lblBGHandBookId.Text = this.pronoteHeader.HandbookId; this.lblBGHandBookDetailId.Text = this.pronoteHeader.HandbookProductId; this.lblPlanNum.Text = this.pronoteHeader.InvoiceXODetailQuantity.HasValue ? this.pronoteHeader.InvoiceXODetailQuantity.Value.ToString() : ""; if (this.pronoteHeader.Employee0 != null && flag != 1) { this.xrLabelEmployee.Text = this.pronoteHeader.Employee0.EmployeeName; } if (pronoteHeader.Product != null) { this.xrLabelProductName.Text = pronoteHeader.Product.ProductName; this.lbl_Pro_Id.Text = pronoteHeader.Product.Id; if (string.IsNullOrEmpty(pronoteHeader.Product.CustomerProductName)) { this.xrLabelCustomerProductName.Text = CommonHelp.GetCustomerProductNameByPronoteHeaderId(pronoteHeader, pronoteHeader.ProductId, pronoteHeader.HandbookProductId); } else { this.xrLabelCustomerProductName.Text = pronoteHeader.Product.CustomerProductName; } this.xrRichTextProDesc.Rtf = this.pronoteHeader.Product.ProductDescription; //商品正侧唛单独划分出一张表 2021年8月22日22:53:53 //if (this.pronoteHeader.Product.AttrZhengMai != null) // this.RichTextZhengMai.Rtf = this.pronoteHeader.Product.AttrZhengMai; //if (this.pronoteHeader.Product.AttrCeMai != null) // this.RichTextCeMai.Rtf = this.pronoteHeader.Product.AttrCeMai; Model.ProductMark mark = new BL.ProductMarkManager().SelectByProductId(this.pronoteHeader.ProductId); if (mark != null) { if (!string.IsNullOrEmpty(mark.MainMark)) { this.RichTextZhengMai.Rtf = mark.MainMark; } if (!string.IsNullOrEmpty(mark.SideMark)) { this.RichTextCeMai.Rtf = mark.SideMark; } } } Model.InvoiceXO xo = new BL.InvoiceXOManager().Get(this.pronoteHeader.InvoiceXOId); if (xo != null) { this.xrLabelCheckedStandard.Text = xo.xocustomer.CheckedStandard; this.xrLabelCustomer.Text = xo.xocustomer.CustomerShortName; this.xrLabelCustomerXOId.Text = xo.CustomerInvoiceXOId; this.xrLabelPiHao.Text = xo.CustomerLotNumber; this.xrLabelXOJHDate.Text = xo.InvoiceYjrq.Value.ToString("yyyy-MM-dd"); } this.xrLabelCount.Text = pronoteHeader.DetailsSum.ToString(); this.xrLabelUnit.Text = pronoteHeader.ProductUnit; this.xrLabelPronotedesc.Text = this.pronoteHeader.Pronotedesc; //if (this.pronoteHeader.DetailProcedures != null && this.pronoteHeader.DetailProcedures.Count > 0) //{ // this.pronoteHeader.DetailProcedures = this.pronoteHeader.DetailProcedures.OrderByDescending(p => p.PronoteProceduresDate).ToList(); // if (this.pronoteHeader.DetailProcedures.First().WorkHouse != null) // this.xrLabelhouseId.Text = this.pronoteHeader.DetailProcedures.First().WorkHouse.Workhousename; //} this.xrSubreport1.ReportSource = new RO1(); this.xrSubreport2.ReportSource = new RO2(); }
public ROJGZHishi(string pronoteHeaderId, int flag) { InitializeComponent(); this.pronoteHeader = this.pronoteHeaderManager.GetDetails(pronoteHeaderId); //CompanyInfo this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName; this.xrLabelDataName.Text = Properties.Resources.Pronotedetails; if (flag == 5) { this.xrLabelDataName.Text = Properties.Resources.GZZhiShi; } else if (flag == 4) { this.xrLabelDataName.Text = Properties.Resources.ZZJiaGong; } this.xrLabelPrintDate.Text = this.xrLabelPrintDate.Text + DateTime.Now.ToShortDateString(); if (pronoteHeader.WorkHouse != null) { this.xrLabelWorkHouse.Text = this.pronoteHeader.WorkHouse.Workhousename; } Model.MRSdetails mrsdetail = this.mRSDetailsManager.Get(this.pronoteHeader.MRSdetailsId); if (mrsdetail != null) { this.xrLabelBeforepPackage.Text = mrsdetail.BeforePackageProduct == null ? string.Empty : (mrsdetail.BeforePackageProduct.IsCustomerProduct.HasValue && mrsdetail.BeforePackageProduct.IsCustomerProduct.Value ? mrsdetail.BeforePackageProduct.ProductName + "{" + mrsdetail.BeforePackageProduct.CustomerProductName + "}" : mrsdetail.BeforePackageProduct.ProductName); } else { this.xrLabelBeforepPackage.Text = string.Empty; } //生產通知 this.xrLabelPronoteHeaderID.Text = this.pronoteHeader.PronoteHeaderID; this.xrLabelPronoteDte.Text = this.pronoteHeader.PronoteDate.Value.ToString("yyyy-MM-dd"); this.xrLabelMRP.Text = this.pronoteHeader.MRSHeaderId; if (this.pronoteHeader.Employee0 != null && flag != 1) { this.xrLabelEmployee.Text = this.pronoteHeader.Employee0.EmployeeName; } this.xrLabel14.Text = this.pronoteHeader.AuditEmp == null ? "" : this.pronoteHeader.AuditEmp.EmployeeName; if (pronoteHeader.Product != null) { this.xrLabelProductName.Text = pronoteHeader.Product.ProductName; if (string.IsNullOrEmpty(pronoteHeader.Product.CustomerProductName)) { this.xrLabelCustomerProductName.Text = new Help().GetCustomerProductNameByPronoteHeaderId(pronoteHeader.PronoteHeaderID, pronoteHeader.ProductId); } else { this.xrLabelCustomerProductName.Text = pronoteHeader.Product.CustomerProductName; } this.xrRichTextProDesc.Rtf = this.pronoteHeader.Product.ProductDescription; } Model.InvoiceXO xo = new BL.InvoiceXOManager().Get(this.pronoteHeader.InvoiceXOId); if (xo != null) { this.xrLabelCheckedStandard.Text = xo.xocustomer.CheckedStandard; this.xrLabelCustomer.Text = xo.xocustomer.CustomerShortName; this.xrLabelCustomerXOId.Text = xo.CustomerInvoiceXOId; if (flag != 0) { this.xrLabelPiHao.Text = xo.CustomerLotNumber; if (flag != 5) { this.xrLabelXOJHDate.Text = xo.InvoiceYjrq.Value.ToString("yyyy-MM-dd"); //生产加工单和加工指示单 不显示交期 } } if (xo.xocustomer != null && !string.IsNullOrEmpty(xo.xocustomer.CheckedStandard)) { if (xo.xocustomer.CheckedStandard.ToLower().Contains("jis") && xo.xocustomer.CustomerFullName.ToUpper().Contains("MIDORI")) { //CreateTagLable("JIS"); this.lbl_JIS.Text = "JIS"; } else if (xo.xocustomer.CheckedStandard.ToLower().Contains("as")) { //CreateTagLable("AS"); this.lbl_JIS.Text = "AS"; } } } this.xrLabelCount.Text = pronoteHeader.DetailsSum.ToString(); this.xrLabelUnit.Text = pronoteHeader.ProductUnit; this.xrLabelPronotedesc.Text = this.pronoteHeader.Pronotedesc; this.lbl_MaterialSum.Text = this.pronoteHeader.Materialprocessum == null ? "" : this.pronoteHeader.Materialprocessum.ToString(); //this.lblChakuang.Text = this.pronoteHeader.Chakuang; //this.lblPaihe.Text = this.pronoteHeader.Paihe; //this.lblMoshu.Text = this.pronoteHeader.Moshu; //if (this.pronoteHeader.DetailProcedures != null && this.pronoteHeader.DetailProcedures.Count > 0) //{ // this.pronoteHeader.DetailProcedures = this.pronoteHeader.DetailProcedures.OrderByDescending(p => p.PronoteProceduresDate).ToList(); // if (this.pronoteHeader.DetailProcedures.First().WorkHouse != null) // this.xrLabelhouseId.Text = this.pronoteHeader.DetailProcedures.First().WorkHouse.Workhousename; //} this.xrSubreport1.ReportSource = new RO1(); this.xrSubreport2.ReportSource = new RO2(); }
public void Update(Model.MRSdetails e) { this.Update <Model.MRSdetails>(e); }
public void Insert(Model.MRSdetails e) { this.Insert <Model.MRSdetails>(e); }