|
|
|
|
using System;
|
|
|
|
|
using System.Collections.Generic;
|
|
|
|
|
using System.Data;
|
|
|
|
|
using System.Linq;
|
|
|
|
|
using System.Web;
|
|
|
|
|
using System.Web.Services;
|
|
|
|
|
using NetLibrary.Data;
|
|
|
|
|
using TradeData;
|
|
|
|
|
using TradeModel;
|
|
|
|
|
using System.Web.Script.Serialization;
|
|
|
|
|
using NetLibrary.ReportPrint;
|
|
|
|
|
using NetLibrary;
|
|
|
|
|
using System.Text;
|
|
|
|
|
|
|
|
|
|
namespace TradeManage.score
|
|
|
|
|
{
|
|
|
|
|
/// <summary>
|
|
|
|
|
/// ScoreService 的摘要说明
|
|
|
|
|
/// </summary>
|
|
|
|
|
[WebService(Namespace = "http://tempuri.org/")]
|
|
|
|
|
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
|
|
|
|
|
[System.ComponentModel.ToolboxItem(false)]
|
|
|
|
|
// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务,请取消注释以下行。
|
|
|
|
|
[System.Web.Script.Services.ScriptService]
|
|
|
|
|
public class ScoreService : System.Web.Services.WebService
|
|
|
|
|
{
|
|
|
|
|
|
|
|
|
|
[WebMethod]
|
|
|
|
|
public string HelloWorld()
|
|
|
|
|
{
|
|
|
|
|
return "Hello World";
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
#region 登陆
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
public string ScoreLogin(string UserName, string PassWord)
|
|
|
|
|
{
|
|
|
|
|
|
|
|
|
|
HY_Member model = new HY_Member();
|
|
|
|
|
|
|
|
|
|
var obj =new HY_MemberScore();
|
|
|
|
|
var md = obj.MemberLogin(UserName.Trim(), PassWord.Trim());
|
|
|
|
|
if (md == null)
|
|
|
|
|
{
|
|
|
|
|
|
|
|
|
|
return "Login failed,username or password error;";
|
|
|
|
|
}
|
|
|
|
|
Session["MemberId"] = md.MemberId;
|
|
|
|
|
Session["ScoreName"] = md.MemberName;
|
|
|
|
|
Session["ScoreNum"] = md.NowScore;
|
|
|
|
|
Session["FirstLogin"] = 1;
|
|
|
|
|
if (md.MemberBirth != null)
|
|
|
|
|
Session["FirstLogin"] = 0;
|
|
|
|
|
var cart = obj.GetBuyCartList(md.MemberId.Value);
|
|
|
|
|
if (cart != null)
|
|
|
|
|
{
|
|
|
|
|
string CartList = "";
|
|
|
|
|
Session["Cart"] =cart.Count;
|
|
|
|
|
foreach (var cmd in cart)
|
|
|
|
|
{
|
|
|
|
|
CartList += cmd.GiftId + ",";
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
Session["CartList"] = CartList.Trim(',');
|
|
|
|
|
}
|
|
|
|
|
return "Login success";
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
#region 退出
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
public string LoginOut()
|
|
|
|
|
{
|
|
|
|
|
|
|
|
|
|
Session.Remove("MemberId");
|
|
|
|
|
Session.Remove("ScoreName");
|
|
|
|
|
Session.Remove("ScoreNum");
|
|
|
|
|
Session.Remove("Cart");
|
|
|
|
|
Session.Remove("CartList");
|
|
|
|
|
return "Logout success";
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
#region 首页推荐
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
public List<HY_Gift> GetHotGift()
|
|
|
|
|
{
|
|
|
|
|
|
|
|
|
|
HY_Member model = new HY_Member();
|
|
|
|
|
|
|
|
|
|
var obj = new HY_MemberScore();
|
|
|
|
|
var list = obj.GetHotGift();
|
|
|
|
|
|
|
|
|
|
return list;
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
#region 首页推荐
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
public List<HY_Gift> GetHot()
|
|
|
|
|
{
|
|
|
|
|
|
|
|
|
|
HY_Member model = new HY_Member();
|
|
|
|
|
|
|
|
|
|
var obj = new HY_MemberScore();
|
|
|
|
|
var list = obj.GetHot();
|
|
|
|
|
|
|
|
|
|
return list;
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
#region 首页推荐
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
public List<HY_Gift> GetHotGift2()
|
|
|
|
|
{
|
|
|
|
|
|
|
|
|
|
HY_Member model = new HY_Member();
|
|
|
|
|
|
|
|
|
|
var obj = new HY_MemberScore();
|
|
|
|
|
var list = obj.GetHotGift2();
|
|
|
|
|
|
|
|
|
|
return list;
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
#region 首页推荐
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
public List<HY_Gift> GetHotGift3()
|
|
|
|
|
{
|
|
|
|
|
|
|
|
|
|
HY_Member model = new HY_Member();
|
|
|
|
|
|
|
|
|
|
var obj = new HY_MemberScore();
|
|
|
|
|
var list = obj.GetHotGift3();
|
|
|
|
|
|
|
|
|
|
return list;
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
|
|
|
|
|
#region 首页推荐
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
public HY_Gift GetGiftModel(int GiftId)
|
|
|
|
|
{
|
|
|
|
|
|
|
|
|
|
HY_Member model = new HY_Member();
|
|
|
|
|
|
|
|
|
|
var obj = new HY_MemberScore();
|
|
|
|
|
var md = obj.GetGiftModel(GiftId);
|
|
|
|
|
if (md != null && md.ImageIds != null && md.ImageIds!="")
|
|
|
|
|
{
|
|
|
|
|
BaseService obj1 = new BaseService();
|
|
|
|
|
var list = obj1.GetListJC_Resource(md.ImageIds.Trim(','));
|
|
|
|
|
md.ImgList = list;
|
|
|
|
|
}
|
|
|
|
|
return md;
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#region 加入购物车
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
public string AddCart(int GiftId,int Num,string Notes)
|
|
|
|
|
{
|
|
|
|
|
if (Session["MemberId"] == null)
|
|
|
|
|
return "Please login first";
|
|
|
|
|
HY_Member model = new HY_Member();
|
|
|
|
|
|
|
|
|
|
var obj = new HY_MemberScore();
|
|
|
|
|
if (Session["CartList"] != null && Session["CartList"].ToString() != "")
|
|
|
|
|
{
|
|
|
|
|
string a = Session["CartList"].ToString() + ",";
|
|
|
|
|
string b = GiftId.ToString() + ",";
|
|
|
|
|
if (a.Contains(b) == true)
|
|
|
|
|
{
|
|
|
|
|
return "The item has been in the shopping cart, can not be repeated to add ";
|
|
|
|
|
}
|
|
|
|
|
Session["CartList"] = Session["CartList"].ToString() + "," + GiftId.ToString();
|
|
|
|
|
}
|
|
|
|
|
else
|
|
|
|
|
Session["CartList"] = GiftId.ToString();
|
|
|
|
|
|
|
|
|
|
if (Session["Cart"] != null && Session["Cart"].ToString() != "")
|
|
|
|
|
Session["Cart"] = Convert.ToInt32(Session["Cart"]) + 1;
|
|
|
|
|
else
|
|
|
|
|
Session["Cart"] = 1;
|
|
|
|
|
var md = new HY_BuyCart();
|
|
|
|
|
md.GiftId = GiftId;
|
|
|
|
|
md.MemberId = Convert.ToInt32(Session["MemberId"]);
|
|
|
|
|
md.Num = Num;
|
|
|
|
|
md.Note = Notes;
|
|
|
|
|
md.State = 1;
|
|
|
|
|
md.InDate = DateTime.Now;
|
|
|
|
|
obj.SaveBuyCart(md);
|
|
|
|
|
return "success";
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
#region 购物车
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
public List<HY_BuyCart> GetBuyCartList()
|
|
|
|
|
{
|
|
|
|
|
if (Session["MemberId"] == null)
|
|
|
|
|
return null;
|
|
|
|
|
HY_Member model = new HY_Member();
|
|
|
|
|
|
|
|
|
|
var obj = new HY_MemberScore();
|
|
|
|
|
var list = obj.GetBuyCartList2(Convert.ToInt32(Session["MemberId"]));
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
return list;
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
#region 会员信息
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
public HY_Addr GetMember()
|
|
|
|
|
{
|
|
|
|
|
if (Session["MemberId"] == null)
|
|
|
|
|
return null;
|
|
|
|
|
HY_Member model = new HY_Member();
|
|
|
|
|
|
|
|
|
|
var obj = new HY_MemberScore();
|
|
|
|
|
var md = obj.GetMember(Convert.ToInt32(Session["MemberId"]));
|
|
|
|
|
if (md != null && md.MemberBirth != null)
|
|
|
|
|
{
|
|
|
|
|
md.Year = md.MemberBirth.Value.Year;
|
|
|
|
|
md.Mon = md.MemberBirth.Value.Month;
|
|
|
|
|
md.Day = md.MemberBirth.Value.Day;
|
|
|
|
|
}
|
|
|
|
|
return md;
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
#region 会员地址
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
public HY_Addr GetAddr()
|
|
|
|
|
{
|
|
|
|
|
if (Session["MemberId"] == null)
|
|
|
|
|
return null;
|
|
|
|
|
|
|
|
|
|
var obj = new HY_MemberScore();
|
|
|
|
|
var md = obj.GetAddr(Convert.ToInt32(Session["MemberId"]));
|
|
|
|
|
|
|
|
|
|
return md;
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
#region 删除购物车
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
public string DeleteBuyCart(int Id, int GiftId)
|
|
|
|
|
{
|
|
|
|
|
if (Session["MemberId"] == null)
|
|
|
|
|
return "";
|
|
|
|
|
if (Session["CartList"] != null && Session["CartList"].ToString() != "")
|
|
|
|
|
{
|
|
|
|
|
string[] clist = Session["CartList"].ToString().Split(',');
|
|
|
|
|
string GiftIds="";
|
|
|
|
|
for (int i = 0; i < clist.Length; i++)
|
|
|
|
|
{
|
|
|
|
|
if (clist[i] != GiftId.ToString())
|
|
|
|
|
GiftIds += clist[i] + ",";
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
Session["CartList"] = GiftIds.Trim(',');
|
|
|
|
|
if (Session["Cart"] != null && Session["Cart"].ToString() != "" && Convert.ToInt32(Session["Cart"])>1)
|
|
|
|
|
Session["Cart"] = Convert.ToInt32(Session["Cart"]) -1;
|
|
|
|
|
else
|
|
|
|
|
Session["Cart"] = "";
|
|
|
|
|
}
|
|
|
|
|
var obj = new HY_MemberScore();
|
|
|
|
|
obj.DeleteBuyCart(Id,0);
|
|
|
|
|
|
|
|
|
|
return "";
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
#region 确定购物
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
public string BuyCart(List<HY_BuyCart> list,HY_Addr model)
|
|
|
|
|
{
|
|
|
|
|
if (Session["MemberId"] == null)
|
|
|
|
|
return "Please login first";
|
|
|
|
|
var obj = new HY_MemberScore();
|
|
|
|
|
if (list != null)
|
|
|
|
|
{
|
|
|
|
|
int Score = 0;
|
|
|
|
|
foreach (var md in list)
|
|
|
|
|
{
|
|
|
|
|
Score += md.TotalScore.Value;
|
|
|
|
|
}
|
|
|
|
|
if (Convert.ToInt32(Session["ScoreNum"]) < Score)
|
|
|
|
|
return "Your score is not enough";
|
|
|
|
|
else
|
|
|
|
|
Session["ScoreNum"] = Convert.ToInt32(Session["ScoreNum"]) - Score;
|
|
|
|
|
|
|
|
|
|
foreach (var md in list)
|
|
|
|
|
{
|
|
|
|
|
var cmd = new HY_ScoreChange();
|
|
|
|
|
cmd.ChangeScore = md.TotalScore;
|
|
|
|
|
cmd.Num = md.Num;
|
|
|
|
|
cmd.State = 1;
|
|
|
|
|
cmd.Note = md.Note;
|
|
|
|
|
cmd.MemberId = Convert.ToInt32(Session["MemberId"]);
|
|
|
|
|
cmd.InDate = DateTime.Now;
|
|
|
|
|
cmd.AddrId = model.AddrId.Value;
|
|
|
|
|
obj.DeleteBuyCart(md.Id.Value, 2);
|
|
|
|
|
obj.UpdateGiftLeft(md.GiftId.Value, md.Num.Value);
|
|
|
|
|
}
|
|
|
|
|
obj.UpdateUserScore(Convert.ToInt32(Session["MemberId"]), Convert.ToInt32(Session["ScoreNum"]));
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
obj.SaveAddr(model);
|
|
|
|
|
var cart = obj.GetBuyCartList(Convert.ToInt32(Session["MemberId"]));
|
|
|
|
|
if (cart != null)
|
|
|
|
|
{
|
|
|
|
|
string CartList = "";
|
|
|
|
|
Session["Cart"] = cart.Count;
|
|
|
|
|
foreach (var cmd in cart)
|
|
|
|
|
{
|
|
|
|
|
CartList += cmd.GiftId + ",";
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
Session["CartList"] = CartList.Trim(',');
|
|
|
|
|
}
|
|
|
|
|
return "success";
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#region 保存信息
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
public string SaveMember(HY_Addr model)
|
|
|
|
|
{
|
|
|
|
|
if (Session["MemberId"] == null)
|
|
|
|
|
return "Please login first";
|
|
|
|
|
var obj = new HY_MemberScore();
|
|
|
|
|
model.MemberBirth =Convert.ToDateTime(model.Year.Value.ToString() + "-" + model.Mon.Value.ToString() + "-" + model.Day.Value.ToString());
|
|
|
|
|
obj.SaveAddr2(model);
|
|
|
|
|
|
|
|
|
|
return "success";
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
|
|
|
|
|
#region 查询商品
|
|
|
|
|
[WebMethod(EnableSession = true)]
|
|
|
|
|
public JsonModel<List<HY_Gift>> GetListGift(int SortId, string Name, int SPoint, int EPoint, int PageIndex, int PageSize, string Sort)
|
|
|
|
|
{
|
|
|
|
|
|
|
|
|
|
int UserId = Convert.ToInt32(Session["UserId"]);
|
|
|
|
|
RefParameterCollection Param = new RefParameterCollection();
|
|
|
|
|
|
|
|
|
|
if (SortId > 0)
|
|
|
|
|
Param.Add("a.SortId", "=", SortId, DbType.Int32);
|
|
|
|
|
|
|
|
|
|
Param.Add("a.State", "=", 1, DbType.Int32);
|
|
|
|
|
|
|
|
|
|
if (Name != "")
|
|
|
|
|
{
|
|
|
|
|
Name = Name.Trim();
|
|
|
|
|
|
|
|
|
|
Param.Add("a.GiftName", "like", Name, DbType.String);
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
if (SPoint > 0)
|
|
|
|
|
Param.Add("a.ChangeScore", ">=", SPoint, DbType.Int32);
|
|
|
|
|
if (EPoint > 0)
|
|
|
|
|
Param.Add("a.ChangeScore", "<=", EPoint, DbType.Int32);
|
|
|
|
|
|
|
|
|
|
JsonModel<List<HY_Gift>> resultModel = new JsonModel<List<HY_Gift>>();
|
|
|
|
|
|
|
|
|
|
int RowCount = 0;
|
|
|
|
|
var obj = new HY_MemberScore();
|
|
|
|
|
|
|
|
|
|
resultModel.DataSource = obj.GetListHY_Gift2(Param, PageIndex, PageSize, Sort, out RowCount);
|
|
|
|
|
resultModel.RowCount = RowCount;
|
|
|
|
|
return resultModel;
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
}
|
|
|
|
|
}
|