//加工单查看 private void repositoryItemHyperLinkEdit1_Click(object sender, EventArgs e) { string pronoteHeaderid = (this.bindingSource1.Current as Model.ProduceInDepotDetail).PronoteHeaderId; Model.PronoteHeader d = new BL.PronoteHeaderManager().Get(pronoteHeaderid); if (d != null) { PronoteHeader.EditForm f = new Book.UI.produceManager.PronoteHeader.EditForm(d); f.ShowDialog(); } }
public RO(string produceMaterialExitId) { InitializeComponent(); this.produceMaterialExit = this.produceMaterialExitManager.Get(produceMaterialExitId); if (this.produceMaterialExit == null) { return; } this.produceMaterialExit.Detail = this.produceMaterialExitDetailManager.Select(this.produceMaterialExit); this.DataSource = this.produceMaterialExit.Detail; //CompanyInfo this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName; this.xrLabelDataName.Text = Properties.Resources.ProduceMaterialExitDetail; this.xrLabelDate.Text += DateTime.Now.ToShortDateString(); //生產退料 this.xrLabelPronoteHeader.Text = this.produceMaterialExit.PronoteHeaderID; this.xrLabelDepot.Text = this.produceMaterialExit.Depot == null ? string.Empty : this.produceMaterialExit.Depot.ToString(); this.lblSupplier.Text = this.produceMaterialExit.Supplier == null ? string.Empty : this.produceMaterialExit.Supplier.ToString(); this.xrLabelProduceExitMaterialId.Text = this.produceMaterialExit.ProduceMaterialExitId; this.xrLabelProduceExitMaterialDate.Text = this.produceMaterialExit.ProduceExitMaterialDate.Value.ToString("yyyy-MM-dd"); //客戶訂單編號 this.xrLabelInvoiceCusXoId.Text = this.produceMaterialExit.CustomerInvoiceXOId; if (this.produceMaterialExit.Employee0 != null) { this.xrLabelEmployee0.Text = this.produceMaterialExit.Employee0.EmployeeName; } if (this.produceMaterialExit.WorkHouse != null) { this.xrLabelDepartment.Text = this.produceMaterialExit.WorkHouse.Workhousename; } this.xrLabelProduceExitMaterialDesc.Text = this.produceMaterialExit.ProduceExitMaterialDesc; if (!string.IsNullOrEmpty(this.produceMaterialExit.PronoteHeaderID)) { Model.PronoteHeader mPH = new BL.PronoteHeaderManager().Get(this.produceMaterialExit.PronoteHeaderID); if (mPH != null) { this.lblZhuJianProductName.Text = mPH.Product.ToString(); } } //明细 this.xrTableCell1ProductId.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialExitDetail.PRO_Inumber); this.xrTableproductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); this.xrDepotPosi.DataBindings.Add("Text", this.DataSource, "DepotPosition." + Model.DepotPosition.PROPERTY_ID); this.xrUnit.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialExitDetail.PRO_ProductUnit); this.xrTableProduceQuantity.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialExitDetail.PRO_ProduceQuantity); this.xrTableGuiGe.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductSpecification); this.xrProductioinBatch.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialExitDetail.PRO_ProductioinBatch); }
public XR(string ProduceStatisticsId) { InitializeComponent(); this.produceStatistics = this.produceStatisticsManager.Get(ProduceStatisticsId); if (this.produceStatistics == null) { return; } this.produceStatistics.Details = this.produceStatisticsdetailsManager.Select(this.produceStatistics); this.DataSource = this.produceStatistics.Details; this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName; this.xrLabelDataName.Text = Properties.Resources.ProduceNums; this.xrLabelPrintDate.Text += DateTime.Now.ToShortDateString(); this.xrLabelProduceStatisticsDate.Text = this.produceStatistics.ProduceStatisticsDate.Value.ToString("yyyy-MM-dd"); this.xrLabelProduceStatisticsId.Text = this.produceStatistics.ProduceStatisticsId; if (this.produceStatistics.Employee != null) { this.xrLabelEmployeeId.Text = this.produceStatistics.Employee.EmployeeName; } if (this.produceStatistics.WorkHouse != null) { this.xrLabelWorkHouseId.Text = this.produceStatistics.WorkHouse.Workhousename; } this.xrLabelPronoteHeaderID.Text = this.produceStatistics.PronoteHeaderID; if (!string.IsNullOrEmpty(this.produceStatistics.PronoteHeaderID)) { Model.PronoteHeader pronoteHeader = new BL.PronoteHeaderManager().Get(this.produceStatistics.PronoteHeaderID); if (pronoteHeader != null) { Model.InvoiceXO invoiceXO = new BL.InvoiceXOManager().Get(pronoteHeader.InvoiceXOId); this.xrLabelCustomerXoId.Text = invoiceXO == null ? string.Empty : invoiceXO.CustomerInvoiceXOId; if (pronoteHeader.Product != null) { this.xrLabelProductId.Text = pronoteHeader.Product.Id; this.xrLabelProductName.Text = pronoteHeader.Product.ProductName; this.xrRichText3.Rtf = pronoteHeader.Product.ProductDescription; } } } else { this.xrLabelCustomerXoId.Text = string.Empty; } if (this.produceStatistics.Procedures != null) { this.xrLabelProceduresId.Text = this.produceStatistics.Procedures.Id; this.xrRichText1.Rtf = this.produceStatistics.Procedures.Procedurename; } this.xrLabelDescription.Text = this.produceStatistics.Description; //Ã÷ϸ this.xrTableCellDate.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_DetailDate, "{0:yyyy-MM-dd}"); this.xrTableCellType.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_BusinessHoursType); this.xrTableCellEllo.DataBindings.Add("Text", this.DataSource, "Employee0." + Model.Employee.PROPERTY_EMPLOYEENAME); this.xrTableCellElpple.DataBindings.Add("Text", this.DataSource, "Employee." + Model.Employee.PROPERTY_EMPLOYEENAME); this.xrTableCellPcount.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_ProduceQuantity); this.xrTableCellHege.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_HeGeQuantity); this.xrTableCellNoPcount.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_RejectionRate); this.xrTableCelldescription.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_Description); this.xrTableCellUpdatDate.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_UpdateTime, "{0:yyyy-MM-dd}"); this.xrTableCell25.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_HeiDian); this.xrTableCell26.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_Zazhi); this.xrTableCell27.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_JingDian); this.xrTableCell28.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_ChaShang); this.xrTableCell29.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_FuMo); this.xrTableCell30.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_SuoShui); this.xrTableCell31.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_GuoHuo); this.xrTableCell32.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_BaiYan); this.xrLabel2.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_HeiYan); this.xrLabel4.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_JieHeXian); this.xrLabel6.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_HuiWen); this.xrLabel8.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_QiPao); this.xrLabel10.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_LengLiao); this.xrLabel12.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_GuaiShouZhuangShang); this.xrLabel14.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_ChaMoCiShu); this.xrLabel16.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsDetail.PRO_LiaoDian); }
public override void Refresh() { if (this._pcdic == null) { this.AddNew(); this.action = "insert"; } else { if (this.action == "view") { this._pcdic = this._pcdicManage.GetDetail(this._pcdic); } } //初始化控件 this.txtPCDoubleImpactCheckID.Text = this._pcdic.PCDoubleImpactCheckID; //this.txtInvoiceCusXOId.Text = this._pcdic.InvoiceCusXOId; if (!string.IsNullOrEmpty(this._pcdic.PronoteHeaderId)) { Model.PronoteHeader ph = new BL.PronoteHeaderManager().Get(this._pcdic.PronoteHeaderId); if (ph != null) { this.txtInvoiceCusXOId.Text = (ph.InvoiceXO == null ? null : ph.InvoiceXO.CustomerInvoiceXOId); } } else { this.txtInvoiceCusXOId.Text = null; } this.txtPronoteHeaderId.Text = this._pcdic.PronoteHeaderId; this.txtPCDoubleImpactCheckDesc.Text = this._pcdic.PCDoubleImpactCheckDesc; this.DE_PCDoubleImpactCheckDate.EditValue = this._pcdic.PCDoubleImpactCheckDate.Value; this.BEProduct.EditValue = this._pcdic.Product; this.nccEmployee0.EditValue = this._pcdic.Employee; this.txtCheckedStandard.Text = this._pcdic.CheckStandard; this.calcPCDoubleImpactCheckCount.EditValue = this._pcdic.PCDoubleImpactCheckCount.HasValue ? this._pcdic.PCDoubleImpactCheckCount.Value : 0; this.ceInvoiceXOCount.EditValue = this._pcdic.InvoiceXOQuantity.HasValue ? this._pcdic.InvoiceXOQuantity.Value : 0; this.newChooseContorlAuditEmp.EditValue = this._pcdic.AuditEmp; this.txt_AuditState.EditValue = this.GetAuditName(this._pcdic.AuditState); this.coBoxCJLD.Text = string.IsNullOrEmpty(this._pcdic.PowerImpact) ? this.coBoxCJLD.Text : this._pcdic.PowerImpact; this.comBox_ChongJICeShiJiaRe.Text = string.IsNullOrEmpty(this._pcdic.JiaReWenDu) ? this.comBox_ChongJICeShiJiaRe.Text : this._pcdic.JiaReWenDu; this.comBox_ChongJICeShiLengDong.Text = string.IsNullOrEmpty(this._pcdic.LengDongWenDu) ? this.comBox_ChongJICeShiLengDong.Text : this._pcdic.LengDongWenDu; this.coBoxZQZL.Text = string.IsNullOrEmpty(this._pcdic.ZhuiQiuKG) ? this.coBoxZQZL.Text : this._pcdic.ZhuiQiuKG; this.coBoxLYBTXX.Text = string.IsNullOrEmpty(this._pcdic.PrintHeader) ? this.coBoxLYBTXX.Text : this._pcdic.PrintHeader; this.lookUpEditUnit.EditValue = this._pcdic.ProductUnitId; #region LookUpEditor DataTable dt = new DataTable(); DataColumn dc = new DataColumn("id", typeof(string)); DataColumn dc1 = new DataColumn("name", typeof(string)); dt.Columns.Add(dc); dt.Columns.Add(dc1); DataRow dr; dr = dt.NewRow(); dr[0] = "-1"; dr[1] = string.Empty; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = "0"; dr[1] = "√"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = "1"; dr[1] = "△"; dt.Rows.Add(dr); dr = dt.NewRow(); dr[0] = "2"; dr[1] = "X"; dt.Rows.Add(dr); for (int i = 0; i < this.gridView1.Columns.Count; i++) { if (this.gridView1.Columns[i].ColumnEdit is DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit && this.gridView1.Columns[i].Name != "Employee") { ((DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit) this.gridView1.Columns[i].ColumnEdit).DataSource = dt; ((DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit) this.gridView1.Columns[i].ColumnEdit).Columns.Clear(); ((DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit) this.gridView1.Columns[i].ColumnEdit).Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] { new DevExpress.XtraEditors.Controls.LookUpColumnInfo("name", 25, "标识"), }); ((DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit) this.gridView1.Columns[i].ColumnEdit).DisplayMember = "name"; ((DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit) this.gridView1.Columns[i].ColumnEdit).ValueMember = "id"; } } #endregion this.GirdViewLookUpEditEmployee.DataSource = this.bsLUEemployees; this.bindingSource1.DataSource = this._pcdic.Detail; base.Refresh(); switch (this.action) { case "insert": this.gridView1.OptionsBehavior.Editable = true; break; case "update": this.gridView1.OptionsBehavior.Editable = true; break; case "view": this.gridView1.OptionsBehavior.Editable = false; break; } //this.ceInvoiceXOCount.Enabled = false; this.txtPCDoubleImpactCheckID.Properties.ReadOnly = true; //this.nccEmployee0.Enabled = false; }
//导出Excel private void btn_ExportExcel_Click(object sender, EventArgs e) { SetValue(); IList <Book.Model.PronoteHeader> listPronoteHeader = new BL.PronoteHeaderManager().GetDataForExcel(condition.StartDate, condition.EndDate, condition.Customer, condition.CusXOId, condition.Product, condition.PronoteHeaderIdStart, condition.PronoteHeaderIdEnd, condition.SourceTpye, null, false, condition.ProNameKey, condition.ProCusNameKey, condition.PronoteHeaderIdKey, false, false, false, condition.HandbookId); if (listPronoteHeader == null || listPronoteHeader.Count == 0) { MessageBox.Show("无数据", "提示", MessageBoxButtons.OK); return; } //转换RTF的商品描述到普通String System.Windows.Forms.RichTextBox rtBox = new System.Windows.Forms.RichTextBox(); foreach (var item in listPronoteHeader) { rtBox.Rtf = item.ProductDesc; item.ProductDesc = rtBox.Text.Trim(); //放在这里太耗性能,筛选完“保税”后,在查询 商品型号 //if (string.IsNullOrEmpty(item.CustomerProductName)) //{ // item.CustomerProductName = new produceManager.Help().GetCustomerProductNameByPronoteHeaderId(item, item.ProductId, item.HandbookProductId); //} } var listPronoteHeaderFilter = this.chk_Baoshui.Checked ? listPronoteHeader.Where(l => l.ProductDesc == "保税") : listPronoteHeader; foreach (var item in listPronoteHeaderFilter) { if (string.IsNullOrEmpty(item.CustomerProductName)) { item.CustomerProductName = CommonHelp.GetCustomerProductNameByPronoteHeaderId(item, item.ProductId, item.HandbookProductId); } } if (listPronoteHeaderFilter == null || listPronoteHeaderFilter.Count() == 0) { MessageBox.Show("无数据", "提示", MessageBoxButtons.OK); return; } //根据加工单号查询对应的领料单 //var listPronoteHeaderIds = listPronoteHeaderFilter.GroupBy(l => l.PronoteHeaderID).Select(g => g.Key); //string pronoteHeaderIds = string.Empty; //foreach (var item in listPronoteHeaderIds) //{ // pronoteHeaderIds += "'" + item + "',"; //} //pronoteHeaderIds = pronoteHeaderIds.TrimEnd(','); //IList<Model.ProduceMaterialdetails> listProduceMaterialdetails = new BL.ProduceMaterialdetailsManager().GetDataByPronoteHeaders(pronoteHeaderIds); try { Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application(); excel.Application.Workbooks.Add(true); #region 生产加工单 Microsoft.Office.Interop.Excel.Worksheet sheet = (Microsoft.Office.Interop.Excel.Worksheet)excel.Worksheets[1]; sheet.Name = "生产加工单"; Microsoft.Office.Interop.Excel.Range r = sheet.get_Range(sheet.Cells[1, 1], sheet.Cells[1, 16]); r.MergeCells = true; sheet.Rows.AutoFit(); sheet.Rows.WrapText = true; sheet.Rows.RowHeight = 15; sheet.Rows.Font.Size = 9; sheet.Columns.ColumnWidth = 13; sheet.get_Range(sheet.Cells[2, 1], sheet.Cells[2, 16]).Interior.ColorIndex = 15; //浅灰色 sheet.get_Range(sheet.Cells[1, 1], sheet.Cells[2, 16]).HorizontalAlignment = -4108; //居中对齐 sheet.get_Range(sheet.Cells[1, 1], sheet.Cells[listPronoteHeaderFilter.Count() + 2, 16]).Borders.Value = 1; sheet.get_Range(sheet.Cells[3, 4], sheet.Cells[listPronoteHeaderFilter.Count() + 2, 4]).NumberFormat = "yyyy/MM/dd"; sheet.get_Range(sheet.Cells[3, 2], sheet.Cells[listPronoteHeaderFilter.Count() + 2, 2]).NumberFormat = "@"; sheet.get_Range(sheet.Cells[2, 6], sheet.Cells[2, 6]).ColumnWidth = 30; sheet.get_Range(sheet.Cells[2, 10], sheet.Cells[2, 10]).ColumnWidth = 30; sheet.Cells[1, 1] = "生产加工单明细表"; sheet.Cells[2, 1] = "客户订单编号"; sheet.Cells[2, 2] = "客户型号"; sheet.Cells[2, 3] = "加工单编号"; sheet.Cells[2, 4] = "通知日期"; sheet.Cells[2, 5] = "商品编号"; sheet.Cells[2, 6] = "商品名称"; sheet.Cells[2, 7] = "订单数量"; sheet.Cells[2, 8] = "生产数量"; sheet.Cells[2, 9] = "原料编号"; sheet.Cells[2, 10] = "原料名称"; sheet.Cells[2, 11] = "领料数量"; sheet.Cells[2, 12] = "生产站"; sheet.Cells[2, 13] = "手册号"; sheet.Cells[2, 14] = "手册项号"; sheet.Cells[2, 15] = "来源单据"; sheet.Cells[2, 16] = "描述"; int row = 3; foreach (var item in listPronoteHeaderFilter) { sheet.Cells[row, 1] = item.CustomerInvoiceXOId; sheet.Cells[row, 2] = item.CustomerProductName; sheet.Cells[row, 3] = item.PronoteHeaderID; sheet.Cells[row, 4] = item.PronoteDate; sheet.Cells[row, 5] = item.Id; sheet.Cells[row, 6] = item.ProductName; sheet.Cells[row, 7] = item.InvoiceXODetailQuantity; sheet.Cells[row, 8] = item.DetailsSum; sheet.Cells[row, 9] = item.MaterialId; sheet.Cells[row, 10] = item.MaterialName; sheet.Cells[row, 11] = item.MaterialQty; sheet.Cells[row, 12] = item.Workhousename; sheet.Cells[row, 13] = item.HandbookId; sheet.Cells[row, 14] = item.HandbookProductId; sheet.Cells[row, 15] = item.MRSHeaderId; sheet.Cells[row, 16] = item.ProductDesc; row++; } #endregion #region 生产领料 //if (listProduceMaterialdetails != null && listProduceMaterialdetails.Count > 0) //{ // excel.Worksheets.Add(Missing.Value, sheet, Missing.Value, Missing.Value); // Microsoft.Office.Interop.Excel.Worksheet sheet2 = (Microsoft.Office.Interop.Excel.Worksheet)excel.Worksheets[2]; // sheet2.Name = "生产领料"; // sheet2.Rows.AutoFit(); // sheet2.Rows.WrapText = true; // sheet2.Rows.RowHeight = 15; // sheet2.Rows.Font.Size = 9; // sheet2.Columns.ColumnWidth = 13; // sheet2.get_Range(sheet2.Cells[1, 1], sheet2.Cells[1, 14]).Interior.ColorIndex = 15; //浅灰色 // sheet2.get_Range(sheet2.Cells[1, 1], sheet2.Cells[1, 14]).HorizontalAlignment = -4108; // sheet2.get_Range(sheet2.Cells[1, 1], sheet2.Cells[listProduceMaterialdetails.Count + 1, 14]).Borders.Value = 1; // sheet2.get_Range(sheet2.Cells[2, 2], sheet2.Cells[listProduceMaterialdetails.Count + 1, 2]).NumberFormat = "yyyy/MM/dd"; // sheet2.get_Range(sheet2.Cells[1, 4], sheet2.Cells[1, 4]).ColumnWidth = 30; // sheet2.Cells[1, 1] = "编号"; // sheet2.Cells[1, 2] = "领料日期"; // sheet2.Cells[1, 3] = "商品编号"; // sheet2.Cells[1, 4] = "商品名称"; // sheet2.Cells[1, 5] = "客户型号"; // sheet2.Cells[1, 6] = "手册号"; // sheet2.Cells[1, 7] = "手册项号"; // sheet2.Cells[1, 8] = "数量"; // sheet2.Cells[1, 9] = "生产站"; // sheet2.Cells[1, 10] = "已分配量"; // sheet2.Cells[1, 11] = "客户订单编号"; // sheet2.Cells[1, 12] = "库存"; // sheet2.Cells[1, 13] = "描述"; // sheet2.Cells[1, 14] = "来源单据"; // int row2 = 2; // foreach (var item in listProduceMaterialdetails) // { // sheet2.Cells[row2, 1] = item.ProduceMaterialID; // sheet2.Cells[row2, 2] = item.ProduceMaterialDate; // sheet2.Cells[row2, 3] = item.PID; // sheet2.Cells[row2, 4] = item.ProductName; // sheet2.Cells[row2, 5] = item.CustomerProductName; // sheet2.Cells[row2, 6] = item.HandbookId; // sheet2.Cells[row2, 7] = item.HandbookProductId; // sheet2.Cells[row2, 8] = item.Materialprocessum; // sheet2.Cells[row2, 9] = item.WorkhouseName; // sheet2.Cells[row2, 10] = item.Distributioned; // sheet2.Cells[row2, 11] = item.CusXOId; // sheet2.Cells[row2, 12] = item.ProductStock; // sheet2.Cells[row2, 13] = item.ProduceMaterialdesc; // sheet2.Cells[row2, 14] = item.PronoteHeaderID; // row2++; // } //} #endregion excel.Visible = true;//是否打开该Excel文件 excel.WindowState = XlWindowState.xlMaximized; } catch (Exception ex) { MessageBox.Show("Excel未生成完畢,請勿操作,并重新點擊按鈕生成數據!", "提示!", MessageBoxButtons.OK); return; } }
public XR(string ProduceStatisticsCheckId) { InitializeComponent(); this._ProduceStatisticsCheck = this.ProduceStatisticsCheckManager.Get(ProduceStatisticsCheckId); if (this._ProduceStatisticsCheck == null) { return; } this._ProduceStatisticsCheck.Details = this.ProduceStatisticsCheckdetailsManager.Select(this._ProduceStatisticsCheck); this.DataSource = this._ProduceStatisticsCheck.Details; this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName; this.xrLabelDataName.Text = Properties.Resources.ProduceCheck; this.xrLabelPrintDate.Text += DateTime.Now.ToShortDateString(); this.xrLabelProduceStatisticsDate.Text = this._ProduceStatisticsCheck.ProduceStatisticsCheckDate.Value.ToString("yyyy-MM-dd"); this.xrLabelProduceStatisticsId.Text = this._ProduceStatisticsCheck.ProduceStatisticsCheckId; if (this._ProduceStatisticsCheck.Employee0 != null) { this.xrLabelEmployeeId.Text = this._ProduceStatisticsCheck.Employee0.EmployeeName; } if (this._ProduceStatisticsCheck.Employee1 != null) { this.xrLabel4.Text = this._ProduceStatisticsCheck.Employee1.EmployeeName; } this.xrLabelPronoteHeaderID.Text = this._ProduceStatisticsCheck.PronoteHeaderID; if (!string.IsNullOrEmpty(this._ProduceStatisticsCheck.PronoteHeaderID)) { Model.PronoteHeader pronoteHeader = new BL.PronoteHeaderManager().Get(this._ProduceStatisticsCheck.PronoteHeaderID); if (pronoteHeader != null) { Model.InvoiceXO invoiceXO = new BL.InvoiceXOManager().Get(pronoteHeader.InvoiceXOId); this.xrLabelCustomerXoId.Text = invoiceXO == null ? string.Empty : invoiceXO.CustomerInvoiceXOId; if (pronoteHeader.Product != null) { this.xrLabelProductId.Text = pronoteHeader.Product.Id; this.xrLabelProductName.Text = pronoteHeader.Product.ProductName; this.xrRichText3.Rtf = pronoteHeader.Product.ProductDescription; } } } else { this.xrLabelCustomerXoId.Text = string.Empty; } this.xrLabelDescription.Text = this._ProduceStatisticsCheck.Description; //Ã÷ϸ this.xrTableCellDetailDate.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsCheckDetail.PRO_DetailDate, "{0:yyyy-MM-dd}"); this.xrTableCellBusinessHoursType.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsCheckDetail.PRO_BusinessHoursType); this.xrTableCellEmployee0Id.DataBindings.Add("Text", this.DataSource, "Employee0." + Model.Employee.PROPERTY_EMPLOYEENAME); this.xrTableCellEmployee1Id.DataBindings.Add("Text", this.DataSource, "Employee1." + Model.Employee.PROPERTY_EMPLOYEENAME); this.xrTableCellProduceQuantity.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsCheckDetail.PRO_ProduceQuantity); this.xrTableCellAPian.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsCheckDetail.PRO_APian); this.xrTableCellBPian.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsCheckDetail.PRO_BPian); this.xrTableCellCPian.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsCheckDetail.PRO_CPian); this.xrTableCellFractionDefective.DataBindings.Add("Text", this.DataSource, Model.ProduceStatisticsCheckDetail.PRO_FractionDefective); }
public RO1(Model.PCDoubleImpactCheck _pcdic) { InitializeComponent(); if (_pcdic == null) { return; } details = pcdicdManager.SelectByPCDoubleICId(_pcdic.PCDoubleImpactCheckID); this.DataSource = details; //this.DataSource = _pcdic.Detail; //CompanyInfo this.lblCompanyName.Text = BL.Settings.CompanyChineseName; switch (_pcdic.PCDoubleImpactCheckType) { case 0: this.lblDataName.Text = Properties.Resources.CSAcjcsd; //this.xtcHengWen.Visible = false; //this.xtcJiaRe.Visible = false; //this.TCattrHotL.Visible = false; //this.TCattrHotR.Visible = false; //this.TCattrCoolL.Visible = false; //this.TCattrCoolR.Visible = false; break; case 1: this.lblDataName.Text = Properties.Resources.BSENcjcsd; //this.xtcJIaoLian.Visible = false; //this.TCattrJiaoLianL.Visible = false; //this.TCattrJiaoLianR.Visible = false; break; case 2: this.lblDataName.Text = Properties.Resources.ASNZScjcsd; //this.xtcJIaoLian.Visible = false; //this.TCattrJiaoLianL.Visible = false; //this.TCattrJiaoLianR.Visible = false; //this.xtcHengWen.Visible = false; //this.xtcJiaRe.Visible = false; //this.TCattrHotL.Visible = false; //this.TCattrHotR.Visible = false; //this.TCattrCoolL.Visible = false; //this.TCattrCoolR.Visible = false; break; default: break; } this.lblPriteDate.Text += DateTime.Now.ToShortDateString(); //Control this.lblANSIPCImpactCheckID.Text = _pcdic.PCDoubleImpactCheckID; this.lblANSIPCImpactCheckDate.Text = _pcdic.PCDoubleImpactCheckDate.HasValue ? _pcdic.PCDoubleImpactCheckDate.Value.ToShortDateString() : ""; //this.lblInvoiceCusXOId.Text = _pcdic.InvoiceCusXOId; if (!string.IsNullOrEmpty(_pcdic.PronoteHeaderId)) { Model.PronoteHeader ph = new BL.PronoteHeaderManager().Get(_pcdic.PronoteHeaderId); if (ph != null) { this.lblInvoiceCusXOId.Text = (ph.InvoiceXO == null ? null : ph.InvoiceXO.CustomerInvoiceXOId); } } this.lblPronoteHeaderId.Text = _pcdic.PronoteHeaderId; this.lblProduct.Text = _pcdic.Product == null ? "" : _pcdic.Product.ToString(); this.lblEmployee0.Text = _pcdic.Employee == null ? "" : _pcdic.Employee.ToString(); this.RTDescript.Text = _pcdic.PCDoubleImpactCheckDesc; this.lblCheckStandard.Text = _pcdic.CheckStandard; this.lblChongJiLiDu.Text = _pcdic.PowerImpact; this.lblInvoiceXOQuantity.Text = _pcdic.InvoiceXOQuantity.HasValue ? _pcdic.InvoiceXOQuantity.ToString() : ""; this.lblPCDoubleImpactCheckCount.Text = _pcdic.PCDoubleImpactCheckCount.HasValue ? _pcdic.PCDoubleImpactCheckCount.ToString() : ""; this.lbl_ProductUnit.Text = _pcdic.ProductUnit == null ? "" : _pcdic.ProductUnit.ToString(); //Details #region 更改详细显示 foreach (Model.PCDoubleImpactCheckDetail detail in details) { foreach (var a in detail.GetType().GetProperties()) { if (a.Name.IndexOf("attr") > -1) { if (a.GetValue(detail, null) != null) { switch (a.GetValue(detail, null).ToString()) { case "0": a.SetValue(detail, "√", null); break; case "1": a.SetValue(detail, "△", null); break; case "2": a.SetValue(detail, "X", null); break; case "-1": a.SetValue(detail, " ", null); break; default: break; } } } } } #endregion this.TCPCDoubleImpactCheckDetailDate.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_PCDoubleImpactCheckDetailDate, "{0:yyyy-MM-dd}"); this.TCattrJiaoLianL.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrJiaoLianL); this.TCattrJiaoLianR.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrJiaoLianR); //this.TCattrJPUpL.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrJPUpL); //this.TCattrJPUpR.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrJPUpR); //this.TCattrJPDownL.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrJPDownL); //this.TCattrJPDownR.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrJPDownR); //this.TCattrJPLeftL.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrJPLeftL); //this.TCattrJPLeftR.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrJPLeftR); //this.TCattrJPRightL.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrJPRightL); //this.TCattrJPRightR.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrJPRightR); this.TCattrBiZhong.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrBiZhong); this.TCattrShangLiangL.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrShangLiangL); this.TCattrShangLiangR.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrShangLiangR); this.TCattrJPZYL.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrJPZYL); this.TCattrJPZYR.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrJPZYR); this.TCattrS_SZhongL.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrS_SZhongL); this.TCattrS_SZhongR.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrS_SZhongR); this.TCattrS_SShangL.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrS_SShangL); this.TCattrS_SShangR.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrS_SShangR); this.TCattrS_SXiaL.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrS_SXiaL); this.TCattrS_SXiaR.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrS_SXiaR); //this.TCattrHotL.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrHotL); //this.TCattrHotR.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrHotR); //this.TCattrCoolL.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrCoolL); //this.TCattrCoolR.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.PRO_attrCoolR); //this.TCEmployee.DataBindings.Add("Text", this.DataSource, "Employee." + Model.Employee.PROPERTY_EMPLOYEENAME); this.TCNote.DataBindings.Add("Text", this.DataSource, Model.PCDoubleImpactCheckDetail.Pro_Note); }
public RO(string produceMaterialID) { InitializeComponent(); this.produceMaterial = this.produceMaterialManager.Get(produceMaterialID); if (this.produceMaterial == null) { return; } if (this.produceMaterial.SourceType != 1) { Model.PronoteHeader pheader = ph.Get(produceMaterial.InvoiceId); if (pheader != null) { this.xrLabelProduct.Text = string.IsNullOrEmpty(pheader.Product.CustomerProductName) ? pheader.Product.ProductName : pheader.Product.ProductName + "{" + pheader.Product.CustomerProductName + "}"; } } this.produceMaterial.Details = this.produceMaterialdetailsManager.Select(this.produceMaterial); this.DataSource = this.produceMaterial.Details; //CompanyInfo this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName; this.xrLabelDataName.Text = Properties.Resources.ProduceMaterialdetails; //加工领料 this.xrLabelProduceMaterialDate.Text = this.produceMaterial.ProduceMaterialDate.Value.ToString("yyyy-MM-dd"); this.xrBarCodeProduceMaterialID.Text = this.produceMaterial.ProduceMaterialID; this.xrLabelInsertTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); //if (this.produceMaterial.SourceType == 1) //{ // this.xrLabelSourceType.Text = "需求計劃"; //} //else { this.xrLabelSourceType.Text = "生產加工"; } //this.xrLabelPronoteHeaderID.Text = this.produceMaterial.InvoiceId; // this.xrLabelMRP.Text=this.produceMaterial. //if (this.produceMaterial.Employee1 != null) //{ // this.xrLabelEmployee1.Text = this.produceMaterial.Employee1.EmployeeName; //} if (this.produceMaterial.Employee0 != null) { this.xrLabelEmployee0.Text = this.produceMaterial.Employee0.EmployeeName; } if (this.produceMaterial.Employee2 != null) { this.xrLabelEmployee2.Text = this.produceMaterial.Employee2.EmployeeName; } if (this.produceMaterial.WorkHouse != null) { this.xrLabelDepartment.Text = this.produceMaterial.WorkHouse.Workhousename; } this.xrLabel1ProduceMaterialdesc.Text = this.produceMaterial.ProduceMaterialdesc; this.xrLabelProduceMaterialId.Text = this.produceMaterial.ProduceMaterialID; //if (this.produceMaterial.InvoiceXO != null) //{ // this.xrLabelXOId.Text = invoiceXoManager.Get(this.produceMaterial.InvoiceXO)==null?"":invoiceXoManager.Get(this.produceMaterial.InvoiceXO).CustomerInvoiceXOId; //} if (this.produceMaterial.SourceType != 1 && !string.IsNullOrEmpty(this.produceMaterial.InvoiceId)) { Model.MRSdetails mrsdetail = new Book.Model.MRSdetails(); Model.PronoteHeader pronoteHeader = new BL.PronoteHeaderManager().Get(this.produceMaterial.InvoiceId); if (pronoteHeader != null) { mrsdetail = new BL.MRSdetailsManager().Get(pronoteHeader.MRSdetailsId); } Model.InvoiceXO invoiceXO = new BL.InvoiceXOManager().Get(produceMaterial.InvoiceXOId); if (invoiceXO != null) { this.xrLabelPiHao.Text = invoiceXO.CustomerLotNumber; foreach (Model.InvoiceXODetail detail in invoiceXO.Details) { if (mrsdetail != null && detail.ProductId == mrsdetail.MadeProductId) { this.xrLabelInvoiceSum.Text = detail.InvoiceXODetailQuantity.Value.ToString("F0"); } } } } if (!string.IsNullOrEmpty(this.produceMaterial.InvoiceXOId)) { Model.InvoiceXO invoiceXO = new BL.InvoiceXOManager().Get(produceMaterial.InvoiceXOId); if (invoiceXO != null) { this.xrLabelXOId.Text = invoiceXO == null ? string.Empty : invoiceXO.CustomerInvoiceXOId; } } //明细 this.xrTableCell5.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_Inumber); //this.xrTableCell1ProductId.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_Id); this.xrTableCellProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); this.xrTableCusProName.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_Pihao);//后来改批号 this.xrTableCellQuantity.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_Materialprocessum); //this.xrTableHasOutDepot.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_Distributioned, "{0:0.####}"); // this.xrTableMPSSum.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_MPSDetailsSum, "{0:0.####}"); this.xrTableCellUnit.DataBindings.Add("Text", this.DataSource, "ProductUnit"); //this.xrTableCellProductSpecification.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_StocksQuantity, "{0:0.####}"); this.TCDepotStock.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_Pihao); // this.xrTableMRP.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_MRSHeaderId); // this.xrTableCusXOID.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_CustomerInvoiceXOId); this.TCCustomerProduct.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_CustomerProductName); this.xrRichText1.DataBindings.Add("Rtf", this.DataSource, "ProductDescription"); this.TCInvoiceId.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_InvoiceFrom); this.TCHandbookId.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_HandbookId); this.TCDepotStock.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_DepotStock); this.lblStockInvoiceId.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_StockInvoiceId); }