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()); }