private void SetDGV(List <FactoryDB_VO> _cboToFac)
{
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "선택";
chk.Name = "chk";
chk.Width = 40;
dgvStockStatus.Columns.Add(chk);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "고객주문번호", "so_wo_id", true, 208, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "품목", "product_codename", true, 190, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "품명", "product_name", true, 260, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "납기일", "so_edate", true, 170, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "잔여수량", "so_pcount", true, 170, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "From창고", "from_wh", true, 170, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "From창고재고", "w_count_present", true, 170, DataGridViewContentAlignment.MiddleRight);
#region DGV콤보박스
comboBoxColumn.HeaderText = "TO창고";
comboBoxColumn.Name = "combo";
for (int i = 0; i < _cboToFac.Count; i++)
{
comboBoxColumn.DisplayMember = _cboToFac[i].factory_name;
comboBoxColumn.ValueMember = _cboToFac[i].factory_id.ToString();
comboBoxColumn.Items.Add(_cboToFac[i].factory_name);
}
comboBoxColumn.Items.RemoveAt(0);
dgvStockStatus.Columns.Add(comboBoxColumn);
dgvStockStatus.Rows.Add();
dgvStockStatus.AllowUserToAddRows = false;
#endregion
GridViewUtil.AddNewColumnToTextBoxGridView(dgvStockStatus, "비고", "wh_comment", false, 200);
GridViewUtil.AddNewColumnToTextBoxGridView(dgvStockStatus, "이동수량", "transfer_count", true, 150, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "so_id", "so_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "업로드날짜", "so_sdate", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "PlanID", "plan_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "고객사코드", "company_code", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "업체유형", "company_type", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "From창고코드", "from_wh_value", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "품번", "product_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "출고수량", "so_ocount", false, 100, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "취소수량", "so_ccount", false, 100, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "To창고", "to_wh", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "To창고코드", "to_wh_value", false, 100, DataGridViewContentAlignment.MiddleCenter);
//GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "수정자", "uadmin", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvStockStatus, "To창고이름", "factory_name", false, 100, DataGridViewContentAlignment.MiddleCenter);
dgvStockStatus.AutoGenerateColumns = false;
dgvStockStatus.DataSource = shipment_list;
GridViewUtil.SetDataGridView(dgvStockStatus);
}
private void SetDGV()
{
shipment_service = new ShipmentService();
List <ShipmentOutVO> shipmentlist = shipment_service.GetClientOrder();
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "선택";
chk.Name = "chk";
chk.Width = 40;
dgvClientOrder.Columns.Add(chk);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "고객주문번호", "so_wo_id", true, 180, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "고객사코드", "company_code", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "고객사", "company_name", true, 160, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "품목", "product_codename", true, 150, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "품명", "product_name", true, 190, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "주문수량", "so_pcount", true, 100, DataGridViewContentAlignment.MiddleRight);
//TODO 쿼리수정
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "주문가능수량", "orderable_count", true, 150, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "마감수량", "so_ocount", true, 100, DataGridViewContentAlignment.MiddleRight, true);
GridViewUtil.AddNewColumnToTextBoxGridView(dgvClientOrder, "매출확정수량", "s_count", true, 150, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "매출확정금액", "s_TotalPrice", true, 150, DataGridViewContentAlignment.MiddleRight, true);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "마감일자", "s_date", true, 128, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "품번", "product_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "so_id", "so_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "취소수량", "so_ccount", false, 100, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "To창고이름", "w_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "납기일", "so_edate", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "From창고", "from_wh", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "From창고재고", "w_count_present", false, 100, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToTextBoxGridView(dgvClientOrder, "비고", "wh_comment", false, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "업로드날짜", "so_sdate", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "업체유형", "company_type", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "From창고코드", "from_wh_value", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "To창고", "to_wh", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "To창고코드", "to_wh_value", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "수정자", "uadmin", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "To창고이름", "factory_name", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "고객주문번호", "plan_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
dgvClientOrder.AutoGenerateColumns = false;
dgvClientOrder.DataSource = shipmentlist;
GridViewUtil.SetDataGridView(dgvClientOrder);
}
private void SetDGV()
{
dgvClientOrder.Columns.Clear();
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "고객주문번호", "so_wo_id", true, 200, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "고객주문번호", "so_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "고객주문번호", "plan_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "고객사코드", "s_company", true, 170, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "고객사", "company_name", true, 210, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "품목", "product_codename", true, 190, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "품명", "product_name", true, 268, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "주문수량", "so_pcount", true, 125, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "마감수량", "s_count", true, 125, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "매출액", "s_TotalPrice", true, 170, DataGridViewContentAlignment.MiddleRight, true);
GridViewUtil.AddNewColumnToDataGridView(dgvClientOrder, "마감일", "s_date", true, 170, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.SetDataGridView(dgvClientOrder);
dgvClientOrder.AutoGenerateColumns = false;
}