private void SetDataGridOrdering()
{
dgvOrdering.Columns.Clear();
GridViewUtil.SetDataGridView(dgvOrdering);
dgvOrdering.AutoGenerateColumns = false;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "선택";
chk.Name = "chk";
chk.Width = 40;
dgvOrdering.Columns.Add(chk);
//Point headerLocation = dgvOrdering.GetCellDisplayRectangle(0, -1, true).Location;
//headerCheckBox1.Location = new Point(headerLocation.X + 8, headerLocation.Y + 2); //그냥 이렇게 주면 위치가 썩 이쁘지않아서 숫자 좀 더 플러스함
//headerCheckBox1.BackColor = Color.White;
//headerCheckBox1.Size = new Size(18, 18);
//headerCheckBox1.Click += new EventHandler(HeaderCheckbox_Click);
//dgvOrdering.Controls.Add(headerCheckBox1);
GridViewUtil.AddNewColumnToDataGridView(dgvOrdering, "Plan ID", "plan_id", true, 110);
GridViewUtil.AddNewColumnToDataGridView(dgvOrdering, "발주업체", "company_name", true);
GridViewUtil.AddNewColumnToDataGridView(dgvOrdering, "품목", "product_codename", true);
//GridViewUtil.AddNewColumnToDataGridView(dgvOrdering, "창고", "factory_name", true);
GridViewUtil.AddNewColumnToDataGridView(dgvOrdering, "품명", "producct_name", true);
GridViewUtil.AddNewColumnToTextBoxGridView(dgvOrdering, "납기일", "pro_date", true);
GridViewUtil.AddNewColumnToDataGridView(dgvOrdering, "현재고", "present_count", true, 70, DataGridViewContentAlignment.MiddleRight, true);
GridViewUtil.AddNewColumnToDataGridView(dgvOrdering, "발주제안수량", "pro_count", true, 110, DataGridViewContentAlignment.MiddleRight, true);
GridViewUtil.AddNewColumnToTextBoxGridView(dgvOrdering, "발주수량", "", true, 80, DataGridViewContentAlignment.MiddleRight);
}
private void SetDataGridResult()
{
dgvResult.Columns.Clear();
GridViewUtil.SetDataGridView(dgvResult);
dgvResult.AutoGenerateColumns = false;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "";
chk.Name = "chk";
chk.Width = 30;
dgvResult.Columns.Add(chk);
Point headerLocation = dgvResult.GetCellDisplayRectangle(0, -1, true).Location;
headerCheckBox2.Location = new Point(headerLocation.X + 8, headerLocation.Y + 2); //그냥 이렇게 주면 위치가 썩 이쁘지않아서 숫자 좀 더 플러스함
headerCheckBox2.BackColor = Color.White;
headerCheckBox2.Size = new Size(18, 18);
headerCheckBox2.Click += new EventHandler(HeaderCheckbox_Click2);
dgvResult.Controls.Add(headerCheckBox2);
GridViewUtil.AddNewColumnToDataGridView(dgvResult, "발주시리얼", "order_serial", true, 110);
GridViewUtil.AddNewColumnToDataGridView(dgvResult, "발주일자", "order_ddate", true, 200);
GridViewUtil.AddNewColumnToDataGridView(dgvResult, "발주업체", "company_name", true, 200);
GridViewUtil.AddNewColumnToDataGridView(dgvResult, "품목", "product_codename", true, 200);
GridViewUtil.AddNewColumnToDataGridView(dgvResult, "품명", "product_name", true, 200);
GridViewUtil.AddNewColumnToDataGridView(dgvResult, "발주량", "order_count", true, 200);
GridViewUtil.AddNewColumnToTextBoxGridView(dgvResult, "입고일자", "order_pdate", true, 200);
GridViewUtil.AddNewColumnToTextBoxGridView(dgvResult, "출발일", "order_sdate", true, 200);
GridViewUtil.AddNewColumnToDataGridView(dgvResult, "주문상태", "common_name", true, 200);
}
private void SetDataGrid()
{
dataGridView1.Columns.Clear();
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "날짜", "date", true);
//GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "수량", "", true, 130);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "수량", "", true, 130);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "주중/주말", "plan_type", false, 130);
}
private void DMRMgt_Load(object sender, EventArgs e)
{
{
ResourceService R_survice = new ResourceService();
List <MachineVO> lst = R_survice.GetMachineAll();
ComboUtil.ComboBinding <MachineVO>(comboBox1, lst, "m_id", "m_name", "미선택");
}
dataGridView1.RowHeadersVisible = false;
dataGridView1.ReadOnly = true;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
DataGridViewCheckBoxColumn checkBoxColumn = new DataGridViewCheckBoxColumn();
checkBoxColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
checkBoxColumn.Name = "ck";
checkBoxColumn.HeaderText = "선택";
checkBoxColumn.MinimumWidth = 50;
dataGridView1.Columns.Add(checkBoxColumn);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "pro_id", "pro_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "플랜id", "plan_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "계획시작일자", "pro_date", true, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, " ", "so_sdate", false, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "설비코드", "m_code", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "설비명", "m_name", true, 100, DataGridViewContentAlignment.MiddleLeft); //
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "상태", "pro_state", false, 100, DataGridViewContentAlignment.MiddleLeft); //ff
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "상태", "common_name", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "상품코드", "product_codename", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "상품명", "producct_name", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "소요창고", "m_use_sector", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "양품창고", "m_ok_sector", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "불량창고", "m_ng_sector", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "계획수량", "pro_count", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "", "pro_pcount", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "", "pro_mcount", false, 100, DataGridViewContentAlignment.MiddleLeft);
DateTime today = DateTime.Now;
dateTimePicker1.Value = today.AddDays(-10);
dateTimePicker2.Value = today.AddDays(20);
ProcessService P_service = new ProcessService();
dt = P_service.GetProductionPlanCheckHis(dateTimePicker1.Value.ToShortDateString(), dateTimePicker2.Value.ToShortDateString());
// dataGridView1.DataSource =
DataView dv = dt.DefaultView;
DataTable table = new DataTable();
dv.RowFilter = "pro_state = 'COMMAND' ";
if (dv.Count > 0)
{
table = dv.ToTable();
dataGridView1.DataSource = table;
}
GridViewUtil.SetDataGridView(dataGridView1);
}
private void SetDataGrid()
{
dataGridView1.Columns.Clear();
GridViewUtil.SetDataGridView(dataGridView1);
dataGridView1.AutoGenerateColumns = false;
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "HISTORY 번호", "wh_id", false, 110);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "창고번호", "w_id", false, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "제품번호", "product_id", false, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "Plan ID", "plan_id", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "product_name", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목", "product_codename", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "수량", "wh_product_count", true, 150);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "수정일", "wh_udate", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "잔량", "wh_comment", false, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "카테고리", "common_name", true, 150);
}
private void SetDataGrid()
{
dataGridView1.Columns.Clear();
GridViewUtil.SetDataGridView(dataGridView1);
dataGridView1.AutoGenerateColumns = false;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "선택";
chk.Name = "chk";
chk.Width = 45;
dataGridView1.Columns.Add(chk);
//Point headerLocation = dataGridView1.GetCellDisplayRectangle(0, -1, true).Location;
//headerCheckBox.Location = new Point(headerLocation.X + 8, headerLocation.Y + 2); //그냥 이렇게 주면 위치가 썩 이쁘지않아서 숫자 좀 더 플러스함
//headerCheckBox.BackColor = Color.White;
//headerCheckBox.Size = new Size(18, 18);
//headerCheckBox.Click += new EventHandler(HeaderCheckbox_Click);
//dataGridView1.Controls.Add(headerCheckBox);
//GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "No.", "count", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "발주시리얼", "order_serial", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "PlanID", "plan_id", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "납품업체", "company_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "주문상태", "common_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목", "product_codename", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "product_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "납기일", "order_pdate", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "발주량", "order_count", true);
//GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "입고량", "", true);
//GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "출발량", "company_order_code", true);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "취소량", "", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "취소가능량", "order_count", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "발주일", "order_ddate", true);
}
private void SetDataGrid()
{
dataGridView1.Columns.Clear();
GridViewUtil.SetDataGridView(dataGridView1);
dataGridView1.AutoGenerateColumns = false;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "선택";
chk.Name = "chk";
chk.Width = 40;
dataGridView1.Columns.Add(chk);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "발주시리얼", "order_serial", true, 110);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "입고일", "order_pdate", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "입고창고", "factory_name", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목", "product_codename", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "product_name", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "입고량", "order_qcount", true, 150);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "취소량", "", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "잔량", "order_qcount", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "업체", "company_name", true, 150);
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
dataGridView2.DataSource = null;
dataGridView2.Columns.Clear();
dataGridView2.DataSource = null;
ndt = null;
List <DMRVO> lst = new List <DMRVO>();
ProcessService P_service = new ProcessService();
DMRVO vo = new DMRVO();
try
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (Convert.ToBoolean(dataGridView1.Rows[i].Cells[0].Value) == true) //체크박스가 true?
{
vo.product_codename = dataGridView1.Rows[i].Cells[9].Value.ToString(); //제품코드네임
vo.factory_name = dataGridView1.Rows[i].Cells[11].Value.ToString(); //창고명
vo.pro_id = Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value.ToString()); //pro_id
vo.plan_id = dataGridView1.Rows[i].Cells[2].Value.ToString(); //plan_id
if (P_service.GetDMRMgt(vo).Count >= 5)
{
lst = (P_service.GetDMRMgt(vo));
}
}
}
for (int i = 0; i < lst.Count; i++)
{
lst[i].req_date = DateTime.Now.ToShortDateString();
}
// lst = P_service.GetDMRMgt(vo);
//dt = P_service.GetProductionPlanCheckHis(dateTimePicker1.Value.ToShortDateString(), dateTimePicker2.Value.ToShortDateString());
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "pro_id", "pro_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "플랜id", "plan_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "product_id", "product_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "제품코드명", "product_codename", true, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "제품명", "product_name", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "", "factory_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "창고명", "factory_name", true, 100, DataGridViewContentAlignment.MiddleLeft); //ff
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "계획수량", "pro_count", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "소요량", "bom_use_count", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "소요수량", "plan_count", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "자재창고 재고", "w_count_present", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "이전재고", "w_count_past", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "요청창고id", "req_factory_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "요청창고", "req_factory", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "요청창고 재고", "nam", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "요청량", "req_count", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "사유", "reason", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "요청일", "req_date", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "w_id", "w_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "", "order_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
dataGridView2.RowsDefaultCellStyle.BackColor = Color.FromArgb(240, 240, 240);
dataGridView2.AlternatingRowsDefaultCellStyle.BackColor = Color.White;
dataGridView2.DefaultCellStyle.SelectionBackColor = Color.Gray; //Color.DimGray;
dataGridView2.DefaultCellStyle.SelectionForeColor = Color.White;
dataGridView2.DataSource = lst;
}
catch (Exception err)
{
string st = err.Message;
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void Business_showings_Load(object sender, EventArgs e)
{
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "작업지시번호", "worknum", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "", "pro_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "시작일", "pro_date", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "시작시간", "pd_stime", false, 100, DataGridViewContentAlignment.MiddleLeft); //수정
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "완료시간", "pd_etime", false, 100, DataGridViewContentAlignment.MiddleLeft); // 수정
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "product_id", "product_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "품목코드명", "product_codename", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "품목", "product_name", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "상태", "pro_state", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "상태", "common_name", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "작업시간", "worktime", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "작업수량", "pro_count", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "양품수량", "ok_cnt", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "불량수량", "ng_cnt", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "설비명", "m_name", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "소진창고", "m_use_sector", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "양품창고", "m_ok_sector", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "plan_id", "plan_id", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "요청일", "req_date", false, 100, DataGridViewContentAlignment.MiddleLeft); // 요청일
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "사유", "reason", false, 100, DataGridViewContentAlignment.MiddleLeft); //사유
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "w_id", "w_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "order_id", "order_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "m_id", "m_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "소진창고", "m_use_sector_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "양품창고", "m_ok_sector_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "작업지시번호", "worknum", true, 120, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "", "pro_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "시작일", "pro_date", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "시작시간", "pd_stime", false, 100, DataGridViewContentAlignment.MiddleLeft); // 수정
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "완료시간", "pd_etime", false, 100, DataGridViewContentAlignment.MiddleLeft); //수정
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "product_id", "product_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "품목코드명", "product_codename", true, 120, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "품목", "product_name", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "상태", "pro_state", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "상태", "common_name", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "작업시간", "worktime", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "작업수량", "pro_count", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "양품수량", "ok_cnt", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "불량수량", "ng_cnt", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "설비명", "m_name", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "소진창고", "m_use_sector", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "양품창고", "m_ok_sector", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "plan_id", "plan_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "요청일", "req_date", false, 100, DataGridViewContentAlignment.MiddleLeft); // 요청일
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "사유", "reason", false, 100, DataGridViewContentAlignment.MiddleLeft); //사유
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "w_id", "w_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "order_id", "order_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "m_id", "m_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "소진창고", "m_use_sector_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "양품창고", "m_ok_sector_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.SetDataGridView(dataGridView2);
ProcessService P_service = new ProcessService();
List <WorkRecode_VO> W_lst = P_service.WorkRecode();
dataGridView1.DataSource = W_lst;
List <WorkRecode_VO> n_lst = P_service.GetWork();
dataGridView2.DataSource = n_lst;
}
