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 ComboBinding() { common_service = new CommonCodeService(); codelist = common_service.GetCommonCodeAll(); product_service = new ProductService(); List <FactoryDB_VO> f_list = new List <FactoryDB_VO>(); ResourceService resource_service = new ResourceService(); f_list = resource_service.GetFactoryAll(); List <UserVO> user_list = product_service.GetUserAll(); #region 사용여부cbo List <CommonVO> _cboUseFlag = (from item in codelist where item.common_type == "user_flag" select item).ToList(); ComboUtil.ComboBinding(cboIsUsed, _cboUseFlag, "common_value", "common_name", "선택"); #endregion #region 품목유형cbo _cboUseFlag = (from item in codelist where item.common_type == "item_type" select item).ToList(); ComboUtil.ComboBinding(cboProductType, _cboUseFlag, "common_value", "common_name", "선택"); #endregion #region 납품업체cbo List <CompanyVO> company_list = new List <CompanyVO>(); OrderService order_service = new OrderService(); company_list = order_service.GetCompanyAll("customer"); ComboUtil.ComboBinding(cboCompany, company_list, "company_code", "company_name", "선택"); #endregion #region 발주업체cbo company_list = order_service.GetCompanyAll("cooperative"); ComboUtil.ComboBinding(cboSupplyCompany, company_list, "company_code", "company_name", "선택"); List <UserVO> user_vo = new List <UserVO>(); #endregion #region 담당자cbo ComboUtil.ComboBinding(cboAdmin, user_list, "user_id", "user_name", "선택"); #endregion #region 입고창고cbo List <FactoryDB_VO> _cboInSector = (from item in f_list where item.facility_value == "FAC200" select item).ToList(); ComboUtil.ComboBinding(cboInSector, _cboInSector, "factory_code", "factory_name", "선택"); #endregion #region 출고창고cbo List <FactoryDB_VO> _cboOutSector = (from item in f_list where item.facility_value == "FAC100" select item).ToList(); ComboUtil.ComboBinding(cboOutSector, _cboOutSector, "factory_code", "factory_name", "선택"); #endregion }
private void CboBinding() { OrderService order_service = new OrderService(); ProductService product_service = new ProductService(); CommonCodeService common_service = new CommonCodeService(); #region 발주업체cbo List <CompanyVO> company_list = order_service.GetCompanyAll("COOPERATIVE"); ComboUtil.ComboBinding(cboCompany, company_list, "company_id", "company_name", "선택"); #endregion #region 품목cbo product_service = new ProductService(); List <ProductVO> product_list = new List <ProductVO>(); product_list = product_service.GetAllProducts(); ComboUtil.ComboBinding(cboProduct, product_list, "product_id", "product_name", "선택"); #endregion #region 사용여부 List <CommonVO> codelist = common_service.GetCommonCodeAll(); List <CommonVO> _cboUseFlag = (from item in codelist where item.common_type == "user_flag" select item).ToList(); ComboUtil.ComboBinding(cboIsUsed, _cboUseFlag, "common_value", "common_name", "선택"); #endregion }
private void FactoryMgt_Load(object sender, EventArgs e) { this.ImeMode = ImeMode.Hangul; dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "ID", "factory_id", false, 60); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "시설군", "facility_class", true, 80); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "시설구분", "facility_type", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "시설타입", "facility_value", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "시설코드", "factory_code", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "시설명", "factory_name", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상위시설", "factory_parent", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "업체명", "company_name", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "사용유무", "factory_yn", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "수정자", "factory_uadmin", false); GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "수정시간", "factory_udate", true); GridViewUtil.SetDataGridView(dataGridView1); LoadData(); CommonCodeService Common_service = new CommonCodeService(); common_list = Common_service.GetCommonCodeAll(); var mCode = (from item in common_list where item.common_type == "facility_class_id" select item).ToList(); ComboUtil.ComboBinding <CommonVO>(cboSearchFacilityGroup, mCode, "common_value", "common_name", "미선택"); panel1.Focus(); dataGridView1.CurrentCell = null; dataGridView1.ClearSelection(); }
} //cbo.SelectedValue null처리(string) private void ComboBoxBinding() { common_service = new CommonCodeService(); bom_service = new BomService(); codelist = common_service.GetCommonCodeAll(); #region 사용여부cbo List <CommonVO> _cboUseFlag = (from item in codelist where item.common_type == "user_flag" select item).ToList(); ComboUtil.ComboBinding(cboIsUsed, _cboUseFlag, "common_value", "common_name", "선택"); List <CommonVO> _cboRequiredPlan = (from item in codelist where item.common_type == "user_flag" select item).ToList(); ComboUtil.ComboBinding(cboRequiredPlan, _cboRequiredPlan, "common_value", "common_name"); #endregion #region 품목cbo product_service = new ProductService(); List <ProductVO> product_list = new List <ProductVO>(); product_list = product_service.GetAllProducts(); ComboUtil.ComboBinding(cboProduct, product_list, "product_id", "product_name", "선택"); #endregion #region 상위품목cbo List <BomVO> bom_list = new List <BomVO>(); bom_list = bom_service.GetBomAll(); ComboUtil.ComboBinding(cboParentProduct, bom_list, "product_id", "bom_name", "-"); #endregion }
private void FacilitieInfoPop_Load(object sender, EventArgs e) { txtModifyTime.Text = string.Format("{0:yyyy-MM-dd HH:mm:ss}", today); //콤보박스 바인딩 { service = new CommonCodeService(); list = service.GetCommonCodeAll(); { //사용유무 var mCode = (from item in list where item.common_type == "user_flag" select item).ToList(); ComboUtil.ComboBinding <CommonVO>(cboIsUsed, mCode, "common_value", "common_name"); } { var mCode = (from item in list where item.common_type == "user_flag" select item).ToList(); mCode.Reverse(); ComboUtil.ComboBinding <CommonVO>(cboIsOS, mCode, "common_value", "common_name"); } R_service = new ResourceService(); var Fatory_list = R_service.GetFactoryAll(); var WH1 = (from wh1 in Fatory_list where wh1.facility_class == "창고" select wh1).ToList(); ComboUtil.ComboBinding <FactoryDB_VO>(cboUseWH, WH1, "factory_id", "factory_name", "미선택"); var WH2 = (from wh1 in Fatory_list where wh1.facility_class == "창고" select wh1).ToList(); ComboUtil.ComboBinding <FactoryDB_VO>(cboOkWH, WH2, "factory_id", "factory_name", "미선택"); var WH3 = (from wh1 in Fatory_list where wh1.facility_class == "창고" select wh1).ToList(); ComboUtil.ComboBinding <FactoryDB_VO>(cboNgWH, WH3, "factory_id", "factory_name", "미선택"); } if (mode == EditMode.Update) { MachineVO vo = this.VO; lblID.Text = VO.m_id.ToString(); lblGrCodeID.Text = VO.mgrade_id.ToString(); txtMgrade_code.Text = VO.mgrade_code; txtCodeFacility.Text = VO.m_code; txtNameFacility.Text = VO.m_name; cboUseWH.Text = VO.m_use_sector; cboOkWH.Text = VO.m_ok_sector; cboNgWH.Text = VO.m_ng_sector; cboIsUsed.Text = VO.m_yn; cboIsOS.Text = VO.m_os_yn; txtModifier.Text = VO.m_uadmin; txtModifyTime.Text = VO.m_udate; txtCheck.Text = VO.m_check; txtComment.Text = VO.m_comment; } }
private void ComboBinding() { common_service = new CommonCodeService(); codelist = common_service.GetCommonCodeAll(); List <CommonVO> _cboUseFlag = (from item in codelist where item.common_type == "user_flag" select item).ToList(); ComboUtil.ComboBinding(cboIsUsed, _cboUseFlag, "common_value", "common_name", "선택"); }
private void CompanyPop_Load(object sender, EventArgs e) { string udate = string.Format("{0:yyyy-MM-dd HH:mm:ss}", today); txtUdate.Text = udate; service = new CommonCodeService(); common_list = service.GetCommonCodeAll(); { //사용유무 var mCode = (from item in common_list where item.common_type == "vendor_type" select item).ToList(); ComboUtil.ComboBinding <CommonVO>(cboCompanyType, 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_service = new ResourceService(); u_list = R_service.GetUserAll(); ComboUtil.ComboBinding <UserVO>(cboUser, u_list, "user_id", "user_name"); } if (mode == EditMode.Update) { if (lblID.Text != "") { CompanyDB_VO vo = R_service.GetCompanyByID(Convert.ToInt32(lblID.Text)); txtCodeCompany.Text = vo.company_code; txtNameCompany.Text = vo.company_name; cboCompanyType.Text = vo.common_name; txtCEO.Text = vo.company_ceo; txtCnum.Text = vo.company_cnum; txtbtype.Text = vo.company_btype; txtGtype.Text = vo.company_gtype; cboUser.Text = vo.user_name; txtEmail.Text = vo.company_email; txtPhone.Text = vo.company_phone; txtFax.Text = vo.company_fax; cboYN.Text = vo.company_yn; txtAdmin.Text = vo.company_uadmin; txtUdate.Text = udate; txtComment.Text = vo.company_comment; txtOrder_code.Text = vo.company_order_code; } } }
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 FacilitiesPop_Load(object sender, EventArgs e) { string todayFormat = string.Format("{0:yyyy-MM-dd HH:mm:ss}", today); txtMgrade_udate.Text = todayFormat; service = new CommonCodeService(); list = service.GetCommonCodeAll(); { //사용유무 var mCode = (from item in list where item.common_type == "user_flag" select item).ToList(); ComboUtil.ComboBinding <CommonVO>(cboYN, mCode, "common_value", "common_name"); } }
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 FactoryPop_Load(object sender, EventArgs e) { { //콤보박스 업체 바인딩 R_service = new ResourceService(); Company_list = R_service.GetCompanyAll(); var C_Code = (from R_Item in Company_list select R_Item).ToList(); ComboUtil.ComboBinding <CompanyDB_VO>(cboCompany, C_Code, "company_id", "company_name", "미선택"); } service = new CommonCodeService(); Common_list = service.GetCommonCodeAll(); ComboUtil.ComboBinding <CommonVO>(cboFactoryGrade, Combo("facility_class_id"), "common_value", "common_name", "미선택"); ComboUtil.ComboBinding <CommonVO>(cboTypeFactory, Combo("facility_type"), "common_value", "common_name", "미선택"); ComboUtil.ComboBinding <CommonVO>(cboYN, Combo("user_flag2"), "common_value", "common_name"); { if (mode == EditMode.Update) { VO = R_service.GetFactoryByID(Convert.ToInt32(lblID.Text)); string Comapany_Name = (VO.company_name == null) ? "" : VO.company_name.ToString(); txtCodeFactory.Text = VO.factory_code; txtComment.Text = VO.factory_comment; txtUadmin.Text = VO.factory_uadmin; txtUdate.Text = string.Format("{0:yyyy-MM-dd HH:mm:ss}", today); txtNameFactory.Text = VO.factory_name; cboCompany.Text = Comapany_Name; cboTypeFactory.Text = VO.factory_type; txtpr.Text = VO.factory_parent; cboYN.Text = VO.factory_yn; cboFactoryGrade.Text = VO.factory_grade; } else if (mode == EditMode.Input) { txtUdate.Text = string.Format("{0:yyyy-MM-dd HH:mm:ss}", today); } } }
private void businessMgt_Load(object sender, EventArgs e) { dataGridView2.SelectionMode = DataGridViewSelectionMode.FullRowSelect; GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업체ID", "company_id", false); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업체코드", "company_code", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업체명", "company_name", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업체타입", "common_name", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업체타입", "company_type", false); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "대표자명", "company_ceo", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "사업자등록번호", "company_cnum", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업종", "company_btype", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업태", "company_gtype", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "담당자", "user_name", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "담당자id", "user_id", false); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "이메일", "company_email", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "전화번호", "company_phone", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "팩스", "company_fax", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "수정자", "company_uadmin", false); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "수정시간", "company_udate", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업체정보", "company_comment", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "사용유무", "company_yn", true); GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업체발주코드", "company_order_code", false); GridViewUtil.SetDataGridView(dataGridView2); LoadData(); common_service = new CommonCodeService(); common_list = common_service.GetCommonCodeAll(); { //사용유무 var mCode = (from item in common_list where item.common_type == "vendor_type" select item).ToList(); ComboUtil.ComboBinding <CommonVO>(cboTypeCompany, mCode, "common_value", "common_name", "미선택"); } }
private void BOR_Load(object sender, EventArgs e) { this.ImeMode = ImeMode.Hangul; GridViewUtil.SetDataGridView(dataGridView1); dgvColumnSet(); LoadData(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; // 셀 클릭하면 행 전체가 선택 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>(cboProcess, mCode, "common_value", "common_name", "미선택"); } }
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"); }
private void ComboBoxBinding() { //TODO 메서드 하나로 모듈화 ProductService product_service = new ProductService(); ResourceService resource_service = new ResourceService(); List <FactoryDB_VO> f_list = new List <FactoryDB_VO>(); common_service = new CommonCodeService(); codelist = common_service.GetCommonCodeAll(); List <UserVO> user_list = product_service.GetUserAll(); List <CommonVO> _cboUnit = (from item in codelist where item.common_type == "item_unit" select item).ToList(); ComboUtil.ComboBinding(cboProductUnit, _cboUnit, "common_value", "common_name", "선택"); List <CommonVO> _cboUseFlag = (from item in codelist where item.common_type == "user_flag" select item).ToList(); ComboUtil.ComboBinding(cboIsUsed, _cboUseFlag, "common_value", "common_name", "선택"); List <CommonVO> _commonlist = (from item in codelist where item.common_type == "item_type" select item).ToList(); ComboUtil.ComboBinding(cboProductType, _commonlist, "common_value", "common_name", "선택"); List <CommonVO> _commonmeastype = (from item in codelist where item.common_type == "meastype" select item).ToList(); ComboUtil.ComboBinding(cboMeasType, _commonmeastype, "common_value", "common_name", "선택"); #region 담당자cbo ComboUtil.ComboBinding(cboAdmin, user_list, "user_id", "user_name", "선택"); #endregion #region 입고창고cbo f_list = resource_service.GetFactoryAll(); List <FactoryDB_VO> _cboInSector = (from item in f_list where item.facility_value == "FAC200" || item.facility_value == "FAC400" select item).ToList(); ComboUtil.ComboBinding(cboInSector, _cboInSector, "factory_code", "factory_name", "선택"); #endregion #region 출고창고cbo List <FactoryDB_VO> _cboOutSector = (from item in f_list where item.facility_value == "FAC100" select item).ToList(); ComboUtil.ComboBinding(cboOutSector, _cboOutSector, "factory_code", "factory_name", "선택"); #endregion #region 발주방식cbo _commonlist = (from item in codelist where item.common_type == "order_method" select item).ToList(); ComboUtil.ComboBinding(cboOrderType, _commonlist, "common_value", "common_name", "선택"); #endregion #region 납품업체cbo List <CompanyVO> company_list = new List <CompanyVO>(); OrderService order_service = new OrderService(); company_list = order_service.GetCompanyAll("COOPERATIVE"); ComboUtil.ComboBinding(cboSupplyCompany, company_list, "company_code", "company_name", "선택"); #endregion #region 발주업체cbo company_list = order_service.GetCompanyAll("CUSTOMER"); ComboUtil.ComboBinding(cboDemandCompany, company_list, "company_code", "company_name", "선택"); List <UserVO> user_vo = new List <UserVO>(); #endregion }