protected void Page_Load(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request["query"] + ""))
{
string query = Request["query"] + "";
object[] arr = new object[] {
new { Code = "1", Name = "AAAAA" },
new { Code = "2", Name = "BBBBB" },
new { Code = "3", Name = "CCCCC" },
new { Code = "4", Name = "DDDDD" },
new { Code = "5", Name = "FFFFF" },
new { Code = "6", Name = "GGGGG" }
};
GridJsonStruct gjs = new GridJsonStruct(arr, 5);
string Json = Razor.DynamicJson.DynamicJsonConvert.SerializeObject(arr);
Response.Write(Json);
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["action"] + "" == "read")
{
Response.Write(ResponseJsonBySQL());
Response.End();
}
if (Request["action"] + "" == "data")
{
}
if (!IsPostBack)
{
string sql = "select top 1000 * from Employee where 1=1 ";
DataTable dt = Razor.DataHelper.QueryDataTable(sql);
DataTable newDt = GetPagedTable(dt, 1, 20);
GridJsonStruct gjs = new GridJsonStruct(newDt, dt.Rows.Count);
string JsonStr = JsonConvert.SerializeObject(gjs);
PageState.Add("PageData", JsonStr);
}
}
/// <summary>
/// 输出Json字符串
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
private string ResponseJsonBySQL()
{
//if (string.IsNullOrEmpty(sql)) return null;
List <ICriterion> exps = new List <ICriterion>();
//查询数据时
if (!string.IsNullOrEmpty(PagingStruct.search))
{
var jarr = (JArray)JsonConvert.DeserializeObject(PagingStruct.search);
dynamic jsonObj = Razor.DynamicJson.DynamicJsonConvert.Parse(PagingStruct.search);
string Name = jsonObj[0].Name;
string Age = jsonObj[1].Age;
string Email = jsonObj[2].Email;
if (!string.IsNullOrEmpty(Name))
{
exps.Add((ICriterion)Expression.Like("Name", Name));
}
if (!string.IsNullOrEmpty(Age))
{
exps.Add((ICriterion)Expression.Eq("Age", int.Parse(Age)));
}
if (!string.IsNullOrEmpty(Email))
{
exps.Add((ICriterion)Expression.Like("Email", Email));
}
}
var list = DataHelper.GetPageList <Employee>(PagingStruct.Page, PagingStruct.PageSize,
new Order[] { new Order("CreateTime", false) }, exps.ToArray());
GridJsonStruct gjs = new GridJsonStruct(list, DataHelper.GetCount <Employee>());
return(Razor.DynamicJson.DynamicJsonConvert.SerializeObject(gjs));
}
/// <summary>
/// 输出Json字符串
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
private string ResponseJsonBySQL()
{
//if (string.IsNullOrEmpty(sql)) return null;
string sql = "select * from Employee where 1=1 ";
//查询数据时
if (!string.IsNullOrEmpty(GridPagingStruct.search))
{
var jarr = (JArray)JsonConvert.DeserializeObject(GridPagingStruct.search);
dynamic jsonObj = Razor.DynamicJson.DynamicJsonConvert.Parse(GridPagingStruct.search);
string Name = jsonObj[0].Name;
string Age = jsonObj[1].Age;
string Email = jsonObj[2].Email;
if (!string.IsNullOrEmpty(Name))
{
sql += " and Name like '%" + Name + "%' ";
}
if (!string.IsNullOrEmpty(Age))
{
sql += " and Age=" + jsonObj[1].Age;
}
if (!string.IsNullOrEmpty(Email))
{
sql += " and Email like '%" + Email + "%' ";
}
}
sql = sql + " order by CreateTime desc";
DataTable dt = Razor.Data.DataHelper.QueryDataTable(sql);
DataTable newDt = GetPagedTable(dt, GridPagingStruct.Page, GridPagingStruct.PageSize);
GridJsonStruct gjs = new GridJsonStruct(newDt, dt.Rows.Count);
return(JsonConvert.SerializeObject(gjs, new JsonConverter[] { new DataTableConverter(), new IsoDateTimeConverter() }));
}
