/// <summary>
/// 获取指定的库位名称的行数
/// </summary>
/// <param name="depotSeatModel">库位模型</param>
/// <returns>返回指定的库位名称的行数</returns>
public static int GetSeatNameCountByWareHouseIDSeatName(DepotSeatModel depotSeatModel)
{
SqlParameter[] sparams = new SqlParameter[]
{
new SqlParameter("@wareHouseID", SqlDbType.Int),
new SqlParameter("@seatName", SqlDbType.VarChar, 50)
};
sparams[0].Value = depotSeatModel.WareHouseID;
sparams[1].Value = depotSeatModel.SeatName;
return(Convert.ToInt32(DBHelper.ExecuteScalar("GetSeatNameCountByWareHouseIDSeatName", sparams, CommandType.StoredProcedure)));
}
/// <summary>
/// 根据仓库id返会库位名称，返回的是一个xml格式的字符串
/// </summary>
/// <param name="WareHouseID"></param>
/// <returns></returns>
//public string GetDepotSeat(string WareHouseID)
//{
// SqlDataReader dr = DBHelper.ExecuteReader("select SeatName from dbo.DepotSeat where WareHouseID='"+WareHouseID+"' for xml raw('Row'),elements,root('Root')");
// dr.Read();
// string xmlstr=dr[0].ToString();
// dr.Close();
// return xmlstr;
//}
/// <summary>
/// 向库位表中插入记录
/// </summary>
/// <param name="depotSeatModel">库位模型</param>
/// <returns>返回向库位表中插入记录所影响的行数</returns>
public static int AddDepotSeat(DepotSeatModel depotSeatModel)
{
SqlParameter[] sparams = new SqlParameter[]
{
new SqlParameter("@wareHouseID", SqlDbType.Int),
new SqlParameter("@depotSeatID", SqlDbType.Int),
new SqlParameter("@seatName", SqlDbType.VarChar, 50),
new SqlParameter("@remark", SqlDbType.VarChar, 200)
};
sparams[0].Value = depotSeatModel.WareHouseID;
sparams[1].Value = depotSeatModel.DepotSeatID;
sparams[2].Value = depotSeatModel.SeatName;
sparams[3].Value = depotSeatModel.Remark;
return(DBHelper.ExecuteNonQuery("AddDepotSeat", sparams, CommandType.StoredProcedure));
}
/// <summary>
/// 更新指定的库位信息
/// </summary>
/// <param name="depotSeatModel">库位模型</param>
/// <returns>返回更新指定的库位信息所影响的行数</returns>
public static int UpdDepotSeatByID(DepotSeatModel depotSeatModel)
{
return(DepotSeatDAL.UpdDepotSeatByID(depotSeatModel));
}
/// <summary>
/// 向库位表中插入记录
/// </summary>
/// <param name="depotSeatModel">库位模型</param>
/// <returns>返回向库位表中插入记录所影响的行数</returns>
public static int AddDepotSeat(DepotSeatModel depotSeatModel)
{
return(DepotSeatDAL.AddDepotSeat(depotSeatModel));
}
/// <summary>
/// 获取指定的库位名称的行数
/// </summary>
/// <param name="depotSeatModel">库位模型</param>
/// <returns>返回指定的库位名称的行数</returns>
public static int GetSeatNameCountByIDWareHouseIDSeatName(DepotSeatModel depotSeatModel)
{
return(DepotSeatDAL.GetSeatNameCountByIDWareHouseIDSeatName(depotSeatModel));
}
