/// <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));
}
