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