public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
var userinfo = hxsc.UserInfo.FirstOrDefault(o => o.Userid == Userid);
if (userinfo == null)
{
return(SetError("用户不存在！"));
}
if (hxsc.Item.FirstOrDefault(u => u.Itemid == itemid) == null)
{
return(SetError("书本不存在！"));
}
Clickrecord clickre = new Clickrecord()
{
Createtime = DateTime.Now,
Itemid = itemid,
Source = key,
Userid = Userid
};
hxsc.Clickrecord.AddObject(clickre);
hxsc.SaveChanges();
DataPack = new Layer()
{
Clickrecordid = clickre.Clickrecordid
};
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
if (hxsc.UserInfo.FirstOrDefault(u => u.Userid == Userid) == null)
{
return(SetError("用户不存在"));
}
if (hxsc.Item.FirstOrDefault(u => u.Itemid == ItemId) == null)
{
return(SetError("书本不存在！"));
}
Favorites Favorites = new EfModel.Favorites()
{
Createtime = DateTime.Now,
DelTime = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue,
ItmeId = ItemId,
Source = key,
State = 0,
Userid = Userid
};
hxsc.Favorites.AddObject(Favorites);
hxsc.SaveChanges();
Layer layer = new Layer();
layer.favoritesid = Favorites.FavoritesId;
DataPack = layer;
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
var billlist = (from c in hxsc.Bill
orderby c.Createtime descending
select c).ToList().FindAll(GetMath);
List <Layer> layerlist = new List <Layer>();
foreach (var item in billlist)
{
Layer layer = new Layer()
{
amt = item.Amt,
bank = item.Bank,
billid = item.Billid,
countryid = item.Countryid,
createtime = item.Createtime.ToString("yyyy-MM-dd HH:mm:ss"),
isexpend = item.Isexpend,
orderid = item.Orderid,
purpose = item.Purpose,
userid = item.Userid
};
layerlist.Add(layer);
}
DataPack = layerlist;
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
var invoicelist = (from c in hxsc.Invoice
orderby c.Createtime descending
select c).ToList();
invoicelist = invoicelist.FindAll(GetMatch);
DataPack = (from o in invoicelist
select new
{
Account = o.Account,
Amt = o.Amt,
Bank = o.Bank,
Companyaddress = o.Companyaddress,
Createtime = o.Createtime,
Orderid = o.Orderid,
Phone = o.Phone,
State = o.State,
Tax = o.Tax,
Unit = o.Unit,
Userid = o.Userid
}).ToList();
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
DataPack = (from o in hxsc.OrderD
join item in hxsc.Item
on o.Itemid equals item.Itemid
where o.Orderhid == orderid
select new
{
amt = o.Amt,
createtime = o.Createtime,
discount = o.Discount,
orderhid = o.Orderhid,
coverurl = item.Coverurl,
itemid = o.Itemid,
itemna = item.Itemna,
number = o.Number,
price = o.Price,
realamt = o.Realamt,
serial = o.Serial,
start = o.Start
}).ToList();
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
var list = (from f in hxsc.Favorites
join item in hxsc.Item
on f.ItmeId equals item.Itemid
where f.State == 0
orderby f.Createtime descending
select new
{
Createtime = f.Createtime,
FavoritesId = f.FavoritesId,
ItmeId = f.ItmeId,
State = f.State,
Userid = f.Userid,
Itemna = item.Itemna,
Price = item.Price
}).ToList();
if (!string.IsNullOrEmpty(Userid) && createtime == DateTime.MinValue)
{
list = list.FindAll(o => o.Userid == Userid);
}
else if (string.IsNullOrEmpty(Userid) && createtime != DateTime.MinValue)
{
list = list.FindAll(o => o.Createtime > createtime);
}
else if (!string.IsNullOrEmpty(Userid) && createtime != DateTime.MinValue)
{
list = list.FindAll(o => o.Createtime > createtime && o.Userid == Userid);
}
DataPack = list;
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
if (hxsc.UserInfo.FirstOrDefault(o => o.Userid == Userid) == null)
{
return(SetError("用户不存在！"));
}
DataPack = (from um in hxsc.UseriMail
join m in hxsc.Mail
on um.Mailid equals m.Mailid
where um.Userid == Userid
select new
{
Userid = um.Userid,
State = um.State,
Mailid = um.Mailid,
Genre = m.Genre,
Classify = m.Classify,
Contenttxt = m.Contenttxt,
Levelx = m.Levelx,
Parentsmailid = m.Parentsmailid
}).ToList();
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
var userinfo = hxsc.UserInfo.FirstOrDefault(o => o.Userid == User_id);
if (userinfo == null)
{
return(SetError("用户不存在！"));
}
userinfo.Sex = sex;
userinfo.Balance = balance;
userinfo.Birthday = birthday;
userinfo.CityId = cityid;
userinfo.CountryId = countryid;
userinfo.ImageUrl = imageurl;
userinfo.Phone = phone;
userinfo.RegionId = regionid;
userinfo.Start = start;
userinfo.Street = street;
userinfo.UserName = username;
userinfo.WorkDetail = workdetail;
userinfo.WorkId = workid;
userinfo.ProvinceId = provinceid;
hxsc.SaveChanges();
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
if (hxsc.UserInfo.Count() > 0)
{
var userinfo = hxsc.UserInfo.FirstOrDefault(o => o.Userna == userna);
if (userinfo != null)
{
return(SetError("此用户名已被使用，请更换一个用户名！"));
}
}
pwd = CryptoHelper.MD5_Encrypt(pwd, CryptoHelper.Key, Encoding.UTF8);
UserInfo userInfo = new UserInfo()
{
Userid = System.Guid.NewGuid().ToString().Replace("-", ""),
Pwd = pwd,
Userna = userna,
};
hxsc.UserInfo.AddObject(userInfo);
hxsc.SaveChanges();
outDate od = new outDate()
{
userid = userInfo.Userid
};
DataPack = od;
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
if (hxsc.UserInfo.FirstOrDefault(u => u.Userid == Userid) == null)
{
return(SetError("用户不存在！"));
}
var listN = (from oh in hxsc.OrderD
join o in hxsc.OrderH
on oh.Orderhid equals o.OrderhId
join i in hxsc.Item
on oh.Itemid equals i.Itemid
where o.Start == 1 && o.UserId == Userid
select new
{
Itemna = i.Itemna,
Itemid = i.Itemid,
Coverurl = i.Coverurl,
Orderhid = oh.Orderhid,
Amt = o.Amt,
}).ToList();
DataPack = listN;
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
var userinfo = hxsc.UserInfo.FirstOrDefault(o => o.Userid == Userid);
if (userinfo == null)
{
return SetError("用户不存在！");
}
Bill Bill = new Bill()
{
Amt = Amt,
Bank = Bank,
Countryid = Countryid,
Createtime = DateTime.Now,
Isexpend = Isexpend,
Orderid = Orderid,
Purpose = Purpose,
Source = key,
Userid = Userid
};
hxsc.Bill.AddObject(Bill);
hxsc.SaveChanges();
DataPack = new Layer() { Billid = Bill.Billid };
return true;
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
if (hxsc.UserInfo.FirstOrDefault(u => u.Userid == Userid) == null)
{
return(SetError("用户不存在！"));
}
if (hxsc.Item.FirstOrDefault(u => u.Itemid == Itemid) == null)
{
return(SetError("图书不存在！"));
}
Shoppingbasket shopingbasket = new Shoppingbasket()
{
Createtime = DateTime.Now,
Itemid = Itemid,
Source = key,
State = 0,
Userid = Userid
};
hxsc.Shoppingbasket.AddObject(shopingbasket);
hxsc.SaveChanges();
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
if (hxsc.UserInfo.FirstOrDefault(u => u.Userid == Userid) == null)
{
return(SetError("用户不存在！"));
}
if (hxsc.Item.FirstOrDefault(u => u.Itemid == Itemid) == null)
{
return(SetError("图书不存在！"));
}
Comments comments = new Comments()
{
Commentstxt = Connentstxt,
Createtime = DateTime.Now,
Itemid = Itemid,
Source = key,
Star = Star,
Parentscommentsid = Parentscommentsid,
Userid = Userid
};
hxsc.Comments.AddObject(comments);
hxsc.SaveChanges();
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
if (hxsc.UserInfo.FirstOrDefault(o => o.Userid == Userid) == null)
{
return(SetError("用户不存在！"));
}
if (hxsc.Mail.FirstOrDefault(o => o.Mailid == mailid) == null)
{
return(SetError("邮件不存在！"));
}
UseriMail userMail = hxsc.UseriMail.FirstOrDefault(o => o.Userid == Userid && o.Mailid == mailid);
if (userMail != null)
{
return(SetError("该邮件已订阅，不需要再订阅！"));
}
userMail = new UseriMail()
{
Mailid = mailid, Source = key, State = state, Userid = Userid
};
hxsc.UseriMail.AddObject(userMail);
hxsc.SaveChanges();
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
//if (hxsc.UserInfo.FirstOrDefault(u => u.Userid == Userid) == null)
//{
// return SetError("用户不存在！");
//}
//if (hxsc.Item.FirstOrDefault(u => u.Itemid == Itemid) == null)
//{
// return SetError("图书不存在！");
//}
var list = (from o in hxsc.Comments
orderby o.Createtime descending
select o).ToList();
list = list.FindAll(GetMath);
var listN = (from o in list
select new
{
o.Commentsid,
o.Commentstxt,
o.Createtime,
o.Itemid,
o.Parentscommentsid,
o.Star,
o.Userid
}).ToList();
DataPack = listN;
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
if (hxsc.UserInfo.FirstOrDefault(u => u.Userid == Userid) == null)
{
return(SetError("用户不存在！"));
}
if (hxsc.Item.FirstOrDefault(u => u.Itemid == itemid) == null)
{
return(SetError("图书不存在！"));
}
Bookmark Bookmark = new Bookmark()
{
Createtime = DateTime.Now,
Itemid = itemid,
Position = Position,
Userid = Userid,
Source = key
};
hxsc.Bookmark.AddObject(Bookmark);
hxsc.SaveChanges();
DataPack = new Layer()
{
Bookmarkid = Bookmark.Bookmarkid
};
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
var list = (from c in hxsc.Shoppingbasket
join i in hxsc.Item
on c.Itemid equals i.Itemid
where c.State == 0
orderby c.Createtime descending
select new
{
Shoppingbasketid = c.Shoppingbasketid,
Userid = c.Userid,
Itemid = c.Itemid,
Createtime = c.Createtime,
Coverurl = i.Coverurl,
Itemna = i.Itemna
}).ToList();
if (!string.IsNullOrEmpty(Userid) && createtime == DateTime.MinValue)
{
list = list.FindAll(o => o.Userid == Userid);
}
else if (string.IsNullOrEmpty(Userid) && createtime != DateTime.MinValue)
{
list = list.FindAll(o => o.Createtime > createtime);
}
else if (!string.IsNullOrEmpty(Userid) && createtime != DateTime.MinValue)
{
list = list.FindAll(o => o.Createtime > createtime && o.Userid == Userid);
}
DataPack = list;
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
if (hxsc.UserInfo.FirstOrDefault(o => o.Userid == Userid) == null)
{
return(SetError("用户不存在！"));
}
OrderH orderH = hxsc.OrderH.FirstOrDefault(o => o.OrderhId == orderid);
if (orderH == null)
{
return(SetError("订单不存在！"));
}
if (orderH.Start == 0)
{
SetError("未付款订单不能退货!");
}
var orderDlist = (from od in hxsc.OrderD
where od.Orderhid == orderid
select od).ToList();
foreach (var item in Contenttxt)
{
if (orderDlist.Find(o => o.Itemid == item.Itemid) == null)
{
return(SetError("订单图书不存在"));
}
}
ReturnedH returnedH = new ReturnedH()
{
Amt = Contenttxt.Sum(o => o.Amt),
Orderid = orderid,
Source = key,
State = 0,
Userid = Userid,
CreateTime = DateTime.Now,
};
hxsc.ReturnedH.AddObject(returnedH);
hxsc.SaveChanges();
foreach (var item in Contenttxt)
{
ReturnedD returnedD = new ReturnedD()
{
Amt = item.Amt,
Createtime = DateTime.Now,
Itemid = item.Itemid,
Returnedid = returnedH.ReturnedId,
Serial = "",
State = 0
};
hxsc.ReturnedD.AddObject(returnedD);
}
hxsc.SaveChanges();
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
var userinfo = hxsc.UserInfo.FirstOrDefault(o => o.Userna == userna);
if (userinfo != null)
{
return(SetError("此用户名已被注册，请更换一个用户名！"));
}
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
var userinfo = hxsc.UserInfo.FirstOrDefault(o => o.Phone == phone && o.Verification == verification);
if (userinfo == null)
{
return(SetError("此用户名或密码不正确！"));
}
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
Item item = hxsc.Item.FirstOrDefault(o => o.Itemid == itemid);
if (item == null)
{
return(SetError("图书信息不存在!"));
}
DataPack = item;
return(true);
}
private object GetDetail(HXSCEntities hxsc, int ReturnedId)
{
return((from o in hxsc.ReturnedD
where o.Returnedid == ReturnedId
select new
{
itemid = o.Itemid,
amt = o.Amt,
createtime = o.Createtime,
start = o.State
}).ToList());
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
Favorites Favorites = hxsc.Favorites.FirstOrDefault(o => o.FavoritesId == faboritesid);
if (Favorites == null)
{
SetError("此收藏不存在");
}
Favorites.State = 0;
hxsc.SaveChanges();
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
Shoppingbasket Shoppingbasket = hxsc.Shoppingbasket.FirstOrDefault(u => u.Shoppingbasketid == shoppingbasketid);
if (Shoppingbasket == null)
{
return(SetError("购物车中商品不存在！"));
}
Shoppingbasket.State = 1;
hxsc.SaveChanges();
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
Bookmark Bookmark = hxsc.Bookmark.FirstOrDefault(u => u.Bookmarkid == Bookmarkid);
if (Bookmark == null)
{
return(SetError("书签不存在！"));
}
Bookmark.Position = Position;
hxsc.SaveChanges();
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
var userinfo = hxsc.UserInfo.FirstOrDefault(o => o.Userid == userid);
if (userinfo == null)
{
return(SetError("用户不存在！"));
}
pwd = CryptoHelper.MD5_Encrypt(pwd, CryptoHelper.Key, Encoding.UTF8);
userinfo.Pwd = pwd;
hxsc.SaveChanges();
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
Mail mail = hxsc.Mail.FirstOrDefault(o => o.Mailid == mailid);
if (mail == null)
{
return(SetError("邮件不存在！"));
}
hxsc.Mail.DeleteObject(mail);
hxsc.SaveChanges();
return(true);
}
protected bool SetHttpContext(HttpContext Context)
{
hxsc = new HXSCEntities();
context = Context;
if (context.Request.Params["MethodType"] != null)
{
methodTpye = context.Request.Params["MethodType"];
}
if (methodTpye == "")
{
context.Response.Write("param is error……");
return(false);
}
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
if (hxsc.UserInfo.FirstOrDefault(u => u.Userid == Userid) == null)
{
return(SetError("用户不存在！"));
}
var UserInfo = (from o in hxsc.UserInfo
where o.Userid == Userid
select new { Balance = o.Balance }).FirstOrDefault();
DataPack = UserInfo;
return(true);
}
public override bool TakeAction()
{
HXSCEntities hxsc = new HXSCEntities();
DataPack = (from o in hxsc.Mail
select new
{
mailid = o.Mailid,
genre = o.Genre,
classify = o.Classify,
Contenttxt = o.Contenttxt,
levelx = o.Levelx,
parentsmailid = o.Parentsmailid
}).ToList();
return(true);
}
