public int ShipWait(ShipWaitVO vo) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; SqlTransaction trans = conn.BeginTransaction(); cmd.Transaction = trans; try { cmd.CommandText = @"insert into TBL_SHIPMENT (so_id, ship_count, ship_uadmin, ship_udate, ship_state) values(@so_id, @ship_count, @ship_uadmin, replace(convert(varchar(10), getdate(), 120), '-', '-'), '검사대기'); update TBL_SO_MASTER set so_deleted = 'Y' where so_id = @so_id"; cmd.Parameters.AddWithValue("@so_id", vo.so_id); cmd.Parameters.AddWithValue("@ship_count", vo.ship_count); cmd.Parameters.AddWithValue("@ship_uadmin", LoginVO.user.Name); cmd.ExecuteNonQuery(); cmd.CommandText = "insert into TBL_PRODUCT_STOCK (product_id, ps_odate, ps_stock) values (@product_id, replace(convert(varchar(10), getdate(), 120), '-', '-'), @ship_count)"; cmd.Parameters.AddWithValue("@product_id", vo.product_id); cmd.ExecuteNonQuery(); cmd.CommandText = "insert into TBL_SHIP_CHECKLIST (ship_id) select IDENT_CURRENT('TBL_SHIPMENT')"; cmd.ExecuteNonQuery(); trans.Commit(); conn.Close(); return(1); } catch (Exception err) { string msg = err.Message; trans.Rollback(); conn.Close(); return(0); } } }
public int ShipWait(ShipWaitVO vo) { ShipmentDAC dac = new ShipmentDAC(); return(dac.ShipWait(vo)); }