private void frmShipment_Load(object sender, EventArgs e)
{
newBtns1.btnBarCode.Visible = false;
newBtns1.btnCreate.Visible = false;
newBtns1.btnDelete.Visible = false;
newBtns1.btnExcel.Visible = false;
newBtns1.btnSearch.Visible = false;
newBtns1.btnUpdate.Visible = false;
newBtns1.btnPrint.Visible = false;
newBtns1.btnDocument.Visible = false;
CommonUtil.SetInitGridView(dgvList);
CommonUtil.AddGridTextColumn(dgvList, "수주번호", "so_id", 200);
CommonUtil.AddGridTextColumn(dgvList, "업체명", "company_name", 300);
CommonUtil.AddGridTextColumn(dgvList, "품목명", "product_name", 300);
CommonUtil.AddGridTextColumn(dgvList, "납기일", "so_edate", 250);
CommonUtil.AddGridTextColumn(dgvList, "주문수량", "so_ocount", 250);
CommonUtil.AddGridTextColumn(dgvList, "담당자", "so_rep", 250);
CommonUtil.AddGridTextColumn(dgvList, "상태", "so_state", 250);
CommonUtil.SetInitGridView(dgvShipment);
CommonUtil.AddGridTextColumn(dgvShipment, "출하번호", "ship_id", 150);
CommonUtil.AddGridTextColumn(dgvShipment, "업체명", "company_name", 200);
CommonUtil.AddGridTextColumn(dgvShipment, "품목명", "product_name", 200);
CommonUtil.AddGridTextColumn(dgvShipment, "출하수량", "ship_count", 200);
CommonUtil.AddGridTextColumn(dgvShipment, "출하일", "ship_edate", 200);
CommonUtil.AddGridTextColumn(dgvShipment, "상태", "ship_state", 200);
SOListBind();
ShipListBind();
}
private void frmUser_Load(object sender, EventArgs e)
{
UserService service = new UserService();
CommonUtil util = new CommonUtil();
util.DepartmentBinding(cboDepartment, service.DepartmentCboList());
newBtns1.btnBarCode.Visible = false;
newBtns1.btnDocument.Visible = false;
newBtns1.btnSearch.Visible = false;
newBtns1.btnShipment.Visible = false;
newBtns1.btnWait.Visible = false;
newBtns1.btnPrint.Visible = false;
newBtns1.btnDelete.Text = "퇴사";
CommonUtil.SetInitGridView(dgvUser);
CommonUtil.AddGridTextColumn(dgvUser, "사원번호", "user_id", 80);
CommonUtil.AddGridTextColumn(dgvUser, "사원명", "user_name", 80);
CommonUtil.AddGridTextColumn(dgvUser, "입사일", "user_hiredate", 120);
CommonUtil.AddGridTextColumn(dgvUser, "국적", "user_national", 120);
CommonUtil.AddGridTextColumn(dgvUser, "퇴사일", "user_enddate", 120);
CommonUtil.AddGridTextColumn(dgvUser, "관리자여부", "user_isadmin", 80);
CommonUtil.AddGridTextColumn(dgvUser, "부서명", "department_name", 150);
CommonUtil.AddGridTextColumn(dgvUser, "전화번호", "user_phone", 120);
CommonUtil.AddGridTextColumn(dgvUser, "생년월일", "user_birth", 120);
CommonUtil.AddGridTextColumn(dgvUser, "비밀번호", "user_pwd", 80);
UserList();
}
private void frmOrder_Load(object sender, EventArgs e)
{
CommonUtil.SetInitGridView(dgvCompany);
CommonUtil.AddGridTextColumn(dgvCompany, "업체명", "company_name", 200);
CommonUtil.SetInitGridView(dgvProduct);
CommonUtil.AddGridTextColumn(dgvProduct, "업체명", "company_name", 200);
CommonUtil.AddGridTextColumn(dgvProduct, "업체번호", "company_id", 0, false);
CommonUtil.AddGridTextColumn(dgvProduct, "품목명", "product_name", 200);
CommonUtil.AddGridTextColumn(dgvProduct, "품목번호", "product_id", 0, false);
CommonUtil.AddGridTextColumn(dgvProduct, "현재고", "", 120);
//CommonUtil.AddGridTextColumn(dgvProduct, "발주수량", "", 120);
DataGridViewTextBoxColumn col = new DataGridViewTextBoxColumn();
col.Name = "";
col.HeaderText = "발주수량";
col.Width = 120;
col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvProduct.Columns.Add(col);
OrderService service = new OrderService();
list = service.OrderPList();
dgvCompany.DataSource = service.CompanyList();
if (order_id != 0)
{
label1.Text = "발주 수정";
}
}
private void frmBOR_Load(object sender, EventArgs e)
{
string[] gubun = { "공정명" };
ProductService pService = new ProductService();
List <ComboItemVO> allProcessItem = pService.GetProcessInfoByCodeTypes(gubun);
List <ProdCBOBindingVO> allProItem = pService.GetProductInfo();
MachineService mService = new MachineService();
List <MachineVO> allMachineItem = mService.GetMachineInfo();
CommonUtil.ComboBinding(cboProcess, allProcessItem, "공정명");
CommonUtil.ProdNameBinding(cboProduct, allProItem);
CommonUtil.MachineNameBinding(cboMachine, allMachineItem);
CommonUtil.SetInitGridView(dgvBOR);
CommonUtil.AddGridTextColumn(dgvBOR, "BOR_ID", "bor_id", 60);
CommonUtil.AddGridTextColumn(dgvBOR, "품목ID", "product_id", 150);
CommonUtil.AddGridTextColumn(dgvBOR, "품목명", "product_name", 150);
CommonUtil.AddGridTextColumn(dgvBOR, "공정명", "process_name", 150);
CommonUtil.AddGridTextColumn(dgvBOR, "설비ID", "m_id", 150);
CommonUtil.AddGridTextColumn(dgvBOR, "설비명", "m_name", 150);
CommonUtil.AddGridTextColumn(dgvBOR, "Tact_Time", "bor_tacttime", 150);
CommonUtil.AddGridTextColumn(dgvBOR, "사용유무", "bor_yn", 60);
CommonUtil.AddGridTextColumn(dgvBOR, "비고", "bor_comment", 200);
CommonUtil.AddGridTextColumn(dgvBOR, "수정자", "bor_uadmin", 120);
CommonUtil.AddGridTextColumn(dgvBOR, "수정일", "bor_udate", 120);
DGV_Binding();
}
private void frmperformanceStatus_Load(object sender, EventArgs e)
{
//품목명바인딩, 공정명바인딩
string[] gubun = { "공정명" };
ProductService processService = new ProductService();
List <ComboItemVO> allProcessItem = processService.GetProcessInfoByCodeTypes(gubun);
ProductService productService = new ProductService();
List <ProdCBOBindingVO> allProItem = productService.GetProductInfo();
CommonUtil.ComboBinding(cboProcess, allProcessItem, "공정명");
CommonUtil.ProdNameBinding(cboProduct, allProItem);
//performance_id, production_id, product_id, process_name, performance_qty_ok, performance_qty_ng, performance_qtyimport
//production_state, production_sdate
CommonUtil.SetInitGridView(dgvPerformance);
CommonUtil.AddGridTextColumn(dgvPerformance, "실적ID", "performance_id", 80);
CommonUtil.AddGridTextColumn(dgvPerformance, "생산ID", "production_id", 80);
CommonUtil.AddGridTextColumn(dgvPerformance, "품목ID", "product_id", 120);
CommonUtil.AddGridTextColumn(dgvPerformance, "품목명", "product_name", 120);
CommonUtil.AddGridTextColumn(dgvPerformance, "공정명", "process_name", 120);
CommonUtil.AddGridTextColumn(dgvPerformance, "양품수량", "performance_qty_ok", 100);
CommonUtil.AddGridTextColumn(dgvPerformance, "불량수량", "performance_qty_ng", 100);
CommonUtil.AddGridTextColumn(dgvPerformance, "생산용청수량", "performance_qtyimport", 120);
CommonUtil.AddGridTextColumn(dgvPerformance, "상태", "production_state", 120);
CommonUtil.AddGridTextColumn(dgvPerformance, "생산시작일", "production_sdate", 120);
DGV_Binding();
}
/// <summary>
/// 컬럼 헤더 텍스트 바인딩
/// 데이터 조회해서 바인딩
/// 품목명, 창고명, 품목분류 콤보박스바인딩
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmPDStock_Load(object sender, EventArgs e)
{
try
{
CommonUtil.SetInitGridView(dgv_PDStock);
//CommonUtil.AddGridTextColumn(dgv_PDStock, "번호", "ps_id", 80);
CommonUtil.AddGridTextColumn(dgv_PDStock, "품목코드", "product_id", 220);
CommonUtil.AddGridTextColumn(dgv_PDStock, "품목명", "product_name", 220);
CommonUtil.AddGridTextColumn(dgv_PDStock, "분류", "product_type", 220);
CommonUtil.AddGridTextColumn(dgv_PDStock, "창고명", "w_name", 170);
CommonUtil.AddGridTextColumn(dgv_PDStock, "회사명", "company_name", 150);
CommonUtil.AddGridTextColumn(dgv_PDStock, "재고량", "ps_stock", 150);
DGVBinding();
ProdStatusService service = new ProdStatusService();
prodName = service.GetProdName();
CommonUtil.ProdStatus_ProdNameBinding(cbProdName, prodName);
whName = service.GetWHName();
CommonUtil.ProdStatus_WHNameBinding(cbWHName, whName);
pdType = service.GetProdType();
CommonUtil.ProdTypeBinding(cbProdType, pdType);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void frmWarehouse_Load(object sender, EventArgs e)
{
WarehouseService service = new WarehouseService();
CommonUtil.ComboBinding(cboType, service.WType(), "창고구분");
newBtns1.btnBarCode.Visible = false;
newBtns1.btnDocument.Visible = false;
newBtns1.btnShipment.Visible = false;
newBtns1.btnExcel.Visible = false;
newBtns1.btnPrint.Visible = false;
newBtns1.btnWait.Visible = false;
newBtns1.btnSearch.Visible = false;
CommonUtil.SetInitGridView(dgvList);
CommonUtil.AddGridTextColumn(dgvList, "창고번호", "w_id", 150);
CommonUtil.AddGridTextColumn(dgvList, "창고명", "w_name", 150);
CommonUtil.AddGridTextColumn(dgvList, "창고주소", "w_address", 150);
CommonUtil.AddGridTextColumn(dgvList, "창고구분", "w_type", 150);
CommonUtil.AddGridTextColumn(dgvList, "사용유무", "w_deleted", 150);
CommonUtil.AddGridTextColumn(dgvList, "수정자", "w_uadmin", 150);
CommonUtil.AddGridTextColumn(dgvList, "수정일", "w_udate", 150);
WarehouseList();
}
private void frmShift_Load(object sender, EventArgs e)
{
newBtns1.btnBarCode.Visible = false;
newBtns1.btnDocument.Visible = false;
newBtns1.btnShipment.Visible = false;
newBtns1.btnExcel.Visible = false;
newBtns1.btnPrint.Visible = false;
newBtns1.btnWait.Visible = false;
newBtns1.btnSearch.Visible = false;
CommonUtil.SetInitGridView(dgvShift);
CommonUtil.AddGridTextColumn(dgvShift, "shift번호", "shift_id", 80);
CommonUtil.AddGridTextColumn(dgvShift, "설비번호", "m_id", 80);
CommonUtil.AddGridTextColumn(dgvShift, "시작시간", "shift_stime", 100);
//CommonUtil.AddGridTextColumn(dgvShift, "완료시간", "shift_etime", 100);
CommonUtil.AddGridTextColumn(dgvShift, "시작일", "shift_sdate", 120);
CommonUtil.AddGridTextColumn(dgvShift, "완료일", "shift_edate", 120);
CommonUtil.AddGridTextColumn(dgvShift, "사용유무", "shift_yn", 80);
CommonUtil.AddGridTextColumn(dgvShift, "비고", "shift_comment", 150);
CommonUtil.AddGridTextColumn(dgvShift, "수정자", "shift_uadmin", 100);
CommonUtil.AddGridTextColumn(dgvShift, "수정일", "shift_udate", 100);
CommonUtil.AddGridTextColumn(dgvShift, "투입인원", "shift_personnel", 80);
CommonUtil.AddGridTextColumn(dgvShift, "주말사용", "shift_weekend", 80);
CommonUtil.AddGridTextColumn(dgvShift, "주/야간", "shift_dns", 80);
ShiftList();
}
private void Form1_Load(object sender, EventArgs e)
{
//공정명 콤보박스
string[] gubun = { "공정명" };
ProductService processService = new ProductService();
List <ComboItemVO> allProcessItem = processService.GetProcessInfoByCodeTypes(gubun);
CommonUtil.ComboBinding(cboProcessname, allProcessItem, "공정명");
//작업대기DGV
CommonUtil.SetInitGridView(dgvWaitWork);
CommonUtil.AddGridTextColumn(dgvWaitWork, "작업지시ID", "wo_id", 200);
CommonUtil.AddGridTextColumn(dgvWaitWork, "생산실적ID", "performance_id", 200);
CommonUtil.AddGridTextColumn(dgvWaitWork, "생산ID", "production_id", 120);
CommonUtil.AddGridTextColumn(dgvWaitWork, "품목ID", "product_id", 180);
CommonUtil.AddGridTextColumn(dgvWaitWork, "품목명", "product_name", 250);
CommonUtil.AddGridTextColumn(dgvWaitWork, "공정명", "process_name", 320);
CommonUtil.AddGridTextColumn(dgvWaitWork, "생산요청수량", "performance_qtyimport", 250);
CommonUtil.AddGridTextColumn(dgvWaitWork, "설비명", "m_name", 250);
CommonUtil.AddGridTextColumn(dgvWaitWork, "상태", "production_state", 180);
CommonUtil.AddGridTextColumn(dgvWaitWork, "생산시작일", "production_sdate", 250);
//작업진행중DGV
CommonUtil.SetInitGridView(dgvWorking);
CommonUtil.AddGridTextColumn(dgvWorking, "작업지시ID", "wo_id", 200);
CommonUtil.AddGridTextColumn(dgvWorking, "생산ID", "production_id", 120);
CommonUtil.AddGridTextColumn(dgvWorking, "생산실적ID", "performance_id", 200);
CommonUtil.AddGridTextColumn(dgvWorking, "품목ID", "product_id", 180);
CommonUtil.AddGridTextColumn(dgvWorking, "품목명", "product_name", 250);
CommonUtil.AddGridTextColumn(dgvWorking, "공정명", "process_name", 320);
CommonUtil.AddGridTextColumn(dgvWorking, "양품수량", "performance_qty_ok", 150);
CommonUtil.AddGridTextColumn(dgvWorking, "불량수량", "performance_qty_ng", 150);
CommonUtil.AddGridTextColumn(dgvWorking, "생산요청수량", "performance_qtyimport", 250);
CommonUtil.AddGridTextColumn(dgvWorking, "설비명", "m_name", 250);
CommonUtil.AddGridTextColumn(dgvWorking, "상태", "production_state", 180);
CommonUtil.AddGridTextColumn(dgvWorking, "생산시작일", "production_sdate", 250);
//작업종료DGV
CommonUtil.SetInitGridView(dgvEndWork);
CommonUtil.AddGridTextColumn(dgvEndWork, "작업지시ID", "wo_id", 200);
CommonUtil.AddGridTextColumn(dgvEndWork, "생산ID", "production_id", 120);
CommonUtil.AddGridTextColumn(dgvEndWork, "생산실적ID", "performance_id", 200);
CommonUtil.AddGridTextColumn(dgvEndWork, "품목ID", "product_id", 180);
CommonUtil.AddGridTextColumn(dgvEndWork, "품목명", "product_name", 250);
CommonUtil.AddGridTextColumn(dgvEndWork, "공정명", "process_name", 320);
CommonUtil.AddGridTextColumn(dgvEndWork, "양품수량", "performance_qty_ok", 150);
CommonUtil.AddGridTextColumn(dgvEndWork, "불량수량", "performance_qty_ng", 150);
CommonUtil.AddGridTextColumn(dgvEndWork, "생산요청수량", "performance_qtyimport", 250);
CommonUtil.AddGridTextColumn(dgvEndWork, "설비명", "m_name", 250);
CommonUtil.AddGridTextColumn(dgvEndWork, "상태", "production_state", 180);
CommonUtil.AddGridTextColumn(dgvEndWork, "생산시작일", "production_sdate", 250);
CommonUtil.AddGridTextColumn(dgvEndWork, "생산종료일", "production_edate", 250);
DGV_Binding();
changePeriod();
GetTime();
performance_qty_ok = performance_qty_ng = count = 0;
}
private void frmSalesStatus_Load(object sender, EventArgs e)
{
CommonUtil.SetInitGridView(dgvSales);
CommonUtil.AddGridTextColumn(dgvSales, "업체명", "company_name", 200);
CommonUtil.AddGridTextColumn(dgvSales, "품목명", "product_name", 200);
CommonUtil.AddGridTextColumn(dgvSales, "출하수량", "ship_count", 200, true, DataGridViewContentAlignment.MiddleRight);
CommonUtil.AddGridTextColumn(dgvSales, "매출액", "sales_price", 200, true, DataGridViewContentAlignment.MiddleRight);
CommonUtil.AddGridTextColumn(dgvSales, "출하일", "sales_date", 200);
SalesList();
}
private void frmWorkOrderRegi_Load(object sender, EventArgs e)
{
//품목명바인딩, 생산상태 바인딩
string[] gubun = { "생산상태" };
ProductService pService = new ProductService();
List <ComboItemVO> allState = pService.GetProcessInfoByCodeTypes(gubun);
List <ProdCBOBindingVO> allProItem = pService.GetProductInfo();
CommonUtil.ProdNameBinding(cboProductName, allProItem);
CommonUtil.ComboBinding(cboState, allState, "생산상태");
//데이터그리드뷰 컬럼 추가
dgvOrder.AutoGenerateColumns = false;
dgvOrder.AllowUserToAddRows = false;
dgvOrder.MultiSelect = false;
dgvOrder.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "";
chk.Name = "chk";
chk.Width = 30;
dgvOrder.Columns.Add(chk);
//Header체크 속성추가
Point point = dgvOrder.GetCellDisplayRectangle(0, -1, true).Location;
headerCheck.Location = new Point(point.X + 8, point.Y + 2);
headerCheck.BackColor = Color.White;
headerCheck.Size = new Size(18, 18);
headerCheck.Click += HeaderCheck_Click;
dgvOrder.Controls.Add(headerCheck);
CommonUtil.SetInitGridView(dgvOrder);
CommonUtil.AddGridTextColumn(dgvOrder, "WO_NUM", "wo_id", 80);
CommonUtil.AddGridTextColumn(dgvOrder, "수주번호", "so_id", 80);
CommonUtil.AddGridTextColumn(dgvOrder, "제품ID", "product_id", 150);
CommonUtil.AddGridTextColumn(dgvOrder, "제품명", "product_name", 150);
CommonUtil.AddGridTextColumn(dgvOrder, "설비ID", "m_id", 80);
CommonUtil.AddGridTextColumn(dgvOrder, "설비명", "m_name", 150);
CommonUtil.AddGridTextColumn(dgvOrder, "수주량", "wo_pcount", 100);
CommonUtil.AddGridTextColumn(dgvOrder, "지시량", "wo_count", 100);
CommonUtil.AddGridTextColumn(dgvOrder, "지시일", "wo_date", 150);
CommonUtil.AddGridTextColumn(dgvOrder, "작업시작일", "wo_sdate", 150);
CommonUtil.AddGridTextColumn(dgvOrder, "상태", "wo_state", 100);
CommonUtil.AddGridTextColumn(dgvOrder, "수정자", "wo_uadmin", 100);
CommonUtil.AddGridTextColumn(dgvOrder, "수정일", "wo_udate", 120);
DGV_Binding(dgvOrder);
}
private void frmOrder_Load(object sender, EventArgs e)
{
//코드 데이터들을 조회해서 콤보박스 바인딩
string[] gubun = { "Customer", "Employee", "Category", "Shipper" };
CommonService service = new CommonService();
List <ComboItemVO> allList = service.GetCodeInfoByCodeTypes(gubun);
#region 주문 신규등록 탭
CommonUtil.ComboBinding(cboCustomer, allList, "Customer", true, "선택");
CommonUtil.ComboBinding(cboEmployee, allList, "Employee");
CommonUtil.ComboBinding(cboCategory, allList, "Category");
//배송희망일(납기희망일) 7일 후로 셋팅
dtpRequiredDate.Value = DateTime.Now.AddDays(7);
//장바구니 데이터그리드뷰의 항목을 셋팅
CommonUtil.SetInitGridView(dgvCart);
CommonUtil.AddGridTextColumn(dgvCart, "카테고리", "CategoryName", 150);
CommonUtil.AddGridTextColumn(dgvCart, "제품ID", "ProductID", visibility: false);
CommonUtil.AddGridTextColumn(dgvCart, "제품명", "ProductName", 310);
CommonUtil.AddGridTextColumn(dgvCart, "제품단가", "UnitPrice");
CommonUtil.AddGridTextColumn(dgvCart, "주문수량", "Quantity");
#endregion
#region 주문 조회/관리 탭
CommonUtil.ComboBinding(cboCustomer2, allList, "Customer");
CommonUtil.ComboBinding(cboEmployee2, allList, "Employee");
CommonUtil.ComboBinding(cboShipper, allList, "Shipper");
//주문일자 검색조건
period1.ChangedPeriod += Period1_ChangedPeriod;
//period1.dtFrom = DateTime.Now.AddDays(-3).ToShortDateString();
//period1.dtTo = DateTime.Now.ToShortDateString();
//주문목록, 주문상세목록 데이터그리드뷰의 항목을 셋팅
CommonUtil.SetInitGridView(dgvOrder);
CommonUtil.AddGridTextColumn(dgvOrder, "주문ID", "OrderID");
CommonUtil.AddGridTextColumn(dgvOrder, "거래처명", "CompanyName", 200);
CommonUtil.AddGridTextColumn(dgvOrder, "직원명", "EmployeeName", 200);
CommonUtil.AddGridTextColumn(dgvOrder, "주문일", "OrderDate");
CommonUtil.AddGridTextColumn(dgvOrder, "요청일", "RequiredDate");
CommonUtil.AddGridTextColumn(dgvOrder, "배송일", "ShippedDate");
CommonUtil.AddGridTextColumn(dgvOrder, "배송업체", "ShipCompanyName", 150);
CommonUtil.AddGridTextColumn(dgvOrder, "배송료", "Freight");
CommonUtil.SetInitGridView(dgvOrderDetail);
CommonUtil.AddGridTextColumn(dgvOrderDetail, "카테고리", "CategoryName");
CommonUtil.AddGridTextColumn(dgvOrderDetail, "제품명", "ProductName", 250);
CommonUtil.AddGridTextColumn(dgvOrderDetail, "제품단가", "UnitPrice");
CommonUtil.AddGridTextColumn(dgvOrderDetail, "주문수량", "Quantity");
#endregion
}
private void frmEmployee_Load(object sender, EventArgs e)
{
CommonUtil.SetInitGridView(dgvEmp);
CommonUtil.AddGridTextColumn(dgvEmp, "사원번호", "EmployeeID");
CommonUtil.AddGridTextColumn(dgvEmp, "사원명", "FirstName");
CommonUtil.AddGridTextColumn(dgvEmp, "사원명", "LastName");
CommonUtil.AddGridTextColumn(dgvEmp, "직책", "Title", 150);
CommonUtil.AddGridTextColumn(dgvEmp, "출생일", "BirthDate");
CommonUtil.AddGridTextColumn(dgvEmp, "입사일", "HireDate");
CommonUtil.AddGridTextColumn(dgvEmp, "전화번호", "HomePhone", 130);
InitControl();
LoadData();
}
/// <summary>
/// 컬럼헤더 체크박스 바인딩
/// 컬럼헤더 텍스트 바인딩
/// 데이터 조회하여 바인딩
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmProductManage_Load(object sender, EventArgs e)
{
try
{
dgvProduct.AutoGenerateColumns = false;
dgvProduct.AllowUserToAddRows = false;
dgvProduct.MultiSelect = false;
dgvProduct.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "";
chk.Name = "chk";
chk.Width = 30;
dgvProduct.Columns.Add(chk);
Point point = dgvProduct.GetCellDisplayRectangle(0, -1, true).Location;
headerCheck.Location = new Point(point.X + 8, point.Y + 2);
headerCheck.BackColor = Color.White;
headerCheck.Size = new Size(18, 18);
headerCheck.Click += HeaderCheck_Click;
dgvProduct.Controls.Add(headerCheck);
#region 그리드뷰 컬럼헤더 바인딩
CommonUtil.SetInitGridView(dgvProduct);
CommonUtil.AddGridTextColumn(dgvProduct, "번호", "product_id", 60); //1
CommonUtil.AddGridTextColumn(dgvProduct, "품목명", "product_name", 150); //2
CommonUtil.AddGridTextColumn(dgvProduct, "제품분류", "product_type", 100); //3
CommonUtil.AddGridTextColumn(dgvProduct, "단위", "product_unit", 100); //4
CommonUtil.AddGridTextColumn(dgvProduct, "창고명", "w_name", 150); //5
CommonUtil.AddGridTextColumn(dgvProduct, "최소발주량", "product_lorder_count", 100); //6
CommonUtil.AddGridTextColumn(dgvProduct, "안전재고량", "product_safety_count", 100); //7
CommonUtil.AddGridTextColumn(dgvProduct, "거래처명", "company_name", 170); //8
CommonUtil.AddGridTextColumn(dgvProduct, "검사여부", "product_exam", 90); //9
CommonUtil.AddGridTextColumn(dgvProduct, "규격", "product_stnd", 130); //10
CommonUtil.AddGridTextColumn(dgvProduct, "비고", "product_comment", 10, false); //11
CommonUtil.AddGridTextColumn(dgvProduct, "삭제여부", "product_deleted", 90); //12
CommonUtil.AddGridTextColumn(dgvProduct, "거래처id", "company_id", 10, false); //13
CommonUtil.AddGridTextColumn(dgvProduct, "창고id", "w_id", 10, false); //14
#endregion
SearchCBBinding();
DGV_Binding();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
/// <summary>
/// 폼 로드이벤트
/// 컬럼헤더를 바인딩하고 DB에서 0레벨 BOM을 우선 조회한다.
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmBOM_Load(object sender, EventArgs e)
{
try
{
#region 0레벨 BOM GridView
CommonUtil.SetInitGridView(dgvBOM_Lv0);
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "번호", "bom_id", 40); //0
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "상위BOMID", "bom_parent_id", 10, false); //1
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "상위품목ID", "prod_parent_id", 10, false); //2
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "상위품목명", "prod_parent_name", 10, false); //3
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "품목코드", "product_id", 80); //4
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "품목명", "product_name", 90); //5
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "분류", "product_type", 60); //6
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "단위", "product_unit", 60); //7
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "소요량", "bom_use_count", 70); //8
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "레벨", "bom_level", 40); //9
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "비고", "bom_comment", 140, false); //10
#endregion
#region BOMAll GridView
CommonUtil.SetInitGridView(dgvBOMAll);
CommonUtil.AddGridTextColumn(dgvBOMAll, "번호", "bom_id", 80); //0
CommonUtil.AddGridTextColumn(dgvBOMAll, "품목코드", "product_id", 140); //1
CommonUtil.AddGridTextColumn(dgvBOMAll, "품목명", "product_name", 160); //2
CommonUtil.AddGridTextColumn(dgvBOMAll, "분류", "product_type", 160); //3
CommonUtil.AddGridTextColumn(dgvBOMAll, "단위", "product_unit", 140); //4
CommonUtil.AddGridTextColumn(dgvBOMAll, "소요량", "bom_use_count", 150); //5
CommonUtil.AddGridTextColumn(dgvBOMAll, "레벨", "bom_level", 140); //6
#endregion
gbBOM.Visible = false;
allList = service.GetBOMCBProdName();
CommonUtil.BOMProdName(cbProdName, allList);
ProdStatusService service2 = new ProdStatusService();
GetProdType = service2.GetProdType();
CommonUtil.ProdTypeBinding(cbProdType, GetProdType);
DGV_Binding_Lv0();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void frmDepartment_Load(object sender, EventArgs e)
{
newBtns1.btnBarCode.Visible = false;
newBtns1.btnDocument.Visible = false;
newBtns1.btnSearch.Visible = false;
newBtns1.btnShipment.Visible = false;
newBtns1.btnWait.Visible = false;
newBtns1.btnPrint.Visible = false;
CommonUtil.SetInitGridView(dgvDepartment);
CommonUtil.AddGridTextColumn(dgvDepartment, "부서번호", "department_id", 150);
CommonUtil.AddGridTextColumn(dgvDepartment, "부서명", "department_name", 250);
CommonUtil.AddGridTextColumn(dgvDepartment, "수정자", "department_uadmin", 200);
CommonUtil.AddGridTextColumn(dgvDepartment, "수정일", "department_udate", 200);
DepartmentList();
dgvDepartment.DataSource = list;
}
public frmPDStockPopUp(string product_id)
{
InitializeComponent();
CommonUtil.SetInitGridView(dgvPDStockPop);
CommonUtil.AddGridTextColumn(dgvPDStockPop, "번호", "ps_id", 70);
CommonUtil.AddGridTextColumn(dgvPDStockPop, "품목코드", "product_id", 100);
CommonUtil.AddGridTextColumn(dgvPDStockPop, "품목명", "product_name", 80);
CommonUtil.AddGridTextColumn(dgvPDStockPop, "분류", "product_type", 80);
CommonUtil.AddGridTextColumn(dgvPDStockPop, "창고명", "w_name", 80);
CommonUtil.AddGridTextColumn(dgvPDStockPop, "회사명", "company_name", 100);
CommonUtil.AddGridTextColumn(dgvPDStockPop, "재고량", "ps_stock", 100);
CommonUtil.AddGridTextColumn(dgvPDStockPop, "입고일", "ps_idate", 110);
CommonUtil.AddGridTextColumn(dgvPDStockPop, "출고일", "ps_odate", 110);
DGVBinding(product_id);
newBtns1.btnBarCode.Visible = newBtns1.btnExcel.Visible = newBtns1.btnSearch.Visible = newBtns1.btnPrint.Visible = newBtns1.btnDocument.Visible = newBtns1.btnShipment.Visible = newBtns1.btnWait.Visible = newBtns1.btnCreate.Visible = false;
}
/// <summary>
/// 그리드뷰에 체크박스 바인딩
/// 컬럼 헤더 텍스트 바인딩 후 데이터 조회
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmImportInspection_Load(object sender, EventArgs e)
{
try
{
dgvIncomming.AutoGenerateColumns = false;
dgvIncomming.AllowUserToAddRows = false;
dgvIncomming.MultiSelect = false;
dgvIncomming.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "";
chk.Name = "chk";
chk.Width = 30;
dgvIncomming.Columns.Add(chk);
Point point = dgvIncomming.GetCellDisplayRectangle(0, -1, true).Location;
headerCheck.Location = new Point(point.X + 8, point.Y + 2);
headerCheck.BackColor = Color.White;
headerCheck.Size = new Size(18, 18);
headerCheck.Click += HeaderCheck_Click;
dgvIncomming.Controls.Add(headerCheck);
CommonUtil.SetInitGridView(dgvIncomming);
CommonUtil.AddGridTextColumn(dgvIncomming, "입고번호", "incomming_ID", 80);
CommonUtil.AddGridTextColumn(dgvIncomming, "발주번호", "order_id", 100);
CommonUtil.AddGridTextColumn(dgvIncomming, "품목코드", "product_id", 100);
CommonUtil.AddGridTextColumn(dgvIncomming, "품목명", "product_name", 100);
CommonUtil.AddGridTextColumn(dgvIncomming, "입고상태", "incomming_state", 100);
CommonUtil.AddGridTextColumn(dgvIncomming, "입고일", "incomming_date", 150);
CommonUtil.AddGridTextColumn(dgvIncomming, "담당자", "incomming_rep", 150);
CommonUtil.AddGridTextColumn(dgvIncomming, "입고량", "incomming_count", 150);
CommonUtil.AddGridTextColumn(dgvIncomming, "합불판정", "orderexam_result", 100);
CommonUtil.AddGridTextColumn(dgvIncomming, "수정자", "incomming_uadmin", 150);
CommonUtil.AddGridTextColumn(dgvIncomming, "수정일", "incomming_udate", 150);
DGVBinding();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void frmSO_Load(object sender, EventArgs e)
{
newBtns1.btnBarCode.Visible = false;
newBtns1.btnDocument.Visible = false;
newBtns1.btnSearch.Visible = false;
newBtns1.btnShipment.Visible = false;
newBtns1.btnWait.Visible = false;
newBtns1.btnExcel.Visible = false;
newBtns1.btnPrint.Visible = false;
CommonUtil.SetInitGridView(dgvSO);
CommonUtil.AddGridTextColumn(dgvSO, "수주번호", "so_id", 200);
CommonUtil.AddGridTextColumn(dgvSO, "업체명", "company_name", 300);
CommonUtil.AddGridTextColumn(dgvSO, "품목명", "product_name", 300);
CommonUtil.AddGridTextColumn(dgvSO, "납기일", "so_edate", 250);
CommonUtil.AddGridTextColumn(dgvSO, "주문수량", "so_ocount", 250);
CommonUtil.AddGridTextColumn(dgvSO, "담당자", "so_rep", 250);
SOList();
}
/// <summary>
/// 그리드뷰에 체크박스 바인딩
/// 컬럼 헤더 텍스트 바인딩
/// 데이터 조회해서 바인딩
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmProdInspection_Load(object sender, EventArgs e)
{
try
{
dgvProdCheck.AutoGenerateColumns = false;
dgvProdCheck.AllowUserToAddRows = false;
dgvProdCheck.MultiSelect = false;
dgvProdCheck.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "";
chk.Name = "chk";
chk.Width = 30;
dgvProdCheck.Columns.Add(chk);
Point point = dgvProdCheck.GetCellDisplayRectangle(0, -1, true).Location;
headerCheck.Location = new Point(point.X + 8, point.Y + 2);
headerCheck.BackColor = Color.White;
headerCheck.Size = new Size(18, 18);
headerCheck.Click += HeaderCheck_Click;
dgvProdCheck.Controls.Add(headerCheck);
CommonUtil.SetInitGridView(dgvProdCheck);
CommonUtil.AddGridTextColumn(dgvProdCheck, "생산번호", "production_id", 90);
CommonUtil.AddGridTextColumn(dgvProdCheck, "작업지시번호", "wo_id", 120);
CommonUtil.AddGridTextColumn(dgvProdCheck, "수주번호", "so_id", 90);
CommonUtil.AddGridTextColumn(dgvProdCheck, "품목코드", "product_id", 150);
CommonUtil.AddGridTextColumn(dgvProdCheck, "품목명", "product_name", 150);
CommonUtil.AddGridTextColumn(dgvProdCheck, "출하상태", "ship_state", 200);
CommonUtil.AddGridTextColumn(dgvProdCheck, "생산상태", "production_state", 200);
CommonUtil.AddGridTextColumn(dgvProdCheck, "납기일", "so_edate", 150);
CommonUtil.AddGridTextColumn(dgvProdCheck, "출하번호", "ship_id", 150);
CommonUtil.AddGridTextColumn(dgvProdCheck, "생산량", "production_QtyReleased", 150);
DGVBinding();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
/// <summary>
/// 컬럼헤더 바인딩
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmCompany_Load(object sender, EventArgs e)
{
CommonUtil.SetInitGridView(dgvCompany);
CommonUtil.AddGridTextColumn(dgvCompany, "업체번호", "company_id", 80); //0
CommonUtil.AddGridTextColumn(dgvCompany, "업체명", "company_name", 100); //1
CommonUtil.AddGridTextColumn(dgvCompany, "업체구분", "company_type", 80); //2
CommonUtil.AddGridTextColumn(dgvCompany, "대표명", "company_ceo", 100); //3
CommonUtil.AddGridTextColumn(dgvCompany, "사업자번호", "company_cnum", 100); //4
CommonUtil.AddGridTextColumn(dgvCompany, "업종", "company_btype", 80); //5
CommonUtil.AddGridTextColumn(dgvCompany, "업태", "company_gtype", 80); //6
CommonUtil.AddGridTextColumn(dgvCompany, "이메일", "company_email", 200); //7
CommonUtil.AddGridTextColumn(dgvCompany, "전화번호", "company_phone", 100); //8
CommonUtil.AddGridTextColumn(dgvCompany, "팩스번호", "company_fax", 100); //9
CommonUtil.AddGridTextColumn(dgvCompany, "지번", "company_ZipCode", 10, false); //10
CommonUtil.AddGridTextColumn(dgvCompany, "주소", "company_Address", 140); //11
CommonUtil.AddGridTextColumn(dgvCompany, "주소상세", "company_DetAddress", 400); //12
CommonUtil.AddGridTextColumn(dgvCompany, "수정자", "company_uadmin", 10, false); //13
CommonUtil.AddGridTextColumn(dgvCompany, "수정일", "company_udate", 10, false); //14
CommonUtil.AddGridTextColumn(dgvCompany, "비고", "company_comment", 10, false); //15
DGVBinding();
}
/// <summary>
/// 폼로드
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmCheckList_Load(object sender, EventArgs e)
{
string[] gubun = { "검사구분" };
CheckListService cService = new CheckListService();
List <ComboItemVO> allCheckType = cService.GetCheckTypeInfoByCodeTypes(gubun);
CommonUtil.ComboBinding(cboCheckType, allCheckType, "검사구분");
CommonUtil.SetInitGridView(dgvCheckList);
CommonUtil.AddGridTextColumn(dgvCheckList, "검사ID", "cl_id", 60);
CommonUtil.AddGridTextColumn(dgvCheckList, "검사명", "cl_name", 150);
CommonUtil.AddGridTextColumn(dgvCheckList, "품목ID", "product_id", 60);
CommonUtil.AddGridTextColumn(dgvCheckList, "품목명", "product_name", 150);
CommonUtil.AddGridTextColumn(dgvCheckList, "검사타입", "cl_type", 120);
CommonUtil.AddGridTextColumn(dgvCheckList, "기준", "cl_stnd", 100);
CommonUtil.AddGridTextColumn(dgvCheckList, "비고", "cl_comment", 150);
CommonUtil.AddGridTextColumn(dgvCheckList, "수정자", "cl_uadmin", 100);
CommonUtil.AddGridTextColumn(dgvCheckList, "수정일", "cl_udate", 150);
DGV_Binding();
}
private void frmCustomerManagement_Load(object sender, EventArgs e)
{
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.Name = "chk";
chk.HeaderText = "";
chk.Width = 30;
dgvMember.Columns.Add(chk); //헤더박스 추가, 여기까지는 맨 뒤쪽에 체크박스가 추가된 상태
Point headercelllocation = dgvMember.GetCellDisplayRectangle(-1, -1, true).Location;
headercheckbox.Location = new Point(headercelllocation.X + 8, headercelllocation.Y + 1);
headercheckbox.BackColor = Color.White;
headercheckbox.Size = new Size(18, 18);
headercheckbox.Click += Headercheckbox_Click;
dgvMember.Controls.Add(headercheckbox);
CommonUtil.SetinitGridView(dgvMember);
CommonUtil.AddGridTextColumn(dgvMember, "고객번호", "CustomerNum");
CommonUtil.AddGridTextColumn(dgvMember, "고객명", "CustomerName");
CommonUtil.AddGridTextColumn(dgvMember, "고객주소", "CustomerAddress", 150);
CommonUtil.AddGridTextColumn(dgvMember, "고객ID", "CustomerID");
CommonUtil.AddGridTextColumn(dgvMember, "관리자여부", "IsAdmin");
CommonUtil.AddGridTextColumn(dgvMember, "고객비밀번호", "CustomerPw", 120);
CommonUtil.AddGridTextColumn(dgvMember, "연락처", "CustomerPhone");
CommonUtil.AddGridTextColumn(dgvMember, "고객이메일", "CustomerEmail", 180);
CommonUtil.AddGridTextColumn(dgvMember, "고객이미지경로", "CustomerImage", 120);
CommonUtil.AddGridTextColumn(dgvMember, "휴면계좌여부", "IsResting", 150);
CustomerDB db = new CustomerDB();
dt = db.GetEveryData();
if (dt != null)
{
dgvMember.DataSource = dt;
dgvMember.ClearSelection();
}
}
/// <summary>
/// 컬럼 헤더 텍스트 바인딩, 데이터 조회
/// 콤보박스에 설비명 바인딩
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmMachine_Load(object sender, EventArgs e)
{
try
{
CommonUtil.SetInitGridView(dgvMachine);
CommonUtil.AddGridTextColumn(dgvMachine, "설비번호", "m_id", 80);
CommonUtil.AddGridTextColumn(dgvMachine, "설비정보", "m_info", 250);
CommonUtil.AddGridTextColumn(dgvMachine, "설비명", "m_name", 200);
CommonUtil.AddGridTextColumn(dgvMachine, "사용여부", "m_yn", 80);
CommonUtil.AddGridTextColumn(dgvMachine, "비고", "m_comment", 500);
CommonUtil.AddGridTextColumn(dgvMachine, "수정자", "m_uadmin", 120);
CommonUtil.AddGridTextColumn(dgvMachine, "수정일", "m_udate", 150);
DGVBinding();
List <MachineVO> allMachineItem = service.GetMachineInfo();
CommonUtil.MachineNameBinding(cbMachine, allMachineItem);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void frmIncommingWait_Load(object sender, EventArgs e)
{
newBtns1.btnBarCode.Visible = false;
newBtns1.btnDocument.Visible = false;
newBtns1.btnSearch.Visible = false;
newBtns1.btnShipment.Visible = false;
newBtns1.btnCreate.Visible = false;
newBtns1.btnDelete.Visible = false;
newBtns1.btnExcel.Visible = false;
newBtns1.btnPrint.Visible = false;
newBtns1.btnUpdate.Visible = false;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "";
chk.Name = "chk";
chk.Width = 30;
dgvOrder.Columns.Add(chk);
//Header체크 속성추가
Point point = dgvOrder.GetCellDisplayRectangle(0, -1, true).Location;
headerCheck.Location = new Point(point.X + 8, point.Y + 2);
headerCheck.BackColor = Color.White;
headerCheck.Size = new Size(18, 18);
headerCheck.Click += HeaderCheck_Click;
dgvOrder.Controls.Add(headerCheck);
CommonUtil.SetInitGridView(dgvOrder);
CommonUtil.AddGridTextColumn(dgvOrder, "발주번호", "order_id", 200);
CommonUtil.AddGridTextColumn(dgvOrder, "업체명", "company_name", 300);
CommonUtil.AddGridTextColumn(dgvOrder, "품목명", "product_name", 300);
CommonUtil.AddGridTextColumn(dgvOrder, "발주수량", "order_count", 200);
CommonUtil.AddGridTextColumn(dgvOrder, "발주일", "order_date", 200);
CommonUtil.AddGridTextColumn(dgvOrder, "납기일", "order_edate", 200);
CommonUtil.AddGridTextColumn(dgvOrder, "담당자", "user_name", 200);
OrderList();
}
private void frmdefectiveStatus_Load(object sender, EventArgs e)
{
string[] gubun = { "공정명" };
ProductService pService = new ProductService();
List <ComboItemVO> allProcessItem = pService.GetProcessInfoByCodeTypes(gubun);
List <ProdCBOBindingVO> allProItem = pService.GetProductInfo();
CommonUtil.ComboBinding(cboProcess, allProcessItem, "공정명");
CommonUtil.ProdNameBinding(cboProduct, allProItem);
CommonUtil.SetInitGridView(dgvStatus);
CommonUtil.AddGridTextColumn(dgvStatus, "불량이력ID", "defective_ID", 120);
CommonUtil.AddGridTextColumn(dgvStatus, "품목코드", "product_id", 120);
CommonUtil.AddGridTextColumn(dgvStatus, "품목명", "product_name", 120);
CommonUtil.AddGridTextColumn(dgvStatus, "공정명", "process_name", 120);
CommonUtil.AddGridTextColumn(dgvStatus, "발생시간", "defective_stime", 150);
CommonUtil.AddGridTextColumn(dgvStatus, "생산실적ID", "performance_id", 100);
CommonUtil.AddGridTextColumn(dgvStatus, "불량명", "common_name", 150);
CommonUtil.AddGridTextColumn(dgvStatus, "불량갯수", "defective_count", 100);
DGV_Binding();
}
/// <summary>
/// 그리드뷰에 체크박스 바인딩
/// 컬럼헤더 바인딩
/// 데이터 조회하여 바인딩
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmProdInspPopUp_Load(object sender, EventArgs e)
{
try
{
dgv_CheckList.AutoGenerateColumns = false;
dgv_CheckList.AllowUserToAddRows = false;
dgv_CheckList.MultiSelect = false;
dgv_CheckList.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "";
chk.Name = "chk";
chk.Width = 30;
dgv_CheckList.Columns.Add(chk);
Point point = dgv_CheckList.GetCellDisplayRectangle(0, -1, true).Location;
headerCheck.Location = new Point(point.X + 8, point.Y + 2);
headerCheck.BackColor = Color.White;
headerCheck.Size = new Size(18, 18);
headerCheck.Click += HeaderCheck_Click;
dgv_CheckList.Controls.Add(headerCheck);
CommonUtil.SetInitGridView(dgv_CheckList);
CommonUtil.AddGridTextColumn(dgv_CheckList, "검사번호", "cl_ship_id", 80);
CommonUtil.AddGridTextColumn(dgv_CheckList, "출하번호", "ship_id", 80);
CommonUtil.AddGridTextColumn(dgv_CheckList, "품목명", "product_name", 90);
CommonUtil.AddGridTextColumn(dgv_CheckList, "구성품", "cl_ship_Components", 90);
CommonUtil.AddGridTextColumn(dgv_CheckList, "포장", "cl_ship_Packing", 90);
CommonUtil.AddGridTextColumn(dgv_CheckList, "기타", "etc", 90);
CommonUtil.AddGridTextColumn(dgv_CheckList, "생산상태", "production_state", 200);
DGVBinding();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
/// <summary>
/// DGV 셀의 0번째에 체크박스를 바인딩
/// 컬럼헤더 텍스트 바인딩 후 데이터 조회
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmImpInspecPopUp_Load(object sender, EventArgs e)
{
try
{
dgvCheckList.AutoGenerateColumns = false;
dgvCheckList.AllowUserToAddRows = false;
dgvCheckList.MultiSelect = false;
dgvCheckList.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "";
chk.Name = "chk";
chk.Width = 30;
dgvCheckList.Columns.Add(chk);
Point point = dgvCheckList.GetCellDisplayRectangle(0, -1, true).Location;
headerCheck.Location = new Point(point.X + 8, point.Y + 2);
headerCheck.BackColor = Color.White;
headerCheck.Size = new Size(18, 18);
headerCheck.Click += HeaderCheck_Click;
dgvCheckList.Controls.Add(headerCheck);
CommonUtil.SetInitGridView(dgvCheckList);
CommonUtil.AddGridTextColumn(dgvCheckList, "검사번호", "cl_inc_id", 80);
CommonUtil.AddGridTextColumn(dgvCheckList, "입고번호", "incomming_ID", 80);
CommonUtil.AddGridTextColumn(dgvCheckList, "색상", "cl_inc_Color", 90);
CommonUtil.AddGridTextColumn(dgvCheckList, "찢어짐", "cl_inc_Torn", 90);
CommonUtil.AddGridTextColumn(dgvCheckList, "길이", "cl_inc_Length", 90);
CommonUtil.AddGridTextColumn(dgvCheckList, "찍힘", "cl_inc_Crack", 90);
CommonUtil.AddGridTextColumn(dgvCheckList, "기타", "etc", 200);
DGVBinding();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
/// <summary>
/// 컬럼 헤더를 바인딩하고 DB에서 조회.
/// 수입검사인지 제품검사 구분을 콤보박스에 바인딩
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmCheckHistory_Load(object sender, EventArgs e)
{
try
{
CommonUtil.SetInitGridView(dgvCheckHistory);
CommonUtil.AddGridTextColumn(dgvCheckHistory, "이력번호", "ch_id", 160);
CommonUtil.AddGridTextColumn(dgvCheckHistory, "검사항목", "ch_item", 250);
CommonUtil.AddGridTextColumn(dgvCheckHistory, "품목코드", "product_id", 160);
CommonUtil.AddGridTextColumn(dgvCheckHistory, "검사일", "ch_date", 160);
CommonUtil.AddGridTextColumn(dgvCheckHistory, "검사구분", "ch_type", 160);
CommonUtil.AddGridTextColumn(dgvCheckHistory, "비고", "ch_comment", 250);
CommonUtil.AddGridTextColumn(dgvCheckHistory, "제품검사ID", "cl_ship_id", 150);
CommonUtil.AddGridTextColumn(dgvCheckHistory, "수입검사ID", "cl_inc_id", 150);
DGVBinding();
check = service.GetCheckTypeComboBox();
CommonUtil.CheckHis_CheckTypeBinding(cbCheckType, check);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
/// <summary>
/// 컬럼 헤더 텍스트 바인딩
/// 데이터 조회하여 데이터바인딩
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmMatPriceManage_Load(object sender, EventArgs e)
{
try
{
CommonUtil.SetInitGridView(dgvMatPrice);
CommonUtil.AddGridTextColumn(dgvMatPrice, "번호", "price_id", 60); //0
CommonUtil.AddGridTextColumn(dgvMatPrice, "품목id", "product_id", 10, false); //1
CommonUtil.AddGridTextColumn(dgvMatPrice, "품목명", "product_name", 260); //2
CommonUtil.AddGridTextColumn(dgvMatPrice, "거래처id", "company_id", 10, false); //3
CommonUtil.AddGridTextColumn(dgvMatPrice, "거래처명", "company_name", 260); //4
CommonUtil.AddGridTextColumn(dgvMatPrice, "현재단가", "price_present", 180); //5
CommonUtil.AddGridTextColumn(dgvMatPrice, "이전단가", "price_past", 180); //6
CommonUtil.AddGridTextColumn(dgvMatPrice, "시작일", "price_sdate", 200); //7
CommonUtil.AddGridTextColumn(dgvMatPrice, "종료일", "price_edate", 200); //8
CommonUtil.AddGridTextColumn(dgvMatPrice, "사용유무", "price_yn", 120); //9
CommonUtil.AddGridTextColumn(dgvMatPrice, "비고", "price_comment", 10, false); //10
DGV_Binding();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}