/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="curPage">当前页</param>
/// <param name="pageSize">每页个数</param>
/// <param name="type">用户类型 0-普通用户、游客 1-VIP用户 2-SVIP用户
/// 3-特约用户（可发布商品） 4-管理员 5-超级管理员 9-全部</param>
/// <param name="filter">查询条件</param>
/// <returns></returns>
public ReturnResult <List <Users> > GetUserInfos(int curPage, int pageSize, int type, string filter)
{
ReturnResult <List <Users> > result = new ReturnResult <List <Users> >();
using (GoodsEntities GoodsDb = new GoodsEntities())
{
try
{
//查寻用户
result.data = (from user in GoodsDb.Users
where (filter == "" || user.userid.Contains(filter)) &&
(user.usertype == type || (type == 9 && user.usertype != 5))
orderby user.registertime descending
select user).Skip(curPage * pageSize).Take(pageSize).ToList();
}
catch (Exception exp)
{
LogWriter.WebError(exp);
result.code = -1;
result.message = "服务已断开，请稍后重试！";
return(result);
}
result.code = 1;
}
return(result);
}
/// <summary>
/// 获取广告信息
/// </summary>
/// <param name="key">广告关键字</param>
/// <returns></returns>
public ReturnResult <AdInfo> GetAdvertisement(string key)
{
ReturnResult <AdInfo> result = new ReturnResult <AdInfo>();
try
{
using (GoodsEntities GoodsDb = new GoodsEntities())
{
var query = (from ad in GoodsDb.Advertisements
where ad.key == key && ad.state == 1
select ad).FirstOrDefault();
if (query == null)
{
result.code = -113;
result.message = "无可用的广告跳转！";
}
else
{
result.data = new AdInfo();
result.data.adInfo = query;
//result.data.goodsInfo = new Model.Goods();
//商品类信息要再获取商品信息
if (query.type == 2)
{
var query1 = (from goods in GoodsDb.Goods
where goods.id == query.goodskey && goods.state == 2
select goods).FirstOrDefault();
if (query1 == null)
{
result.code = -114;
result.message = "无已审核的商品信息！";
}
else
{
result.data.goodsInfo = query1;
result.code = 1;
}
}
}
}
}
catch (Exception exp)
{
result.code = -1;
result.message = "服务已断开，请稍后重试！";
//记录日志
LogWriter.WebError(exp);
}
return(result);
}
/// <summary>
/// 注册用户
/// </summary>
/// <param name="strCode">用户名</param>
/// <param name="password">用户密码</param>
/// <returns></returns>
public ReturnResult <Users> RegisterUserInfo(string strCode, string password)
{
ReturnResult <Users> result = new ReturnResult <Users>();
try
{
using (GoodsEntities GoodsDb = new GoodsEntities())
{
//查找用户
var query = (from user in GoodsDb.Users
where user.userid == strCode
select user).ToList();
if (query != null && query.Count != 0)
{
result.code = -104;
result.message = "无法注册，用户名已存在！";
return(result);
}
DateTime now = DateTime.Now;
//新增用户
Users tempUser = new Users
{
id = Guid.NewGuid().ToString(),
userid = strCode,
nickname = strCode,
password = EncryptDES(password, now.ToString(timeStyle)),
usertype = 0,
registertime = now,
};
GoodsDb.Users.Add(tempUser);
if (GoodsDb.SaveChanges() <= 0)
{
result.code = -1;
result.message = "用户信息注册失败！";
return(result);
}
result.code = 1;
result.data = tempUser;
}
}
catch (Exception exp)
{
result.code = -1;
result.message = "服务已断开，请稍后重试！";
//记录日志
LogWriter.WebError(exp);
}
return(result);
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="userInfo">待更新用户信息</param>
/// <returns></returns>
public ReturnResult <bool> SaveUserInfo(Users userInfo)
{
ReturnResult <bool> result = new ReturnResult <bool>();
try
{
using (GoodsEntities GoodsDb = new GoodsEntities())
{
//验证用户
Users updateUser = (from user in GoodsDb.Users
where user.id == userInfo.id
select user).FirstOrDefault();
updateUser.userlevel = userInfo.userlevel;
updateUser.nickname = userInfo.nickname;
updateUser.phonenumber = userInfo.phonenumber;
updateUser.qq = userInfo.qq;
updateUser.realname = userInfo.realname;
updateUser.sina = userInfo.sina;
updateUser.taobao = userInfo.taobao;
updateUser.usertype = userInfo.usertype;
updateUser.wechat = userInfo.wechat;
updateUser.birth = userInfo.birth;
updateUser.idcard = userInfo.idcard;
updateUser.usersignature = userInfo.usersignature;
if (GoodsDb.SaveChanges() <= 0)
{
result.code = -111;
result.message = "信息无更新！";
}
else
{
result.code = 1;
result.data = true;;
}
}
}
catch (Exception exp)
{
result.code = -1;
result.message = "服务已断开，请稍后重试！";
//记录日志
LogWriter.WebError(exp);
}
return(result);
}
/// <summary>
/// 用户修改密码
/// </summary>
/// <param name="id">用户主键</param>
/// <param name="oldPassword">旧密码</param>
/// <param name="newPassword">新密码</param>
/// <returns></returns>
public ReturnResult <bool> ChangePassword(string id, string oldPassword, string newPassword)
{
ReturnResult <bool> result = new ReturnResult <bool>();
try
{
using (GoodsEntities goodsDb = new GoodsEntities())
{
var user = (from u in goodsDb.Users
where u.id == id
select u).FirstOrDefault();
oldPassword = EncryptDES(oldPassword, (user.registertime ?? DateTime.Now)
.ToString(timeStyle));
LogWriter.WebLog("oldPassword:"******"newPassword:"******"用户密码更新失败！";
}
result.code = 1;
result.data = true;
}
else
{
result.code = -109;
result.message = "用户原密码错误！";
}
};
}
catch (Exception exp)
{
//记录日志
LogWriter.WebError(exp);
result.code = -1;
result.message = "服务已断开，请稍后重试！";
}
return(result);
}
/// <summary>
/// 验证用户登录信息，登录名支持用户名、邮箱、手机号。
/// </summary>
/// <param name="strCode">用户名、邮箱或手机号</param>
/// <param name="password">用户密码(加密)</param>
/// <returns></returns>
public ReturnResult <Users> ValidateUserInfo(string strCode, string password)
{
ReturnResult <Users> result = new ReturnResult <Users>();
try
{
using (GoodsEntities GoodsDb = new GoodsEntities())
{
//验证用户
var query = (from user in GoodsDb.Users
where user.userid == strCode
select user).FirstOrDefault();
if (query == null)
{
result.code = -102;
result.message = "您输入的用户名不存在！";
return(result);
}
else
{
if (EncryptDES(password, (query.registertime ?? DateTime.Now)
.ToString(timeStyle)) != query.password)
{
result.code = -103;
result.message = "您输入的密码错误！";
return(result);
}
else
{
result.code = 1;
result.data = query;
}
}
}
}
catch (Exception exp)
{
result.code = -1;
result.message = "服务已断开，请稍后重试！";
//记录日志
LogWriter.WebError(exp);
}
return(result);
}
/// <summary>
/// 保存用户反馈信息
/// </summary>
/// <param name="userInfo">用户反馈信息</param>
/// <returns></returns>
public ReturnResult <bool> SaveQuestion(Questions questionInfo)
{
ReturnResult <bool> result = new ReturnResult <bool>();
try
{
using (GoodsEntities GoodsDb = new GoodsEntities())
{
//验证用户
if (string.IsNullOrEmpty(questionInfo.id))
{
questionInfo.id = Guid.NewGuid().ToString();
}
questionInfo.feedbacktime = DateTime.Now;
GoodsDb.Questions.Add(questionInfo);
if (GoodsDb.SaveChanges() <= 0)
{
result.code = -112;
result.message = "问题反馈信息无更新！";
}
else
{
result.code = 1;
result.data = true;;
}
}
}
catch (Exception exp)
{
result.code = -1;
result.message = "服务已断开，请稍后重试！";
//记录日志
LogWriter.WebError(exp);
}
return(result);
}
/// <summary>
/// 商品点击量自增
/// </summary>
/// <param name="articleId">商品唯一标识</param>
/// <returns>是否新增成功</returns>
public ReturnResult <bool> ClickCounIncrement(string goodsId)
{
ReturnResult <bool> result = new ReturnResult <bool>();
try
{
using (GoodsEntities GoodsDb = new GoodsEntities())
{
Model.Goods query = GoodsDb.Goods.FirstOrDefault(goods =>
goods.id == goodsId && goods.state == 2);
if (query == null)
{
result.code = -106;
result.message = "找不到对应商品。";
return(result);
}
query.clickcount = (query.clickcount ?? 0) + 1;
if (GoodsDb.SaveChanges() <= 0)
{
result.code = -107;
result.message = "商品点击数未更新成功。";
return(result);
}
result.code = 1;
result.data = true;
}
}
catch (Exception exp)
{
result.code = -1;
result.message = "服务已断开，请稍后重试！";
//记录日志
LogWriter.WebError(exp);
}
return(result);
}
/// <summary>
/// 保存商品信息
/// </summary>
/// <param name="goodsInfo">商品信息</param>
/// <returns></returns>
public ReturnResult <bool> SaveGoodsInfo(Model.Goods goodsInfo)
{
ReturnResult <bool> result = new ReturnResult <bool>();
if (!string.IsNullOrEmpty(goodsInfo.id))//需要修改的数据
{
if (goodsInfo.state >= 2)
{
goodsInfo.audittime = DateTime.Now;
}
else
{
goodsInfo.recommendtime = DateTime.Now;
}
}
try
{
using (GoodsEntities GoodsDb = new GoodsEntities())
{
if (string.IsNullOrEmpty(goodsInfo.id))
{
goodsInfo.id = Guid.NewGuid().ToString();
goodsInfo.image = ImageUtil.StrToUri(goodsInfo.image, goodsInfo.id + ".jpg");
goodsInfo.buyimage = ImageUtil.StrToUri(goodsInfo.buyimage, goodsInfo.id + "_buy.jpg");
goodsInfo.recommendtime = DateTime.Now;
GoodsDb.Goods.Add(goodsInfo);
}
else
{
//修改的商品，可能已经是地址模式化
if (goodsInfo.image != null && !goodsInfo.image.Contains(".jpg"))
{
goodsInfo.image = ImageUtil.StrToUri(goodsInfo.image, goodsInfo.id + ".jpg");
}
if (goodsInfo.image != null && !goodsInfo.image.Contains("http:"))
{
goodsInfo.buyimage = ImageUtil.StrToUri(goodsInfo.buyimage, goodsInfo.id + "_buy.jpg");
}
Model.Goods temp = GoodsDb.Goods.First(p => p.id == goodsInfo.id);
temp.state = goodsInfo.state;
temp.image = goodsInfo.image;
temp.buyimage = goodsInfo.buyimage;
temp.recommender = goodsInfo.recommender;
temp.recommendname = goodsInfo.recommendname;
temp.auditname = goodsInfo.auditname;
temp.audituser = goodsInfo.audituser;
temp.audittime = goodsInfo.audittime;
}
GoodsDb.SaveChanges();
result.code = 1;
result.data = true;
}
}
catch (Exception exp)
{
LogWriter.WebError(exp);
result.code = -1;
result.message = "服务已断开，请稍后重试！";
result.data = false;
}
return(result);
}
/// <summary>
/// 获取商品-
/// </summary>
/// <param name="curPage">获取第几页 默认从0开始</param>
/// <param name="pageSize">每页个数</param>
/// <param name="type">0-保存草稿 1-待审核 2-已审核 9-全部 10-保存草稿+待审核</param>
/// 310-保存草稿+待审核+拒绝
/// <param name="filter">查询条件</param>
/// <returns></returns>
public ReturnResult <List <Model.Goods> > GetGoodsList(int curPage, int pageSize, int type, string filter)
{
List <int> states = new List <int>();
if (type == 10)
{
states.Add(0);
states.Add(1);
}
else if (type == 9)
{
states.Add(0);
states.Add(1);
states.Add(2);
states.Add(3);
}
else if (type == 310)
{
states.Add(0);
states.Add(1);
states.Add(3);
}
else
{
states.Add(type);
}
if (string.IsNullOrEmpty(filter))
{
filter = string.Empty;
}
if (pageSize <= 0)
{
pageSize = 10; //默认取10条
}
ReturnResult <List <Model.Goods> > result = new ReturnResult <List <Model.Goods> >();
try
{
using (GoodsEntities GoodsDb = new GoodsEntities())
{
var query = (from goods in GoodsDb.Goods
where states.Contains(goods.state ?? 0) &&
(filter == string.Empty || goods.description.Contains(filter))
orderby goods.recommendtime descending
select goods).Skip(curPage * pageSize).Take(pageSize)
.OrderByDescending(p => p.recommendtime);
List <Goods.Model.Goods> tempResult = query.ToList();
if (tempResult == null || tempResult.Count == 0)
{
result.code = -105;
result.message = "已加载完。";
return(result);
}
result.code = 1;
result.data = tempResult;
}
}
catch (Exception exp)
{
result.code = -1;
result.message = "服务已断开，请稍后重试！";
//记录日志
LogWriter.WebError(exp);
}
return(result);
}
