public List <Menu> QueryMenus()
{
Menu menu = new Menu();
string cmd = SqlCmdHelper.GenerateSampleSelectSql <Menu>();// menu.QueryMenus();
return(CommonRepository.QueryModelList <Menu>(cmd, null, SqlConnString, 0, int.MaxValue));
}
public IList <CategoryItems> QueryAll()
{
List <CategoryItems> datas = new List <CategoryItems>();
CategoryItems model = new CategoryItems();
string sql = model.QueryAllDataOfSql();
return(CommonRepository.QueryModelList <CategoryItems>(sql, null, SqlConnString, 0, int.MaxValue));
}
public IList <RelyTable> QueryAll()
{
InitTableData();
RelyTable rely = new RelyTable();
string sql = rely.GetSampleQuerySql();
return(CommonRepository.QueryModelList <RelyTable>(sql, null, SqlConnString, 0, int.MaxValue));
}
public List <ReserveEmailAccount> QueryEmailAccounts()
{
string sql = new ReserveEmailAccount().GetSelectAllSql();
SqlCmdHelper help = new SqlCmdHelper()
{
SqlConnString = SqlConnString
};
return(CommonRepository.QueryModelList <ReserveEmailAccount>(sql, null, SqlConnString, 0, int.MaxValue));
}
public List <CategoryItems> GetNodeListByParent(string parentNodeCode)
{
List <CategoryItems> datas = new List <CategoryItems>();
CategoryItems model = new CategoryItems();
string sql = model.BuilderSqlParam();
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter()
{
ParameterName = "@code", Value = parentNodeCode
}
};
return(CommonRepository.QueryModelList <CategoryItems>(sql, param, SqlConnString, 0, int.MaxValue));
}
public List <Organze> QueryOrganzes(RequestParam param)
{
string sql = SqlCmdHelper.GenerateSampleSelectSql <Organze>() + " where 1=1";
List <SqlParameter> sqlParam = new List <SqlParameter>();
if (!string.IsNullOrEmpty(param.QueryKey))
{
sql += "and Code like @key+'%' or Name like @key+'%'";
sqlParam.Add(new SqlParameter()
{
ParameterName = "@key", Value = param.QueryKey
});
}
SqlCmdHelper help = new SqlCmdHelper()
{
SqlConnString = SqlConnString
};
return(CommonRepository.QueryModelList <Organze>(sql, sqlParam.ToArray(), SqlConnString, param.RowBeginIndex, param.RowEndIndex));
}
