/// <summary>
/// 添加新手卡
/// </summary>
/// <param name="cn">新手卡</param>
/// <returns>返回是否添加成功</returns>
public Boolean AddCard(cardsname cn)
{
try
{
string sql = "insert into cardsname(gameid,serverid,cardname,carddesc,img,urls,islock,gamename,servername)"
+ "values (@GameId,@serverid,@cardname,@carddesc,@Img,@urls,@islock,@gamename,@servername)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@GameId",cn.gameid),
new SqlParameter("@serverid",cn.serverid),
new SqlParameter("@cardname",cn.cardname),
new SqlParameter("@carddesc",string.IsNullOrEmpty(cn.carddesc)?"":cn.carddesc),
new SqlParameter("@Img",string.IsNullOrEmpty( cn.img)?"":cn.img),
new SqlParameter("@urls",string.IsNullOrEmpty(cn.urls)?"":cn.urls),
new SqlParameter("@islock",cn.islock),
new SqlParameter("@gamename",cn.gamename),
new SqlParameter("@servername",cn.servername)
};
return db.ExecuteNonQuery(sql, sp);
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
}
public ActionResult GameGift(int CardId)
{
cardsname c = new cardsname();
c = cm.GetCard(CardId);
g = gm.GetGame(c.gameid);
ViewData["CardName"] = c.cardname;
ViewData["Img"] = c.img;
ViewData["CardCount"] = cm.GetCardCount(CardId);
ViewData["CardDes"] = c.carddesc;
ViewData["CardId"] = CardId;
ViewData["GameNo"] = g.GameNo;
return View("~/Views/GameGift/GetGift.cshtml");
}
public string DoGetGift(int CardId, string CardNum)
{
cardsname cn = new cardsname();
cn = cm.GetCard(CardId);
g = gm.GetGame(cn.gameid);
if (cm.GetCardCount(CardId) < 1)
{
return "<span><b>温馨提示：</b><lable style=\"color:red\">该新手卡已经被抢空啦！</span>";
}
int UserId = BBRequest.GetUserId();
if (UserId <= 0)
{
if (Utils.GetCookie("6qmgamesame") != "")
{
string value = Utils.GetCookie("6qmgamesame");
string UserName = DESEncrypt.DesDecrypt(value.Split('|')[0]);
string PWD = DESEncrypt.DesDecrypt(value.Split('|')[1]);
GameUser gu = gum.GetGameUser(UserName, DESEncrypt.Md5(PWD, 32));
if (gu != null)
{
BBRequest.WriteUserId(gu.Id);
gum.UpdateLastLogin(gu.Id);
UserId = BBRequest.GetUserId();
}
else
{
return "<span><b>温馨提示：</b><lable style=\"color:red\">登录后才可领取！</lable></span>";
}
}
else
{
return "<span><b>温馨提示：</b><lable style=\"color:red\">登录后才可领取！</lable></span>";
}
}
if (CardNum == null)
{
if (cm.ExitCardLog(UserId, CardId))
{
return "<span id=\"showno\" ><b>温馨提示：</b><lable style=\"color:red\">您已经领取过该新手卡啦！</span>";
}
else
{
cards c = new cards();
c = cm.GetCards(CardId);
CardNum = c.cardnum;
cardslog cl = new cardslog();
cl.userid = UserId;
cl.cardid = CardId;
cl.cardsid = c.id;
cm.AddCardLog(cl);
cm.UpdateCard(1, c.id);
sysmsg sysmsg1 = new sysmsg();
sysmsg1.msgid = 0;
sysmsg1.title = "新手卡信息：" + cn.cardname;
sysmsg1.type = 2;
sysmsg1.userid = UserId;
sysmsg1.msg = "领取新手卡成功！卡号：" + c.cardnum;
sysmsg1.fromid = 0;
new SysMsgManager().AddSysMsg(sysmsg1);
return "<span id=\"showno\" ><b>领取成功!激活码：</b> <label id=\"lblno\" style=\"color:red\"> " + CardNum + " </label></span>";
}
}
else
{
return "<span id=\"showno\" ><b>领取成功!激活码：</b> <label id=\"lblno\" style=\"color:red\"> " + CardNum + " </label></span>";
}
}
public Boolean DoAddCard()
{
if (Session[Keys.SESSION_ADMIN_INFO] == null)
{
return false;
}
else
{
Master master = Session[Keys.SESSION_ADMIN_INFO] as Master;
if (rcm.GetRoleCompetence(master.RoleId, 11252))
{
cardsname cn = new cardsname();
cn.gameid = int.Parse(Request["GameId"]);
cn.serverid = int.Parse(Request["ServerId"]);
cn.cardname = Request["CardName"];
cn.urls = Request["Url"];
cn.islock = Request["IsLock"] == "on" ? 1 : 0;
cn.img = Request["Img"];
cn.carddesc = Request["CardDesc"];
return cm.AddCard(cn);
}
else
{
return false;
}
}
}
public ActionResult EditCard(int CardId)
{
if (Session[Keys.SESSION_ADMIN_INFO] == null)
{
return RedirectToAction("Login", "Admin");
}
else
{
Master master = Session[Keys.SESSION_ADMIN_INFO] as Master;
if (rcm.GetRoleCompetence(master.RoleId, 11251))
{
ViewData["Function"] = "UpdateData('/Card/UpdateCard')";
cardsname cn = new cardsname();
cn = cm.GetCard(CardId);
ViewData["CardId"] = cn.id;
ViewData["GameId"] = cn.gameid;
ViewData["ServerId"] = cn.serverid;
ViewData["CardName"] = cn.cardname;
ViewData["Url"] = cn.urls;
ViewData["IsLock"] = cn.islock == 1 ? true : false; ;
ViewData["Img"] = cn.img;
ViewData["CardDesc"] = cn.carddesc;
return View("Card");
}
else
{
return RedirectToAction("Login", "Admin");
}
}
}
/// <summary>
/// 添加新手卡
/// </summary>
/// <param name="cn">新手卡</param>
/// <returns>返回是否添加成功</returns>
public Boolean AddCard(cardsname cn)
{
cn.gamename = new GamesManager().GetGame(cn.gameid).Name;
cn.servername = cn.serverid == 0 ? "" : new ServersMananger().GetGameServer(cn.serverid).Name;
return cs.AddCard(cn);
}
/// <summary>
/// 更新新手卡信息
/// </summary>
/// <param name="cn">新手卡</param>
/// <returns>返回是否更新成功</returns>
public Boolean UpdateCard(cardsname cn)
{
try
{
string sql = "update cardsname set gameid=@GameId,serverid=@serverid,cardname=@cardname,carddesc=@carddesc," +
"img=@Img,urls=@urls,islock=@islock,gamename=@gamename,servername=@servername" +
" where id=@Id ";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@GameId",cn.gameid),
new SqlParameter("@serverid",cn.serverid),
new SqlParameter("@cardname",cn.cardname),
new SqlParameter("@carddesc",string.IsNullOrEmpty(cn.carddesc)?"":cn.carddesc),
new SqlParameter("@Img",string.IsNullOrEmpty( cn.img)?"":cn.img),
new SqlParameter("@urls",string.IsNullOrEmpty(cn.urls)?"":cn.urls),
new SqlParameter("@islock",cn.islock),
new SqlParameter("@gamename",cn.gamename),
new SqlParameter("@servername",cn.servername),
new SqlParameter("@Id",cn.id)
};
return db.ExecuteNonQuery(sql, sp);
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
}
/// <summary>
/// 获取新手卡
/// </summary>
/// <param name="CardId">卡Id</param>
/// <returns>返回新手卡</returns>
public cardsname GetCard(int CardId)
{
cardsname cn = new cardsname();
try
{
string sql = "select * from cardsname where id=@CardId";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@CardId",CardId)
};
using (SqlDataReader reder = db.GetReader(sql, sp))
{
while (reder.Read())
{
cn.id = (int)reder["id"];
cn.gameid = (int)reder["gameid"];
cn.serverid = (int)reder["serverid"];
cn.cardname = reder["cardname"].ToString();
cn.carddesc = reder["carddesc"].ToString();
cn.urls = reder["urls"].ToString();
cn.islock = (int)reder["islock"];
cn.gamename = reder["gamename"].ToString();
cn.servername = reder["servername"].ToString();
cn.img = reder["img"].ToString();
}
}
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
return cn;
}
