/// <summary> /// 修改项目 /// </summary> /// <param name="warehouse">需修改项目</param> public int UpdateWarehouse(Warehouse_Warehouse warehouse) { string cmdText = @"UPDATE [EasySystem].[dbo].[Warehouse_Warehouse] SET [WarehouseName] = @WarehouseName WHERE [WarehouseID] = @WarehouseID"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@WarehouseName", warehouse.WarehouseName), new SqlParameter("@WarehouseID", warehouse.WarehouseID) }; return(DBHelper.ExecuteNonQuery(cmdText, parameters, CommandType.Text)); }
/// <summary> /// 新增项目 /// </summary> /// <param name="warehouse">待新增项目</param> public int AddWarehouse(Warehouse_Warehouse warehouse) { int result = 0; string cmdText = @"PROC_AddWarehouse"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@WarehouseName", warehouse.WarehouseName), new SqlParameter("@Result", DbType.Int32) }; parameters[4].Direction = ParameterDirection.Output; DBHelper.ExecuteNonQuery(cmdText, parameters, CommandType.StoredProcedure); if (parameters[1].Value != null) { warehouse.WarehouseID = Convert.ToInt32(parameters[1].Value); return(1); } return(-1); }
/// <summary> /// 获取项目列表 /// </summary> public List <Warehouse_Warehouse> GetWarehouses() { List <Warehouse_Warehouse> Warehouses = null; string cmdText = "SELECT * FROM Warehouse_Warehouse"; using (SqlDataReader reader = DBHelper.ExecuteReader(cmdText, CommandType.Text)) { if (reader.HasRows) { Warehouses = new List <Warehouse_Warehouse>(); while (reader.Read()) { Warehouse_Warehouse warehouse = new Warehouse_Warehouse() { WarehouseID = Convert.ToInt32(reader["WarehouseID"]), WarehouseName = reader["WarehouseName"] as string }; Warehouses.Add(warehouse); } } } return(Warehouses); }