public static string GetAppRights(string account) { Res.ErrInfo = ErrorHelper.ErrNone; Res.RspInfo = null; DataTable table = null; string sql = "select * from table"; try { table = DbHelper.ExecuteDbQueryDt(sql); if (table.Rows.Count == 0 || string.IsNullOrEmpty(table.Rows[0][0].ToString())) { Res.ErrInfo = ErrorHelper.ErrNullData; } } catch { Res.ErrInfo = ErrorHelper.ErrDbError; } if (table?.Rows.Count > 0 && !string.IsNullOrEmpty(table.Rows[0][0].ToString())) { Res.RspInfo = ConverToJson.DataTableToList(table); } return(ConverToJson.RspInfoToJson(Res)); }
//用户信息 public static string GetUserInfo(string account) { Res.ErrInfo = ErrorHelper.ErrNone; Res.RspInfo = null; DataTable table = new DataTable(); string sql = "select * from table"; try { table = DbHelper.ExecuteDbQueryDt(sql); if (table.Rows.Count == 0) { Res.ErrInfo = ErrorHelper.ErrNullData; } } catch { Res.ErrInfo = ErrorHelper.ErrDbError; } if (table?.Rows.Count > 0) { Res.RspInfo = ConverToJson.DataTableToList(table); } return(ConverToJson.RspInfoToJson(Res)); }