/// <summary>
/// 查询上架信息（上架表有上架信息）
/// </summary>
/// <param name="Request"></param>
/// <returns></returns>
//public GetShelvesByConditionResponse GetReceiptReceiving(ReceiptReceivingSearchCondition Request)
//{
// GetShelvesByConditionResponse ConditionResponse = new GetShelvesByConditionResponse();
// string sqlWhere = SearchConditionsqlWhere(Request);
// DbParam[] dbParams = new DbParam[]{
// new DbParam("@WhereSql", DbType.String,Request.RID, ParameterDirection.Input),
// };
// DataSet ds = this.ExecuteDataSet("Proc_GetReceiptReceiving", dbParams);
// ConditionResponse.storesByGetReceipt = ds.Tables[0].ConvertToEntity<StoresByGetReceipt>();
// ConditionResponse.Shelves = ds.Tables[1].ConvertToEntityCollection<Shelves>();
// return ConditionResponse;
//}
private string SearchConditionsqlWhere(ReceiptReceivingSearchCondition Condition)
{
StringBuilder sb = new StringBuilder();
if (Condition.RID != 0)
{
sb.Append("and r.id='" + Condition.RID + "'");
}
return(sb.ToString());
}
/// <summary>
/// 查询上架信息（上架表没有上架单）
/// </summary>
/// <param name="Request"></param>
/// <returns></returns>
public GetShelvesByConditionResponse GetShelves(ReceiptReceivingSearchCondition Request)
{
GetShelvesByConditionResponse ConditionResponse = new GetShelvesByConditionResponse();
string sqlWhere = SearchConditionsqlWhere(Request);
DbParam[] dbParams = new DbParam[] {
new DbParam("@WhereSql", DbType.String, Request.RID, ParameterDirection.Input),
};
DataSet ds = this.ExecuteDataSet("Proc_WMS_GetShelves", dbParams);
ConditionResponse.storesByGetReceipt = ds.Tables[0].ConvertToEntity <StoresByGetReceipt>();
ConditionResponse.Shelves = ds.Tables[1].ConvertToEntityCollection <Shelves>();
return(ConditionResponse);
}