/// <summary>
/// 获取单个礼品信息
/// </summary>
/// <param name="context"></param>
public void GetSingleGift(HttpContext context)
{
Model.ExchangGifts g = _IExchangGiftsBLL.GetSingleGift(Convert.ToInt32(context.Request["EG_ID"]));
string json = JsonConvert.SerializeObject(g);
context.Response.Write(json);
}
/// <summary>
/// 兑换积分
/// </summary>
/// <param name="context"></param>
public void PointExchange(HttpContext context)
{
using (TransactionScope ts = new TransactionScope())
{
Model.ExchangLogs el = new Model.ExchangLogs();
Model.MemCards m = new Model.MemCards();
Model.Users u = (Model.Users)context.Session["Users"];
Model.ExchangGifts eg = new Model.ExchangGifts();
el.S_ID = u.S_ID;
el.U_ID = u.U_ID;
el.EG_ID = Convert.ToInt32(context.Request["EG_ID"]);
el.EG_GiftCode = context.Request["EG_GiftCode"];
el.EG_GiftName = context.Request["EG_GiftName"];
el.EL_Number = Convert.ToInt32(context.Request["EL_Number"]);
el.EL_Point = Convert.ToInt32(context.Request["EL_Point"]);
el.EL_CreateTime = DateTime.Now;
el.MC_CardID = context.Request["MC_CardID"];
el.MC_ID = Convert.ToInt32(context.Request["MC_ID"]);
el.MC_Name = context.Request["MC_Name"];
m.MC_Point = Convert.ToInt32(context.Request["MC_Point"]);
eg.EG_ExchangNum = Convert.ToInt32(context.Request["EG_ExchangNum"]);
eg.EG_Number = Convert.ToInt32(context.Request["EG_Number"]);
string s;
if (_IExchangLogsBLL.PointExchange(el, m, eg))
{
s = "1";
}
else
{
s = "0";
}
context.Response.Write(s);
ts.Complete();
}
}
/// <summary>
/// 删除礼品
/// </summary>
/// <param name="context"></param>
public void DeleteGift(HttpContext context)
{
Model.ExchangGifts g = new Model.ExchangGifts();
g.EG_ID = Convert.ToInt32(context.Request["EG_ID"]);
string s;
if (_IExchangGiftsBLL.DeleteGift(g))
{
s = "1";
}
else
{
s = "0";
}
context.Response.Write(s);
}
/// <summary>
/// 修改礼品
/// </summary>
/// <param name="context"></param>
public void UpdateGift(HttpContext context)
{
Model.ExchangGifts g = new Model.ExchangGifts();
g.EG_ID = Convert.ToInt32(context.Request["EG_ID"]);
g.EG_GiftCode = context.Request["EG_GiftCode"];
g.EG_GiftName = context.Request["EG_GiftName"];
g.EG_Photo = context.Request["EG_Photo"];
g.EG_Remark = context.Request["EG_Remark"];
g.EG_Point = Convert.ToInt32(context.Request["EG_Point"]);
g.EG_Number = Convert.ToInt32(context.Request["EG_Number"]);
string s;
if (_IExchangGiftsBLL.UpdateGift(g))
{
s = "1";
}
else
{
s = "0";
}
context.Response.Write(s);
}
public bool PointExchange(ExchangLogs el, MemCards m, Model.ExchangGifts eg)
{
string sql = "P_PointExchange";
SqlParameter[] para =
{
new SqlParameter("@S_ID", el.S_ID),
new SqlParameter("@U_ID", el.U_ID),
new SqlParameter("@MC_ID", el.MC_ID),
new SqlParameter("@MC_CardID", el.MC_CardID),
new SqlParameter("@MC_Name", el.MC_Name),
new SqlParameter("@EG_ID", el.EG_ID),
new SqlParameter("@EG_GiftCode", el.EG_GiftCode),
new SqlParameter("@EG_GiftName", el.EG_GiftName),
new SqlParameter("@EL_Number", el.EL_Number),
new SqlParameter("@EL_Point", el.EL_Point),
new SqlParameter("@EL_CreateTime", el.EL_CreateTime),
new SqlParameter("@MC_Point", m.MC_Point),
new SqlParameter("@EG_Number", eg.EG_Number),
new SqlParameter("@EG_ExchangNum", eg.EG_ExchangNum)
};
return(DBHelper.ExecuteNonQuery(sql, true, para));
}
/// <summary>
/// 新增礼品
/// </summary>
/// <param name="context"></param>
public void InsertGift(HttpContext context)
{
Model.Users u = (Model.Users)context.Session["Users"];
Model.ExchangGifts g = new Model.ExchangGifts();
g.S_ID = u.S_ID;
g.EG_GiftCode = context.Request["EG_GiftCode"];
g.EG_GiftName = context.Request["EG_GiftName"];
g.EG_Photo = context.Request["EG_Photo"];
g.EG_Remark = context.Request["EG_Remark"];
g.EG_Point = Convert.ToInt32(context.Request["EG_Point"]);
g.EG_Number = Convert.ToInt32(context.Request["EG_Number"]);
string s;
if (_IExchangGiftsBLL.InsertGift(g))
{
s = "1";
}
else
{
s = "0";
}
context.Response.Write(s);
}
public bool PointExchange(ExchangLogs el, MemCards m, Model.ExchangGifts eg)
{
return(_IExchangLogsDAL.PointExchange(el, m, eg));
}
