/// <summary>
/// 입고 처리
/// </summary>
/// <param name="vo"></param>
/// <returns></returns>
public bool InsertWareHouse(WareHouseVO vo)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.Connection.Open();
SqlTransaction tran = cmd.Connection.BeginTransaction();
try
{
cmd.CommandText = "SP_WAREHOUSE_INSERT";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Transaction = tran;
cmd.Parameters.AddWithValue("@order_no", vo.order_no);
cmd.Parameters.AddWithValue("@order_seq", vo.order_seq);
cmd.Parameters.AddWithValue("@warehouse_date", vo.warehouse_date);
cmd.Parameters.AddWithValue("@warehouse_quantity", vo.warehouse_quantity);
cmd.Parameters.AddWithValue("@storage_id", vo.storage_id);
int num = Convert.ToInt32(cmd.ExecuteScalar());
cmd.CommandText = "SP_STOCK_UPDATE";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@warehouse_no", num);
cmd.Parameters.AddWithValue("@storage_id", vo.storage_id);
cmd.Parameters.AddWithValue("@order_no", vo.order_no);
cmd.Parameters.AddWithValue("@product_id", vo.product_id);
cmd.Parameters.AddWithValue("@stock_quantity", vo.warehouse_quantity);
cmd.ExecuteNonQuery();
tran.Commit();
// SELECT od.order_no ,od.order_seq ,(SELECT storage_name FROM TBL_STORAGE WHERE storage_id = w.storage_id) storage_name, od.product_id , (SELECT product_name FROM TBL_PRODUCT WHERE product_id = od.product_id) product_name
// ,due_date, w.warehouse_quantity , stock_quantity
//, (SELECT final_regist_time FROM TBL_ORDER WHERE order_no = od.order_no) final_regist_time
//, (SELECT final_regist_employee FROM TBL_ORDER WHERE order_no = od.order_no) final_regist_employee
// FROM TBL_ORDER_DETAIL od INNER JOIN TBL_WAREHOUSE w ON od.order_no = w.order_no
// INNER JOIN TBL_STOCK s ON s.stock_no = w.
// where od.order_no = 4 and od.order_seq = 4
// ORDER BY final_regist_time desc
return(true);
}
catch (Exception err)
{
tran.Rollback();
throw err;
}
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
WareHouseVO vo = new WareHouseVO();
vo.order_no = order_no;
vo.product_id = product_id;
vo.warehouse_date = Convert.ToDateTime(dtpIN.Value.ToShortDateString());
vo.warehouse_quantity = Convert.ToInt32(txtquantity.Text);
vo.storage_id = Convert.ToInt32(cboStorage.SelectedValue);
vo.order_seq = order_seq;
OrderService service = new OrderService();
if (service.InsertWareHouse(vo))
{
MessageBox.Show("입고 처리 되었습니다.");
this.DialogResult = DialogResult.OK;
this.Close();
}
}
public bool InsertWareHouse(WareHouseVO vo)
{
return(dac.InsertWareHouse(vo));
}
