public GetPrintByConditionResponse GetPrintHeaderByCondition(PrintHeaderSearchCondition SearchCondition, int pageIndex, int pageSize, out int rowCount)
{
GetPrintByConditionResponse response = new GetPrintByConditionResponse();
string sqlWhere = this.GenGetPrintHeaderWhere(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_GetPrintHeaderByCondition", dbParams);
rowCount = (int)dbParams[3].Value;
response.PrintHeaderCollection = ds.Tables[0].ConvertToEntityCollection <PrintHeader>();
return(response);
}
public string GenGetPrintHeaderWhere(PrintHeaderSearchCondition SearchCondition)
{
StringBuilder sb = new StringBuilder();
if (!String.IsNullOrEmpty(SearchCondition.PrintKey))
{
sb.Append(" and w.PrintKey='" + SearchCondition.PrintKey + "'");
}
if (!String.IsNullOrEmpty(SearchCondition.CustomerID.ToString()))
{
sb.Append(" and w.CustomerID='" + SearchCondition.CustomerID + "'");
}
//if (!String.IsNullOrEmpty(SearchCondition.WarehouseID.ToString()))
// sb.Append(" and w.WarehouseID='" + SearchCondition.WarehouseID + "'");
if (!string.IsNullOrEmpty(SearchCondition.WarehouseName))
{
sb.Append(" AND w.WarehouseName in (select WarehouseName from wms_warehouse where id in ( ").Append(SearchCondition.WarehouseName.Trim()).Append(")) ");
//sb.Append(" AND o.Warehouse='").Append(SearchCondition.Warehouse).Append("' ");
}
return(sb.ToString());
}
