public int UpdateWaitCheckGoodsState(Guid goodsId, Guid warehouseId, WaitCheckGoodsState state)
{
const string SQL = "UPDATE lmshop_WaitCheckGoods SET [state]=@state WHERE GoodsId=@goodsId AND WarehouseId=@warehouseId";
var sqlparams = new[] {
new SqlParameter("@state", (int)state),
new SqlParameter("@goodsId", goodsId),
new SqlParameter("@warehouseId", warehouseId)
};
return(SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL, sqlparams));
}
public IList <Keede.Ecsoft.Model.WaitCheckGoodsInfo> GetWaitCheckGoodsInfo(Guid warehouseId, WaitCheckGoodsState state, string goodsName)
{
const string SQL = "SELECT [GoodsId],[GoodsName],[State],[WarehouseId] FROM lmshop_WaitCheckGoods WHERE [WarehouseId]=@warehouseId AND [State]=@state AND CHARINDEX(@goodsname,GoodsName)>0";
var sqlparams = new[] {
new SqlParameter("@state", (int)state),
new SqlParameter("@warehouseId", warehouseId),
new SqlParameter("@goodsname", goodsName)
};
IList <Keede.Ecsoft.Model.WaitCheckGoodsInfo> list = new List <Keede.Ecsoft.Model.WaitCheckGoodsInfo>();
using (var dr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, SQL, sqlparams))
{
while (dr.Read())
{
var entity = new Keede.Ecsoft.Model.WaitCheckGoodsInfo
{
GoodsId = dr.GetGuid(0),
GoodsName = dr.GetString(1),
State = dr.GetInt32(2),
WarehouseId = dr.GetGuid(3)
};
list.Add(entity);
}
}
return(list);
}
