public ActionResult loadlist()
{
Dictionary <string, object> result = new Dictionary <string, object>();
string strSql = "select T.Sys_Permission_Id as ID,T.CNAME,T.CURL,T.PID,IORDER,IISAVAILABLE from sys_permission t";
var dbbase = DataBaseHelper.CreateDataBase();
DataTable dt;
using (DbConnection conn = dbbase.CreateConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
dt = dbbase.ExecuteDataSet(CommandType.Text, strSql).Tables[0];
}
ArrayList list = FormatJsonExtension.DataTableArrayList(dt);
result.Add("code", "0");
result.Add("msg", "");
result.Add("count", list.Count);
result.Add("data", list);
return(this.JsonFormat(result));
}
/// <summary>
/// 查询数据分页显示
/// </summary>
/// <returns></returns>
public ActionResult loadlistpage()
{
//页码
int page = Convert.ToInt32(Request["page"]);
//页条数
int rows = Convert.ToInt32(Request["limit"]);
//where
string sqlwhere = "1=1";
string aaa = Request["aaa"];
//排序
string sort = "ID desc";
//表名
string tableName = "MT_WORKORDER";
//列
string columns = "ID,CCODE,CCODENAME,DDATE,CMAKER,DCREATESYSTIME,CSOUCE,CTHINGADDRESS";
//总条数
int toalCount = 0;
Database db = DataBaseHelper.CreateDataBase();
//DatabaseFactory.CreateDatabase("DEFAULT_CONNECTION_STRING");
SqlPage sqlpage = new SqlPage();
DataTable dt = sqlpage.GetDataSet(tableName, columns, sqlwhere, sort, page, rows, out toalCount).Tables[0];
ArrayList list = FormatJsonExtension.DataTableArrayList(dt);
Dictionary <String, object> result = new Dictionary <string, object>();
result.Add("code", "0");
result.Add("msg", "");
result.Add("count", toalCount);
result.Add("data", list);
return(this.JsonFormat(result));
}
