private void BindText() { Place place = new Place(); place.Place_id = Convert.ToInt32(id); PlaceProvider provider = new PlaceProvider(); DataTable table = new DataTable(); table = provider.Select(place); this.txt_name.Text = table.Rows[0]["place_num"].ToString(); this.ddl_state.SelectedValue = table.Rows[0]["place_state"].ToString(); }
private int IsSame() { Place place = this.AddProduct(); PlaceProvider provider = new PlaceProvider(); place.Place_num = this.txt_name.Text; DataTable table = new DataTable(); table = provider.Select(place); if (table.Rows.Count != 0) { this.Alert("该库位编号已经存在,请重新输入!!!"); return(1); } else { return(0); } }
/// <summary> /// 绑定Place信息的数据源 /// </summary> private void BindSource(int start, string name) { if (name != null) { Place place = new Place(); place.Place_num = name; PlaceProvider provider = new PlaceProvider(); DataTable table = provider.Select(place, start, this.ListPager1.PageSize); this.GridView1.DataSource = table.DefaultView; this.GridView1.DataBind(); } else { PlaceProvider provider = new PlaceProvider(); DataTable table = provider.GetAll(start, this.ListPager1.PageSize); this.GridView1.DataSource = table.DefaultView; this.GridView1.DataBind(); } }
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, "已全部收货"); } } } } } } } }