public IEnumerable<dynamic> QueryPayAddressOrderInfo(string beOrderID)
{
SQLStringInfo _sqlInfo = new SQLStringInfo();
_sqlInfo.ColumnSB.Append(",line.ID as LineID");
return base.QueryPayAddressOrderInfo(beOrderID, _sqlInfo);
}
/// <summary>
/// 首页 + 模块列表页面可用商品列表查询
/// </summary>
/// <param name="page"></param>
/// <param name="size"></param>
/// <param name="moduleID"></param>
/// <returns></returns>
public IEnumerable<CommodityDiscountInfoCNa> CommodityInfoQueryByPage(int page, int size, string moduleID, string strSearch = "")
{
//Param
object par = null;
//SqlInfo
SQLStringInfo _sqlInfo = new SQLStringInfo();
//增加折扣相关列
_sqlInfo.ColumnSB.Append(",DIS.StartTime,DIS.EndTime,DIS.PostType as DiscountPostType,DIS.IsEndCommodity,DIS.OpeDate as DiscountOpeDate,DIS.DiscountID");
_sqlInfo.ColumnSB.Append(",DIS.DiscountValue,DIS.DiscountPrice,DIS.DiscountCount");
//增加 WHERE + LIMIT 语句
_sqlInfo.WhereSB.Append(" WHERE COMM.Flag=@Flag ");
if (!string.IsNullOrEmpty(strSearch)) { _sqlInfo.WhereSB.Append(" AND COMM.Title LIKE @Search "); strSearch = string.Format("%{0}%", strSearch); }
if (!string.IsNullOrEmpty(moduleID)) { _sqlInfo.WhereSB.Append(" AND MID=@MID "); par = new { Flag = 1, MID = int.Parse(moduleID), Search = strSearch }; }
else { par = new { Flag = 1, Search = strSearch }; }
//_sqlInfo.OrderBySB.AppendFormat(" LIMIT {0},{1}", (page - 1) * size, size);
//Query
string strSql = _sqlInfo.GetSQLString(CommodityRelevanceDiscountSQL());
return base.Query<CommodityDiscountInfoCNa>(strSql, par);
}
/// <summary>
/// 全部商品关联折扣表、分页查询
/// </summary>
/// <param name="page"></param>
/// <param name="size"></param>
/// <returns></returns>
public IEnumerable<dynamic> CommodityRelevanceDiscountByPage(int page, int size)
{
//增加 LIMIT 语句
SQLStringInfo _sqlInfo = new SQLStringInfo();
_sqlInfo.OrderBySB.AppendFormat(" LIMIT {0},{1}", (page - 1) * size, size);
string strSql = _sqlInfo.GetSQLString(CommodityRelevanceDiscountSQL());
return base.Query(strSql);
}
/// <summary>
/// 关键词搜索商品、分页查询
/// </summary>
/// <param name="page"></param>
/// <param name="size"></param>
/// <param name="searchValue"></param>
/// <returns></returns>
public IEnumerable<dynamic> CommodityRelevanceDiscountBySearch(int page, int size, string searchValue)
{
//增加 WHERE + LIMIT 语句
SQLStringInfo _sqlInfo = new SQLStringInfo();
_sqlInfo.WhereSB.AppendFormat(" WHERE COMM.Title LIKE '%{0}%' ", searchValue);
_sqlInfo.OrderBySB.AppendFormat(" LIMIT {0},{1}", (page - 1) * size, size);
string strSql = _sqlInfo.GetSQLString(CommodityRelevanceDiscountSQL());
return base.Query(strSql);
}
/// <summary>
/// 该用户未付款订单列表
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public IEnumerable<dynamic> QueryAwaitPayListInfo(string userID)
{
//Init
string strSql = QueryOrderListSQL("beorder");
//对SQL进行二次加工
SQLStringInfo _sqlInfo = new SQLStringInfo();
_sqlInfo.WhereSB.Append(" AND beorder.OrderState = 1 ");
//调用获取SQL
strSql = _sqlInfo.GetSQLString(strSql);
//执行
var result = base.Query(strSql, new { UserID = userID });
return result;
}
public IEnumerable<dynamic> CommodityDiscountItem(string discountID)
{
//Init
SQLStringInfo _sqlInfo = new SQLStringInfo();
_sqlInfo.ColumnSB.Append(" ,DIS.PostType,DIS.IsEndCommodity ");
_sqlInfo.WhereSB.Append(" WHERE DiscountID = @DiscountID");
_sqlInfo.OrderBySB.Append(",COMM.Title");
//DAL
CommodityDiscountInfoDAL discountDal = new CommodityDiscountInfoDAL();
string strSql = _sqlInfo.GetSQLString(discountDal.CommodityDiscountListSQL());
IEnumerable<dynamic> list = discountDal.Query(strSql, new { DiscountID = discountID });
return list;
}
/// <summary>
/// 限时折扣列表页面数据查询逻辑业务方法
/// </summary>
/// <param name="queryType"></param>
/// <param name="page"></param>
/// <param name="size"></param>
/// <returns></returns>
public Tuple<IEnumerable<dynamic>, string> CommodityDiscountListOpe(string queryType, int page, int size)
{
//Init
SQLStringInfo _sqlInfo = new SQLStringInfo();
//Query
IEnumerable<dynamic> list = new CommodityDiscountInfoDAL().CommodityDiscountListOpe(_sqlInfo);
//Result
IEnumerable<dynamic> result = null;
string strState = string.Empty;
int startIndex = (page - 1) * size;
switch (queryType)
{
case "1"://进行中
result = list.Where(x => DateTime.Compare(DateTime.Parse(x.StartTime.ToString()), DateTime.Now) <= 0 && DateTime.Compare(DateTime.Parse(x.EndTime.ToString()), DateTime.Now) >= 0);
strState = "进行中";
break;
case "2"://未开始
result = list.Where(x => DateTime.Compare(DateTime.Parse(x.StartTime.ToString()), DateTime.Now) > 0);
strState = "未开始";
break;
case "3"://已结束
result = list.Where(x => DateTime.Compare(DateTime.Parse(x.EndTime.ToString()), DateTime.Now) < 0);
strState = "已结束";
break;
default:
result = list;
break;
}
result = result.Count() != 0 ? result.Skip(startIndex).Take(size) : null;
return new Tuple<IEnumerable<dynamic>, string>(result, strState);
}
/// <summary>
/// 该用户已付款订单，待发货 + 待收货 + 待确认订单列表
/// Remark：LogisticsState = 0、1、2
/// </summary>
/// <param name="userID"></param>
/// <param name="logisticsState"></param>
/// <returns></returns>
public IEnumerable<dynamic> QueryAwaitLogisticsListInfo(string userID, int logisticsState)
{
//Init
string strSql = QueryOrderListSQL("order");
//对SQL进行二次加工
SQLStringInfo _sqlInfo = new SQLStringInfo();
_sqlInfo.ColumnSB.Append(" ,exp.ExpressNum,exp.ExpressCode ");
_sqlInfo.RelationSB.Append(" LEFT JOIN wx_zzscorderexpress exp ON exp.OrderNum = beorder.OrderNum ");
_sqlInfo.WhereSB.Append(" AND beorder.OrderState = 3 ");
_sqlInfo.WhereSB.Append(" AND beorder.LogisticsState = @LogisticsState ");
//调用获取SQL
strSql = _sqlInfo.GetSQLString(strSql);
//执行
var result = base.Query(strSql, new { UserID = userID, LogisticsState = logisticsState });
return result;
}
/// <summary>
/// 限时折扣列表页面数据查询业务逻辑方法
/// </summary>
/// <param name="_sqlInfo"></param>
/// <returns></returns>
public IEnumerable<dynamic> CommodityDiscountListOpe(SQLStringInfo _sqlInfo)
{
string strSql = _sqlInfo.GetSQLString(CommodityDiscountListSQL());
return base.Query(strSql);
}
/// <summary>
/// 商品详情页面
/// </summary>
/// <param name="strWhere"></param>
/// <param name="param"></param>
/// <returns></returns>
public IEnumerable<CommodityDiscountInfoCNa> CommodityInfoQueryOnce(string strWhere, object param = null)
{
//SqlInfo
SQLStringInfo _sqlInfo = new SQLStringInfo();
//增加折扣相关列
_sqlInfo.ColumnSB.Append(",DIS.StartTime,DIS.EndTime,DIS.PostType as DiscountPostType,DIS.IsEndCommodity,DIS.OpeDate as DiscountOpeDate,DIS.DiscountID");
_sqlInfo.ColumnSB.Append(",DIS.DiscountValue,DIS.DiscountPrice,DIS.DiscountCount");
//增加 WHERE + LIMIT 语句
_sqlInfo.WhereSB.AppendFormat(" WHERE {0} ", strWhere);
//Query
string strSql = _sqlInfo.GetSQLString(CommodityRelevanceDiscountSQL());
return base.Query<CommodityDiscountInfoCNa>(strSql, param);
}