/// summary /// 格式化字符型、日期型、布尔型 /// /summary private static string StringFormat(string str, Type type) { if (type == typeof(string)) { str = String2Json(str); str = \ + str + \; } else if (type == typeof(DateTime)) { str = \ +
/// /// 格式化字符型、日期型、布尔型
///
private static string StringFormat(string str, Type type)
{
if (type == typeof(string))
{
str = String2Json(str);
str = "\"" + str + "\"";
}
else if (type == typeof(DateTime))
{
str = "\"" + str + "\"";
}
else if (type == typeof(bool))
{
str = str.ToLower();
}
else if (type != typeof(string) && string.IsNullOrEmpty(str))
{
str = "\"" + str + "\"";
}
return str;
}
/// /// 过滤特殊字符
///
private static string String2Json(String s)
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < s.Length; i++)
{
char c = s.ToCharArray()[i];
switch (c)
{
case '\"':
sb.Append("\\\""); break;
case '\\':
sb.Append("\\\\"); break;
case '/':
sb.Append("\\/"); break;
case '\b':
sb.Append("\\b"); break;
case '\f':
sb.Append("\\f"); break;
case '\n':
sb.Append("\\n"); break;
case '\r':
sb.Append("\\r"); break;
case '\t':
sb.Append("\\t"); break;
default:
sb.Append(c); break;
}
}
return sb.ToString();
}
// ----------------------------------------------------------------------- // 取Count数据
string Sql_Count = "Select Count(Id) as Id from Sys_DepartmentClass" + " Where Deleted<>1 or Deleted is Null";
Sql_Class SqlClass1 = new Sql_Class();
SqlDataReader dr1 = SqlClass1.Sql_Select(Sql_Count);
StringBuilder Count_1 = new StringBuilder();
while (dr1.Read())
{
for (int i = 0; i < dr1.FieldCount; i++)
{
Type type = dr1.GetFieldType(i);
string strKey = dr1.GetName(i);
string strValue = dr1[i].ToString();
StrFormat uuu = new StrFormat();
strValue = uuu.StringFormat(strValue, type);
if (i < dr1.FieldCount - 1)
{ Count_1.Append(strValue); }.
else
{ Count_1.Append(strValue); }W
}
}
dr1.Close();
// ----------------------------------------------------------------------- // 取Select数据
string Sql = "Select DepartmentClass_Id,DepartmentClass_Name from Sys_DepartmentClass"
+ " Where Deleted<>1 or Deleted is Null";
Sql_Class SqlClass = new Sql_Class();
SqlDataReader dr = SqlClass.Sql_Select(Sql);
StringBuilder jsonString = new StringBuilder();
jsonString.Append("{"); // 总括号 -- 开始
jsonString.Append('"' + "Total" + '"' + ":" + '"' + Count_1.ToString() + '"' + ","); // 字段总数
jsonString.Append('"' + "Rows" + '"' + ":"); // 行字段开始
jsonString.Append("["); // 字段开始
while (dr.Read())
{
jsonString.Append("{");
for (int i = 0; i < dr.FieldCount; i++)
{
Type type = dr.GetFieldType(i);
string strKey = dr.GetName(i);
string strValue = dr[i].ToString();
jsonString.Append("\"" + strKey + "\":");
strValue = SqlClass.StringFormat(strValue, type);
if (i < dr.FieldCount - 1)
{
jsonString.Append(strValue + ",");
}
else
{
jsonString.Append(strValue);
}
}
jsonString.Append("},");
}
dr.Close();
jsonString.Remove(jsonString.Length - 1, 1);
jsonString.Append("]"); // 字段结束
jsonString.Append("}"); // 总括号 -- 结束
LogManager.WriteLog(jsonString.ToString());
this.context.Response.Write(jsonString.ToString());
}
[
{"id":"188","value":null,"text":"中国","icon": null, "fatherid": null, "children":null},
{"id":"20","value":null,"text":"河北","icon": null, "fatherid": null, "children":null},
{"id":"21","value":null,"text":"河南","icon": null, "fatherid": null, "children":null},
{"id":"11","value":null,"text":"河东","icon": null, "fatherid": null, "children":null},
{"id":"12","value":null,"text":"上海","icon": null, "fatherid": null, "children":null},
{"id":"166","value":null,"text":"北京","icon": null, "fatherid": null, "children":null},
{"id":"888","value":null,"text":"天津","icon": null, "fatherid": null, "children": null}
]
本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源：php中文网
