private void UpdateData()
{
JsonTransfer jt = new JsonTransfer();
var user = AccountHelper.GetCurUser();
if (user.RoleType != RoleType.SuperManage)
{
jt.SetError("无权限");
Response.Write(jt.ToJson());
return;
}
Account account = new Account();
account.Id = GetInt("id");
account.RoleType = (RoleType)GetInt("roletype");
account.UserName = GetString("username");
account.Pwd = GetString("pwd");
account.Avatar = GetString("avatar");
account.Sex = (SexType)GetInt("sex");
account.CreateTime = GetTime("createtime");
int num = AccountHelper.SaveAccount(account);
jt.Add("num", num);
Response.Write(jt.ToJson());
}
/// <summary>
/// 获取用户详情
/// </summary>
public void GetUserDetail()
{
var userid = GetInt("userid");
var user = AccountHelper.GetUser(userid);
if (user == null)
{
ReturnErrorMsg("用户不存在");
return;
}
if (user.SellerId == 0 && CurrentUser.RoleType > RoleType.Manage)
{
ReturnErrorMsg("无权访问该商户");
return;
}
var data = new RetUserDetail();
data.User = user;
data.UserLevels = SystemHelper.GetUserLevels(user.SellerId).ToList();
var jt = new JsonTransfer();
jt.Add("data", data);
Response.Write(jt.ToJson());
Response.End();
}
private void Login()
{
//string str = DesAlgorithm.EncryptString("1235678");
string userName = GetString("userName");
string pwd = GetString("pwd");
Account user = AccountHelper.FindUser(userName);
JsonTransfer jt = new JsonTransfer();
if (user == null)
{
jt.SetError("不存在此用户");
}
else if (user.Pwd != pwd)
{
jt.SetError("密码错误");
}
else
{
//设置已登录
AccountHelper.SetLogOn(user.Id, true, AccountHelper.GetStringFromEntity(user), DateTime.Now.AddDays(1));
if (user.RoleType == RoleType.Merchant)
{
jt.Add("success", "1");
}
else if (user.RoleType < RoleType.Merchant)
{
jt.Add("success", "2");
}
user.LastLoginTime = DateTime.Now;
AccountHelper.SaveAccount(user);
}
Response.Write(jt.ToJson());
}
/// <summary>
/// 获取结算记录列表
/// </summary>
private void GetSettleMentList()
{
var status = GetInt("status");
var start = GetInt("start");
var limit = GetInt("limit");
var wheresql = "";
if (status == 0)
{
wheresql = string.Format(" where Status = {0} ", status);
}
else
{
wheresql = " where Status <> 0 ";
}
var result = ExtractMoneyHelper.GetPagings(0, start * limit, limit, "", wheresql);
var jt = new JsonTransfer();
jt.Add("list", result.Results);
jt.Add("totalcount", result.TotalCount);
Response.Write(jt.ToJson());
Response.End();
}
/// <summary>
/// 获取订单列表
/// </summary>
public void GetUserList()
{
int start = GetInt("start");
int limit = GetInt("limit");
string wheresql = string.Format(" where SellerId = {0} and Status = 0", CurSellerId);
var result = AccountHelper.GetUserList(wheresql, "", start * limit, limit, 1);
//var list = new List<OrdersItem>();
//foreach (var item in result.Results)
//{
// var i = new OrdersItem();
// i.Id = item.Id;
// i.UserId = item.UserId;
// i.Money = item.TotalPrice;
// i.CreateTime = item.CreateTime.ToString("yyyy-M-d HH:mm:ss");
// i.GoodsCount = item.NumList.Sum(o => o);
// i.Status = (int)item.GetReqStatus();
// i.Type = (int)item.OrderType;
// list.Add(i);
//}
var jt = new JsonTransfer();
jt.Add("list", result.Results);
jt.Add("count", result.TotalCount);
Response.Write(jt.ToJson());
Response.End();
}
private void DelData()
{
JsonTransfer jt = new JsonTransfer();
var user = AccountHelper.GetCurUser();
if (user.RoleType != RoleType.SuperManage)
{
jt.SetError("无权限");
Response.Write(jt.ToJson());
return;
}
int id = GetInt("id");
int num = AccountHelper.DelUser(id);
jt.Add("num", num);
Response.Write(jt.ToJson());
}
private void Logout()
{
AccountHelper.SetLogOut();
//Response.Redirect("../login.aspx");
JsonTransfer jt = new JsonTransfer();
jt.Add("success", "退出成功");
Response.Write(jt.ToJson());
}
/// <summary>
/// 获取商户产品分类列表
/// </summary>
private void GetGoodsCategoriesList()
{
JsonTransfer jt = new JsonTransfer();
//角色为商户时 Id即为商户id 相当于用户的SellerId
var list = GoodsCategoriesHelper.GetList(CurSellerId);
jt.Add("list", list.Results);
jt.Add("count", list.TotalCount);
Response.Write(jt.ToJson());
}
/// <summary>
/// 获取平台广告配置
/// </summary>
public void GetAdCfg()
{
var cfg = ParamHelper.PlatformCfgData;
var jt = new JsonTransfer();
jt.Add("data", cfg);
Response.Write(jt.ToJson());
Response.End();
}
/// <summary>
/// 获得支付方式列表
/// </summary>
private void GetPaymentList()
{
var result = PaymentHelper.GetList();
var jt = new JsonTransfer();
jt.Add("list", result);
jt.Add("totalcount", result.Count);
Response.Write(jt.ToJson());
Response.End();
}
/// <summary>
/// 获取产品列表
/// </summary>
public void GetGoodsList()
{
int cid = GetInt("cid");
//int order = GetInt("order");
int start = GetInt("start");
int limit = GetInt("limit");
int type = GetInt("type");
string wheresql = string.Empty;
string shoppingcartql = "";
if (cid > 0)
{
wheresql += string.Format(" and Cid={0}", cid);
}
if (type > 0)
{
switch (type)
{
case 1:
wheresql += " and IsHot>0 "; break;
case 2:
wheresql += " and IsRecommend>0 "; break;
default: break;
}
}
//switch (order)
//{
// case 1:
// shoppingcartql += " order by Sales asc "; break;
// case -1:
// shoppingcartql += " order by Sales desc "; break;
// case 2:
// shoppingcartql += " order by CreateTime asc "; break;
// case -2:
// shoppingcartql += " order by CreateTime desc "; break;
// case 3:
// shoppingcartql += " order by Nowprice asc "; break;
// case -3:
// shoppingcartql += " order by Nowprice desc "; break;
// default: break;
//}
var goodsresult = GoodsHelper.GetGoodsList(CurSellerId, wheresql, shoppingcartql, start * limit, limit, 1);
var jt = new JsonTransfer();
jt.Add("list", goodsresult.Results);
jt.Add("totalcount", goodsresult.TotalCount);
Response.Write(jt.ToJson());
Response.End();
}
private void GetManagerList()
{
JsonTransfer jt = new JsonTransfer();
var user = AccountHelper.GetCurUser();
if (user.RoleType != RoleType.SuperManage)
{
jt.SetError("无权限");
Response.Write(jt.ToJson());
return;
}
int pageIndex = GetInt("pageIndex");
int pageSize = GetInt("pageSize");
var result = AccountHelper.GetUserList(" where (RoleType = 2 or RoleType = 3) ", "",
pageIndex * pageSize, pageSize, 1);
jt.Add("list", result.Results);
jt.Add("count", result.TotalCount);
jt.Add("curcount", result.TotalCount);
Response.Write(jt.ToJson());
}
/// <summary>
/// 获取公告列表
/// </summary>
public void GetAnnouncemmentList()
{
var start = GetInt("start");
var limit = GetInt("limit");
var result = AnnouncementHelper.GetList(start * limit, limit);
var jt = new JsonTransfer();
jt.Add("list", result.Results);
jt.Add("totalcount", result.TotalCount);
Response.Write(jt.ToJson());
Response.End();
}
/// <summary>
/// 获取模板列表
/// </summary>
public void GetTempleList()
{
var typeid = GetInt("typeid");
var start = GetInt("start");
var limit = GetInt("limit");
var result = TempleHelper.GetList(typeid, start * limit, limit);
var jt = new JsonTransfer();
jt.Add("list", result.Results);
jt.Add("totalcount", result.TotalCount);
Response.Write(jt.ToJson());
Response.End();
}
/// <summary>
/// 获取商户列表
/// </summary>
public void GetMerchantList()
{
var mid = GetInt("mid");
var orderby = GetInt("orderby");
var orderbytype = GetInt("orderbytype");
var start = GetInt("start");
var limit = GetInt("limit");
var merresult = MerchantHelper.GetMerchantList(mid, orderby, orderbytype, start * limit, limit);
var mertyperesult = MerchantTypeHelper.GetList();
var data = new List <MerchantItem>();
var idlist = merresult.Results.Select(o => o.Id).ToList();
var users = AccountHelper.GetUserList(Utility.GetWhereSql(idlist));
foreach (var merchant in merresult.Results)
{
var merchantitem = new MerchantItem();
merchantitem.Id = merchant.Id;
merchantitem.UserCount = merchant.UserCount;
var user = users.Results.FirstOrDefault(o => o.Id == merchant.Id);
if (user == null)
{
ReturnErrorMsg("数据出错");
return;
}
merchantitem.Money = user.Money;
var mertype = mertyperesult.FirstOrDefault(o => o.Id == merchant.Mid);
if (mertype == null)
{
ReturnErrorMsg("数据出错");
return;
}
merchantitem.Cname = mertype.Name;
merchantitem.CreateTime = merchant.CreateTime;
merchantitem.DevName = merchant.DevName;
merchantitem.Name = merchant.Name;
merchantitem.LogoUrl = merchant.LogoUrl;
data.Add(merchantitem);
}
var jt = new JsonTransfer();
jt.Add("list", data);
jt.Add("totalcount", merresult.TotalCount);
Response.Write(jt.ToJson());
Response.End();
}
/// <summary>
/// 获取模板信息
/// </summary>
public void GetTemple()
{
var id = GetInt("id");
var temple = TempleHelper.GetTemple(id);
if (temple == null)
{
ReturnErrorMsg("找不到模板");
return;
}
var jt = new JsonTransfer();
jt.Add("data", temple);
Response.Write(jt.ToJson());
Response.End();
}
/// <summary>
/// 获取商户详情页面的一些配置列表
/// </summary>
public void GetCfgList()
{
var result = MerchantTypeHelper.GetList();
var tresult = TempleHelper.GetList();
var signlist = ParamHelper.PlatformCfgData.SignList;
var jt = new JsonTransfer();
var nowdate = DateTime.Now.ToString("yyyy-MM-d");
var serverdata = DateTime.Now.AddYears(1).ToString("yyyy-MM-d");;
jt.Add("mertypelist", result);
jt.Add("templelist", tresult.Results);
jt.Add("signlist", signlist);
jt.Add("nowdate", nowdate);
jt.Add("serverdata", serverdata);
Response.Write(jt.ToJson());
Response.End();
}
/// <summary>
/// 获取商户类型列表
/// </summary>
public void GetMerchantTypeList()
{
var type = GetInt("type");
var result = MerchantTypeHelper.GetList();
if (type == 0)
{
result.Insert(0, new MerchantType()
{
Id = 0, Name = "全部分类"
});
}
var jt = new JsonTransfer();
jt.Add("list", result);
Response.Write(jt.ToJson());
Response.End();
}
/// <summary>
/// 获取商户广告配置
/// </summary>
public void GetAdCfg()
{
var merchant = MerchantHelper.GetMerchant(CurSellerId);
if (merchant == null)
{
ReturnErrorMsg("不存在改id的商户");
return;
}
//var cfg = ParamHelper.GetMerchantCfgData(CurSellerId, merchant.Name);//ParamHelper.MerchantCfgData;
var jt = new JsonTransfer();
jt.Add("data", merchant);
var str = jt.ToJson();
Response.Write(str);
Response.End();
}
private void GetPayment()
{
var id = GetInt("id");
var payment = PaymentHelper.GetPayment(id);
if (payment == null)
{
ReturnErrorMsg("不存在该支付方式");
return;
}
var result = PaymentHelper.GetPayment(id);
var jt = new JsonTransfer();
jt.Add("data", result);
Response.Write(jt.ToJson());
Response.End();
}
/// <summary>
/// 获取商户信息
/// </summary>
public void GetMerchant()
{
var id = GetInt("id");
var user = AccountHelper.GetUser(id);
var merchant = MerchantHelper.GetMerchant(id);
if (merchant == null || user == null)
{
ReturnErrorMsg("商户不存在");
return;
}
var jt = new JsonTransfer();
jt.Add("mer", merchant);
jt.Add("user", user);
Response.Write(jt.ToJson());
Response.End();
}
/// <summary>
/// 获取充值统计
/// </summary>
private void GetConsumeStat()
{
var sellerId = CurSellerId;
var type = (StatisticsType)GetInt("type"); //统计类型
var start = GetInt("start"); //传0
var limit = GetInt("limit"); //传10 只取前十名
var data = new ConsumeStatResponse();
data.Stat = new ConsumeStatisticsHelper.ReqConsumeStatistics(type);
switch (type)
{
case StatisticsType.Day:
data.Stat = ConsumeStatisticsHelper.GetConsumeDateStatisticsList(sellerId, DateTime.Now); break;
case StatisticsType.Month:
data.Stat = ConsumeStatisticsHelper.GetConsumeMonthStatisticsList(sellerId, DateTime.Now.Year, DateTime.Now.Month); break;
case StatisticsType.Quarter:
data.Stat = ConsumeStatisticsHelper.GetConsumeQuarterStatisticsList(sellerId, DateTime.Now.Year); break;
case StatisticsType.Year:
data.Stat = ConsumeStatisticsHelper.GetConsumeYearStatisticsList(sellerId, DateTime.Now.Year); break;
}
var startTime = DateTime.Now;
var endTime = DateTime.Now;
switch (type)
{
case StatisticsType.Day:
startTime = DateTime.Now.Date;
endTime = startTime.AddDays(1).AddMilliseconds(-1);
break;
case StatisticsType.Month:
startTime = new DateTime(startTime.Year, startTime.Month, 1).Date;
endTime = startTime.AddMonths(1).AddMilliseconds(-1);
break;
case StatisticsType.Quarter:
case StatisticsType.Year:
startTime = new DateTime(startTime.Year, 1, 1).Date;
endTime = startTime.AddYears(1).AddMilliseconds(-1);
break;
}
var glist = new List <ConsumeGoodsItem>();
var list = ChargeLogHelper.GetChargeLogList(CurSellerId, startTime, endTime, start * limit, limit);
var index = 0;
foreach (var chargeLog in list)
{
index = 0;
foreach (var i in chargeLog.GidList)
{
var item = glist.FirstOrDefault(o => o.Gid == i);
if (item == null)
{
item = new ConsumeGoodsItem();
item.Gid = i;
item.Num = chargeLog.NumList[index];
glist.Add(item);
}
else
{
item.Num += chargeLog.NumList[index];
}
index++;
}
}
var goodslist = GoodsHelper.GetGoodsList(glist.Select(o => o.Gid).ToList());
foreach (var goodse in goodslist)
{
var ritem = new ReqConsumeStatItem();
ritem.GoodsName = goodse.Title;
ritem.GoodsCategoriesName = goodse.Cname;
var gitem = glist.FirstOrDefault(o => o.Gid == goodse.Id);
if (gitem != null)
{
ritem.Num = gitem.Num;
ritem.Pre = (ritem.Num * 1.0 / data.Stat.TotalGoodsNum * 100).ToString("F2");
}
data.List.Add(ritem);
}
data.List = data.List.OrderBy(o => o.Num).ToList();//排序
var jt = new JsonTransfer();
jt.Add("data", data);
Response.Write(jt.ToJson());
Response.End();
}
/// <summary>
/// 获取充值统计
/// </summary>
private void GetChargeStat()
{
var sellerId = CurSellerId;
var type = (StatisticsType)GetInt("type"); //统计类型
var start = GetInt("start"); //传0
var limit = GetInt("limit"); //传10 只取前十名
var data = new ChargeStatResponse();
data.Stat = new RechargeStatisticsHelper.ReqRechargeStatistics(type);
switch (type)
{
case StatisticsType.Day:
data.Stat = RechargeStatisticsHelper.GetRechargeDateStatisticsList(sellerId, DateTime.Now); break;
case StatisticsType.Month:
data.Stat = RechargeStatisticsHelper.GetRechargeMonthStatisticsList(sellerId, DateTime.Now.Year, DateTime.Now.Month); break;
case StatisticsType.Quarter:
data.Stat = RechargeStatisticsHelper.GetRechargeQuarterStatisticsList(sellerId, DateTime.Now.Year); break;
case StatisticsType.Year:
data.Stat = RechargeStatisticsHelper.GetRechargeYearStatisticsList(sellerId, DateTime.Now.Year); break;
}
var startTime = DateTime.Now;
var endTime = DateTime.Now;
switch (type)
{
case StatisticsType.Day:
startTime = DateTime.Now.Date;
endTime = startTime.AddDays(1).AddMilliseconds(-1);
break;
case StatisticsType.Month:
startTime = new DateTime(startTime.Year, startTime.Month, 1).Date;
endTime = startTime.AddMonths(1).AddMilliseconds(-1);
break;
case StatisticsType.Quarter:
case StatisticsType.Year:
startTime = new DateTime(startTime.Year, 1, 1).Date;
endTime = startTime.AddYears(1).AddMilliseconds(-1);
break;
}
var list = ChargeLogHelper.GetRechargeLogList(CurSellerId, startTime, endTime, start * limit, limit);
foreach (var chargeLog in list)
{
var item = new ReqChargeStatItem();
item.UserId = chargeLog.UserId;
item.TotalMoney = chargeLog.TotalMoney;
item.UserName = chargeLog.UserName;
item.Pre = (chargeLog.TotalMoney * 1.0 / data.Stat.TotalMoney * 100).ToString("F2");
data.List.Add(item);
}
var jt = new JsonTransfer();
jt.Add("data", data);
Response.Write(jt.ToJson());
Response.End();
}
/// <summary>
/// 获取订单详情
/// </summary>
public void GetOrdersDetail(HttpContext context)
{
var orderid = GetInt("orderid");
var orders = OrdersHelper.GetOrders(orderid);
if (orders == null)
{
ReturnErrorMsg("订单不存在");
return;
}
if (orders.SellerId != CurSellerId)
{
ReturnErrorMsg("无权访问订单");
return;
}
var merchant = MerchantHelper.GetMerchant(orders.SellerId);
if (merchant == null)
{
ReturnErrorMsg("不存在该id商户");
return;
}
if (orders.GidList.Count != orders.ImgList.Count || orders.ImgList.Count != orders.TitleList.Count || orders.TitleList.Count != orders.NumList.Count || orders.NumList.Count != orders.NowPriceList.Count)
{
ReturnErrorMsg("订单数据出错");
return;
}
var data = new OrdersDetailData();
data.Id = orders.Id;
data.CreateTime = orders.CreateTime.ToString("yyyy-M-d HH:mm:ss");
data.Status = (int)orders.GetReqStatus();
data.Type = (int)orders.OrderType;
data.Address = orders.Address;
data.LinkMan = orders.LinkMan;
data.Mobile = orders.Mobile;
data.CtotalPrice = orders.CtotalPrice;
data.Ccontent = orders.Ccontent;
data.Remark = orders.Remark;
data.TotalPrice = orders.TotalPrice;
data.StotalPrice = orders.StotalPrice;
data.SendPrice = merchant.Freight;
data.OrderTime = orders.OrderTime.ToString("yyyy-M-d HH:mm:ss");
//var merchantCfg = ParamHelper.GetMerchantCfgData(orders.SellerId, merchant.Name);
//if (merchantCfg != null)
//{
// data.SendPrice = merchantCfg.SendPrice;
//}
var i = 0;
foreach (var url in orders.ImgList)
{
var item = new OrdersGoodsItem();
item.ImgUrl = url;
item.Title = orders.TitleList[i];
item.NowPrice = orders.NowPriceList[i];
item.Num = orders.NumList[i];
item.TotalPrice = item.NowPrice * item.Num;
data.list.Add(item);
i++;
}
var jt = new JsonTransfer();
jt.Add("data", data);
Response.Write(jt.ToJson());
Response.End();
}
/// <summary>
/// 获取订单列表
/// </summary>
public void GetOrdersList()
{
int start = GetInt("start");
int limit = GetInt("limit");
var type = (ReqOrderStatus)(GetInt("type") + 1);
//if (type == ReqOrderStatus.WaitDeliverGoods) type = ReqOrderStatus.End;
var wheresql = "";//string.Format(" where Status={0} ", (int)OrderStatus.Pay)
switch (type)
{
case ReqOrderStatus.Pay:
wheresql = string.Format(" where Status={0} ", (int)OrderStatus.Pay);
break;
//case ReqOrderStatus.WaitDeliverGoods:
// wheresql = string.Format(" where OrderType={0} and Status={1} ", (int)OrderType.WaitDelivery, (int)OrderStatus.Pay);
// break;
case ReqOrderStatus.DeliverGoodsed:
wheresql = string.Format(" where OrderType={0} and Status={1} ", (int)OrderType.Deliveryed, (int)OrderStatus.Pay);
break;
case ReqOrderStatus.End:
wheresql = string.Format(" where Status={0} ", (int)OrderStatus.End);
break;
default: break;
}
if (string.IsNullOrEmpty(wheresql))
{
wheresql = string.Format(" where sellerId={0}", CurSellerId);
}
else
{
wheresql += string.Format(" and sellerId={0}", CurSellerId);
}
var result = OrdersHelper.GetOrdersList(wheresql, "", start * limit, limit, 1);
var list = new List <OrdersItem>();
foreach (var item in result.Results)
{
var i = new OrdersItem();
i.Id = item.Id;
i.UserId = item.UserId;
i.Money = item.TotalPrice;
i.CreateTime = item.CreateTime.ToString("yyyy-M-d HH:mm:ss");
i.GoodsCount = item.NumList.Sum(o => o);
i.Status = (int)item.GetReqStatus();
i.Type = (int)item.OrderType;
list.Add(i);
}
var jt = new JsonTransfer();
jt.Add("list", list);
jt.Add("count", result.TotalCount);
Response.Write(jt.ToJson());
Response.End();
}
