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