public QuerySKUProductResponse QueryProductAndArticleDetail(int StorerID, IEnumerable <WMS_SKUAndArticleNoTable> list)
{
using (SqlConnection conn = new SqlConnection(BaseAccessor._dataBase.ConnectionString))
{
QuerySKUProductResponse response = new QuerySKUProductResponse();
SqlCommand cmd = new SqlCommand("[Proc_WMS_QueryProductAndArticleDetail]", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StorerID", StorerID);
cmd.Parameters[0].SqlDbType = SqlDbType.Int;
cmd.Parameters.AddWithValue("@SKUAndArticleNo", list.Select(p => new WMS_SKUAndArticleNoToDb(p)));
cmd.Parameters[1].SqlDbType = SqlDbType.Structured;
cmd.CommandTimeout = 300;
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(ds);
conn.Close();
response.Info = ds.Tables[0].ConvertToEntityCollection <ProductStorerInfo>();
response.ArticleDetail = ds.Tables[1].ConvertToEntityCollection <WMS_ArticleDetail>();
return(response);
}
}
/// <summary>
/// 查询详细SKU
/// </summary>
/// <param name="SKU"></param>
/// <returns></returns>
public QuerySKUProductResponse QuerySKUProductFG(string ID)
{
QuerySKUProductResponse response = new QuerySKUProductResponse();
DbParam[] dbParams = new DbParam[] {
new DbParam("@ID", DbType.String, ID, ParameterDirection.Input),
};
DataSet ds = this.ExecuteDataSet("[Proc_WMS_QuerySKUProductFG]", dbParams);
response.ProductStorerInfo = ds.Tables[0].ConvertToEntity <ProductStorerInfo>();
//response.InfoDetail = ds.Tables[1].ConvertToEntityCollection<ProductDetail>();
return(response);
//return dt.ConvertToEntity<ProductStorerInfo>();
// return response;
}
