/// <summary> /// 查询DMS玫琳凯运单 /// </summary> public IEnumerable <DMS_POD> QueryDMSPOD(QueryDMSPODRequest SearchCondition, int PageIndex, int PageSize, out int RowCount) { string sqlWhere = " WHERE Status='已发运' ";//this.GenQueryAttachmentSql(SearchCondition, Customers); int tempRowCount = 0; using (SqlConnection conn = new SqlConnection(BaseAccessor.DMSSqlConnection)) { SqlCommand cmd = new SqlCommand("Proc_QueryPOD", conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Where", sqlWhere); cmd.Parameters[0].SqlDbType = SqlDbType.VarChar; cmd.Parameters.AddWithValue("@PageIndex", PageIndex); cmd.Parameters[1].SqlDbType = SqlDbType.Int; cmd.Parameters.AddWithValue("@PageSize", PageSize); cmd.Parameters[2].SqlDbType = SqlDbType.Int; cmd.Parameters.AddWithValue("@RowCount", tempRowCount); cmd.Parameters[3].SqlDbType = SqlDbType.Int; conn.Open(); using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { DataSet ds = new DataSet(); sda.Fill(ds); RowCount = Convert.ToInt32(cmd.Parameters[3].Value); cmd.Parameters.Clear(); return(ds.Tables[0].ConvertToEntityCollection <DMS_POD>()); } } }
/// <summary> /// 查询DMS玫琳凯运单 /// </summary> public Response <QueryDMSPODResponse> QueryDMSPOD(QueryDMSPODRequest request) { Response <QueryDMSPODResponse> response = new Response <QueryDMSPODResponse>() { Result = new QueryDMSPODResponse() }; if (request == null) { ArgumentNullException ex = new ArgumentNullException("QueryDMSPOD request"); LogError(ex); response.ErrorCode = ErrorCode.Argument; response.Exception = ex; return(response); } try { MaryKayAccessor accessor = new MaryKayAccessor(); int RowCount; response.Result.DMS_PODCollection = accessor.QueryDMSPOD(request, request.PageIndex, request.PageSize, out RowCount); response.Result.PageCount = RowCount % request.PageSize == 0 ? RowCount / request.PageSize : RowCount / request.PageSize + 1; response.Result.PageIndex = request.PageIndex; response.IsSuccess = true; } catch (Exception ex) { LogError(ex); response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; } return(response); }