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);
}
}
public DataTable GetMaterialStockList(MaterialStockVO vo)
{
using (SqlCommand cmd = new SqlCommand())
{
StringBuilder sql = new StringBuilder();
//sql.Append($"select w_id, plan_id, factory_code, factory_name, p.product_codename, product_name, w_count_present, common_name as product_type from TBL_WAREHOUSE w inner join TBL_FACTORY f on w.factory_id = f.factory_id inner join TBL_PRODUCT p on p.product_id = w.product_id inner join TBL_COMMON_CODE c on c.common_value = p.product_type where 1=1");
sql.Append($"select w.factory_id, factory_code,p.product_id,sum(w_count_present) as w_count_present, factory_name, product_codename, product_name, common_name as product_type from TBL_WAREHOUSE w inner join TBL_FACTORY f on w.factory_id = f.factory_id inner join TBL_PRODUCT p on p.product_id = w.product_id inner join TBL_COMMON_CODE c on c.common_value = p.product_type where 1=1");
if (vo.factory_code != null)
{
sql.Append(" and f.factory_code = @factory_code");
cmd.Parameters.AddWithValue("@factory_code", vo.factory_code);
}
if (vo.product_type != null)
{
sql.Append($" and common_name = @product_type");
cmd.Parameters.AddWithValue("@product_type", vo.product_type);
}
if (vo.product_codename != null)
{
sql.Append($" and product_codename like '%{vo.product_codename}%'");
//cmd.Parameters.AddWithValue("@product_codename", vo.order_id);
}
sql.Append($" group by w.factory_id, p.product_id, factory_name, factory_code, product_codename, product_name, common_name");
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = sql.ToString();
cmd.CommandType = CommandType.Text;
DataTable dataTable = new DataTable();
cmd.Connection.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dataTable);
da.Dispose();
cmd.Connection.Close();
return(dataTable);
}
}
public DataTable GetMaterialStockList(MaterialStockVO vo)
{
StockDAC dac = new StockDAC();
return(dac.GetMaterialStockList(vo));
}
