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