/// <summary>
/// 获取店铺销售额信息
/// </summary>
/// <param name="platform_id"></param>
/// <param name="shop_id"></param>
/// <param name="start_time"></param>
/// <param name="end_time"></param>
/// <param name="exmsg"></param>
/// <returns></returns>
public List <StoreSalesModel> GetStoreSalesInfo(Int64?platform_id, Int64?shop_id, DateTime?start_time, DateTime?end_time, out string exmsg)
{
StoreSalesResult result = new StoreSalesResult();
using (var db = SugarDao.GetInstance(LoginUser.GetConstr()))
{
try
{
var sql = "SELECT base_platform.platform_name, base_shop.shop_name, " +
" (SELECT SUM(order_summoney) AS Expr2 FROM busi_custorder WHERE (del_flag = 1) AND (shop_id = " + shop_id + ") GROUP BY shop_id) AS sumshopmoney, " +
" (SELECT SUM(order_summoney) AS Expr1 FROM busi_custorder AS busi_custorder_2 WHERE (del_flag = 1) AND (platform_id = " + platform_id + ") GROUP BY platform_id) AS sumplatformmoney" +
" FROM busi_custorder AS busi_custorder_1 INNER JOIN" +
" base_platform ON busi_custorder_1.platform_id = base_platform.platform_id INNER JOIN" +
" base_shop ON base_platform.platform_id = base_shop.platform_id" +
" WHERE (base_platform.del_flag = 1) AND (base_shop.del_flag = 1) AND (busi_custorder_1.del_flag = 1) AND " +
" (busi_custorder_1.platform_id = " + platform_id + ") AND (busi_custorder_1.shop_id = " + shop_id + ")" +
" AND (busi_custorder_1.create_time >= CONVERT(DATETIME, '" + start_time + "', 102)) " +
" AND (busi_custorder_1.create_time < CONVERT(DATETIME, '" + end_time + "', 102))" +
" GROUP BY busi_custorder_1.platform_id, busi_custorder_1.shop_id, base_platform.platform_name, base_shop.shop_name";
var list = db.SqlQuery <StoreSalesModel>(sql).ToList();
exmsg = "";
return(list.ToList());
}
catch (Exception ex)
{
exmsg = ex.ToString();
return(null);
}
}
}
public ActionResult GetShopList(Int64?platform_id)
{
StoreSalesResult com = new StoreSalesResult();
try
{
com = _service.GetShopList(platform_id.Value);
return(Json(com));
}
catch (Exception ex)
{
com.Msg = ex.ToString();
com.success = false;
return(Json(com));
}
}
public ActionResult GetStoreSalesInfo(Int64?platform_id, Int64?shop_id, DateTime?start_time, DateTime?end_time)
{
StoreSalesResult com = new StoreSalesResult();
if (platform_id == 0)
{
com.success = false;
com.Msg = "请选择平台!";
return(Json(com));
}
if (shop_id == 0)
{
com.success = false;
com.Msg = "请填写店铺!";
return(Json(com));
}
if (!start_time.HasValue)
{
com.success = false;
com.Msg = "开始时间不得为空!";
return(Json(com));
}
if (start_time > end_time)
{
com.success = false;
com.Msg = "结束时间不得小于开始时间!";
return(Json(com));
}
DateTime torrow = end_time.Value.AddDays(1);
string exmsg = string.Empty;
List <StoreSalesModel> mylist = _service.GetStoreSalesInfo(platform_id, shop_id, start_time, torrow, out exmsg);
if (!string.IsNullOrEmpty(exmsg))
{
com.Msg = exmsg;
com.success = false;
return(Json(com));
}
else
{
StoreSalesViewModel mylistview = new StoreSalesViewModel();
mylistview.supplist = mylist;
com.DataResult = mylistview;
com.success = true;
return(Json(com));
}
}
/// <summary>
/// 根据平台ID获取店铺信息
/// </summary>
/// <param name="platform_id"></param>
/// <returns></returns>
public StoreSalesResult GetShopList(Int64?platform_id)
{
StoreSalesResult result = new StoreSalesResult();
using (var db = SugarDao.GetInstance(LoginUser.GetConstr()))
{
try
{
if (platform_id == 0)
{
result.success = false;
result.Msg = "请选择平台!";
return(result);
}
var list = db.Queryable <base_shop>().Where(a => a.del_flag && a.platform_id == platform_id).OrderBy("shop_id DESC").ToList();
if (list.Count <= 0)
{
result.success = false;
result.Msg = "该平台下暂无店铺信息!";
return(result);
}
var list1 = "<option value=\"0\">请选择...</option>";
foreach (var item in list)
{
list1 += "<option value=\"" + item.shop_id + "\">" + item.shop_name + "</option>";
}
result.success = true;
result.Msg = list1;
return(result);
}
catch (Exception ex)
{
result.success = false;
result.Msg = "获取店铺信息失败!";
return(result);
}
}
}
