public kong <view_CustomServices> seleview_CustomServices(int index, int size)
{
string sql = string.Format(@"select top {0} * from view_CustomServices where CSID not in
(select top {1} CSID from view_CustomServices)", size, (index - 1) * size);
int tiaoshu = DALBase.GetCount <view_CustomServices>();
int count = tiaoshu % size == 0 ? tiaoshu / size : tiaoshu / size + 1;
List <view_CustomServices> u = DALBase.SelectByWhere <view_CustomServices>(sql);
kong <view_CustomServices> s = new kong <view_CustomServices>();
s.biao = u;
s.count = count;
return(s);
}
public kong <Chances> seleChances(int index, int size)
{
string sql = string.Format(@"select top {0} * from Chances where ChanID not in
(select top {1} ChanID from Chances) and Chanstate != 1", size, (index - 1) * size);
int tiaoshu = DALBase.GetCount <Chances>();
int count = tiaoshu % size == 0 ? tiaoshu / size : tiaoshu / size + 1;
List <Chances> u = DALBase.SelectByWhere <Chances>(sql);
kong <Chances> s = new kong <Chances>();
s.biao = u;
s.count = count;
return(s);
}
public kong <Activitys> seleActivitys(int index, int size, int id)
{
string sql = string.Format(@"select top {0} * from Activitys where ActID not in
(select top {1} ActID from Activitys) and cusid = {2}", size, (index - 1) * size, id);
int tiaoshu = DALBase.GetCount <Activitys>();
int count = tiaoshu % size == 0 ? tiaoshu / size : tiaoshu / size + 1;
List <Activitys> u = DALBase.SelectByWhere <Activitys>(sql);
kong <Activitys> s = new kong <Activitys>();
s.biao = u;
s.count = count;
return(s);
}
public kong <Role> seleRoles(int index, int size)
{
string sql = string.Format(@"select top {0} * from Role where id not in
(select top {1} id from Role)", size, (index - 1) * size);
int tiaoshu = DALBase.GetCount <Role>();
int count = tiaoshu % size == 0 ? tiaoshu / size : tiaoshu / size + 1;
List <Role> u = DALBase.SelectByWhere <Role>(sql);
kong <Role> s = new kong <Role>();
s.biao = u;
s.count = count;
return(s);
}
