private QueryResult Export(NeweggAmbassadorOrderQueryFilter filter, QueryResultHandler fun)
{
int totalCount;
DataSet ds = fun(filter, out totalCount);
DataTable firstTableInfo = ds.Tables[0];//第一个DataTable
QueryResult listInfo = new QueryResult();
listInfo.Data = firstTableInfo;
listInfo.TotalCount = totalCount;
return(listInfo);
}
private QueryResultList GetQueryResult(NeweggAmbassadorOrderQueryFilter filter, QueryResultHandler fun)
{
int totalCount;
DataSet ds = fun(filter, out totalCount);
DataTable firstTableInfo = ds.Tables[0]; //第一个DataTable
DataTable secondTableInfo = ds.Tables[1]; //第二个DataTable
QueryResult listInfo = new QueryResult();
listInfo.Data = firstTableInfo;
listInfo.TotalCount = totalCount;
QueryResult summaryResult = new QueryResult();
summaryResult.Data = secondTableInfo;
QueryResultList result = new QueryResultList();
result.Add(listInfo);
result.Add(summaryResult);
return(result);
}
/// <summary>
/// 查询代购订单信息。
/// </summary>
/// <param name="filter"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataSet QueryPurchaseOrderInfo(NeweggAmbassadorOrderQueryFilter filter, out int totalCount)
{
PagingInfoEntity pagingEntity = new PagingInfoEntity();
pagingEntity.SortField = filter.PagingInfo.SortBy;
pagingEntity.MaximumRows = filter.PagingInfo.PageSize;
pagingEntity.StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize;
var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("GetPanliOrderList");
cmd.SetParameterValue("@CustomersType", filter.SelectedUserType);
cmd.SetParameterValue("@NeweggAmbassadorID", filter.CustomerID);
cmd.SetParameterValue("@SOID", filter.OrderSysNo);
cmd.SetParameterValue("@OrderDateFrom", filter.OrderTimeFrom);
cmd.SetParameterValue("@OrderDateTo", filter.OrderTimeTo);
cmd.SetParameterValue("@PointCreateFrom", filter.PointTimeFrom);
cmd.SetParameterValue("@PointCreateTo", filter.PointTimeTo);
cmd.SetParameterValue("@SOStatus", filter.SelectedSOStatus);
cmd.SetParameterValue("@PointStatus", filter.SelectedPointStatus);
cmd.SetParameterValue("@BigProvinceSysNo", filter.BigAreaSysNo);
if (!string.IsNullOrEmpty(filter.PagingInfo.SortBy))
{
string[] sortInfo = filter.PagingInfo.SortBy.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
if (sortInfo.Length > 1)
{
cmd.SetParameterValue("@SortField", sortInfo[0]);
cmd.SetParameterValue("@SortType", sortInfo[1]);
}
else
{
cmd.SetParameterValue("@SortField", null);
cmd.SetParameterValue("@SortType", null);
}
}
else
{
cmd.SetParameterValue("@SortField", null);
cmd.SetParameterValue("@SortType", null);
}
cmd.SetParameterValue("@PageSize", filter.PagingInfo.PageSize);
cmd.SetParameterValue("@PageCurrent", filter.PagingInfo.PageIndex);
cmd.SetParameterValue("@CompanyCode", filter.CompanyCode);
DataSet ds = cmd.ExecuteDataSet();
EnumColumnList enumConfigNews = new EnumColumnList();
enumConfigNews.Add("SOStatus", typeof(SOStatus));
enumConfigNews.Add("RASysNo", typeof(NYNStatus));
enumConfigNews.Add("IsAddPoint", typeof(PointStatus));
enumConfigNews.Add("PayStatus", typeof(PayStatus));
cmd.ConvertEnumColumn(ds.Tables[0], enumConfigNews);
totalCount = Convert.ToInt32(ds.Tables[1].Rows[0]["TotalCount"]);
return(ds);
}
public virtual QueryResultList QueryPointInfo(NeweggAmbassadorOrderQueryFilter filter)
{
return(GetQueryResult(filter, ObjectFactory <INeweggAmbassadorQueryDA> .Instance.QueryPointInfo));
}
public virtual QueryResult ExportAmbassadorRecommendOrderInfo(NeweggAmbassadorOrderQueryFilter filter)
{
return(Export(filter, ObjectFactory <INeweggAmbassadorQueryDA> .Instance.QueryRecommendOrderInfo));
}
