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;
        }