/// <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; }