private void BtnSearch_Click(object sender, EventArgs e)
{
try
{
MaterialSearchVO vo = new MaterialSearchVO();
vo.startDate = dtpStartDate.Value.ToShortDateString();
vo.endDate = dtpEndDate.Value.ToShortDateString();
if (cboFactory.Text != "선택")
{
vo.factory_name = cboFactory.Text;
}
if (cboProductType.Text != "선택")
{
vo.product_type = cboProductType.Text;
}
if (txtProduct.Text != "")
{
vo.product_name = txtProduct.Text;
}
StockService service = new StockService();
DataTable dt = service.GetInOutHistory(vo);
SetDataGrid();
dataGridView1.DataSource = dt;
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
//조회버튼
try
{
MaterialStockVO vo = new MaterialStockVO();
if (txtProductCode.Text != "")
{
vo.product_codename = txtProductCode.Text;
}
if (cboProductType.Text != "선택")
{
vo.product_type = cboProductType.Text;
}
if (cboFactory.Text != "선택")
{
vo.factory_code = cboFactory.SelectedValue.ToString();
}
StockService service = new StockService();
DataTable dt = service.GetMaterialStockList(vo);
SetDataGrid();
dataGridView1.DataSource = dt;
// SetRowNumber();
//dataGridView1.Columns[6].DefaultCellStyle.BackColor = Color.Red;
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void MaterialStockList_Load(object sender, EventArgs e)
{
StockService service = new StockService();
try
{
//품목유형 콤보박스 바인딩
List <CommonVO> productTypeList = new List <CommonVO>();
productTypeList = service.GetProductType("item_type");
ComboUtil.ComboBinding(cboProductType, productTypeList, "common_value", "common_name", "선택");
List <FactoryComboVO> factoryList = new List <FactoryComboVO>();
factoryList = service.GetFactory();
ComboUtil.ComboBinding(cboFactory, factoryList, "factory_code", "factory_name", "선택");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
SetLoad();
SetDataGrid();
//조회버튼
try
{
MaterialStockVO vo = new MaterialStockVO();
if (txtProductCode.Text != "")
{
vo.product_codename = txtProductCode.Text;
}
if (cboProductType.Text != "선택")
{
vo.product_type = cboProductType.Text;
}
if (cboFactory.Text != "선택")
{
vo.factory_code = cboFactory.SelectedValue.ToString();
}
DataTable dt = service.GetMaterialStockList(vo);
SetDataGrid();
dataGridView1.DataSource = dt;
// SetRowNumber();
//dataGridView1.Columns[6].DefaultCellStyle.BackColor = Color.Red;
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void InOutList_Load(object sender, EventArgs e)
{
try
{
//창고 콤보박스 바인딩
StockService service = new StockService();
List <FactoryComboVO> fList = new List <FactoryComboVO>();
fList = service.GetFactory();
ComboUtil.ComboBinding(cboFactory, fList, "factory_code", "factory_name", "선택");
//품목유형 콤보박스 바인딩
List <CommonVO> productTypeList = new List <CommonVO>();
productTypeList = service.GetProductType("item_type");
ComboUtil.ComboBinding(cboProductType, productTypeList, "common_value", "common_name", "선택");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
SetLoad();
try
{
MaterialSearchVO vo = new MaterialSearchVO();
vo.startDate = dtpStartDate.Value.ToShortDateString();
vo.endDate = dtpEndDate.Value.ToShortDateString();
if (cboFactory.Text != "선택")
{
vo.factory_name = cboFactory.Text;
}
if (cboProductType.Text != "선택")
{
vo.product_type = cboProductType.Text;
}
if (txtProduct.Text != "")
{
vo.product_name = txtProduct.Text;
}
StockService service = new StockService();
DataTable dt = service.GetInOutHistory(vo);
SetDataGrid();
dataGridView1.DataSource = dt;
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void warehouseHistoryPop_Load(object sender, EventArgs e)
{
SetDataGrid();
try
{
StockService service = new StockService();
DataTable dt = service.GetMaterialHistory(vo);
dataGridView1.DataSource = dt;
}
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();
}