public void GetList()
{
int sellerid = GetInt("sellerid");
int start = GetInt("start");
int limit = GetInt("limit");
var result = CommentHelper.GetPagings(sellerid, CommentType.All, 0, start * limit, limit);
var data = new PagResults <object>();
foreach (var item in result.Results)
{
var user = AccountHelper.GetUser(item.UserId);
var feedbackStauts = item.Feedback != null && item.Feedback.Length > 0;
var o = new
{
Id = item.Id,
Title = item.Title,
Content = item.Content,
Feedback = item.Feedback,
FeedbackStatus = feedbackStauts ? "已回复" : "未回复",
CreateTime = item.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"),
Type = EnumHelper.CommentTypeToName(item.Type),
UserId = item.UserId,
UserName = user.UserName,
NickName = user.NickName
};
data.Results.Add(o);
}
data.TotalCount = result.TotalCount;
JsonTransfer jt = new JsonTransfer();
jt.AddSuccessParam();
jt.Add("data", data);
Response.Write(DesEncrypt(jt).ToLower());
Response.End();
}
/// <summary>
/// 图片列表接口
/// </summary>
/// <returns></returns>
public void GetList(HttpContext context)
{
int pageIndex = GetInt("start");
int pageSize = GetInt("limit");
int sellerId = GetInt("sellerid");
PagResults <SourceMaterial> results = SourceMaterialHelper.GetPaging(pageIndex * pageSize, pageSize, sellerId);
var data = new List <object>();
foreach (var r in results.Results)
{
var imgurl = Utility.GetSizePicUrl(r.Url, 200, 0, context);
var d = new
{
pid = r.Id,
img = imgurl,
height = Utility.GetImgHeight(imgurl, context),
title = r.Title
};
r.Views += 1;
SourceMaterialHelper.Update(r);
data.Add(d);
}
JsonTransfer jt = new JsonTransfer();
jt.AddSuccessParam();
jt.Add("data", data);
Response.Write(DesEncrypt(jt).ToLower());
Response.End();
}
private void GetCashs()
{
int index = GetInt("start");
int size = GetInt("limit");
var cashs = ExtractMoneyHelper.GetPagings(0, index * size, size);
var results = new PagResults <object>();
results.TotalCount = cashs.TotalCount;
foreach (var c in cashs.Results)
{
var item = new
{
Id = c.Id,
Fee = c.Fee,
Bank = c.Bank,
CardNumber = c.CardNumber,
AccountName = c.AccountName,
Money = c.Money,
SellerId = c.SellerId,
Status = c.Status == 1 ? "已处理" : "未处理",
CreateTime = c.CreateTime.ToString("yyyy-MM-dd HH:mm:ss")
};
results.Results.Add(item);
}
JsonTransfer jt = new JsonTransfer();
jt.Add("data", results);
Response.Write(DesEncrypt(jt));
Response.End();
}
private void GetCashList()
{
var sellerId = GetInt("sellerid");
var start = GetInt("start");
var limit = GetInt("limit");
var result = ExtractMoneyHelper.GetPagings(sellerId, start * limit, limit);
var data = new PagResults <object>();
data.TotalCount = result.TotalCount;
foreach (var item in result.Results.OrderByDescending(o => o.CreateTime))
{
var d = new
{
Id = item.Id,
CreateTime = item.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"),
Money = item.Money,
Fee = item.Fee,
Balance = item.Balance,
Bank = item.Bank,
CardNumber = item.CardNumber,
Status = item.Status == 1 ? "提现成功" : "处理中",
SellerId = item.SellerId
};
data.Results.Add(d);
}
JsonTransfer jt = new JsonTransfer();
jt.Add("data", data);
Response.Write(DesEncrypt(jt));
Response.End();
}
private void GetAdmins()
{
int index = GetInt("start");
int size = GetInt("limit");
var admins = AccountHelper.GetPagAdmins(index * size, size);
var result = new PagResults <object>();
result.TotalCount = admins.TotalCount;
foreach (var admin in admins.Results)
{
result.Results.Add(new
{
Id = admin.Id,
NickName = admin.NickName,
RoleType = GetRoleTypeName(admin.RoleType),
LastLoginTime = admin.LastLoginTime.ToString("yyyy-MM-dd HH:mm:ss")
});
}
JsonTransfer jt = new JsonTransfer();
jt.Add("data", result);
Response.Write(DesEncrypt(jt));
Response.End();
}
private void GetPushs()
{
var sellerId = GetInt("sellerid");
var start = GetInt("start");
var limit = GetInt("limit");
var list = SystemHelper.GetPagPushs(sellerId, start * limit, limit);
var items = new PagResults <object>();
foreach (var l in list.Results)
{
var o = new
{
Id = l.Id,
CreateTime = l.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"),
Title = l.Title,
Content = l.Content,
PushType = l.PushType,
SellerId = l.SellerId,
TypeId = l.TypeId
};
items.Results.Add(o);
}
items.TotalCount = list.TotalCount;
JsonTransfer jt = new JsonTransfer();
jt.Add("data", list);
Response.Write(DesEncrypt(jt).ToLower());
Response.End();
}
private void GetList()
{
var sellerId = GetInt("sellerId");
var index = GetInt("start");
var size = GetInt("limit");
var cid = GetInt("cid");
var status = GetInt("status");
var list = PositionHelper.GetPaging(sellerId, index * size, size, cid);
var results = new PagResults <object>();
var boxTypes = PositionHelper.GetListBoxTypes(sellerId, 0, 0);
results.TotalCount = list.TotalCount;
foreach (var item in list.Results)
{
var boxType = boxTypes.FirstOrDefault(b => b.Id == item.BoxTypeId);
var o = new
{
Id = item.Id,
BoxNumber = item.BoxNumber,
BoxTypeId = item.BoxTypeId,
BoxTypeTitle = boxType.Title,
Lowest = boxType.Lowest
};
results.Results.Add(o);
}
JsonTransfer jt = new JsonTransfer();
jt.Add("data", results);
Response.Write(DesEncrypt(jt));
Response.End();
}
private void Orders()
{
var sellerId = GetInt("sellerId");
var index = GetInt("start");
var size = GetInt("limit");
var pages = PositionHelper.GetPagingUserPosition(sellerId, index * size, size);
var list = new PagResults <object>();
list.TotalCount = pages.TotalCount;
foreach (var item in pages.Results)
{
var position = PositionHelper.GetItem(item.PositionId);
var boxType = PositionHelper.GetBoxType(position.BoxTypeId);
var timeline = PositionHelper.GetTimeLine(item.TimeId);
list.Results.Add(new
{
Id = item.Id,
BoxNumber = position.BoxNumber,
BoxTypeId = position.BoxTypeId,
BoxTypeTitle = boxType.Title,
Time = timeline.BeginTime.ToString("HH:mm") + "-" + timeline.EndTime.ToString("HH:mm"),
NickName = item.NickName,
Phone = item.Phone,
CreateTime = item.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"),
Status = OrderStatusToName(item.Status)
});
}
JsonTransfer jt = new JsonTransfer();
jt.Add("data", list);
Response.Write(DesEncrypt(jt));
Response.End();
}
/// <summary>
///
/// </summary>
/// <param name="sellId"></param>
/// <param name="type"></param>
/// <param name="index"></param>
/// <param name="size"></param>
/// <param name="order">排序sql</param>
/// <returns></returns>
public static PagResults<Active> GetPagings(int sellerId, int index, int size, string order = "")
{
var results = new PagResults<Active>();
results.Results = new List<Active>();
string commandText = @"select * from active where sellerId = ?sellerId LIMIT ?index,?size " + order;
List<MySqlParameter> parameters = new List<MySqlParameter>();
parameters.Add(new MySqlParameter("?sellerId", sellerId));
parameters.Add(new MySqlParameter("?index", index));
parameters.Add(new MySqlParameter("?size", size));
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text,
commandText, parameters.ToArray());
while (reader.Read())
{
Active a = new Active();
a.Id = (int)reader["Id"];
a.SellerId = (int)reader["SellerId"];
a.CouponId = (int)reader["CouponId"];
a.CoverImgId = (int)reader["CoverImgId"];
a.CoverImgUrl = reader["CoverImgUrl"].ToString();
a.Title = reader["Title"].ToString();
a.Summary = reader["Summary"].ToString();
a.Description = reader["Description"].ToString();
a.CreateTime = (DateTime)reader["CreateTime"];
a.Views = (int)reader["Views"];
a.Commentnum = (int)reader["Commentnum"];
results.Results.Add(a);
}
//一个函数有两次连接数据库 先把连接断开 然后重连
conn.Close();
conn.Dispose();
conn.Open();
commandText = "select count(*) from active where sellerId = ?sellerId";
parameters.Clear();
parameters.Add(new MySqlParameter("?sellerId", sellerId));
reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText,
parameters.ToArray());
if (reader.HasRows)
{
if (reader.Read())
{
results.TotalCount = reader.GetInt32(0);
}
}
}
}
catch (System.Exception ex)
{
throw;
}
return results;
}
public static PagResults <SourceMaterial> GetPaging(int pageIndex, int pageSize, int sellerId)
{
var results = new PagResults <SourceMaterial>();
results.Results = new List <SourceMaterial>();
int totalnum = 0;
string commandText = @"select * from material where sellerId = ?sellerId order by CreateTime desc LIMIT ?index,?size";
List <MySqlParameter> parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("?sellerId", sellerId));
parameters.Add(new MySqlParameter("?index", pageIndex));
parameters.Add(new MySqlParameter("?size", pageSize));
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
while (reader.Read())
{
SourceMaterial sm = new SourceMaterial();
sm.Id = reader.GetInt32(0);
sm.Url = reader["Url"].ToString();
sm.Title = reader["Title"].ToString();
sm.Description = reader["Description"].ToString();
sm.Views = (int)reader["Views"];
sm.Commentnum = (int)reader["Commentnum"];
sm.SellerId = (int)reader["SellerId"];
sm.CreateTime = (DateTime)reader["CreateTime"];
sm.ImageType = (UploadType)reader["ImageType"];
results.Results.Add(sm);
}
//一个函数有两次连接数据库 先把连接断开 然后重连
conn.Close();
conn.Dispose();
conn.Open();
commandText = @"select count(*) from material where sellerId=?sellerId";
parameters.Clear();
parameters.Add(new MySqlParameter("?sellerId", sellerId));
reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
if (reader.HasRows)
{
if (reader.Read())
{
results.TotalCount = reader.GetInt32(0);
}
}
}
}
catch (System.Exception ex)
{
throw;
}
return(results);
}
internal static PagResults <Timeline> GetTimeLines(int positionId, int sellerId, int index, int size)
{
var results = new PagResults <Timeline>();
int totalnum = 0;
string commandText = @"select * from timeline where positionId = ?positionId and sellerId = ?sellerId limit ?index,?size";
List <MySqlParameter> parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("?positionId", positionId));
parameters.Add(new MySqlParameter("?sellerId", sellerId));
parameters.Add(new MySqlParameter("?index", index));
parameters.Add(new MySqlParameter("?size", size));
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
while (reader.Read())
{
Timeline t = new Timeline();
t.Id = reader.GetInt32(0);
t.PositionId = (int)reader["PositionId"];
t.Status = (int)reader["Status"];
t.Title = reader["Title"].ToString();
t.BeginTime = (DateTime)reader["BeginTime"];
t.EndTime = (DateTime)reader["EndTime"];
t.SellerId = (int)reader["SellerId"];
t.Date = (DateTime)reader["Date"];
results.Results.Add(t);
}
conn.Close();
conn.Dispose();
conn.Open();
commandText = @"select count(*) from timeline where positionId = ?positionId and sellerId = ?sellerId";
parameters.Clear();
parameters.Add(new MySqlParameter("?positionId", positionId));
parameters.Add(new MySqlParameter("?sellerId", sellerId));
reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
if (reader.HasRows)
{
if (reader.Read())
{
results.TotalCount = reader.GetInt32(0);
}
}
}
}
catch (System.Exception ex)
{
throw;
}
return(results);
}
public static PagResults <BoxType> GetPagingBoxTypes(int sellerId, int pageIndex, int pageSize)
{
var results = new PagResults <BoxType>();
string commandText = @"select * from boxtype where sellerId = ?sellerId LIMIT ?index,?size";
List <MySqlParameter> parameters = new List <MySqlParameter>();
if (pageSize == 0)
{
commandText = @"select * from boxtype where sellerId = ?sellerId";
parameters.Add(new MySqlParameter("?sellerId", sellerId));
}
else
{
parameters.Add(new MySqlParameter("?sellerId", sellerId));
parameters.Add(new MySqlParameter("?index", pageIndex));
parameters.Add(new MySqlParameter("?size", pageSize));
}
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
while (reader.Read())
{
BoxType b = new BoxType();
b.Id = reader.GetInt32(0);
b.SellerId = (int)reader["SellerId"];
b.HoldNum = (int)reader["HoldNum"];
b.Lowest = (int)reader["Lowest"];
b.Title = reader["Title"].ToString();
results.Results.Add(b);
}
conn.Close();
conn.Dispose();
conn.Open();
commandText = @"select count(*) from boxType where sellerId = ?sellerId";
parameters.Clear();
parameters.Add(new MySqlParameter("?sellerId", sellerId));
reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
if (reader.HasRows)
{
if (reader.Read())
{
results.TotalCount = reader.GetInt32(0);
}
}
}
}
catch (System.Exception ex)
{
throw;
}
return(results);
}
public static PagResults <Fastlinks> GetPagFastlinks(int start, int limit)
{
var results = new PagResults <Fastlinks>();
string commandText; List <MySqlParameter> parameters = new List <MySqlParameter>();
if (limit == 0)
{
commandText = @"select * from fastlinks order by CreateTime desc";
}
else
{
commandText = @"select * from fastlinks order by CreateTime desc limit ?index,?size";
parameters.Add(new MySqlParameter("?index", start));
parameters.Add(new MySqlParameter("?size", limit));
}
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
while (reader.Read())
{
Fastlinks f = new Fastlinks();
f.Id = reader.GetInt32(0);
f.Title = reader["Title"].ToString();
f.ImgUrl = reader["ImgUrl"].ToString();
f.Url = reader["Url"].ToString();
f.CreateTime = (DateTime)reader["CreateTime"];
results.Results.Add(f);
}
//一个函数有两次连接数据库 先把连接断开 然后重连
conn.Close();
conn.Dispose();
conn.Open();
commandText = @"select count(*) from fastlinks";
reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
if (reader.HasRows)
{
if (reader.Read())
{
results.TotalCount = reader.GetInt32(0);
}
}
}
}
catch (System.Exception ex)
{
throw;
}
return(results);
}
/// <summary>
/// 获取模板列表
/// </summary>
/// <returns></returns>
public static PagResults <Temple> GetList(int typeid = 0, int start = 0, int limit = 0)
{
var result = new PagResults <Temple>();
result.Results = new List <Temple>();
string wheresql = typeid == 0 ? string.Empty : string.Format(" where TypeId={0} ", typeid);
string limitsql = limit != 0 ? " LIMIT ?start,?limit" : string.Empty;
var cmdText = @"select * from Temple " + wheresql + limitsql;
List <MySqlParameter> parameters = new List <MySqlParameter>();
if (!string.IsNullOrEmpty(limitsql))
{
parameters.Add(new MySqlParameter("?start", start));
parameters.Add(new MySqlParameter("?limit", limit));
}
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, cmdText, parameters.ToArray());
while (reader.Read())
{
Temple temple = new Temple();
temple.Id = reader.GetInt32(0);
temple.Name = reader["Name"].ToString();
temple.LogoUrl = reader["LogoUrl"].ToString();
temple.TypeId = (int)reader["TypeId"];
result.Results.Add(temple);
}
//一个函数有两次连接数据库 先把连接断开 然后重连
conn.Close();
conn.Dispose();
conn.Open();
cmdText = "select count(*) from Temple " + wheresql;
reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, cmdText);
if (reader.HasRows)
{
if (reader.Read())
{
result.TotalCount = reader.GetInt32(0);
}
}
}
}
catch (System.Exception ex)
{
throw;
}
return(result);
}
/// <summary>
/// 获取用户未领取的优惠券
/// </summary>
/// <param name="sellerId"></param>
/// <param name="ids"></param>
/// <param name="p"></param>
/// <param name="size"></param>
/// <returns></returns>
internal static PagResults <Coupon> GetPagingUnGetCoupon(int userId, int sellerId, int index, int size)
{
var results = new PagResults <Coupon>();
results.Results = new List <Coupon>();
string limitsql = size == 0 ? " limit ?index,?size" : string.Empty;
string commandText = @"select * from coupon where id not in (select couponid from usercoupon where sellerId = ?sellerId and userId = ?userId) and sellerId=?sellerId and Enabled=1 order by Expiry desc" + limitsql;//and a.GoodsIds not LIKE ?gids
List <MySqlParameter> parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("?userId", userId));
parameters.Add(new MySqlParameter("?sellerId", sellerId));
if (size == 0)
{
parameters.Add(new MySqlParameter("?index", index));
parameters.Add(new MySqlParameter("?size", size));
}
//parameters.Add(new MySqlParameter("?gids", gids + "%"));
try
{
using (var conn = new MySqlConnection(GlobalConfig.DbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
while (reader.Read())
{
var c = new Coupon();
c.Id = reader.GetInt32(0);
c.ImgId = (int)reader["ImgId"];
c.ImgUrl = reader["ImgUrl"].ToString();
c.Title = reader["Title"].ToString();
c.Description = reader["Description"].ToString();
c.Expiry = (DateTime)reader["Expiry"];
c.Extcredit = (int)reader["Extcredit"];
c.FullMoney = (int)reader["FullMoney"];
c.DiscountMoney = (int)reader["DiscountMoney"];
c.GoodsIds = Utility.GetListint(reader["GoodsIds"].ToString());
c.Commentnum = (int)reader["Commentnum"];
c.Views = (int)reader["Views"];
c.SellerId = (int)reader["SellerId"];
c.Enabled = (int)reader["Enabled"];
results.Results.Add(c);
}
}
}
catch (System.Exception ex)
{
throw;
}
return(results);
}
public static PagResults <Push> GetPagPushs(int sellerId, int start, int limit)
{
var results = new PagResults <Push>();
string commandText = @"select * from push where sellerId = ?sellerId order by CreateTime desc limit ?index,?size";
List <MySqlParameter> parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("?sellerId", sellerId));
parameters.Add(new MySqlParameter("?index", start));
parameters.Add(new MySqlParameter("?size", limit));
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
while (reader.Read())
{
Push p = new Push();
p.Id = reader.GetInt32(0);
p.SellerId = (int)reader["SellerId"];
p.CreateTime = (DateTime)reader["CreateTime"];
p.TypeId = (int)reader["Discount"];
p.PushType = (PushType)reader["PushType"];
p.Title = reader["Title"].ToString();
p.Content = reader["Content"].ToString();
p.CreateTime = (DateTime)reader["CreateTime"];
results.Results.Add(p);
}
//一个函数有两次连接数据库 先把连接断开 然后重连
conn.Close();
conn.Dispose();
conn.Open();
commandText = @"select count(*) from push";
reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
if (reader.HasRows)
{
if (reader.Read())
{
results.TotalCount = reader.GetInt32(0);
}
}
}
}
catch (System.Exception ex)
{
throw;
}
return(results);
}
/// <summary>
/// 获取公告列表
/// </summary>
/// <returns></returns>
public static PagResults <Announcement> GetList(int start, int limit)
{
var result = new PagResults <Announcement>();
result.Results = new List <Announcement>();
string limitsql = limit != 0 ? " LIMIT ?start,?limit" : string.Empty;
var cmdText = @"select * from Announcement " + limitsql;
List <MySqlParameter> parameters = new List <MySqlParameter>();
if (!string.IsNullOrEmpty(limitsql))
{
parameters.Add(new MySqlParameter("?start", start));
parameters.Add(new MySqlParameter("?limit", limit));
}
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, cmdText, parameters.ToArray());
while (reader.Read())
{
Announcement announcement = new Announcement();
announcement.Id = reader.GetInt32(0);
announcement.Content = reader["Content"].ToString();
announcement.CreateTime = (DateTime)reader["CreateTime"];
result.Results.Add(announcement);
}
//一个函数有两次连接数据库 先把连接断开 然后重连
conn.Close();
conn.Dispose();
conn.Open();
cmdText = string.Format("select count(*) from Announcement;");
reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, cmdText);
if (reader.HasRows)
{
if (reader.Read())
{
result.TotalCount = reader.GetInt32(0);
}
}
}
}
catch (System.Exception ex)
{
throw;
}
return(result);
}
/// <summary>
/// 图片列表接口
/// </summary>
/// <returns></returns>
public void GetList()
{
int pageIndex = GetInt("start");
int pageSize = GetInt("limit");
int sellerId = GetInt("sellerid");
PagResults <SourceMaterial> data = SourceMaterialHelper.GetPaging(pageIndex * pageSize, pageSize, sellerId);
JsonTransfer jt = new JsonTransfer();
jt.AddSuccessParam();
jt.Add("data", data);
Response.Write(DesEncrypt(jt).ToLower());
Response.End();
}
/// <summary>
/// 获取订单可用的优惠券列表
/// </summary>
/// <param name="userId"></param>
/// <param name="sellerId"></param>
/// <param name="gids"></param>
/// <returns></returns>
public static PagResults <Coupon> GetOrderCouponList(int userId, int sellerId)//, string gids
{
var results = new PagResults <Coupon>();
results.Results = new List <Coupon>();
string commandText = @"select a.*,b.Id as userCouponId from coupon a left join usercoupon b on a.id=b.CouponId where b.userId = ?userId and a.SellerId=?sellerId and b.Status = 0 order by Expiry desc ";//and a.GoodsIds not LIKE ?gids
List <MySqlParameter> parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("?userId", userId));
parameters.Add(new MySqlParameter("?sellerId", sellerId));
//parameters.Add(new MySqlParameter("?gids", gids + "%"));
try
{
using (var conn = new MySqlConnection(GlobalConfig.DbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
while (reader.Read())
{
Coupon c = new Coupon();
c.Id = Convert.ToInt32(reader["userCouponId"]);
c.ImgId = (int)reader["ImgId"];
c.ImgUrl = reader["ImgUrl"].ToString();
c.Title = reader["Title"].ToString();
c.Description = reader["Description"].ToString();
c.Expiry = (DateTime)reader["Expiry"];
c.Extcredit = (int)reader["Extcredit"];
c.FullMoney = (int)reader["FullMoney"];
c.DiscountMoney = (int)reader["DiscountMoney"];
c.GoodsIds = Utility.GetListint(reader["GoodsIds"].ToString());
c.Commentnum = (int)reader["Commentnum"];
c.Views = (int)reader["Views"];
c.SellerId = (int)reader["SellerId"];
c.Enabled = (int)reader["Enabled"];
results.Results.Add(c);
}
}
}
catch (System.Exception ex)
{
throw;
}
return(results);
}
public void GetList(HttpContext context)
{
int index = GetInt("start");
int size = GetInt("limit");
int sid = GetInt("sellerid");
int uid = GetInt("uid");
//var results = CouponHelper.GetPagings(sid, 0, 0);
PagResults <Coupon> results = new PagResults <Coupon>();
if (uid != 0)
{
results = CouponHelper.GetPagingUnGetCoupon(uid, sid, index * size, size);
}
else
{
results = CouponHelper.GetPagings(sid, index * size, size);
}
var data = new List <object>();
foreach (var r in results.Results)
{
var d = new
{
couponid = r.Id,
title = r.Title,
img = Utility.GetSizePicUrl(r.ImgUrl, 180, 143, context),
extcredit = r.Extcredit,
expiry = r.Expiry.GetUnixTime(),
description = r.Description,
Views = r.Views,
Commentnum = r.Commentnum
};
data.Add(d);
}
JsonTransfer jt = new JsonTransfer();
jt.AddSuccessParam();
jt.Add("data", data);
Response.Write(DesEncrypt(jt).ToLower());
Response.End();
}
public void GetList()
{
int index = GetInt("start");
int size = GetInt("limit");
int sid = GetInt("sellerid");
int type = GetInt("type");
var results = CouponHelper.GetPagings(sid, type, index * size, size);
var data = new PagResults <object>();
data.TotalCount = results.TotalCount;
foreach (var item in results.Results)
{
var o = new
{
Id = item.Id,
ImgId = item.ImgId,
ImgUrl = item.ImgUrl == "" ? "http://placehold.it/180x90" : item.ImgUrl,
SellerId = item.SellerId,
Enabled = item.Enabled,
Summary = item.Summary,
Title = item.Title,
Commentnum = item.Commentnum,
Description = item.Description,
DiscountMoney = item.DiscountMoney,
Expiry = item.Expiry.ToString("yyyy-MM-dd HH:mm:ss"),
Extcredit = item.Extcredit,
FullMoney = item.FullMoney,
DownloadTimes = item.DownloadTimes,
UserTimes = item.UsedTimes
};
data.Results.Add(o);
}
JsonTransfer jt = new JsonTransfer();
jt.AddSuccessParam();
jt.Add("data", data);
Response.Write(DesEncrypt(jt).ToLower());
Response.End();
}
public void GetList()
{
int index = GetInt("start");
int size = GetInt("limit");
int sid = GetInt("sellerid");
var data = ActiveHelper.GetPagings(sid, index * size, size);
var result = new PagResults <object>();
result.TotalCount = data.TotalCount;
foreach (var item in data.Results)
{
var o = new
{
Id = item.Id,
SellerId = item.SellerId,
Summary = item.Summary,
Title = item.Title,
Views = item.Views,
Commentnum = item.Commentnum,
ImgId = item.CoverImgId,
HasCoupon = item.CouponId != 0,
ImgUrl = item.CoverImgUrl == "" ? "http://placehold.it/128x128" : item.CoverImgUrl,
CreateTime = item.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"),
Description = item.Description
};
result.Results.Add(o);
}
JsonTransfer jt = new JsonTransfer();
jt.AddSuccessParam();
jt.Add("data", result);
Response.Write(DesEncrypt(jt).ToLower());
Response.End();
}
private void GetGoods()
{
var sellerid = GetInt("sellerid");
var start = GetInt("start");
var limit = GetInt("limit");
var goods = GoodsHelper.GetGoodsList(sellerid, "", "", start * limit, limit);
var data = new PagResults <object>();
data.TotalCount = goods.TotalCount;
foreach (var item in goods.Results)
{
var o = new
{
id = item.Id,
title = item.Title
};
data.Results.Add(o);
}
JsonTransfer jt = new JsonTransfer();
jt.Add("data", data);
Response.Write(DesEncrypt(jt).ToLower());
Response.End();
}
public static PagResults <ExtcreditLog> GetExtcreditLogList(int sellerId, int userId, int start = 0,
int limit = 0, int ifgetcount = 0)
{
var result = new PagResults <ExtcreditLog>();
result.Results = new List <ExtcreditLog>();
string limitsql = limit != 0 ? " LIMIT ?start,?limit" : string.Empty;
var cmdText = @"select * from ExtcreditLog where SellerId=?SellerId and UserId=?UserId order by createtime desc " + limitsql;
List <MySqlParameter> parameters = new List <MySqlParameter>();
if (limit != 0)
{
parameters.Add(new MySqlParameter("?start", start));
parameters.Add(new MySqlParameter("?limit", limit));
}
parameters.Add(new MySqlParameter("?SellerId", sellerId));
parameters.Add(new MySqlParameter("?UserId", userId));
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, cmdText,
parameters.ToArray());
while (reader.Read())
{
ExtcreditLog extcreditLog = new ExtcreditLog();
extcreditLog.Id = reader.GetInt32(0);
extcreditLog.SellerId = (int)reader["SellerId"];
extcreditLog.UserId = (int)reader["UserId"];
extcreditLog.SourceId = (int)reader["SourceId"];
extcreditLog.Extcredit = (int)reader["Extcredit"];
extcreditLog.Type = (ExtcreditSourceType)reader["Type"];
extcreditLog.CreateTime = (DateTime)reader["CreateTime"];
result.Results.Add(extcreditLog);
}
//一个函数有两次连接数据库 先把连接断开 然后重连
conn.Close();
conn.Dispose();
conn.Open();
if (ifgetcount > 0)
{
cmdText = cmdText = @"select count(*) from ExtcreditLog where SellerId=?SellerId and UserId=?UserId;";
parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("?SellerId", sellerId));
parameters.Add(new MySqlParameter("?UserId", userId));
reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, cmdText, parameters.ToArray());
if (reader.HasRows)
{
if (reader.Read())
{
result.TotalCount = reader.GetInt32(0);
}
}
}
}
}
catch (System.Exception ex)
{
throw;
}
return(result);
}
/// <summary>
/// 获取分类列表
/// </summary>
/// <param name="sellerId"></param>
/// <param name="totalnum"></param>
/// <param name="wheresql"></param>
/// <param name="ordersql"></param>
/// <param name="start"></param>
/// <param name="limit"></param>
/// <returns></returns>
public static PagResults <GoodsCategories> GetList(int sellerId, string wheresql = "",
string ordersql = "", int start = 0, int limit = 0, int isgettotal = 0)
{
var result = new PagResults <GoodsCategories>();
result.Results = new List <GoodsCategories>();
if (ordersql == "")
{
ordersql = " order by `Index` ";
}
string limitsql = limit != 0 ? " LIMIT ?start,?limit" : string.Empty;
var cmdText = @"select * from GoodsCategories where SellerId=?SellerId " + wheresql + ordersql + limitsql;
List <MySqlParameter> parameters = new List <MySqlParameter>();
if (!string.IsNullOrEmpty(limitsql))
{
parameters.Add(new MySqlParameter("?start", start));
parameters.Add(new MySqlParameter("?limit", limit));
}
parameters.Add(new MySqlParameter("?SellerId", sellerId));
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, cmdText,
parameters.ToArray());
while (reader.Read())
{
GoodsCategories goodsCategories = new GoodsCategories();
goodsCategories.Id = reader.GetInt32(0);
goodsCategories.Index = (int)reader["Index"];
goodsCategories.Name = reader["Name"].ToString();
goodsCategories.SellerId = (int)reader["SellerId"];
goodsCategories.Count = (int)reader["Count"];
goodsCategories.ImageUrl = reader["ImageUrl"].ToString();
goodsCategories.Color = reader["Color"].ToString();
result.Results.Add(goodsCategories);
}
if (isgettotal > 0)
{
//一个函数有两次连接数据库 先把连接断开 然后重连
conn.Close();
conn.Dispose();
conn.Open();
cmdText = @"select count(*) from GoodsCategories where SellerId=?SellerId " + wheresql;
parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("?SellerId", sellerId));
reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, cmdText,
parameters.ToArray());
if (reader.HasRows)
{
if (reader.Read())
{
result.TotalCount = reader.GetInt32(0);
}
}
}
}
}
catch (System.Exception ex)
{
throw;
}
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="sellId"></param>
/// <param name="type"></param>
/// <param name="index"></param>
/// <param name="size"></param>
/// <param name="order">排序sql</param>
/// <returns></returns>
public static PagResults <Comment> GetPagings(int sellerId, CommentType type, int typeId, int index, int size, string order = "order by CreateTime desc")
{
var results = new PagResults <Comment>();
results.Results = new List <Comment>();
int skipnum = index * size;
int totalnum = 0;
string commandText = "";
if (type == CommentType.All)
{
commandText = @"select * from comment where sellerId = ?sellerId " + order + " LIMIT ?index,?size";
}
else
{
commandText = @"select * from comment where sellerId = ?sellerId and type = ?type and typeId = ?typeId " + order + " LIMIT ?index,?size";
}
List <MySqlParameter> parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("?sellerId", sellerId));
if (type != CommentType.All)
{
parameters.Add(new MySqlParameter("?type", (int)type));
parameters.Add(new MySqlParameter("?typeId", typeId));
}
parameters.Add(new MySqlParameter("?index", index));
parameters.Add(new MySqlParameter("?size", size));
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
while (reader.Read())
{
Comment c = new Comment();
c.Id = (int)reader["Id"];
c.SellerId = (int)reader["SellerId"];
c.Type = (CommentType)reader["Type"];
c.TypeId = (int)reader["TypeId"];
c.Content = reader["Content"].ToString();
c.CreateTime = (DateTime)reader["CreateTime"];
c.UserId = (int)reader["UserId"];
c.Img = reader["Img"].ToString();
c.Title = reader["Title"].ToString();
c.Feedback = reader["Feedback"].ToString();
results.Results.Add(c);
}
//一个函数有两次连接数据库 先把连接断开 然后重连
conn.Close();
conn.Dispose();
conn.Open();
if (type == CommentType.All)
{
commandText = @"select count(*) from comment where sellerId = ?sellerId ";
}
else
{
commandText = "select count(*) from comment where sellerId = ?sellerId and type = ?type and typeId = ?typeId";
}
parameters.Clear();
parameters.Add(new MySqlParameter("?sellerId", sellerId));
parameters.Add(new MySqlParameter("?type", (int)type));
parameters.Add(new MySqlParameter("?typeId", typeId));
reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
while (reader.Read())
{
results.TotalCount = reader.GetInt32(0);
}
}
}
catch (System.Exception ex)
{
throw;
}
return(results);
}
public static PagResults <ChargeLog> GetChargeLogs(int sellerId, int start = 0, int limit = 0,
int ifgetcount = 0)
{
var result = new PagResults <ChargeLog>();
result.Results = new List <ChargeLog>();
string limitsql = start != 0 ? " LIMIT ?start,?limit" : string.Empty;
var cmdText =
@"select * from ChargeLog where SellerId=?SellerId order by createtime desc " +
limitsql;
List <MySqlParameter> parameters = new List <MySqlParameter>();
if (limit != 0)
{
parameters.Add(new MySqlParameter("?start", start));
parameters.Add(new MySqlParameter("?limit", limit));
}
parameters.Add(new MySqlParameter("?SellerId", sellerId));
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, cmdText,
parameters.ToArray());
while (reader.Read())
{
ChargeLog ChargeLog = new ChargeLog();
ChargeLog.Id = reader.GetInt32(0);
ChargeLog.SellerId = (int)reader["SellerId"];
ChargeLog.UserId = (int)reader["UserId"];
ChargeLog.Money = (float)reader["Money"];
ChargeLog.Pid = (int)reader["Pid"];
ChargeLog.PayName = reader["PayName"].ToString();
ChargeLog.OrderId = reader["OrderId"].ToString();
ChargeLog.CreateTime = (DateTime)reader["CreateTime"];
ChargeLog.Status = (RechargeStatus)reader["Status"];
ChargeLog.UpdateStatusTime = (DateTime)reader["UpdateStatusTime"];
ChargeLog.UpdateStatusTime = (DateTime)reader["UpdateStatusTime"];
ChargeLog.GidList = Utility.GetListint(reader["Gids"].ToString());
ChargeLog.NumList = Utility.GetListint(reader["Nums"].ToString());
ChargeLog.Num = (int)reader["Num"];
result.Results.Add(ChargeLog);
}
if (ifgetcount > 0)
{
//一个函数有两次连接数据库 先把连接断开 然后重连
conn.Close();
conn.Dispose();
conn.Open();
cmdText = @"select count(*) from ChargeLog where SellerId=?SellerId";
parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("?SellerId", sellerId));
reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, cmdText, parameters.ToArray());
if (reader.HasRows)
{
if (reader.Read())
{
result.TotalCount = reader.GetInt32(0);
}
}
}
}
}
catch (System.Exception ex)
{
throw;
}
return(result);
}
/// <summary>
/// 根据条件获取产品列表
/// </summary>
/// <param name="sellerId"></param>
/// <param name="wheresql"></param>
/// <param name="ordersql"></param>
/// <param name="start"></param>
/// <param name="limit"></param>
/// <param name="gettotal"></param>
/// <returns></returns>
public static PagResults <Goods> GetGoodsList(int sellerId, string wheresql = "",
string ordersql = "", int start = 0, int limit = 0, int gettotal = 0)
{
var result = new PagResults <Goods>();
result.Results = new List <Goods>();
if (ordersql == "")
{
ordersql = " order by CreateTime desc ";
}
string limitsql = limit != 0 ? " LIMIT ?start,?limit" : string.Empty;
var cmdText = @"select a.*,b.Name Cname from Goods a join GoodsCategories b on a.Cid=b.Id where a.SellerId=?SellerId " + wheresql + ordersql + limitsql;
List <MySqlParameter> parameters = new List <MySqlParameter>();
if (!string.IsNullOrEmpty(limitsql))
{
parameters.Add(new MySqlParameter("?start", start));
parameters.Add(new MySqlParameter("?limit", limit));
}
parameters.Add(new MySqlParameter("?SellerId", sellerId));
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, cmdText,
parameters.ToArray());
while (reader.Read())
{
Goods goods = new Goods();
goods.Id = reader.GetInt32(0);
goods.SellerId = (int)reader["SellerId"];
//goods.Logo = (int)reader["Logo"];
//goods.ImgIdList = Utility.GetListint(reader["ImgIds"].ToString());
goods.Sales = (int)reader["Sales"];
goods.Title = reader["Title"].ToString();
goods.Cid = (int)reader["Cid"];
goods.Nowprice = (float)reader["Nowprice"];
goods.OriginalPrice = (float)reader["OriginalPrice"];
goods.Score = (float)reader["Score"];
goods.CreateTime = (DateTime)reader["CreateTime"];
goods.FavCount = (int)reader["FavCount"];
goods.ShareCount = (int)reader["ShareCount"];
goods.TagList = Utility.GetListstring(reader["Tag"].ToString());
goods.Content = reader["Content"].ToString();
goods.LogoUrl = reader["LogoUrl"].ToString();
goods.ImageUrlList = Utility.GetListstring(reader["ImagesUrl"].ToString());
goods.CommentCount = (int)reader["CommentCount"];
goods.BrowseCount = (int)reader["BrowseCount"];
goods.IsHot = (int)reader["IsHot"];
goods.IsRecommend = (int)reader["IsRecommend"];
goods.Cname = reader["Cname"].ToString();
result.Results.Add(goods);
}
if (gettotal > 0)
{
//一个函数有两次连接数据库 先把连接断开 然后重连
conn.Close();
conn.Dispose();
conn.Open();
cmdText = string.Format("select count(*) from goods where SellerId={0} ", sellerId) +
wheresql;
reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, cmdText);
if (reader.HasRows)
{
if (reader.Read())
{
result.TotalCount = reader.GetInt32(0);
}
}
}
}
}
catch (System.Exception ex)
{
throw;
}
return(result);
}
public static PagResults <Position> GetPaging(int sellerId, int pageIndex, int pageSize, int cid = 0, int status = -1)
{
var results = new PagResults <Position>();
int totalnum = 0;
string commandText = @"select * from position where sellerId = ?sellerId order by CreateTime desc";
if (cid != 0)
{
commandText += (" and BoxTypeId = " + cid);
}
if (status != -1)
{
commandText += (" and status = " + status);
}
commandText += " LIMIT ?index,?size";
List <MySqlParameter> parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("?sellerId", sellerId));
parameters.Add(new MySqlParameter("?index", pageIndex));
parameters.Add(new MySqlParameter("?size", pageSize));
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
while (reader.Read())
{
Position p = new Position();
p.Id = reader.GetInt32(0);
//p.ImgId = (int)reader["ImgId"];
p.ImgUrls = reader["ImgUrls"].ToString();
p.BoxNumber = reader["BoxNumber"].ToString();
p.Phone = reader["Phone"].ToString();
p.Price = (float)reader["Price"];
p.SellerId = (int)reader["SellerId"];
p.Description = reader["Description"].ToString();
p.Status = (int)reader["Status"];
p.BoxTypeId = (int)reader["BoxTypeId"];
p.CreateTime = (DateTime)reader["CreateTime"];
results.Results.Add(p);
}
//一个函数有两次连接数据库 先把连接断开 然后重连
conn.Close();
conn.Dispose();
conn.Open();
commandText = @"select count(*) from position where sellerId = ?sellerId";
parameters.Clear();
parameters.Add(new MySqlParameter("?sellerId", sellerId));
if (cid != 0)
{
commandText += (" and BoxTypeId = " + cid);
}
if (status != -1)
{
commandText += (" and status = " + status);
}
reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
if (reader.HasRows)
{
if (reader.Read())
{
results.TotalCount = reader.GetInt32(0);
}
}
}
}
catch (System.Exception ex)
{
throw;
}
return(results);
}
public static PagResults <UserPosition> GetPagingUserPosition(int sellerId, int pageIndex, int pageSize)
{
var results = new PagResults <UserPosition>();
string commandText = @"select * from UserPosition where sellerId = ?sellerId order by CreateTime desc LIMIT ?index,?size";
List <MySqlParameter> parameters = new List <MySqlParameter>();
if (pageSize == 0)
{
commandText = @"select * from UserPosition where sellerId = ?sellerId";
parameters.Add(new MySqlParameter("?sellerId", sellerId));
}
else
{
parameters.Add(new MySqlParameter("?sellerId", sellerId));
parameters.Add(new MySqlParameter("?index", pageIndex));
parameters.Add(new MySqlParameter("?size", pageSize));
}
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
while (reader.Read())
{
UserPosition up = new UserPosition();
up.Id = reader.GetInt32(0);
up.SellerId = (int)reader["SellerId"];
up.CreateTime = (DateTime)reader["CreateTime"];
up.Message = reader["Message"].ToString();
up.NickName = reader["NickName"].ToString();
up.PayId = (int)reader["PayId"];
up.Phone = reader["Phone"].ToString();
up.PositionId = (int)reader["PositionId"];
up.Status = (int)reader["Status"];
up.TimeId = (int)reader["TimeId"];
up.UserId = (int)reader["UserId"];
results.Results.Add(up);
}
conn.Close();
conn.Dispose();
conn.Open();
commandText = @"select count(*) from UserPosition where sellerId = ?sellerId";
parameters.Clear();
parameters.Add(new MySqlParameter("?sellerId", sellerId));
reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
if (reader.HasRows)
{
if (reader.Read())
{
results.TotalCount = reader.GetInt32(0);
}
}
}
}
catch (System.Exception ex)
{
throw;
}
return(results);
}