bool bLogin = client.Login(dbId, "Administrator", "888888", 2052);
string sql = "select FID,FBILLNO,FDOCUMENTSTATUS,F_DEV_GRADE,F_DEV_STARTTIME,F_DEV_ENDTTME,F_DEV_Y from Dev_t_CustB_basic";
var result = DBServiceHelper.ExecuteDataSet(this.KDContext.Session.AppContext, sql);
return DataSetToJson(result);
}
///
/// 测试
///
///
public string GetString()
{
return "进行测试";
}
/// dataset转Json
///
///
///
public static string DataSetToJson(DataSet ds)
{
StringBuilder json = new StringBuilder();
json.Append("{\"Tables\":");
json.Append("[");
foreach (DataTable dt in ds.Tables)
{
json.Append(DataTableToJson(dt));
json.Append(",");
}
json.Remove(json.Length - 1, 1);
json.Append("]");
json.Append("}");
return json.ToString();
}
/// table转json
///
///
///
public static string DataTableToJson(DataTable dt)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("{\"Name\":\"" + dt.TableName + "\",\"Rows");
jsonBuilder.Append("\":[");
for (int i = 0; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append("\":\"");
jsonBuilder.Append(dt.Rows[i][j].ToString().Replace("\"", "\\\""));
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return jsonBuilder.ToString();
}