/// <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)); }