1、界面
2、DAL 层代码
//绑定数据源,并设置每页几行的参数 pagecount 为每页几行,page 为跳转到第几页
public static DataTable GetRyjb(string leixing,string Sear,string pagecount,string page)
{
int pa=Convert.ToInt32(page);
int pcount=Convert.ToInt32(pagecount);
string sql = string.Format(@"select top({0})
RJB.YuanGBH,RCC.XingM,JB.JiB,RJB.ShiJ,RJB.Bz From RenYJB RJB,RenCaiC RCC,JiB JB
where
RJB.YuanGBH=RCC.BianH and RJB.DJiBID=JB.ID and RJB.ID in (select max(ID) from
RenYJB group by YuanGBH) and RJB.Id not in (select top({1}) max(RJB.ID) from RenYJB
RJB,RenCaiC RCC group by RJB.YuanGBH,RJB.YuanGBH,RCC.XingM having
RJB.YuanGBH=RJB.YuanGBH and RJB.YuanGBH like '%" + Sear + "%' or RCC.XingM like
'%" + Sear + "%')", pagecount, "" + pa * pcount + "");
if (leixing == "按员工编号查询")
{
sql += " and RJB.YuanGBH like '%"+Sear+"%'";
}
if (leixing == "按员工姓名查询")
{
sql += " and RCC.XingM like '%" + Sear + "%'";