private string GetEasyList(bool format)
{
bool ORMMode = System.Web.HttpContext.Current.Request.Params["ORMMode"] == "true" ? true : false;
string helpid = System.Web.HttpContext.Current.Request.Params["helpid"];
//string limit = System.Web.HttpContext.Current.Request.Params["limit"];
string limit = System.Web.HttpContext.Current.Request.Params["rows"];
string page = System.Web.HttpContext.Current.Request.Params["page"];
bool isAutoComplete = false;
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //内部json查询条件, like %value%
string outJsonQuery = System.Web.HttpContext.Current.Request.Params["outqueryfilter"]; //外部json查询条件, =value
string leftLikeJsonQuery = System.Web.HttpContext.Current.Request.Params["leftLikefilter"]; //查询条件，like value%
string clientSqlFilter = System.Web.HttpContext.Current.Request.Params["clientSqlFilter"]; //客户端传入的sql查询条件，有些情况无法参数化
string clientQuery = string.Empty;
if (!string.IsNullOrEmpty(clientJsonQuery))
{
//clientQuery = DataConverterHelper.BuildQuery(clientJsonQuery);
clientQuery = clientJsonQuery;
}
else
{
string queryValue = System.Web.HttpContext.Current.Request.Params["query"];//联想搜索过滤
if (!string.IsNullOrEmpty(queryValue))
{
isAutoComplete = true;
clientQuery = queryValue;
//queryValue = System.Web.HttpUtility.UrlDecode(queryValue,Encoding.GetEncoding("UTF-8"));
//clientQuery = this.BuildInputQuery(helpid,queryValue);
}
}
int pageSize = 20;
int.TryParse(limit, out pageSize);
if (pageSize == 0)
{
pageSize = 20;
}
int pageIndex = 0;
int.TryParse(page, out pageIndex);
int totalRecord = 0;
//DataTable dt = proxy.GetList(helpid,clientQuery, pageSize, (pageIndex-1), ref totalRecord);
DataTable dt = proxy.GetList(helpid, pageSize, pageIndex, ref totalRecord, clientQuery, outJsonQuery, leftLikeJsonQuery, clientSqlFilter, isAutoComplete, ORMMode);
string str = DataConverterHelper.ToJsonData(dt, totalRecord, format);
System.Web.HttpContext.Current.Response.ContentType = "text/json";
return(str);
}
//public string GetExcelData()
//{
// string tableName = System.Web.HttpContext.Current.Request.Params["tableName"];
// DataTable dt;
// dictionary.TryGetValue(tableName, out dt);//从静态变量中获取数据
// string json = DataConverterHelper.ToJson(dt, dt.Rows.Count);
// return json;
//}
//public string GetFieldNames()
/// <summary>
/// 获取grid列信息和数据
/// </summary>
/// <returns></returns>
public string GetColumInfoAndData()
{
try
{
string tableName = System.Web.HttpContext.Current.Request.Params["tableName"];
string jsonStr;
DataTable dt = proxy.GetExcelDataAndColInfo(tableName, out jsonStr);
//dictionary.Add(tableName, dt);//获取数据，缓存在静态变量中，多w3wp.exe会有问题,应当放到全局缓存中
//return jsonStr;
string data = DataConverterHelper.ToJsonData(dt, dt.Rows.Count, false);
return("{status:true,data:{exceldata:" + data + ",columinfo:" + jsonStr + "}}");
}
catch (Exception ex)
{
Logger.Error(ex.StackTrace);
return("{status:false,message:\"" + ex.Message + "\"}");
}
}
