/// <summary> /// 根据仓库ID绑定库位 /// </summary> /// <returns></returns> public void GetDepotSeat(System.Web.UI.WebControls.DropDownList ddlDepotSeat, string wID) { ddlDepotSeat.Items.Clear(); foreach (DataRow dr in DepotSeatDAL.GetDepotSeat(wID).Rows) { ddlDepotSeat.Items.Add(new System.Web.UI.WebControls.ListItem(dr["SeatName"].ToString(), dr["DepotSeatID"].ToString())); } }
//绑定库位 protected void ddlcangku_SelectedIndexChanged(object sender, EventArgs e) { if (!string.IsNullOrEmpty(ddlcangku.SelectedValue) && ddlcangku.SelectedValue != "-2") { int id = Convert.ToInt32(ddlcangku.SelectedValue); // DepotSeatDAL depot = new DepotSeatDAL(); ddlkuwei.DataSource = DepotSeatDAL.GetDepotSeat(id.ToString()); ddlkuwei.DataValueField = "DepotSeatID"; ddlkuwei.DataTextField = "SeatName"; ddlkuwei.DataBind(); } else { ddlkuwei.Items.Clear(); ddlkuwei.Items.Add(new ListItem(GetTran("000589", "无库位"), "-2")); } }
private void Pagebind() { drpwarehouse.DataSource = WareHouseDAL.GetProductWareHouseInfo(); drpwarehouse.DataTextField = "Name"; drpwarehouse.DataValueField = "ID"; drpwarehouse.DataBind(); if (drpwarehouse.DataSource != null) { drpwarehouse.Attributes.Add("onchange", "showNext(this.options[selectedIndex].value)"); drpdepotseat.Attributes.Add("onchange", "getdepotseat()"); } if (drpwarehouse.Items.Count > 0) { drpdepotseat.DataSource = DepotSeatDAL.GetDepotSeats(drpwarehouse.SelectedItem.Value.ToString()); drpdepotseat.DataTextField = "Name"; drpdepotseat.DataValueField = "ID"; drpdepotseat.DataBind(); } }
//绑定出库库位 protected void ddloutWareHouse_SelectedIndexChanged(object sender, EventArgs e) { if (!string.IsNullOrEmpty(ddloutWareHouse.SelectedValue) && ddloutWareHouse.SelectedValue != "-1") { //绑定入库库位 int id = Convert.ToInt32(ddloutWareHouse.SelectedValue); // DepotSeatDAL depot = new DepotSeatDAL(); this.ddloutDepotSeatID.DataSource = DepotSeatDAL.GetDepotSeat(id.ToString()); this.ddloutDepotSeatID.DataTextField = "SeatName"; this.ddloutDepotSeatID.DataValueField = "DepotSeatID"; this.ddloutDepotSeatID.DataBind(); } else { ddloutDepotSeatID.Items.Clear(); ddloutDepotSeatID.Items.Add(new ListItem(GetTran("000589", "无库位"), "-1")); } int cID = Convert.ToInt32(DropCurrery.SelectedItem.Value); gridBind(cID, Convert.ToInt32(ddloutWareHouse.SelectedValue), Convert.ToInt32(ddloutDepotSeatID.SelectedValue)); }
/// <summary> /// 更新指定的库位信息 /// </summary> /// <param name="depotSeatModel">库位模型</param> /// <returns>返回更新指定的库位信息所影响的行数</returns> public static int UpdDepotSeatByID(DepotSeatModel depotSeatModel) { return(DepotSeatDAL.UpdDepotSeatByID(depotSeatModel)); }
/// <summary> /// 删除指定的库位信息根据仓库编号 /// </summary> /// <param name="id">主键ID</param> /// <returns>返回删除指定的库位信息所影响的行数</returns> public static int DelDepotSeatByWareHouse(int WareHouseID) { return(DepotSeatDAL.DelDepotSeatByWareHouse(WareHouseID)); }
/// <summary> /// 获得当前仓库的库位数量 /// </summary> /// <param name="WareHoseID">仓库ID /// <returns></returns> public static int getDepotSeatCountByWareHoseID(int WareHoseID) { return(DepotSeatDAL.getDepotSeatCountByWareHoseID(WareHoseID)); }
/// <summary> /// 删除指定的库位信息 /// </summary> /// <param name="id">主键ID</param> /// <returns>返回删除指定的库位信息所影响的行数</returns> public static int DelDepotSeatByID(int id) { return(DepotSeatDAL.DelDepotSeatByID(id)); }
/// <summary> /// 向库位表中插入记录 /// </summary> /// <param name="depotSeatModel">库位模型</param> /// <returns>返回向库位表中插入记录所影响的行数</returns> public static int AddDepotSeat(DepotSeatModel depotSeatModel) { return(DepotSeatDAL.AddDepotSeat(depotSeatModel)); }
/// <summary> /// 根据仓库id返会库位名称,返回的是一个xml格式的字符串 /// </summary> /// <param name="WareHouseID"></param> /// <returns></returns> public static DataTable GetDepotSeat(string WareHouseID) { return(DepotSeatDAL.GetDepotSeat(WareHouseID)); }
/// <summary> /// 获取指定的库位信息 /// </summary> /// <param name="id">主键ID</param> /// <returns>返回DataTable对象</returns> public static DataTable GetDepotSeatInfoByID(int id) { return(DepotSeatDAL.GetDepotSeatInfoByID(id)); }
/// <summary> /// Judge the DepotSeatId whether has operation by Id before delete /// </summary> /// <param name="Id">Id</param> /// <returns>Return the counts of the DepotSeat by Id</returns> public static int DepotSeatIdWhetherHasOperation(int Id) { return(DepotSeatDAL.DepotSeatIdWhetherHasOperation(Id)); }
/// <summary> /// 根据仓库ID绑定库位 /// </summary> /// <returns></returns> public static DataTable GetDepotSeat(string wID) { return(DepotSeatDAL.GetDepotSeat(wID)); }
/// <summary> /// 通过仓库ID获取库位信息 /// </summary> /// <param name="wareHouseID">仓库ID</param> /// <returns>返回DataTable对象</returns> public static DataTable GetDepotSeatInfoByWareHouaseID(int wareHouseID) { return(DepotSeatDAL.GetDepotSeatInfoByWareHouaseID(wareHouseID)); }
public DataTable getDepotseat(string houseid) { DataTable talbe = DepotSeatDAL.GetDepotSeats(houseid); return(talbe); }
/// <summary> /// 获取库位信息 /// </summary> /// <returns>返回DataTable对象</returns> public static DataTable GetDepotSeatInfo() { return(DepotSeatDAL.GetDepotSeatInfo()); }
/// <summary> /// 获取最大的库位ID /// </summary> /// <returns>返回最大的库位ID</returns> public static int GetMaxDepotSeatIDFromDepotSeat() { return(DepotSeatDAL.GetMaxDepotSeatIDFromDepotSeat()); }
/// <summary> /// Judge the DepotSeatId whether exist by Id before delete or update /// </summary> /// <param name="Id">Id</param> /// <returns>Return the counts of the DepotSeat by Id</returns> public static int DepotSeatIdIsExist(int Id) { return(DepotSeatDAL.DepotSeatIdIsExist(Id)); }
/// <summary> /// 获取对应库位xml字符串 /// </summary> /// <returns></returns> public static string GetDepotSeatXML(string idvalue) { return(DepotSeatDAL.GetDepotSeatXML(idvalue)); }
/// <summary> /// 获取指定的库位名称的行数 /// </summary> /// <param name="depotSeatModel">库位模型</param> /// <returns>返回指定的库位名称的行数</returns> public static int GetSeatNameCountByIDWareHouseIDSeatName(DepotSeatModel depotSeatModel) { return(DepotSeatDAL.GetSeatNameCountByIDWareHouseIDSeatName(depotSeatModel)); }