public DataTable GetMaterialHistory(StockVO 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 wh_id, w.w_id, w.product_id, product_name, product_codename, wh_product_count, wh_udate, wh_comment, common_name ,plan_id from TBL_WAREHOUSE_HIS h inner join TBL_WAREHOUSE w on h.w_id = w.w_id inner join TBL_PRODUCT p on p.product_id = w.product_id inner join TBL_COMMON_CODE c on c.common_value = h.wh_category inner join TBL_FACTORY f on f.factory_id = w.factory_id where p.product_codename = @product_codename and factory_code = @factory_code order by wh_id desc");
cmd.Parameters.AddWithValue("@product_codename", vo.product_codename);
cmd.Parameters.AddWithValue("@factory_code", vo.factory_code);
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 bool UpdateStock(StockVO stock)
{
string query = "UpdateStock";
SqlParameter[] sqlp = { new SqlParameter("stock_ID", stock.Stock_ID), new SqlParameter("stock_count", stock.Stock_Count) };
return(conn.SendExqueteQuery(query, sqlp));
}
public bool InsertStock(StockVO stock)
{
string query = "insert_stock";
SqlParameter[] sqlp = { new SqlParameter("stock_ID", stock.Stock_ID), new SqlParameter("pro_ID", stock.Pro_Id), new SqlParameter("seller_no", stock.Seller_no), new SqlParameter("stock_size", stock.Stock_Size), new SqlParameter("stock_count", stock.Stock_Count) };
return(conn.SendExqueteQuery(query, sqlp));
}
private void btnInsertStock_Click(object sender, EventArgs e)
{
StockVO stock = new StockVO(lblPro_No.Text + "_" + cmbSize.Text, lblPro_No.Text, Form1.CompanyNo, cmbSize.Text, (int)numStockCount.Value);
try
{
stockDao.InsertStock(stock);
MessageBox.Show("사이즈 추가 성공!");
}
catch (Exception)
{
MessageBox.Show("이미 존재하는 사이즈 입니다.");
}
}
private void btnHistory_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count == 0)
{
return;
}
StockVO vo = new StockVO();
vo.product_codename = dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
vo.factory_code = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
warehouseHistoryPop frm = new warehouseHistoryPop(vo);
frm.ShowDialog();
}
private void btnSubmit_Click(object sender, EventArgs e)
{
stock = null;
Product pro = new Product();
pro.Pro_ID = lblPro_No.Text;
foreach (var item in cat_kinds)
{
if (item.Cat_Kind == cmbCatID.Text)
{
pro.Cat_ID = item.Cat_ID;
}
}
pro.Pro_Name = txtProName.Text;
pro.Pro_Price = int.Parse(txtProPrice.Text);
pro.Main_Comment = txtMainComment.Text;
pro.Sub_Comment = txtSubComment.Text;
if (proPic.Image != null)
{
pro.Main_Image = "https://jinweb.azurewebsites.net/img/" + pathFile;
}
else if (proPic.Image != null && !string.IsNullOrEmpty(row.Cells["main_image"].Value.ToString()))
{
pro.Main_Image = row.Cells["main_image"].Value.ToString();
}
else if (proPic.Image == null)
{
pro.Main_Image = "";
}
pro.Pro_Discount = int.Parse(txtDiscount.Text);
pro.Pro_Gender = cmbGender.Text;
foreach (var item in lstStock)
{
if (lblPro_No.Text + "_" + cmbSize.Text == item.Stock_ID)
{
stock = item;
break;
}
}
if (cmbSize.SelectedIndex > -1 && stock != null)
{
stock.Stock_Count = (int)numStockCount.Value;
}
if (string.IsNullOrEmpty(cmbSize.Text))
{
//try
{
pDao.UpdateProduct(pro);
MessageBox.Show("수정 성공");
}
//catch (Exception)
{
//MessageBox.Show("수정 실패");
}
}
else
{
try
{
if (pDao.UpdateProduct(pro))
{
if (stockDao.UpdateStock(stock))
{
UploadImgToFTP();
MessageBox.Show("수정 성공");
}
}
}
catch (Exception)
{
MessageBox.Show("수정 실패");
}
}
this.Close();
}
public warehouseHistoryPop(StockVO vo)
{
InitializeComponent();
this.vo = vo;
}
public DataTable GetMaterialHistory(StockVO vo)
{
StockDAC dac = new StockDAC();
return(dac.GetMaterialHistory(vo));
}
