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