/// <summary> /// 获取数据返回数据列表 /// </summary> /// <param name="json"></param> /// <param name="proc"></param> /// <param name="userId"></param> /// <param name="entId"></param> /// <returns></returns> protected string GetReturnJson(string json, string proc, string userId, string entId) { string r_json; SqlParameter[] param = (JsonMethod.ListParameter(json, userId, entId)).ToArray();//动态解析json参数 SqlRun sql = new SqlRun(SqlRun.sqlstr); DataSet ds = sql.RunProDataSet(proc, param); if (ds.Tables.Count >= 3) { if (ds.Tables[1].Rows.Count > 0) { int recordCount = Convert.ToInt32(ds.Tables[2].Rows[0]["recordCount"].ToString().Trim()); int pageCount = Convert.ToInt32(ds.Tables[2].Rows[0]["pageCount"].ToString().Trim()); DataTable table = sql.GetChinaName(ds.Tables[1]); r_json = JsonMethod.GetDataTable(0, recordCount, pageCount, table, ds.Tables[1]); } else { string error = "无数据"; r_json = JsonMethod.GetError(1, error); } } else { if (ds.Tables[0].Rows.Count > 0) { int recordCount = 0; int pageCount = 0; r_json = JsonMethod.GetDataTable(0, recordCount, pageCount, ds.Tables[0]); } else { string error = "无数据"; r_json = JsonMethod.GetError(1, error); } } return(r_json); }
public string TabularData(string json, string userId, string entId) { string JSON = "{\"status\":"; string message = "", status = "0"; DataSet ds = new DataSet(); DataTable dt = new DataTable(); DataTable dt_fd = new DataTable(); SqlRun sqlRun = new SqlRun(SqlRun.sqlstr); try { ds = AcquireData(json, userId, entId); int ReCount = 0, pgCount = 0; message = "{\"fdname\":{"; if (ds.Tables.Count > 2) { dt = ds.Tables[1]; dt_fd = sqlRun.GetChinaName(dt); ReCount = Convert.ToInt32(ds.Tables[2].Rows[0]["recordCount"].ToString().Trim()); pgCount = Convert.ToInt32(ds.Tables[2].Rows[0]["PageCount"].ToString().Trim()); } else { dt = ds.Tables[0]; dt_fd = sqlRun.GetChinaName(dt); ReCount = dt.Rows.Count; } if (dt_fd != null) { foreach (DataColumn dc in dt.Columns) { if (dc.ColumnName.Contains("ROWSTAT")) { continue; } DataRow[] dr = dt_fd.Select("fdname = '" + dc.ColumnName + "'"); string chnname = dr.Length == 1 ? dr[0]["chnname"].ToString() : dc.ColumnName; message += "\"" + dc.ColumnName.Trim() + "\":\"" + chnname + "\","; } message = message.Substring(0, message.Length - 1); message += "},"; } else { throw new Exception("未获取字段"); } message += "\"ReCount\":" + ReCount + ",\"pgCount\":" + pgCount + ",\"Content\":"; if (dt.Rows.Count > 0) { message += "["; foreach (DataRow dr in dt.Rows) { message += "{"; foreach (DataColumn dc in dt.Columns) { if (dc.ColumnName.Contains("ROWSTAT")) { continue; } message += "\"" + dc.ColumnName.Trim() + "\":\"" + dr[dc.ColumnName].ToString().Trim() + "\","; } message = message.Substring(0, message.Length - 1); message += "},"; } message = message.Substring(0, message.Length - 1); message += "]"; } else { message += "\"无记录\""; } message += "}"; } catch (Exception e) { status = "2"; message = "\"" + e.Message.Trim().Replace("\"", "\\\"").Replace("\r", "").Replace("\n", "") + "\""; } JSON += "\"" + status + "\""; JSON += ",\"message\":" + message + "}"; return(JSON); }