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); }