/// <summary>
/// 通过货位ID获取库存ID
/// 如果等于0为获取失败
/// </summary>
/// <param name="gsID"></param>
/// <returns></returns>
public long GetStockIDByGsID(int gsID)
{
string whereStr = "GoodsSiteID = " + gsID;
List <StockModel> modelList = GetModelList(whereStr);
if (modelList.Count > 0)
{
StockModel model = GetModelList(whereStr)[0];
return(model.StockID);
}
else
{
return(0);
}
}
/// <summary>
/// 获取添加库存hash用于事物
/// </summary>
/// <param name="model"></param>
public Hashtable GetAddModelHash(StockModel model)
{
Hashtable hs = new Hashtable();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Stock(");
strSql.Append("GoodsSiteID,TrayCode,FullTraySign,Remarks)");
strSql.Append(" values (");
strSql.Append("@GoodsSiteID,@TrayCode,@FullTraySign,@Remarks)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@GoodsSiteID", SqlDbType.Int, 4),
new SqlParameter("@TrayCode", SqlDbType.NVarChar, 50),
new SqlParameter("@FullTraySign", SqlDbType.NVarChar, 50),
new SqlParameter("@Remarks", SqlDbType.NVarChar, 100)
};
parameters[0].Value = model.GoodsSiteID;
parameters[1].Value = model.TrayCode;
parameters[2].Value = model.FullTraySign;
parameters[3].Value = model.Remarks;
hs.Add(strSql.ToString(), parameters);
return(hs);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ECAMSDataAccess.StockModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(ECAMSDataAccess.StockModel model)
{
return(dal.Add(model));
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 获取添加库存hash用于事物
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public Hashtable GetAddModelHash(StockModel model)
{
return(dal.GetAddModelHash(model));
}