private void LoadData() { machineList = R_service.GetMachineAll(); dataGridView2.DataSource = machineList; machineGreadeList = R_service.GetMachineGrpAll(); dataGridView1.DataSource = machineGreadeList; }
private void ShiftMain_Load(object sender, EventArgs e) { GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "ID", "s_id", false, 60); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비코드", "m_code", true, 80); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비명", "m_name", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "Shift", "common_name", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "시작시간", "shift_stime", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "완료시간", "shift_etime", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "적용시작일", "shift_sdate", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "적용완료일", "shift_edate", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "사용유무", "shift_yn", true); dataGridView1.AllowUserToAddRows = false; dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; // ShiftService S_service = new ShiftService(); LoadData(); ResourceService R_service = new ResourceService(); List <MachineVO> m_list = R_service.GetMachineAll(); ComboUtil.ComboBinding(cboMachine, m_list, "m_id", "m_name", "미선택"); CommonCodeService C_service = new CommonCodeService(); List <CommonVO> c_list = C_service.GetCommonCodeAll(); var shift_code = (from shift in c_list where shift.common_type == "shift_code" select shift).ToList(); ComboUtil.ComboBinding(cboShift, shift_code, "common_value", "common_name", "전체"); GridViewUtil.SetDataGridView(dataGridView1); }
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 InitComboBox() { OrderService service = new OrderService(); List <string> list = service.GetPlanID(); // list.Insert(0, ); cboPlanID.DataSource = list; List <MachineVO> lst = R_service.GetMachineAll(); ComboUtil.ComboBinding(cboMachine, lst, "m_id", "m_name", "전체"); }
private void SOO_Load(object sender, EventArgs e) { radioButton6.Checked = true; ResourceService R_service = new ResourceService(); CommonCodeService C_service = new CommonCodeService(); List <CommonVO> c_list = C_service.GetCommonCodeAll(); { var list_c = (from item in c_list where item.common_type == "create_work_order" select item).ToList(); ComboUtil.ComboBinding(cboStatus, list_c, "common_value", "common_name", "미선택"); } { var R_list = (from item in R_service.GetFactoryAll() where item.facility_class == "창고" select item).ToList(); ComboUtil.ComboBinding(cboWH, R_list, "factory_id", "factory_name", "미선택"); } { ComboUtil.ComboBinding(cboMachine, R_service.GetMachineAll(), "m_id", "m_name", "미선택"); } dateTimePicker1.Value = today.AddDays(-10); dateTimePicker2.Value = today.AddDays(20); dt = P_service.GetProductionPlanCheckHis(dateTimePicker1.Value.ToShortDateString(), dateTimePicker2.Value.ToShortDateString()); GridViewUtil.SetDataGridView(dataGridView1); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상품ID", "pro_id", false); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "투입일", "pro_date", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "지시일", "so_sdate", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비코드", "m_code", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비명", "m_name", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상태", "common_name", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상태", "pro_state", false); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목", "product_codename", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "producct_name", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "소진창고", "m_use_sector", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "양품창고", "m_ok_sector", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "불량창고", "m_ng_sector", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "계획수량", "pro_count", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "지시수량", "pro_pcount", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "수량", "pro_mcount", true); GridViewUtil.SetDataGridView(dataGridView1); dataGridView1.DataSource = dt; }
private void GOO_Load(object sender, EventArgs e) { CommonCodeService C_service = new CommonCodeService(); List <CommonVO> c_list = C_service.GetCommonCodeAll(); { var list_c = (from item in c_list where item.common_type == "create_work_order" select item).ToList(); ComboUtil.ComboBinding(cboStatus, list_c, "common_value", "common_name", "미선택"); } dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; dateTimePicker1.Value = DateTime.Now.AddDays(-7); dateTimePicker2.Value = DateTime.Now.AddDays(7); ResourceService R_service = new ResourceService(); List <MachineVO> m_list = R_service.GetMachineAll(); ComboUtil.ComboBinding(cboMachine, m_list, "m_code", "m_name", "미선택"); DataGridViewCheckBoxColumn checkBoxColumn = new DataGridViewCheckBoxColumn(); checkBoxColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; checkBoxColumn.HeaderText = "선택"; dataGridView1.Columns.Add(checkBoxColumn); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "작업지시번호", "WorkID", true, 60); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목", "product_codename", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "product_name", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상태", "common_name", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상태", "pro_state", false); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비코드", "m_code", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비명", "m_name", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "계획수량", "pro_count", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "지시수량", "pro_pcount", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "계획시작일", "pro_date", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "마스터ID", "plan_id", false); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상품ID", "pro_id", false); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "소요시간", "use_time", true); GridViewUtil.SetDataGridView(dataGridView1); LoadData(); }
private void BORPop_Load(object sender, EventArgs e) { R_survice = new ResourceService(); #region 콤보박스 바인딩 common_service = new CommonCodeService(); common_list = common_service.GetCommonCodeAll(); { //공정 var mCode = (from item in common_list where item.common_type == "route" select item).ToList(); ComboUtil.ComboBinding <CommonVO>(cboRoute, mCode, "common_value", "common_name", "미선택"); } { //사용유무 var mCode = (from item in common_list where item.common_type == "user_flag" select item).ToList(); ComboUtil.ComboBinding <CommonVO>(cboYN, mCode, "common_value", "common_name"); } R_survice = new ResourceService(); List <MachineVO> lst = R_survice.GetMachineAll(); ComboUtil.ComboBinding <MachineVO>(cboM_name, lst, "m_id", "m_name", "미선택"); ProductService product_service = new ProductService(); List <ProductVO> list = product_service.GetAllProducts(); ComboUtil.ComboBinding <ProductVO>(cboP_Name, list, "product_id", "product_name", "미선택"); #endregion if (mode == EditMode.Update) { R_survice = new ResourceService(); vo = R_survice.GetBORByID(Convert.ToInt32(lblID.Text), lblRoute.Text); lblID.Text = vo.bor_id.ToString(); cboP_Name.Text = vo.product_name; cboM_name.Text = vo.m_name; cboYN.Text = vo.bor_yn; cboRoute.Text = vo.common_name; txtComment.Text = vo.bor_comment; txtReadyTime.Text = vo.bor_readytime.ToString(); txtTactTime.Text = vo.bor_tacktime.ToString(); } }
private void InitComboBind() { string todayFormat = string.Format("{0:yyyy-MM-dd HH:mm:ss}", today); txtUdate.Text = todayFormat; ResourceService R_service = new ResourceService(); List <MachineVO> m_list = R_service.GetMachineAll(); ComboUtil.ComboBinding(cboM_code, m_list, "m_id", "m_code"); CommonCodeService C_service = new CommonCodeService(); List <CommonVO> c_list = C_service.GetCommonCodeAll(); var shift_code = (from shift in c_list where shift.common_type == "shift_code" select shift).ToList(); ComboUtil.ComboBinding(cboShiftID, shift_code, "common_value", "common_name"); var YN = (from shift in c_list where shift.common_type == "user_flag" select shift).ToList(); ComboUtil.ComboBinding(cboYN, YN, "common_value", "common_name"); }