/// <summary>
/// 获取首页拼团列表
/// </summary>
/// <returns></returns>
public LayuiTableApiResult GroupInfoListForAdmin()
{
using (brnshopEntities context = new brnshopEntities())
{
LayuiTableApiResult result = new LayuiTableApiResult();
try
{
string sql = $@"select * from bsp_groupinfos";
List <GroupInfoModel> groupInfos = context.Database.SqlQuery <GroupInfoModel>(sql).ToList();
var couponTypes = coupon.GetCouponTypeForGroup();
foreach (var groupInfo in groupInfos)
{
groupInfo.couponTypeInfo = couponTypes.SingleOrDefault(t => t.ct_coupontypeid == groupInfo.groupoid);
bool isfind = false;
foreach (var products in ProductCache.ProductList)
{
foreach (var product in products.productInfos)
{
if (product.pid == groupInfo.couponTypeInfo.ct_pid)
{
groupInfo.productInfo = product;
isfind = true;
break;
}
}
if (isfind)
{
break;
}
}
var couponTypeInfodes = "";
if (groupInfo.couponTypeInfo.ct_type == 1)
{
couponTypeInfodes = $@" 满{Math.Round(groupInfo.couponTypeInfo.ct_fullmoney, 2)}减{Math.Round(groupInfo.couponTypeInfo.ct_cutmoney, 2)}";
}
else
{
couponTypeInfodes = $@" {(int)groupInfo.couponTypeInfo.ct_discount}折";
}
groupInfo.title = groupInfo.couponTypeInfo.ct_name + couponTypeInfodes;
}
result.code = 0;
result.msg = "";
result.count = groupInfos.Count;
result.data = groupInfos;
return(result);
}
catch (Exception ex)
{
Logger._.Error("GroupInfoList方法,", ex);
result.code = 1;
result.msg = "GroupInfoList方法," + ex.ToString();
return(result);
}
}
}
/// <summary>
/// 获取所有的优惠券类型（用于后台配置）
/// </summary>
/// <returns></returns>
public LayuiTableApiResult GetCouponType()
{
LayuiTableApiResult result = new LayuiTableApiResult();
try
{
string sql = $@"SELECT bsp_coupontypes.coupontypeid ct_coupontypeid,
state ct_state,
name ct_name,
money ct_money,
count ct_count,
sendmode ct_sendmode,
getmode ct_getmode,
usemode ct_usemode,
userranklower ct_userranklower,
orderamountlower ct_orderamountlower,
limitcateid ct_limitcateid,
limitbrandid ct_limitbrandid,
limitproduct ct_limitproduct,
sendstarttime ct_sendstarttime,
sendendtime ct_sendendtime,
useexpiretime ct_useexpiretime,
usestarttime ct_usestarttime,
useendtime ct_useendtime,
type ct_type,
isstack ct_isstack,
fullmoney ct_fullmoney,
cutmoney ct_cutmoney,
discount ct_discount,
ISNULL(bsp_couponproducts.pid,0) ct_pid
FROM bsp_coupontypes
LEFT JOIN bsp_couponproducts ON bsp_couponproducts.coupontypeid = bsp_coupontypes.coupontypeid
ORDER BY sendendtime DESC
";
DataTable dt = SqlManager.FillDataTable(AppConfig.ConnectionString, new SqlCommand(sql));
List <ShowCouponTypeInfo> list = dt.GetList <ShowCouponTypeInfo>("");
list.ForEach(t => {
t.t_ct_isstack = t.ct_isstack == 1 ? "可以叠加" : "不可以叠加";
t.t_ct_type = EnumToText.ToText((CouponType)t.ct_type);
t.t_ct_fullcut = t.ct_fullmoney.ToString() + '/' + t.ct_cutmoney.ToString();
t.t_ct_sendstarttime = t.ct_sendstarttime.ToString("yyyy-MM-dd");
t.t_ct_sendendtime = t.ct_sendendtime.ToString("yyyy-MM-dd");
});
result.code = 0;
result.msg = "";
result.count = list.Count;
result.data = list;
return(result);
}
catch (Exception ex)
{
Logger._.Error(ex);
return(null);
}
}
