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