protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowIndex = Convert.ToInt32(e.CommandArgument);
if (e.CommandName.Equals("outbound"))
{
Good good = new Good();
good.Good_name = this.GridView1.Rows[rowIndex].Cells[0].Text;
good.Good_code = this.GridView1.Rows[rowIndex].Cells[3].Text;
GoodProvider goodProvider = new GoodProvider();
DataTable table = goodProvider.Select(good);
if (table.Rows.Count != 0)
{
Warehouse warehouse = new Warehouse();
Warehouse_info warehouse_info = new Warehouse_info();
warehouse.Good_id = Convert.ToInt32(table.Rows[0]["good_id"]);
warehouse.Warehouse_type = "出库";
warehouse_info.Good_id = Convert.ToInt32(table.Rows[0]["good_id"]);
WarehouseInfoProvider warehouseInfoProvider = new WarehouseInfoProvider();
table = warehouseInfoProvider.Select(warehouse_info);
WarehouseProvider warehouseProvider = new WarehouseProvider();
Shop shop = new Shop();
shop.Shop_id = Convert.ToInt32(this.GridView1.DataKeys[rowIndex].Value);
ShopProvider shopProvider = new ShopProvider();
if (table.Rows.Count != 0)
{
int number = Convert.ToInt32(table.Rows[0]["warehouse_info_number"]);
if (number < Convert.ToInt32(this.GridView1.Rows[rowIndex].Cells[5].Text))
{
this.Alert("仓库商品数量不足！！！");
}
warehouse_info.Warehouse_info_number = Convert.ToInt32(this.GridView1.Rows[rowIndex].Cells[5].Text);
warehouse.Warehouse_number = Convert.ToInt32(this.GridView1.Rows[rowIndex].Cells[5].Text);
warehouse.Order_id = Convert.ToInt32(id);
warehouse.Warehouse_operators = Session["LOGINED"].ToString();
warehouse.Warehouse_time = Convert.ToDateTime(DateTime.Now.ToString("HH:mm:ss"));
warehouse_info.Warehouse_info_id = Convert.ToInt32(table.Rows[0]["warehouse_info_id"]);
if (warehouseInfoProvider.UpdateOut(warehouse_info.Warehouse_info_number, warehouse_info.Warehouse_info_id))
{
if (shopProvider.Delete(shop))
{
if (warehouseProvider.Insert(warehouse))
{
this.Alert("出库成功！");
Shop shop1 = new Shop();
shop.Order_id = Convert.ToInt32(id);
ShopProvider provider = new ShopProvider();
this.ListPager1.RecordCount = provider.GetSize(shop1);
this.BindSource(0);
}
}
}
}
}
else
{
this.Alert("没有此商品！！！");
}
}
}
/// <summary>
/// 修改库存的内容
/// </summary>
/// <param name="warehouse">新的库存</param>
/// <returns>修改成功返回true,否则返回false</returns>
public bool Update(Warehouse_info warehouse)
{
if (warehouse.Warehouse_info_id == 0)
{
return(false);
}
string commandText = " UPDATE t_warehouse_info " +
" SET good_id=@good_id,warehouse_id=@warehouse_id,warehouse_info_number=@warehouse_info_number ,place_id=@place_id " +
" WHERE warehouse_info_id=@warehouse_info_id ";
DataParameter parmID = new DataParameter();
parmID.ParameterName = "@warehouse_info_id";
parmID.DbType = DbType.Int32;
parmID.Value = warehouse.Warehouse_info_id;
DataParameter parmGood = new DataParameter();
parmGood.ParameterName = "@good_id";
parmGood.DbType = DbType.Int32;
parmGood.Value = warehouse.Good_id;
DataParameter parmWarehouse_id = new DataParameter();
parmWarehouse_id.ParameterName = "@warehouse_id";
parmWarehouse_id.DbType = DbType.Int32;
parmWarehouse_id.Value = warehouse.Warehouse_id;
DataParameter parmNumber = new DataParameter();
parmNumber.ParameterName = "@warehouse_info_number";
parmNumber.DbType = DbType.Int32;
parmNumber.Value = warehouse.Warehouse_info_number;
DataParameter parmPlaceID = new DataParameter();
parmPlaceID.ParameterName = "@place_id";
parmPlaceID.DbType = DbType.Int32;
parmPlaceID.Value = warehouse.Place_id;
IList parameters = new ArrayList();
parameters.Add(parmID);
parameters.Add(parmGood);
parameters.Add(parmWarehouse_id);
parameters.Add(parmNumber);
parameters.Add(parmPlaceID);
return(this.handler.ExecuteCommand(commandText, parameters));
}
/// <summary>
/// 添加一条新的库存
/// </summary>
/// <param unit="warehouse">新的库存</param>
/// <returns>添加成功返回true,否则返回false</returns>
public bool Insert(Warehouse_info warehouse)
{
if (warehouse.Warehouse_info_number == 0)
{
return(false);
}
try
{
string commandText = "INSERT INTO t_warehouse_info VALUES (@good_id,@warehouse_id,@warehouse_info_number,@place_id)";
DataParameter parmGood = new DataParameter();
parmGood.ParameterName = "@good_id";
parmGood.DbType = DbType.Int32;
parmGood.Value = warehouse.Good_id;
DataParameter parmWarehouse_id = new DataParameter();
parmWarehouse_id.ParameterName = "@warehouse_id";
parmWarehouse_id.DbType = DbType.Int32;
parmWarehouse_id.Value = warehouse.Warehouse_id;
DataParameter parmNumber = new DataParameter();
parmNumber.ParameterName = "@warehouse_info_number";
parmNumber.DbType = DbType.Int32;
parmNumber.Value = warehouse.Warehouse_info_number;
DataParameter parmPlaceID = new DataParameter();
parmPlaceID.ParameterName = "@place_id";
parmPlaceID.DbType = DbType.Int32;
parmPlaceID.Value = warehouse.Place_id;
IList parameters = new ArrayList();
parameters.Add(parmGood);
parameters.Add(parmWarehouse_id);
parameters.Add(parmNumber);
parameters.Add(parmPlaceID);
return(this.handler.ExecuteCommand(commandText, parameters));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 利用分页机制,根据指定的过滤条件查询库存
/// </summary>
/// <param name="warehouse">过滤条件</param>
/// <param name="start">起始行</param>
/// <param name="max">获取记录行的总数</param>
/// <returns></returns>
public DataTable Select(Warehouse_info warehouse, int start, int max)
{
StringBuilder commandText = new StringBuilder();
commandText.Append("SELECT * FROM t_warehouse_info WHERE 1=1 ");
IList parameters = new ArrayList();
if (warehouse.Good_id != 0)
{
commandText.Append(" AND good_id=@good_id ");
DataParameter parmID = new DataParameter();
parmID.ParameterName = "@good_id";
parmID.DbType = DbType.Int32;
parmID.Value = warehouse.Good_id;
parameters.Add(parmID);
}
return(this.handler.Query(commandText.ToString(), parameters, start, max));
}
/// <summary>
/// 删除指定的库存记录
/// </summary>
/// <param name="warehouse">将要被删除的库存记录</param>
/// <returns>删除成功返回true,否则返回false</returns>
public bool Delete(Warehouse_info warehouse)
{
if (warehouse.Warehouse_id == 0)
{
return(false);
}
string commandText = "DELETE FROM t_warehouse_info WHERE warehouse_info_id=@warehouse_info_id";
DataParameter parmID = new DataParameter();
parmID.ParameterName = "@warehouse_info_id";
parmID.DbType = DbType.Int32;
parmID.Value = warehouse.Warehouse_info_id;
IList parameters = new ArrayList();
parameters.Add(parmID);
return(this.handler.ExecuteCommand(commandText, parameters));
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowIndex = Convert.ToInt32(e.CommandArgument);
if (e.CommandName.Equals("warehousing"))
{
Good good = new Good();
good.Good_name = this.GridView1.Rows[rowIndex].Cells[0].Text;
////good.Good_code = this.GridView1.Rows[rowIndex].Cells[3].Text;
GoodProvider goodProvider = new GoodProvider();
DataTable table = goodProvider.Select(good);
if (table.Rows.Count != 0)
{
Warehouse warehouse = new Warehouse();
Warehouse_info warehouse_info = new Warehouse_info();
warehouse.Good_id = Convert.ToInt32(table.Rows[0]["good_id"]);
warehouse.Warehouse_type = "入库";
warehouse_info.Good_id = Convert.ToInt32(table.Rows[0]["good_id"]);
WarehouseInfoProvider warehouseInfoProvider = new WarehouseInfoProvider();
table = warehouseInfoProvider.Select(warehouse_info);
WarehouseProvider warehouseProvider = new WarehouseProvider();
Shop shop = new Shop();
shop.Shop_id = Convert.ToInt32(this.GridView1.DataKeys[rowIndex].Value);
ShopProvider shopProvider = new ShopProvider();
if (table.Rows.Count != 0)
{
warehouse_info.Warehouse_info_number = Convert.ToInt32(this.GridView1.Rows[rowIndex].Cells[5].Text);
warehouse.Warehouse_number = Convert.ToInt32(this.GridView1.Rows[rowIndex].Cells[5].Text);
warehouse.Order_id = Convert.ToInt32(id);
warehouse.Warehouse_operators = Session["LOGINED"].ToString();
warehouse.Warehouse_time = Convert.ToDateTime(DateTime.Now.ToString("HH:mm:ss"));
warehouse_info.Warehouse_info_id = Convert.ToInt32(table.Rows[0]["warehouse_info_id"]);
if (warehouseInfoProvider.Update(warehouse_info.Warehouse_info_number, warehouse_info.Warehouse_info_id))
{
if (shopProvider.Delete(shop))
{
if (warehouseProvider.Insert(warehouse))
{
this.Alert("入库成功！");
Shop shop1 = new Shop();
shop.Contrac_id = Convert.ToInt32(id);
ContractShopProvider provider = new ContractShopProvider();
this.ListPager1.RecordCount = provider.GetSize(shop1);
this.BindSource(0);
if (this.ListPager1.RecordCount > 0)
{
ContractProvider contractProvider = new ContractProvider();
contractProvider.Update(id, "已部分收货");
}
else
{
ContractProvider contractProvider = new ContractProvider();
contractProvider.Update(id, "已全部收货");
}
}
}
}
}
else
{
warehouse_info.Warehouse_id = warehouseProvider.GetSize() + 1;
warehouse_info.Warehouse_info_number = Convert.ToInt32(this.GridView1.Rows[rowIndex].Cells[5].Text);
warehouse.Warehouse_number = Convert.ToInt32(this.GridView1.Rows[rowIndex].Cells[5].Text);
warehouse.Order_id = Convert.ToInt32(id);
warehouse.Warehouse_operators = Session["LOGINED"].ToString();
warehouse.Warehouse_time = Convert.ToDateTime(DateTime.Now.Date);
Place place = new Place();
place.Place_state = "空闲";
PlaceProvider placeProvider = new PlaceProvider();
table = placeProvider.Select(place);
warehouse_info.Place_id = Convert.ToInt32(table.Rows[0]["place_id"]);
if (warehouseInfoProvider.Insert(warehouse_info))
{
if (shopProvider.Delete(shop))
{
if (warehouseProvider.Insert(warehouse))
{
this.Alert("入库成功！");
Shop shop1 = new Shop();
shop.Contrac_id = Convert.ToInt32(id);
ContractShopProvider provider = new ContractShopProvider();
this.ListPager1.RecordCount = provider.GetSize(shop1);
this.BindSource(0);
Contract contract = new Contract();
if (this.ListPager1.RecordCount > 0)
{
ContractProvider contractProvider = new ContractProvider();
contractProvider.Update(id, "已部分收货");
}
else
{
ContractProvider contractProvider = new ContractProvider();
contractProvider.Update(id, "已全部收货");
}
}
}
}
}
}
}
}
/// <summary>
/// 根据指定的过滤条件查询库存
/// </summary>
/// <param name="warehouse">过滤条件</param>
/// <returns></returns>
public DataTable Select(Warehouse_info warehouse)
{
return(this.Select(warehouse, 0, 0));
}
