private void getCs(HttpContext context)
{
DataTable dt = DbOperator.GetCs();
string result = ConvertJson.DataTableToJson(dt);
context.Response.ContentType = "text/plain";
context.Response.Write(result);
}
private void testSession(HttpContext context)
{
string payId = context.Request["payId"];
DataTable dt = DbOperator.TestSession(payId);
string result = ConvertJson.DataTableToJson(dt);
context.Response.ContentType = "text/plain";
context.Response.Write(result);
}
private void queryCard(HttpContext context)
{
string where = context.Request["where"];
string table = " jbxx ";
string result = ConvertJson.DataTableToJson(DbOperator.QueryCard(where));
string outPut = "{'total':" + DbOperator.GetCount(table) + ",'rows':" + result + "}";
context.Response.ContentType = "text/plain";
context.Response.Write(result);
}
private void select(HttpContext context)
{
string columns = context.Request["columns"];
string table = context.Request["table"];
string where = context.Request["where"];
string order = context.Request["order"];
string db = context.Request["db"];
DataTable dt = DbOperator.Select(columns, table, where, order, db);
string result = ConvertJson.DataTableToJson(dt);
context.Response.ContentType = "text/plain";
context.Response.Write(result);
}