public DataTable StatisticsSaleStop(string productIds)
{
SqlParameter[] parameters =
{
new SqlParameter("@type", SqlDbType.VarChar),
new SqlParameter("@productIds", SqlDbType.NVarChar)
};
parameters[0].Value = "StatisticsSaleStop";
parameters[1].Value = productIds;
return(ShopMssqlHelper.ExecuteDataTable("usp_Order", parameters));
}
/// <summary>
/// 统计已付款汇总
/// </summary>
/// <param name="orderSearch"></param>
/// <returns></returns>
public DataTable StatisticsPaidTotal(OrderSearchInfo orderSearch)
{
string condition = PrepareCondition(orderSearch).ToString();
SqlParameter[] parameters =
{
new SqlParameter("@condition", SqlDbType.NVarChar)
};
parameters[0].Value = condition;
return(ShopMssqlHelper.ExecuteDataTable("StatisticsPaidTotal", parameters));
}
public DataTable ShopIndexStatistics(int shopId)
{
SqlParameter[] parameters =
{
new SqlParameter("@type", SqlDbType.VarChar),
new SqlParameter("@userId", SqlDbType.Int)
};
parameters[0].Value = "ShopIndexStatistics";
parameters[1].Value = shopId;
return(ShopMssqlHelper.ExecuteDataTable("usp_Usr", parameters));
}
public DataTable StatisticsOrderArea(OrderSearchInfo orderSearch)
{
string condition = PrepareCondition(orderSearch).ToString();
SqlParameter[] parameters =
{
new SqlParameter("@type", SqlDbType.VarChar),
new SqlParameter("@condition", SqlDbType.NVarChar)
};
parameters[0].Value = "StatisticsOrderArea";
parameters[1].Value = condition;
return(ShopMssqlHelper.ExecuteDataTable("usp_Order", parameters));
}
public DataTable StatisticsSaleTotal(OrderSearchInfo orderSearch, DateType dateType)
{
string condition = PrepareCondition(orderSearch).ToString();
SqlParameter[] parameters =
{
new SqlParameter("@type", SqlDbType.VarChar),
new SqlParameter("@condition", SqlDbType.NVarChar),
new SqlParameter("@dateType", SqlDbType.Int)
};
parameters[0].Value = "StatisticsSaleTotal";
parameters[1].Value = condition;
parameters[2].Value = (int)dateType;
return(ShopMssqlHelper.ExecuteDataTable("usp_Order", parameters));
}
/// <summary>
/// 返回DataTable对像
/// </summary>
/// <returns></returns>
public override DataTable ExecuteDataTable()
{
return(ShopMssqlHelper.ExecuteDataTable(ShopMssqlHelper.TablePrefix + "ReadPageList", this.PrepareParameter()));
}
public DataTable NoHandlerStatistics()
{
return(ShopMssqlHelper.ExecuteDataTable(ShopMssqlHelper.TablePrefix + "NoHandlerStatistics"));
}
