static JsonData AddColour(JsonData data, Color c) { data.Add((int)c.R); data.Add((int)c.G); data.Add((int)c.B); return data; }
public void AsArrayTest () { JsonData data = new JsonData (); data.Add (1); data.Add (2); data.Add (3); data.Add ("Launch!"); Assert.IsTrue (data.IsArray, "A1"); Assert.AreEqual ("[1,2,3,\"Launch!\"]", data.ToJson (), "A2"); }
/// <summary> /// Loops the children. /// </summary> /// <returns>The children.</returns> /// <param name="t">T.</param> private static JsonData LoopChildren(Transform t) { RectTransform rt = (RectTransform)t; JsonData jd = new JsonData (); jd ["name"] = t.name; JsonData trJD = new JsonData (); trJD ["position"] = rt.anchoredPosition.VectorToJson (); trJD ["sizeDelta"] = rt.sizeDelta.VectorToJson (); trJD ["anchorMin"] = rt.anchorMin.VectorToJson (); trJD ["anchorMax"] = rt.anchorMax.VectorToJson (); trJD ["pivot"] = rt.pivot.VectorToJson (); trJD ["rotation"] = rt.rotation.eulerAngles.VectorToJson (); trJD ["scale"] = rt.localScale.VectorToJson (); jd ["transform"] = trJD; int len = t.childCount; JsonData ch = new JsonData (); for (int i = 0; i < len; ++i) { ch.Add(LoopChildren (t.GetChild (i))); } string jsStr = JsonMapper.ToJson (ch); jd ["children"] = string.IsNullOrEmpty(jsStr)?"[]":ch; return jd; }
public LitJson.JsonData GetJson <T>() { LitJson.JsonData json = new LitJson.JsonData(); string[] lines = Lines; if (lines.Length > 1) { string[] columnNames = SplitWithDoubleQuote(lines[0], ','); // for UnitySerializer System.Type type = typeof(T); json["___i"] = type.FullName; if (type.IsArray) { json["count"] = lines.Length - 1; LitJson.JsonData array = new LitJson.JsonData(); json["contents"] = array; for (int i = 1; i < lines.Length; i++) { string[] values = SplitWithDoubleQuote(lines[i], ','); LitJson.JsonData aItem = new LitJson.JsonData(); // for UnitySerializer if (type.IsArray) { aItem["___i"] = type.GetElementType().FullName; } for (int v = 0; v < columnNames.Length; v++) { string val = values[v]; if (string.IsNullOrEmpty(val) == false) { aItem[columnNames[v]] = val; } } array.Add(aItem); } } else { string[] values = SplitWithDoubleQuote(lines[1], ','); for (int v = 0; v < columnNames.Length; v++) { string val = values[v]; if (string.IsNullOrEmpty(val) == false) { json[columnNames[v]] = val; } } } } // CLog.Log ( json.ToJson()); return(json); }
public static LitJson.JsonData Export(List <BMGlyph> glyphs) { var data = new LitJson.JsonData(); data.SetJsonType(LitJson.JsonType.Array); glyphs.ForEach(glyph => data.Add(Export(glyph))); return(data); }
public static LitJson.JsonData Export(List <BMSymbol> symbols) { var data = new LitJson.JsonData(); data.SetJsonType(LitJson.JsonType.Array); symbols.ForEach(symbol => data.Add(Export(symbol))); return(data); }
public static string IntArrayToString(int[] array) { JsonData data = new JsonData(); foreach (int a in array) { data.Add(a); } return data.ToJson(); }
public static LitJson.JsonData ExportChildren(GameObject go) { var data = new LitJson.JsonData(); var trans = go.transform; for (var i = 0; i < trans.childCount; i++) { data.Add(Export(trans.GetChild(i).gameObject)); } return(data); }
public void ProcessRequest(HttpContext context) { int total = 0; JsonData rows = new JsonData(); if (context.Request.Cookies["SyglAdmin"] == null) { context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write("未登录或登录超时!请重新登陆!"); context.Response.End(); } else { string connStr = ConfigurationManager.ConnectionStrings["SyglConnStr"].ConnectionString; OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = connStr; conn.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = conn; cmd.CommandText = "select ptmID,ptmName from ptms_tb order by ptmID"; OleDbDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { do { JsonData row = new JsonData(); row["ptmName"] = dr["ptmName"].ToString(); row["ptmID"] = Convert.ToInt32(dr["ptmID"].ToString()); rows.Add(row); } while (dr.Read()); } //查询数量 cmd = new OleDbCommand(); cmd.Connection = conn; cmd.CommandText = "select count(ptmID) from ptms_tb "; total = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); JsonData jsonData = new JsonData(); jsonData["total"] = total; jsonData["rows"] = rows; string echoString = jsonData.ToJson(); context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write(echoString); context.Response.End(); } }
//write json public void WriteJson( JsonData parent ) { JsonData json = new JsonData(); json["name"] = this.m_strName; if(this.m_cRoot != null ) { json["node"] = new JsonData(); json["node"].SetJsonType(JsonType.Object); json["node"] = this.m_cRoot.WriteJson(); } parent.Add(json); }
public static string parseJson(string[] dataString) { LitJson.JsonData json = new LitJson.JsonData(); string[] lines = dataString; if (lines.Length > 1) { string[] columnNames = WWWData.SplitWithDoubleQuote(lines[0], ','); int count = 0; for (int i = 0; i < columnNames.Length; i++) { if (columnNames[i] == string.Empty || columnNames[i].Contains("\r")) { break; } count++; } for (int i = 1; i < lines.Length; i++) { LitJson.JsonData dic = new LitJson.JsonData(); dic.SetJsonType(LitJson.JsonType.Object); string[] value = WWWData.SplitWithDoubleQuote(lines[i], ','); for (int j = 0; j < count; j++) { string val = ""; try { val = value[j]; } catch { Debug.LogError("Utils::parseJson error / line is " + lines[i]); } if (string.IsNullOrEmpty(val) == false) { dic[columnNames[j]] = val; } } json.Add(dic); } } return(json.ToJson()); }
static int Add(IntPtr L) { try { ToLua.CheckArgsCount(L, 2); LitJson.JsonData obj = (LitJson.JsonData)ToLua.CheckObject(L, 1, typeof(LitJson.JsonData)); object arg0 = ToLua.ToVarObject(L, 2); int o = obj.Add(arg0); LuaDLL.lua_pushinteger(L, o); return(1); } catch (Exception e) { return(LuaDLL.toluaL_exception(L, e)); } }
public static LitJson.JsonData Export(Component[] comps) { var data = new LitJson.JsonData(); data.SetJsonType(LitJson.JsonType.Array); foreach (var comp in comps) { var obj = Export(comp); if (obj != null) { obj["meta_type"] = comp.GetType().Name; obj["meta_id"] = comp.GetInstanceID(); data.Add(obj); } } return(data); }
/* 返回json格式 * id:节点id,对载入远程数据很重要。 text:显示在节点的文本。 state:节点状态,'open' or 'closed',默认为'open'。当设置为'closed'时,拥有子节点的节点将会从远程站点载入它们。 checked:表明节点是否被选择。 attributes:可以为节点添加的自定义属性。 children:子节点,必须用数组定义。 */ public void ProcessRequest(HttpContext context) { //查询数据库获取实验室列表 DataModel dm=new DataModel(); JsonData jd = new JsonData(); List<LabType> lts = dm.GetLabTypes(); List<LabChType> lcts = dm.GetLabChTypes(); List<Lab> labs = dm.GetLabs(); foreach (var t in lts) { JsonData jt = new JsonData(); jt["id"] = t.LabTypeID; jt["text"] = t.LabTypeName; jt["iconCls"] = "icon-application_cascade"; jt["children"] = new JsonData(); foreach (var ct in lcts.FindAll(delegate(LabChType lct) { return lct.LabSupType == t.LabTypeID; })) { JsonData jct = new JsonData(); jct["id"] = ct.LabChID; jct["text"] = ct.LabChName; jct["iconCls"] = "icon-application_cascade"; jct["children"] = new JsonData(); foreach (var lb in labs.FindAll(delegate(Lab _lb) { return _lb.LabType == ct.LabChID; })) { JsonData jLab = new JsonData(); jLab["id"] = lb.LabID; jLab["text"] =lb.LabName; //"iconCls":"icon-search" jLab["iconCls"] = "icon-application_home"; jLab["checked"] = lb.LabDefault; jct["children"].Add(jLab); } jt["children"].Add(jct); } jd.Add(jt); } string labStr=jd.ToJson(); context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write(labStr); context.Response.End(); }
// Utility function that takes a list of SemanticObject's evaluated as // having a relationship with the given object and outputs as a JSON object public virtual JsonData GetJsonString(List<SemanticObject> affectedNodes) { if (NetMessenger.logTimingInfo) Debug.LogFormat("Get Json for relationship {1}, {0}", Utils.GetTimeStamp(), name); JsonData retClass = new JsonData(JsonType.Object); Dictionary<SemanticObject, List<SemanticObject>> relationMap; Evaluate(affectedNodes, out relationMap); if (NetMessenger.logTimingInfo) Debug.LogFormat(" Finished evaluate relationships {0}", Utils.GetTimeStamp()); foreach(SemanticObject obj in relationMap.Keys) { JsonData lst = new JsonData(JsonType.Array); foreach(SemanticObject entry in relationMap[obj]) lst.Add(entry.identifier); retClass[obj.identifier] = lst; } if (NetMessenger.logTimingInfo) Debug.LogFormat(" Finished creating relationships json map {0} with {1} keys", Utils.GetTimeStamp(), relationMap.Keys.Count); return retClass; }
public void ProcessRequest(HttpContext context) { OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["SyglConnStr"].ConnectionString); conn.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = conn; cmd.CommandText = "select * from imgs_tb order by imgID"; OleDbDataReader dr = cmd.ExecuteReader(); string echoString=""; JsonData rows = new JsonData(); int total = 0; if (dr.Read()) { do { total++; JsonData jsonDataItem = new JsonData(); jsonDataItem["imgID"] = Convert.ToInt32( dr["imgID"].ToString()); jsonDataItem["imgFile"] = dr["imgFile"].ToString(); jsonDataItem["imgLink"] = dr["imgLink"].ToString(); rows.Add(jsonDataItem); } while (dr.Read()); } else { rows = ""; } JsonData jsonData = new JsonData(); jsonData["total"] = total; jsonData["rows"] = rows; echoString = jsonData.ToJson(); context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write(echoString); context.Response.End(); }
/* 返回json格式 * id:节点id,对载入远程数据很重要。 text:显示在节点的文本。 state:节点状态,'open' or 'closed',默认为'open'。当设置为'closed'时,拥有子节点的节点将会从远程站点载入它们。 checked:表明节点是否被选择。 attributes:可以为节点添加的自定义属性。 children:子节点,必须用数组定义。 */ public void ProcessRequest(HttpContext context) { //查询数据库获取实验室列表 LxyOledb oledb = new LxyOledb(); oledb.Conn.Open(); oledb.Cmd.CommandText = "select * from Term_tb order by TermStartDay desc"; oledb.Dr = oledb.Cmd.ExecuteReader(); JsonData jd = new JsonData(); while(oledb.Dr.Read()){ JsonData jdWeek = new JsonData(); jdWeek["id"] = Convert.ToInt32(oledb.Dr["TermID"]); jdWeek["text"] = oledb.Dr["TermName"].ToString(); jdWeek["TermStartDay"] = ((DateTime)oledb.Dr["TermStartDay"]).ToString("yyyy-MM-dd"); jdWeek["TermWeeks"] = Convert.ToInt32(oledb.Dr["TermWeeks"]); jdWeek["iconCls"] = "icon-date"; jdWeek["isCurrent"] = oledb.Dr["TermIsCurrent"].ToString(); jd.Add(jdWeek); } string jdString = jd.ToJson(); context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write(jdString); context.Response.End(); }
public static LitJson.JsonData Export(UIAtlas atlas) { var data = new LitJson.JsonData(); // iamge name. var tex = atlas.spriteMaterial.mainTexture; var path = AssetDatabase.GetAssetPath(tex); mAtlasImages.Add(path); data["image"] = Path.GetFileName(path); data["width"] = tex.width; data["height"] = tex.height; // pixelSize Export(data, "pixelSize", atlas.pixelSize, 1.0f); // sprites. var sprites = new LitJson.JsonData(); atlas.spriteList.ForEach(sprite => sprites.Add(Export(sprite))); data["sprites"] = sprites; return(data); }
public static JsonData SerializeJson(OSD osd) { switch (osd.Type) { case OSDType.Boolean: return new JsonData(osd.AsBoolean()); case OSDType.Integer: return new JsonData(osd.AsInteger()); case OSDType.Real: return new JsonData(osd.AsReal()); case OSDType.String: return new JsonData(osd.AsString()); case OSDType.Date: return new JsonData("date::" + osd.AsString()); case OSDType.URI: return new JsonData("uri::" + osd.AsString()); case OSDType.UUID: return new JsonData("uuid::" + osd.AsString()); case OSDType.Binary: return new JsonData("b64::" + Convert.ToBase64String(osd.AsBinary())); case OSDType.Array: JsonData jsonarray = new JsonData(); jsonarray.SetJsonType(JsonType.Array); OSDArray array = (OSDArray)osd; for (int i = 0; i < array.Count; i++) jsonarray.Add(SerializeJson(array[i])); return jsonarray; case OSDType.Map: JsonData jsonmap = new JsonData(); jsonmap.SetJsonType(JsonType.Object); OSDMap map = (OSDMap)osd; foreach (KeyValuePair<string, OSD> kvp in map) jsonmap[kvp.Key] = SerializeJson(kvp.Value); return jsonmap; case OSDType.Unknown: default: return new JsonData(); } }
public void ProcessRequest(HttpContext context) { int total = 0; JsonData rows = new JsonData(); if (context.Request.Cookies["SyglAdmin"] == null) { context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write("未登录或登录超时!请重新登陆!"); context.Response.End(); } else { int clm = Convert.ToInt32(context.Request["clm"]); int page = 0; if (context.Request["page"] != null && context.Request["page"] != "") { page = Convert.ToInt32(context.Request["page"]) - 1; } int pageSize = 10; if (context.Request["rows"] != null && context.Request["rows"] != "") { pageSize = Convert.ToInt32(context.Request["rows"]); } string sort = "articlePostTime"; if (context.Request["sort"] != null && context.Request["sort"] != "") { sort = (context.Request["sort"]); } string order = "desc"; if (context.Request["order"] != null && context.Request["order"] != "") { order = (context.Request["order"]); } string connStr = ConfigurationManager.ConnectionStrings["SyglConnStr"].ConnectionString; OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = connStr; conn.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = conn; if (page == 0) { cmd.CommandText = "select top " + pageSize + " articleID,articleTitle,articlePostTime from articles_tb where articleType = @type1 order by " + sort + " " + order + " "; // cmd.CommandText = "select top " + pageSize + // " articleID,articleTitle,articlePostTime from articles_tb where clm =@clm order by articlePostTime desc )"; cmd.Parameters.AddWithValue("@type1", clm); } else { cmd.CommandText = "select top " + pageSize + " articleID,articleTitle,articlePostTime from articles_tb where clm =@clm and articleID not in ( select top " + page * pageSize + " articleID from articles_tb order by order by " + sort + " " + order + " ) order by " + sort + " " + order + " )"; cmd.Parameters.AddWithValue("@clm", clm); cmd.Parameters.AddWithValue("@sort", sort); cmd.Parameters.AddWithValue("@order", order); cmd.Parameters.AddWithValue("@sort_", sort); cmd.Parameters.AddWithValue("@order_", order); } OleDbDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { do { JsonData row = new JsonData(); row["articleTitle"] = dr["articleTitle"].ToString(); row["articlePostTime"] = ((DateTime)dr["articlePostTime"]).ToString("yyyy年MM月dd日"); row["articleID"] = Convert.ToInt32(dr["articleID"].ToString()); rows.Add(row); } while (dr.Read()); } else { rows = ""; } //查询数量 cmd = new OleDbCommand(); cmd.Connection = conn; cmd.CommandText = "select count(articleID) from articles_tb where articleType=@clm "; cmd.Parameters.AddWithValue("@clm", clm); total = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); JsonData jsonData = new JsonData(); jsonData["total"] = total; jsonData["rows"] = rows; string echoString = jsonData.ToJson(); context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write(echoString); context.Response.End(); } }
public void ProcessRequest(HttpContext context) { int total = 0; JsonData rows = new JsonData(); if (context.Session["SlipAdmin"] == null) { context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write("未登录或登录超时!请重新登陆!<a href='LogOn.aspx' target='_top'> 请登录</a>"); context.Response.End(); } else { int page = 0; if (context.Request["page"] != null && context.Request["page"] != "") { page = Convert.ToInt32(context.Request["page"]) - 1; } int pageSize = 10; if (context.Request["rows"] != null && context.Request["rows"] != "") { pageSize = Convert.ToInt32(context.Request["rows"]); } string sort = "cpID"; if (context.Request["sort"] != null && context.Request["sort"] != "") { sort = (context.Request["sort"]); } string order = "desc"; if (context.Request["order"] != null && context.Request["order"] != "") { order = (context.Request["order"]); } SRSql srSql = new SRSql(); srSql.conn.Open(); if (page == 0) { srSql.cmd.CommandText = "select top " + pageSize + " cpID,cpName , cpYear ,cpStartTime ,cpEndTime from cpTB order by " + sort + " " + order + " "; } else { srSql.cmd.CommandText = "select top " + pageSize + " cpID,cpName , cpYear ,cpStartTime ,cpEndTime from cpTB where cpID not in ( select top " + page * pageSize + " cpID from cpTB order by order by " + sort + " " + order + " ) order by " + sort + " " + order + " )"; } srSql.dr = srSql.cmd.ExecuteReader(); if (srSql.dr.Read()) { do { JsonData row = new JsonData(); row["cpName"] = srSql.dr["cpName"].ToString(); row["cpID"] = Convert.ToInt32(srSql.dr["cpID"].ToString()); row["cpYear"] = srSql.dr["cpYear"].ToString(); row["cpEndTime"] = ((DateTime)srSql.dr["cpEndTime"]).ToString("yyyy-MM-dd"); row["cpStartTime"] = ((DateTime)srSql.dr["cpStartTime"]).ToString("yyyy-MM-dd"); rows.Add(row); } while (srSql.dr.Read()); } else { rows = ""; } srSql.dr.Close(); //查询数量 srSql.cmd.CommandText = "select count(supportID) from supportTB "; total = Convert.ToInt32(srSql.cmd.ExecuteScalar()); srSql.conn.Close(); JsonData jsonData = new JsonData(); jsonData["total"] = total; jsonData["rows"] = rows; string echoString = jsonData.ToJson(); context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write(echoString); context.Response.End(); } }
public void ProcessRequest(HttpContext context) { int total = 0; JsonData rows = new JsonData(); if (context.Session["adminID"] == null) { context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write("未登录或登录超时!请重新登陆!"); context.Response.End(); } else { int y = DateTime.Now.Year; int m = DateTime.Now.Month; if (context.Request.Params["y"] == "" || context.Request.Params["y"] == null) { } else { y = Convert.ToInt32(context.Request.Params["y"]); } if (context.Request.Params["y"] == "" || context.Request.Params["y"] == null) { } else { m = Convert.ToInt32(context.Request.Params["m"]); } int page = 0; if (context.Request["page"] != null && context.Request["page"] != "") { page = Convert.ToInt32(context.Request["page"]) - 1; } int pageSize = 15; if (context.Request["rows"] != null && context.Request["rows"] != "") { pageSize = Convert.ToInt32(context.Request["rows"]); } string sort = "wkEntryTime"; if (context.Request["sort"] != null && context.Request["sort"] != "") { sort = (context.Request["sort"]); } string order = "asc"; if (context.Request["order"] != null && context.Request["order"] != "") { order = (context.Request["order"]); } LNSql lnSql = new LNSql(); lnSql.conn.Open(); if (page == 0) { lnSql.cmd.CommandText = "select top " + pageSize + " * FROM workers_tb order by " + sort + " " + order + " "; } else { lnSql.cmd.CommandText = "select top " + pageSize + " * FROM workers_tb where wkID not in ( select top " + page * pageSize + " wkID from from workers_tb order by order by " + sort + " " + order + " ) order by " + sort + " " + order + " )"; } lnSql.da.SelectCommand = lnSql.cmd; lnSql.da.Fill(lnSql.ds, "workers_tb"); //wkID字符串 string wstr = "0"; if (lnSql.ds.Tables["workers_tb"].Rows.Count > 0) { foreach (DataRow dr in lnSql.ds.Tables["workers_tb"].Rows) { wstr += "," + dr["wkID"].ToString(); } //查询工资情况 lnSql.cmd.CommandText = "select * from ( wkPay_tb left join admins_tb on wkPay_tb.wlpAdmin= admins_tb.adminID ) where pWorker in (" + wstr + ") and wkpYear = " + y + " and wkpMonth = " + m + " "; lnSql.da.SelectCommand = lnSql.cmd; lnSql.da.Fill(lnSql.ds, "wkp_tb"); //转化为字符串 foreach (DataRow dr in lnSql.ds.Tables["workers_tb"].Rows) { JsonData row = new JsonData(); row["wkID"] = dr["wkID"].ToString(); row["wkName"] = dr["wkName"].ToString(); row["wkPosition"] = dr["wkPosition"].ToString(); row["wkSalary"] = float.Parse( dr["wkSalary"].ToString()); row["wkYear"] = y; row["wkMonth"] = m; //工资情况 DataRow[] wkpDRs = (lnSql.ds.Tables["wkp_tb"].Select("pWorker=" + dr["wkID"].ToString())); if (wkpDRs.Length > 0) { row["wkpAll"] = float.Parse(wkpDRs[0]["wkpAll"].ToString()); row["wlpYL"] = float.Parse(wkpDRs[0]["wlpYL"].ToString()); row["wlpSY"] = float.Parse(wkpDRs[0]["wlpSY"].ToString()); row["wlpYLiao"] = float.Parse(wkpDRs[0]["wlpYLiao"].ToString()); row["wlpSYe"] = float.Parse(wkpDRs[0]["wlpSYe"].ToString()); row["wlpGS"] = float.Parse(wkpDRs[0]["wlpGS"].ToString()); row["wlpZF"] = float.Parse(wkpDRs[0]["wlpZF"].ToString()); row["wlpTax"] = float.Parse(wkpDRs[0]["wlpTax"].ToString()); row["wlpSubsidy"] = float.Parse(wkpDRs[0]["wlpSubsidy"].ToString()); row["wlpShould"] = float.Parse(wkpDRs[0]["wlpShould"].ToString()); row["wlpReal"] = float.Parse(wkpDRs[0]["wlpReal"].ToString()); row["wkpID"] =Convert.ToInt32( wkpDRs[0]["wkpID"].ToString()); if (wkpDRs[0]["wlpAdmin"].ToString() == null) { row["wlpAdmin"] = ""; row["adminName"] = "未发"; } else { row["wlpAdmin"]= wkpDRs[0]["wlpAdmin"].ToString(); row["adminName"] = wkpDRs[0]["adminName"].ToString(); } if (wkpDRs[0]["wlpTime"].ToString() == "") { row["wlpTime"] = ""; } else { row["wlpTime"] = ((DateTime)wkpDRs[0]["wlpTime"]).ToString("yyyy-MM-dd"); } } else { row["wkpAll"] = ""; row["wlpYL"] = ""; row["wlpSY"] =""; row["wlpYLiao"] = ""; row["wlpSYe"] = ""; row["wlpGS"] = ""; row["wlpZF"] = ""; row["wlpTax"] = ""; row["wlpSubsidy"] = ""; row["wlpShould"] = ""; row["wlpReal"] = ""; row["wlpAdmin"] =""; row["wlpTime"] =""; row["adminName"] = "未发"; row["wkpID"] = ""; } rows.Add(row); } } else { rows = ""; } lnSql.cmd.CommandText = ""; //查询数量 lnSql.cmd.CommandText = "select count(wkID) from workers_tb"; total = Convert.ToInt32(lnSql.cmd.ExecuteScalar()); lnSql.conn.Close(); JsonData jsonData = new JsonData(); jsonData["total"] = total; jsonData["rows"] = rows; string echoString = jsonData.ToJson(); context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write(echoString); context.Response.End(); } }
public void ProcessRequest(HttpContext context) { int total = 0; JsonData rows = new JsonData(); if (context.Session["SlipAdmin"] == null) { context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write("未登录或登录超时!请重新登陆!<a href='LogOn.aspx' target='_top'> 请登录</a>"); context.Response.End(); } else { //查询所属项目 int fcp = Convert.ToInt32(context.Request.Params["pc"]); int page = 0; if (context.Request["page"] != null && context.Request["page"] != "") { page = Convert.ToInt32(context.Request["page"]) - 1; } int pageSize = 10; if (context.Request["rows"] != null && context.Request["rows"] != "") { pageSize = Convert.ToInt32(context.Request["rows"]); } string sort = "tpIndex"; if (context.Request["sort"] != null && context.Request["sort"] != "") { sort = (context.Request["sort"]); } string order = "asc"; if (context.Request["order"] != null && context.Request["order"] != "") { order = (context.Request["order"]); } SRSql srSql = new SRSql(); srSql.conn.Open(); if (page == 0) { srSql.cmd.CommandText = "select top " + pageSize + " tpID,tpName ,tpStartTime ,tpEndTime , tpPostTime , tpIndex from tpTB where forCp = "+fcp+" order by " + sort + " " + order + " "; } else { srSql.cmd.CommandText = "select top " + pageSize + " tpID,tpName ,tpStartTime ,tpEndTime , tpPostTime , tpIndex from tpTB where forCp = " + fcp + " and cpID not in ( select top " + page * pageSize + " tpID from tpTB forCp = " + fcp + " order by order by " + sort + " " + order + " ) order by " + sort + " " + order + " )"; } srSql.da.SelectCommand = srSql.cmd; srSql.da.Fill(srSql.ds,"tps_tb"); //循环执行,初始话项目 int openNext = 1; for (int i = 0; i < 12; i++) { string tp = ""; switch (i) { case 0: tp = "题目征集"; break; case 1: tp = "题目审核"; break; case 2: tp = "发布申报指南"; break; case 3: tp = "项目申报"; break; case 4: tp = "项目评审"; break; case 5: tp = "项目公式及师生互选"; break; case 6: tp = "项目实施"; break; case 7: tp = "中期检查"; break; case 8: tp = "中期检查结果公示"; break; case 9: tp = "开始结题"; break; case 10: tp = "结题验收"; break; case 11: tp = "题目征集"; break; default: break; } DataRow[] drs= srSql.ds.Tables["tps_tb"].Select("tpIndex = "+i); if (drs.Length == 0) { //未开启第i项进程 JsonData row = new JsonData(); row["open"] = openNext; openNext = 0; row["tp"] = tp; row["tpName"] = ""; row["tpID"] = ""; row["tpIndex"] = i; row["tpEndTime"] = ""; row["tpStartTime"] = ""; row["forCp"] = fcp; row["tpPostTime"] = ""; rows.Add(row); } else { DataRow dr = drs[0]; JsonData row = new JsonData(); row["open"] = openNext; openNext = 1; row["tp"] = tp; row["tpName"] = dr["tpName"].ToString(); row["tpID"] = dr["tpID"].ToString(); row["tpIndex"] = i; row["tpEndTime"] = ((DateTime)dr["tpEndTime"]).ToString("yyyy-MM-dd"); row["tpStartTime"] = ((DateTime)dr["tpStartTime"]).ToString("yyyy-MM-dd"); row["tpPostTime"] = ((DateTime)dr["tpPostTime"]).ToString("yyyy-MM-dd"); row["forCp"] = fcp; rows.Add(row); } } srSql.conn.Close(); JsonData jsonData = new JsonData(); jsonData["total"] = 12; jsonData["rows"] = rows; string echoString = jsonData.ToJson(); context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write(echoString); context.Response.End(); } }
public static JsonData SerializeJson(OSD osd) { switch (osd.Type) { case OSDType.Boolean: return new JsonData(osd.AsBoolean()); case OSDType.Integer: return new JsonData(osd.AsInteger()); case OSDType.Real: return new JsonData(osd.AsReal()); case OSDType.String: case OSDType.Date: case OSDType.URI: case OSDType.UUID: return new JsonData(osd.AsString()); case OSDType.Binary: byte[] binary = osd.AsBinary(); JsonData jsonbinarray = new JsonData(); jsonbinarray.SetJsonType(JsonType.Array); for (int i = 0; i < binary.Length; i++) jsonbinarray.Add(new JsonData(binary[i])); return jsonbinarray; case OSDType.Array: JsonData jsonarray = new JsonData(); jsonarray.SetJsonType(JsonType.Array); OSDArray array = (OSDArray)osd; for (int i = 0; i < array.Count; i++) jsonarray.Add(SerializeJson(array[i])); return jsonarray; case OSDType.Map: JsonData jsonmap = new JsonData(); jsonmap.SetJsonType(JsonType.Object); OSDMap map = (OSDMap)osd; foreach (KeyValuePair<string, OSD> kvp in map) { // Default values will not be serialized to the jsonmap JsonData data = SerializeJsonNoDefaults(kvp.Value); if (data != null) jsonmap[kvp.Key] = data; } return jsonmap; case OSDType.Unknown: default: return new JsonData(); } }
public void ProcessRequest(HttpContext context) { int total = 0; JsonData rows = new JsonData(); if (context.Session["adminID"] == null) { context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write("未登录或登录超时!请重新登陆!"); context.Response.End(); } else { int y = DateTime.Now.Year; int m = DateTime.Now.Month; if (context.Request.Params["y"] == "" || context.Request.Params["y"] == null) { } else { y = Convert.ToInt32(context.Request.Params["y"]); } if (context.Request.Params["y"] == "" || context.Request.Params["y"] == null) { } else { m = Convert.ToInt32(context.Request.Params["m"]); } int page = 0; if (context.Request["page"] != null && context.Request["page"] != "") { page = Convert.ToInt32(context.Request["page"]) - 1; } int pageSize = 15; if (context.Request["rows"] != null && context.Request["rows"] != "") { pageSize = Convert.ToInt32(context.Request["rows"]); } string sort = "wkEntryTime"; if (context.Request["sort"] != null && context.Request["sort"] != "") { sort = (context.Request["sort"]); } string order = "asc"; if (context.Request["order"] != null && context.Request["order"] != "") { order = (context.Request["order"]); } LNSql lnSql = new LNSql(); lnSql.conn.Open(); if (page == 0) { lnSql.cmd.CommandText = "select top " + pageSize + " * FROM workers_tb order by " + sort + " " + order + " "; } else { lnSql.cmd.CommandText = "select top " + pageSize + " * FROM workers_tb where wkID not in ( select top " + page * pageSize + " wkID from from workers_tb order by order by " + sort + " " + order + " ) order by " + sort + " " + order + " )"; } lnSql.da.SelectCommand = lnSql.cmd; lnSql.da.Fill(lnSql.ds,"workers_tb"); //wkID字符串 string wstr = "0"; if (lnSql.ds.Tables["workers_tb"].Rows.Count > 0) { foreach (DataRow dr in lnSql.ds.Tables["workers_tb"].Rows) { wstr+=","+dr["wkID"].ToString(); } //查询缺勤情况 lnSql.cmd.CommandText = "select * from unworks_tb where uworker in ("+wstr+") and uwkYear = "+y+" and uwkMonth = "+ m+" "; lnSql.da.SelectCommand = lnSql.cmd; lnSql.da.Fill(lnSql.ds,"uwks_tb"); //查询加班情况 lnSql.cmd.CommandText = "select * from overworks_tb where oworker in (" + wstr + ") and owkYear = " + y + " and owkMonth = " + m + " "; lnSql.da.SelectCommand = lnSql.cmd; lnSql.da.Fill(lnSql.ds, "owks_tb"); //转化为字符串 foreach (DataRow dr in lnSql.ds.Tables["workers_tb"].Rows) { JsonData row = new JsonData(); row["wkID"] = dr["wkID"].ToString(); row["wkName"] = dr["wkName"].ToString(); row["wkPosition"] = dr["wkPosition"].ToString(); row["wkYear"] = y; row["wkMonth"] = m; //缺勤 DataRow[] uwkDRs=(lnSql.ds.Tables["uwks_tb"].Select("uworker=" + dr["wkID"].ToString())); if(uwkDRs.Length>0){ row["uwkTimes"] = float.Parse(uwkDRs[0]["uwkTimes"].ToString()); }else{ row["uwkTimes"] = 0; } //缺勤 DataRow[] owkDRs = (lnSql.ds.Tables["owks_tb"].Select("oworker=" + dr["wkID"].ToString())); if (owkDRs.Length > 0) { row["owkTimes"] = float.Parse(owkDRs[0]["owkTimes"].ToString()); } else { row["owkTimes"] = 0; } rows.Add(row); } } else { rows = ""; } lnSql.cmd.CommandText = ""; //查询数量 lnSql.cmd.CommandText = "select count(wkID) from workers_tb"; total = Convert.ToInt32(lnSql.cmd.ExecuteScalar()); lnSql.conn.Close(); JsonData jsonData = new JsonData(); jsonData["total"] = total; jsonData["rows"] = rows; string echoString = jsonData.ToJson(); context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write(echoString); context.Response.End(); } }
bool AppendBuilding(string path) { IOHelper.WaitWhileFileLocked(BuildingList, sleepTime: 5); string json = "[]"; if (File.Exists(BuildingList)) json = File.ReadAllText(BuildingList); list = JsonMapper.ToObject(json); for (int i = 0; i < list.Count; i++) if ((string)list[i] == path) return true; //List<JsonData> arr = new List<JsonData>(list.Count + 1); //for (int i = 0; i < list.Count; i++) // arr.Add(list[i]); //arr.Add(path); //list = new JsonData(); list.Add(path); json = list.ToJson(); File.WriteAllText(BuildingList, json); return false; }
void RemoveBuilding(string path) { IOHelper.WaitWhileFileLocked(BuildingList, sleepTime: 5); string json = String.Empty; if (File.Exists(BuildingList)) json = File.ReadAllText(BuildingList); list = JsonMapper.ToObject(json); List<JsonData> arr = new List<JsonData>(); for (int i = 0; i < list.Count; i++) if ((string)list[i] != path) arr.Add((string)list[i]); list = JsonMapper.ToObject("[]"); for (int i = 0; i < arr.Count; i++) list.Add(arr[i]); json = list.ToJson(); File.WriteAllText(BuildingList, json); }
public void GetKeysInvalidTypeTest () { JsonData data = new JsonData (); data.Add (42); // turns it into an array // .. but an array doesn't have keys ICollection<string> keys = data.Keys; Assert.IsNotNull (keys); }
private JsonData ToJson(Bundle bundle) { JsonData target = new JsonData(); if (bundle.Type == DataType.Object) { target.SetJsonType(JsonType.Object); foreach (KeyValuePair<string, Bundle> entry in bundle.Dictionary) { switch (entry.Value.Type) { case DataType.Boolean: target[entry.Key] = entry.Value.AsBool(); break; case DataType.Integer: target[entry.Key] = entry.Value.AsLong(); break; case DataType.Double: target[entry.Key] = entry.Value.AsDouble(); break; case DataType.String: target[entry.Key] = entry.Value.AsString(); break; default: target[entry.Key] = ToJson(entry.Value); break; } } } else { target.SetJsonType(JsonType.Array); foreach (Bundle entry in bundle.Array) { switch (entry.Type) { case DataType.Boolean: target.Add(entry.AsBool()); break; case DataType.Integer: target.Add(entry.AsInt()); break; case DataType.Double: target.Add(entry.AsDouble()); break; case DataType.String: target.Add(entry.AsString()); break; default: target.Add(ToJson(entry)); break; } } } return target; }
//准备批量打款参数 public static string prepareTransfersParameters(BCTransfersParameter para) { if (BCCache.Instance.masterSecret == null) { var ex = new BCException("masterSecret未注册, 请查看registerApp方法"); throw ex; } long timestamp = BCUtil.GetTimeStamp(DateTime.Now); JsonData data = new JsonData(); data["app_id"] = BCCache.Instance.appId; data["app_sign"] = BCPrivateUtil.getAppSignatureByMasterSecret(BCCache.Instance.appId, BCCache.Instance.masterSecret, timestamp.ToString()); data["timestamp"] = timestamp; data["channel"] = para.channel; data["batch_no"] = para.batchNo; data["account_name"] = para.accountName; JsonData list = new JsonData(); foreach (var transfer in para.transfersData) { JsonData d = new JsonData(); d["transfer_id"] = transfer.transferId; d["receiver_account"] = transfer.receiverAccount; d["receiver_name"] = transfer.receiverName; d["transfer_fee"] = transfer.transferFee; d["transfer_note"] = transfer.transferNote; list.Add(d); } data["transfer_data"] = list; string paraString = data.ToJson(); return paraString; }
public JsonData MapToData(Map map) { JsonData data = new JsonData (); data ["Name"] = map.mapname; data ["Step"] = map.PerfectMove; data ["Width"] = map.width; data ["Height"] = map.height; data["Grid"]=new JsonData(); JsonData AGD = new JsonData (); for(int i=0;i<GridPos.Count;i++){ JsonData gd=new JsonData(); gd["x"]=GridPos[i].x; gd["y"]=GridPos[i].y; gd["data"]=new JsonData(); gd["data"].Add ((int)GData[i].type); gd["data"].Add ((int)GData[i].color); gd["data"].Add ((int)GData[i].ObjectSide); AGD.Add (gd); } data ["Grid"] = AGD; data ["Block"] = new JsonData (); JsonData ABD = new JsonData (); for(int i=0;i<AllBlock.Count;i++){ JsonData bd=new JsonData(); bd["x"]=AllBlock[i].x; bd["y"]=AllBlock[i].y; ABD.Add (bd); } if (!ABD.IsObject) ABD.Add (null); data ["Block"] = ABD; return data; }
static string CreateInvokeRequest(string id, params string[] invokeArgs) { JsonData req = new JsonData(); req.Add("invoke"); JsonData parameters = new JsonData(); parameters["id"] = id; JsonData args = new JsonData(); args.SetJsonType(JsonType.Array); // To avoid invalid json if it is empty foreach(var arg in invokeArgs) { args.Add(arg); } parameters["args"] = args; req.Add(parameters); return JsonMapper.ToJson(req); }
private static JsonData SerializeJsonNoDefaults(OSD osd) { switch (osd.Type) { case OSDType.Boolean: bool b = osd.AsBoolean(); if (!b) return null; return new JsonData(b); case OSDType.Integer: int v = osd.AsInteger(); if (v == 0) return null; return new JsonData(v); case OSDType.Real: double d = osd.AsReal(); if (d == 0.0d) return null; return new JsonData(d); case OSDType.String: case OSDType.Date: case OSDType.URI: string str = osd.AsString(); if (String.IsNullOrEmpty(str)) return null; return new JsonData(str); case OSDType.UUID: UUID uuid = osd.AsUUID(); if (uuid == UUID.Zero) return null; return new JsonData(uuid.ToString()); case OSDType.Binary: byte[] binary = osd.AsBinary(); if (binary == Utils.EmptyBytes) return null; JsonData jsonbinarray = new JsonData(); jsonbinarray.SetJsonType(JsonType.Array); for (int i = 0; i < binary.Length; i++) jsonbinarray.Add(new JsonData(binary[i])); return jsonbinarray; case OSDType.Array: JsonData jsonarray = new JsonData(); jsonarray.SetJsonType(JsonType.Array); OSDArray array = (OSDArray)osd; for (int i = 0; i < array.Count; i++) jsonarray.Add(SerializeJson(array[i])); return jsonarray; case OSDType.Map: JsonData jsonmap = new JsonData(); jsonmap.SetJsonType(JsonType.Object); OSDMap map = (OSDMap)osd; foreach (KeyValuePair<string, OSD> kvp in map) { JsonData data = SerializeJsonNoDefaults(kvp.Value); if (data != null) jsonmap[kvp.Key] = data; } return jsonmap; case OSDType.Unknown: default: return null; } }
string StepMatches(string stepName) { JsonData matches = new JsonData(); matches.SetJsonType(JsonType.Array); foreach (var sd in _repository.StepDefinitions) { List<StepArgument> args = sd.ArgumentsFrom(stepName); if(args != null) { JsonData stepMatch = new JsonData(); stepMatch["id"] = sd.Id; JsonData jsonArgs = new JsonData(); jsonArgs.SetJsonType(JsonType.Array); foreach (var arg in args) { JsonData jsonArg = new JsonData(); jsonArg["val"] = arg.Val; jsonArg["pos"] = arg.Pos; jsonArgs.Add(jsonArg); } stepMatch["args"] = jsonArgs; matches.Add(stepMatch); } } JsonData response = new JsonData(); response.Add("step_matches"); response.Add(matches); return JsonMapper.ToJson(response); }
public void ProcessRequest(HttpContext context) { int total = 0; JsonData rows = new JsonData(); if (context.Session["SlipAdmin"] == null) { context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write("未登录或登录超时!请重新登陆!"); context.Response.End(); } else { int page = 0; if (context.Request["page"] != null && context.Request["page"] != "") { page = Convert.ToInt32(context.Request["page"]) - 1; } int pageSize = 10; if (context.Request["rows"] != null && context.Request["rows"] != "") { pageSize = Convert.ToInt32(context.Request["rows"]); } string sort = "opID"; if (context.Request["sort"] != null && context.Request["sort"] != "") { sort = (context.Request["sort"]); } string order = "desc"; if (context.Request["order"] != null && context.Request["order"] != "") { order = (context.Request["order"]); } string connStr = ConfigurationManager.ConnectionStrings["SlipConnStr"].ConnectionString; OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = connStr; conn.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = conn; if (page == 0) { cmd.CommandText = "select top " + pageSize + " opID,opTitle ,opYear from oldProjects_tb order by " + sort + " " + order + " "; } else { cmd.CommandText = "select top " + pageSize + " opID,opTitle ,opYear from oldProjects_tb where opID not in ( select top " + page * pageSize + " opID from oldProjects_tb order by order by " + sort + " " + order + " ) order by " + sort + " " + order + " )"; } OleDbDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { do { JsonData row = new JsonData(); row["opTitle"] = dr["opTitle"].ToString(); row["opYear"] = dr["opYear"].ToString(); row["opID"] = Convert.ToInt32(dr["opID"].ToString()); rows.Add(row); } while (dr.Read()); } else { rows = ""; } //查询数量 cmd = new OleDbCommand(); cmd.Connection = conn; cmd.CommandText = "select count(opID) from oldProjects_tb "; total = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); JsonData jsonData = new JsonData(); jsonData["total"] = total; jsonData["rows"] = rows; string echoString = jsonData.ToJson(); context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write(echoString); context.Response.End(); } }
public void SendFrameUpdate(CameraStreamer.CaptureRequest streamCapture, Avatar a) { if (logTimingInfo) Debug.LogFormat("Start SendFrameUpdate() {0} {1}", a.name, Utils.GetTimeStamp()); _lastMessageSent.Clear(); JsonData jsonData = CreateMsgJson(MSG_S_FrameData); // TODO: Additional frame message description? if (a.shouldCollectObjectInfo) { // Look up relationship values for all observed semantics objects jsonData["observed_objects"] = new JsonData(JsonType.Array); foreach(SemanticObject o in a.observedObjs) jsonData["observed_objects"].Add(o.identifier); jsonData["observed_relations"] = new JsonData(JsonType.Object); bool collectAllRelationships = a.relationshipsToRetrieve.Contains("ALL"); foreach(SemanticRelationship rel in _relationsToTest) { if (collectAllRelationships || a.relationshipsToRetrieve.Contains(rel.name)) jsonData["observed_relations"][rel.name] = rel.GetJsonString(a.observedObjs); } } jsonData["avatar_position"] = a.transform.position.ToJson(); jsonData["avatar_rotation"] = a.transform.rotation.ToJson(); // // Add in captured frames // int numValues = Mathf.Min(streamCapture.shadersList.Count, streamCapture.capturedImages.Count); // JSONArray imagesArray = new JsonData(JsonType.Array); // for(int i = 0; i < numValues; ++i) // imagesArray.Add(new JSONData(Convert.ToBase64String(streamCapture.capturedImages[i].pictureBuffer))); // jsonData["captured_pngs"] = imagesArray; //add initial scene info if (a.sendSceneInfo) { jsonData["sceneInfo"] = new JsonData(JsonType.Array); SemanticObject[] allObjects = UnityEngine.Object.FindObjectsOfType<SemanticObject>(); foreach(SemanticObject semObj in allObjects){ JsonData _info; _info = new JsonData(JsonType.Array); _info.Add(semObj.gameObject.name); Color colorID = semObj.gameObject.GetComponentInChildren<Renderer> ().material.GetColor ("_idval"); _info.Add(colorUIDToString(colorID)); jsonData["sceneInfo"].Add(_info); } } if (logTimingInfo) Debug.LogFormat("Finished collect Json data {0}", Utils.GetTimeStamp()); // Send out the real message string jsonString = LitJson.JsonMapper.ToJson(jsonData); _lastMessageSent.Append(jsonString); if (logTimingInfo) Debug.LogFormat("Finished encode json data of length {1}, {0}", Utils.GetTimeStamp(), jsonString.Length); // Add in captured frames(directly, non-JSON) int numValues = Mathf.Min(streamCapture.shadersList.Count, streamCapture.capturedImages.Count); for(int i = 0; i < numValues; ++i) _lastMessageSent.Append(streamCapture.capturedImages[i].pictureBuffer); if (logTimingInfo) Debug.LogFormat("Finished Encode Image data {0}", Utils.GetTimeStamp()); a.myServer.SendMultipartMessage(_lastMessageSent); //Debug.Log (_lastMessageSent.ToString()); Debug.LogFormat("Sending frame message with {0} frames for {1} values", _lastMessageSent.FrameCount, numValues); if (logTimingInfo) Debug.LogFormat("Finish SendFrameUpdate() {0} {1}", a.name, Utils.GetTimeStamp()); }
public void ProcessRequest(HttpContext context) { int total = 0; JsonData rows = new JsonData(); if (context.Session["adminID"] == null) { context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write("未登录或登录超时!请重新登陆!"); context.Response.End(); } else { int page = 0; if (context.Request["page"] != null && context.Request["page"] != "") { page = Convert.ToInt32(context.Request["page"]) - 1; } int pageSize = 15; if (context.Request["rows"] != null && context.Request["rows"] != "") { pageSize = Convert.ToInt32(context.Request["rows"]); } string sort = "adminID"; if (context.Request["sort"] != null && context.Request["sort"] != "") { sort = (context.Request["sort"]); } string order = "asc"; if (context.Request["order"] != null && context.Request["order"] != "") { order = (context.Request["order"]); } LNSql lnSql = new LNSql(); lnSql.conn.Open(); if (page == 0) { lnSql.cmd.CommandText = "select top " + pageSize + " * from admins_tb order by " + sort + " " + order + " "; } else { lnSql.cmd.CommandText = "select top " + pageSize + " * from admins_tb where adminID not in ( select top " + page * pageSize + " adminID from admins_tb order by order by " + sort + " " + order + " ) order by " + sort + " " + order + " )"; } lnSql.dr = lnSql.cmd.ExecuteReader(); if (lnSql.dr.Read()) { do { JsonData row = new JsonData(); row["adminID"] = lnSql.dr["adminID"].ToString(); row["adminName"] = lnSql.dr["adminName"].ToString(); row["adminAccount"] = lnSql.dr["adminAccount"].ToString(); row["adminClass"] = lnSql.dr["adminClass"].ToString(); rows.Add(row); } while (lnSql.dr.Read()); } else { rows = ""; } //查询数量 lnSql.dr.Close(); lnSql.cmd.CommandText = "select count(adminID) from admins_tb"; total = Convert.ToInt32(lnSql.cmd.ExecuteScalar()); lnSql.conn.Close(); JsonData jsonData = new JsonData(); jsonData["total"] = total; jsonData["rows"] = rows; string echoString = jsonData.ToJson(); context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write(echoString); context.Response.End(); } }
internal void RequestSceneRoomList(ulong guid) { UserProcessScheduler dataProcess = LobbyServer.Instance.UserProcessScheduler; UserInfo user = dataProcess.GetUserInfo(guid); if (null != user) { if (user.CurrentState == UserState.Room) { RoomInfo room = user.Room; if (null != room) { List<SceneRoomInfo> list = m_LobbyInfo.GetSceneRoomList(room.SceneType); JsonData jsonList = new JsonData(); int ct = list.Count; for (int i = 0; i < ct; ++i) { JsonData json = new JsonData(); json.Add(list[i].m_RoomIndex); json.Add(list[i].m_UserCount); json.Add(list[i].m_TotalUserCount); json.Add(list[i].m_RoomId); json.Add(list[i].m_SceneId); jsonList.Add(json); } if (ct > 0) { LobbyServer.Instance.SendStoryMessage(user, "onroomlist", JsonMapper.ToJson(jsonList)); } } } } }