/// <summary>
/// 交接单列表查询条件
/// </summary>
/// <param name="SearchCondition"></param>
/// <returns></returns>
public string GenGetDeliverHeaderWhere(DeliverHeaderSearchCondition SearchCondition)
{
StringBuilder sb = new StringBuilder();
if (!String.IsNullOrEmpty(SearchCondition.DeliverKey))
{
sb.Append(" and d.DeliverKey='" + SearchCondition.DeliverKey + "'");
}
if (!String.IsNullOrEmpty(SearchCondition.CustomerID.ToString()))
{
sb.Append(" and d.CustomerID='" + SearchCondition.CustomerID + "'");
}
if (!string.IsNullOrEmpty(SearchCondition.WarehouseName))
{
sb.Append(" AND d.WarehouseName in (select WarehouseName from wms_warehouse where id in ( ").Append(SearchCondition.WarehouseName.Trim()).Append(")) ");
}
return(sb.ToString());
}
/// <summary>
/// 交接单主表查询
/// </summary>
/// <param name="SearchCondition"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="rowCount"></param>
/// <returns></returns>
public GetDeliverByConditionResponse GetDeliverHeaderByCondition(DeliverHeaderSearchCondition SearchCondition, int pageIndex, int pageSize, out int rowCount)
{
GetDeliverByConditionResponse response = new GetDeliverByConditionResponse();
string sqlWhere = this.GenGetDeliverHeaderWhere(SearchCondition);
int tempRowCount = 0;
DbParam[] dbParams = new DbParam[] {
new DbParam("@Where", DbType.String, sqlWhere, ParameterDirection.Input),
new DbParam("@PageIndex", DbType.Int32, pageIndex, ParameterDirection.Input),
new DbParam("@PageSize", DbType.Int32, pageSize, ParameterDirection.Input),
new DbParam("@RowCount", DbType.Int32, tempRowCount, ParameterDirection.Output)
};
DataSet ds = this.ExecuteDataSet("Proc_WMS_GetDeliverHeaderByCondition", dbParams);
rowCount = (int)dbParams[3].Value;
response.DeliverHeaderConnection = ds.Tables[0].ConvertToEntityCollection <DeliverHeader>();
return(response);
}
