public List<Menuitem> RetrieveMenuitemsPaging(MenuitemSearch info,int pageIndex, int pageSize,out int count)
{
try
{
StringBuilder sqlCommand = new StringBuilder(@" SELECT ""MENUITEM"".""MENUID"",""MENUITEM"".""MENUNAME"",""MENUITEM"".""PARENTMENUID"",""MENUITEM"".""MENUADDRESS"",""MENUITEM"".""ORDERBY"",
""MENUITEM"".""FUNCTIONID"",""MENUITEM"".""BUTTONID""
FROM ""MENUITEM""
WHERE 1=1");
#region ���
if (!string.IsNullOrEmpty(info.Menuid))
{
this.Database.AddInParameter(":Menuid",DbType.AnsiString,"%"+info.Menuid+"%");
sqlCommand.AppendLine(@" AND ""MENUITEM"".""MENUID"" LIKE :Menuid");
}
#endregion
#region �˵���
if (!string.IsNullOrEmpty(info.Menuname))
{
this.Database.AddInParameter(":Menuname", "%"+info.Menuname+"%");
sqlCommand.AppendLine(@" AND ""MENUITEM"".""MENUNAME"" LIKE :Menuname");
}
#endregion
#region ���˵����
if (!string.IsNullOrEmpty(info.Parentmenuid))
{
this.Database.AddInParameter(":Parentmenuid",DbType.AnsiString,"%"+info.Parentmenuid+"%");
sqlCommand.AppendLine(@" AND ""MENUITEM"".""PARENTMENUID"" LIKE :Parentmenuid");
}
#endregion
#region ���ӵ�ַ
if (!string.IsNullOrEmpty(info.Menuaddress))
{
this.Database.AddInParameter(":Menuaddress",DbType.AnsiString,"%"+info.Menuaddress+"%");
sqlCommand.AppendLine(@" AND ""MENUITEM"".""MENUADDRESS"" LIKE :Menuaddress");
}
#endregion
#region ���ܱ��
if (!string.IsNullOrEmpty(info.Functionid))
{
this.Database.AddInParameter(":Functionid",DbType.AnsiString,"%"+info.Functionid+"%");
sqlCommand.AppendLine(@" AND ""MENUITEM"".""FUNCTIONID"" LIKE :Functionid");
}
#endregion
#region ��ť��ţ��Զ��ŷָ
if (!string.IsNullOrEmpty(info.Buttonid))
{
this.Database.AddInParameter(":Buttonid",DbType.AnsiString,"%"+info.Buttonid+"%");
sqlCommand.AppendLine(@" AND ""MENUITEM"".""BUTTONID"" LIKE :Buttonid");
}
#endregion
sqlCommand.AppendLine(@" ORDER BY ""MENUITEM"".""MENUID"" DESC");
return this.ExecuteReaderPaging<Menuitem>(sqlCommand.ToString(), pageIndex, pageSize, out count);
}
finally
{
this.Database.ClearParameter();
}
}
public List<Menuitem> RetrieveMenuitemsPaging(MenuitemSearch info,int pageIndex, int pageSize,out int count)
{
return Management.RetrieveMenuitemsPaging(info,pageIndex,pageSize,out count);
}
