public object LoadMenu(dynamic obj) { //Dictionary<string, object> result = new Dictionary<string, object>(); string strSql = "SELECT SYS_PERMISSION_ID as ID,CNAME AS NAME,PID,CURL,IORDER FROM SYS_PERMISSION order by iorder "; Database db = DataBaseHelper.CreateDataBase(); DataTable dt; //DataTable reDataTable; using (DbConnection conn = db.CreateConnection()) { if (conn.State == ConnectionState.Closed) { conn.Open(); } dt = db.ExecuteDataSet(CommandType.Text, strSql).Tables[0]; } ArrayList list = FormatJsonExtension.DataTableArrayList(dt); return(this.JsonFormat(list)); }
public object LoadStoredProcedureMenu(dynamic obj) { Dictionary <string, object> result = new Dictionary <string, object>(); string strSql = "存储过程"; Database db = DataBaseHelper.CreateDataBase(); DataTable dt; using (DbConnection conn = db.CreateConnection()) { if (conn.State == ConnectionState.Closed) { conn.Open(); } dt = db.ExecuteDataSet(CommandType.StoredProcedure, strSql).Tables[0]; } ArrayList list = FormatJsonExtension.DataTableArrayList(dt); result.Add("code", "200"); result.Add("msg", "ok"); result.Add("data", list); result.Add("count", list.Count); return(result); }