private void LoadItem(string poNo) { //var farmCtrl = new FarmController(); //var items = ProductionOrderItemController.GetProductionOrderItems(poNo); DataTable dtPoItem = new DataTable("PO_ITEM"); dtPoItem = ProductionOrderItemController.GetProductionOrderItems(poNo); gvDt.DataSource = dtPoItem; gvDt.Columns[0].HeaderText = "ลำดับ"; gvDt.Columns[1].HeaderText = "รหัสสินค้า"; gvDt.Columns[2].HeaderText = "สินค้า"; gvDt.Columns[3].HeaderText = "จำนวน"; gvDt.Columns[4].HeaderText = "หน่วยคำนวณ"; gvDt.Columns[5].HeaderText = "รหัสหน่วยสินค้า"; gvDt.Columns[6].HeaderText = "หน่วยสินค้า"; gvDt.Columns[7].HeaderText = "ปริมาณจ่าย"; gvDt.Columns[8].HeaderText = "น้ำหนักจ่าย"; gvDt.Columns[1].Visible = false; gvDt.Columns[4].Visible = false; gvDt.Columns[5].Visible = false; gvDt.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; gvDt.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; gvDt.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; gvDt.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; gvDt.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; //################################################### //var coll = items.AsEnumerable().Select(p => new //{ // seq = p.Field<int>("seq"), // product_name = p.Field<string>("product_name"), // po_qty = p.Field<int>("po_qty").ToComma(), // po_wgh = p.Field<decimal>("po_wgh").ToFormat2Decimal(), // unload_qty = p.Field<int>("unload_qty").ToComma(), // unload_wgh = p.Field<decimal>("unload_wgh").ToFormat2Decimal(), //}).ToList(); //gv2.DataSource = coll; //gv2.Columns[0].HeaderText = "ลำดับ"; //gv2.Columns[1].HeaderText = "สินค้า"; //gv2.Columns[2].HeaderText = "จำนวนเบิก"; //gv2.Columns[3].HeaderText = "น้ำหนักเบิก"; //gv2.Columns[4].HeaderText = "จำนวนจ่าย"; //gv2.Columns[5].HeaderText = "น้ำหนักจ่าย"; }
private void LoadDetail() { //var orderItem = PoItemController.GetPoItems(orderNo); dtPoItem = new DataTable("PO_ITEM"); dtPoItem = ProductionOrderItemController.GetProductionOrderItems(this.poNo); gv.DataSource = dtPoItem; gv.Columns["seq"].HeaderText = "ลำดับ"; gv.Columns["product_code"].HeaderText = "รหัสสินค้า"; gv.Columns["product_name"].HeaderText = "ชื่อสินค้า"; gv.Columns["qty_wgh"].HeaderText = "จำนวน"; gv.Columns["issue_unit_method"].HeaderText = "หน่วยคำนวณ"; gv.Columns["unit_code"].HeaderText = "รหัสหน่วยสินค้า"; gv.Columns["unit_name"].HeaderText = "หน่วยสินค้า"; gv.Columns["seq"].Visible = false; gv.Columns["issue_unit_method"].Visible = false; gv.Columns["unit_code"].Visible = false; gv.Columns["unload_qty"].Visible = false; gv.Columns["unload_wgh"].Visible = false; }