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