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