public void ProcessRequest(HttpContext context) { DataBase db = DBProvide.GetLocalDBBase(); string sql = string.Format("select * from gametypes_poker"); List <string> gametypes = new List <string>(); db.Read(sql, (DataSet ds) => { if (ds.Tables.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { string gametype = row["GameType"].ToString(); gametypes.Add(string.Format("<option value={0}>{1}</option>", gametype, gametype)); } } }); db.Close(); string rr = JsonConvert.SerializeObject(gametypes); context.Response.ContentType = "application/json"; context.Response.Write(rr); }
public void ProcessRequest(HttpContext context) { string gametype = context.Request["gametype"]; string cards = context.Request["cards"]; string isuse = context.Request["isuse"]; string remarks = context.Request["remarks"]; DataBase db = DBProvide.GetLocalDBBase(); int status = 0; if (isuse == "true") { status = 1; } if (status == 1) { string sqlclear = string.Format("UPDATE card_configs SET `Status`=0 WHERE GameType='{0}'", gametype); db.Write(sqlclear); } string sql = string.Format("INSERT into card_configs (GameType,Cards,`Status`,Remarks)VALUES('{0}','{1}',{2},'{3}')", gametype, cards, status, remarks); db.Write(sql); db.Close(); context.Response.ContentType = "application/json"; string ss = JsonConvert.SerializeObject("设置成功"); context.Response.Write(ss); }
public void ProcessRequest(HttpContext context) { DataBase db = DBProvide.GetLocalDBBase(); DBRet ret = new DBRet(); string sql = string.Format("select * from card_configs"); db.Read(sql, (DataSet ds) => { if (ds.Tables.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { string cards = row["Cards"].ToString(); if (cards.Length > 150) { row["Cards"] = cards.Substring(0, 150) + "..."; } } ret.data = ds.Tables[0]; } }); db.Close(); string rr = JsonConvert.SerializeObject(ret); context.Response.ContentType = "application/json"; context.Response.Write(rr); }
public void ProcessRequest(HttpContext context) { string gametype = context.Request["gametype"]; string defaultcards = "0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41"; DataBase db = DBProvide.GetLocalDBBase(); DBRet ret = new DBRet(); string sql = string.Format("select * from default_cards where GameType='{0}'", gametype); db.Read(sql, (DataSet ds) => { if (ds.Tables.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { defaultcards = row["DefaultCards"].ToString(); } } }); db.Close(); string[] cards = defaultcards.Split(','); List <int> ncards = new List <int>(); List <string> dic = new List <string>(); foreach (string scardid in cards) { int cardid = -1; int.TryParse(scardid, out cardid); if (cardid != -1) { MahjongType flag; if (Enum.TryParse <MahjongType>(scardid, out flag)) { if (cardid >= (int)MahjongType.春) { dic.Add(string.Format("<option value={0}>{1}</option>", scardid, flag.ToString())); } else { dic.Add(string.Format("<option value={0}>{1}</option>", scardid, flag.ToString())); dic.Add(string.Format("<option value={0}>{1}</option>", scardid, flag.ToString())); dic.Add(string.Format("<option value={0}>{1}</option>", scardid, flag.ToString())); dic.Add(string.Format("<option value={0}>{1}</option>", scardid, flag.ToString())); } } } } string rr = JsonConvert.SerializeObject(dic); context.Response.ContentType = "application/json"; context.Response.Write(rr); }
public void ProcessRequest(HttpContext context) { string index = context.Request["index"]; DataBase db = DBProvide.GetLocalDBBase(); string sql = string.Format("DELETE FROM card_configs WHERE `index`={0}", index); db.Write(sql); db.Close(); string rr = JsonConvert.SerializeObject("移除成功"); context.Response.ContentType = "application/json"; context.Response.Write(rr); }
public void ProcessRequest(HttpContext context) { string index = context.Request["index"]; string gametype = context.Request["gametype"]; DataBase db = DBProvide.GetLocalDBBase(); string sqlclear = string.Format("UPDATE card_configs SET `Status`=0 WHERE GameType='{0}'", gametype); string sql = string.Format("UPDATE card_configs SET `Status`=1 WHERE `index`={0}", index); db.Write(sqlclear); db.Write(sql); db.Close(); string rr = JsonConvert.SerializeObject("激活成功"); context.Response.ContentType = "application/json"; context.Response.Write(rr); }
public void ProcessRequest(HttpContext context) { string gametype = context.Request["gametype"]; string defaultcards = "30,31,33,34,35,36,37,38,39,40,41,42,43,44,45,49,50,51,52,53,54,55,56,57,58,59,60,61,65,66,67,68,69,70,71,72,73,74,75,76,77,81,82,83,84,85,86,87,88,89,90,91,92,93"; DataBase db = DBProvide.GetLocalDBBase(); string sql = string.Format("select * from default_cards_poker where GameType='{0}'", gametype); int count = 1; int handcount = 5; string removecards = ""; db.Read(sql, (DataSet ds) => { if (ds.Tables.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { count = (int)row["Count"]; handcount = (int)row["HandCardCount"]; removecards = row["RemoveCards"].ToString(); } } }); db.Close(); for (int i = 1; i < count; i++) { defaultcards += "," + defaultcards; } List <string> listdefaults = new List <string>(); listdefaults.AddRange(defaultcards.Split(',')); List <string> lstremoves = new List <string>(); lstremoves.AddRange(removecards.Split(',')); for (int i = 0; i < lstremoves.Count; i++) { if (listdefaults.Contains(lstremoves[i])) { listdefaults.Remove(lstremoves[i]); } } List <string> dic = new List <string>(); foreach (string scardid in listdefaults) { int cardid = -1; int.TryParse(scardid, out cardid); if (cardid != -1) { string cardname = PokerTF.GetPokerName(cardid, gametype); dic.Add(string.Format("<option value={0}>{1}</option>", scardid, cardname)); } } RetPokers ret = new RetPokers(); ret.cards = dic; ret.HandCount = handcount; string rr = JsonConvert.SerializeObject(ret); context.Response.ContentType = "application/json"; context.Response.Write(rr); }