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 InitControl()
{
OrderService order_service = new OrderService();
#region 업체cbo
List <CompanyVO> company_list = order_service.GetCompanyAll("CUSTOMER");
ComboUtil.ComboBinding(cboCompany, company_list, "company_id", "company_name", "전체");
#endregion
price_service = new PriceService();
pricelist = price_service.GetPriceInfo("COOPERATIVE");
dgvMUPM.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvMUPM.Columns.Add("Number", "No.");
dgvMUPM.Columns[0].Width = 53;
dgvMUPM.Columns[0].Visible = false;
#region DGV바인딩
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "업체", "company_code", true, 170, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "업체명", "company_name", true, 200, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "품목", "product_codename", true, 180, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "품명", "product_name", true, 240, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "단위", "product_unit", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "현재단가", "price_present", true, 150, DataGridViewContentAlignment.MiddleRight, true);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "이전단가", "price_past", true, 150, DataGridViewContentAlignment.MiddleRight, true);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "시작일", "price_sdate", true, 150, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "종료일", "price_edate", true, 150, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "비고", "price_comment", true, 170, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "사용유무", "price_yn", true, 100, DataGridViewContentAlignment.MiddleCenter);
#endregion
GridViewUtil.SetDataGridView(dgvMUPM);
dgvMUPM.AutoGenerateColumns = false;
dgvMUPM.DataSource = pricelist;
}
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 SODialog_Load(object sender, EventArgs e)
{
txtOutput.Enabled = false;
list = new List <CompanyVO>();
OrderService service = new OrderService();
list = service.GetCompanyAll("cooperative");
ComboUtil.ComboBinding(cbCompany, list, "company_code", "company_name", "선택");
ComboUtil.ComboBinding(cbDestination, list, "company_code", "company_name");
List <ProductVO> pList = new List <ProductVO>();
pList = service.GetProductList();
ComboUtil.ComboBinding(cbProduct, pList, "product_codename", "product_name", "선택");
if (edit == EditMode.Update)
{
//수정 데이터 바인딩
txtSOWO.Text = vo.so_wo_id;
cbProduct.SelectedValue = vo.product_codename;
cbCompany.SelectedValue = vo.company_code;
dtpsDate.Value = Convert.ToDateTime(vo.so_edate);
txtOrder.Text = vo.so_pcount.ToString();
txtOutput.Text = vo.so_ocount.ToString();
txtCancel.Text = vo.so_ccount.ToString();
txtComment.Text = vo.so_comment;
}
}
private void OrderList_Load(object sender, EventArgs e)
{
dtpStartDate.Value = DateTime.Now;
dtpEndDate.Value = DateTime.Now.AddMonths(+1);
OrderService service = new OrderService();
//발주업체 콤보박스 바인딩
CompanyList = new List <CompanyVO>();
try
{
CompanyList = service.GetCompanyAll("customer");
ComboUtil.ComboBinding(cboCompany, CompanyList, "company_code", "company_name", "선택");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
//PurchasingService service = new PurchasingService();
//dt = service.GetOrderList();
SetDataGrid();
//SetRowNumber();
}
private void MaterialReceiving_Load(object sender, EventArgs e)
{
dtpStartDate.Value = DateTime.Now;
dtpEndDate.Value = DateTime.Now.AddMonths(+1);
//발주업체, 주문상태 콤보박스 바인딩
OrderService oService = new OrderService();
MaterialLedgerService mService = new MaterialLedgerService();
CompanyList = new List <CompanyVO>();
orderStateList = new List <OrderStateVO>();
try
{
CompanyList = oService.GetCompanyAll("customer");
ComboUtil.ComboBinding(cboCompany, CompanyList, "company_code", "company_name", "선택");
orderStateList = mService.GetOrderState();
ComboUtil.ComboBinding(cboOrderState, orderStateList, "state_code", "state_name", "선택");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
SetDataGridWatingReceiving();
SetDataGridResult();
}
private void SalesMaster_Load(object sender, EventArgs e)
{
//납기일 초기화
dtpStartDate.Value = DateTime.Now;
dtpEndDate.Value = DateTime.Now.AddMonths(+1).AddDays(-1);
//등록일 초기화
dtpRegFirstDate.Value = DateTime.Now.AddMonths(-1);
dtpRegLastDate.Value = DateTime.Now;
OrderService service = new OrderService();
//List<SOMasterVO> list = service.GetSOMasterAll();
//고객사, 도착지 콤보박스 바인딩
CompanyList = new List <CompanyVO>();
try
{
//datagridview
SetDataGrid();
CompanyList = service.GetCompanyAll("cooperative");
ComboUtil.ComboBinding(cboCompany, CompanyList, "company_code", "company_name", "선택");
//DestinationList = new List<CompanyVO>();
//DestinationList = service.GetCompanyAll("cooperative");
//ComboUtil.ComboBinding(cboDestination, DestinationList, "company_code", "company_name", "선택");
//조회 버튼
WhereSoVO vo = new WhereSoVO();
vo.startDate = dtpStartDate.Value.ToShortDateString();
vo.endDate = dtpEndDate.Value.ToShortDateString();
vo.RegStartDate = dtpRegFirstDate.Value.ToShortDateString();
vo.RegEndDate = dtpRegLastDate.Value.ToShortDateString();
if (cboCompany.Text != "선택")
{
vo.CompanyName = cboCompany.Text;
}
try
{
List <SOMasterVO> list = service.GetSOMasterAll(vo);
dataGridView1.DataSource = list;
SetBottomStatusLabel("조회가 완료되었습니다.");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
SetBottomStatusLabel("조회에 실패하였습니다. 다시 시도하여 주십시오.");
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void MaterialReceivingList_Load(object sender, EventArgs e)
{
try
{
//발주업체 콤보박스 바인딩
OrderService service = new OrderService();
List <CompanyVO> CompanyList = new List <CompanyVO>();
CompanyList = service.GetCompanyAll("customer");
ComboUtil.ComboBinding(cboCompany, CompanyList, "company_code", "company_name", "선택");
StockService sService = new StockService();
List <FactoryComboVO> fList = new List <FactoryComboVO>();
fList = sService.GetInFactory();
ComboUtil.ComboBinding(cboFactory, fList, "factory_code", "factory_name", "선택");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
SetLoad();
SetDataGrid();
}
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
}