private void MyJobList() { BLL.JobBLL bll = new BLL.JobBLL(); int CurrentPage = ReInt("CurrentPage"); DataSet ds = bll.GetJobPageList(" CreateUser='******' and Invalid=0 order by createTime desc ", CurrentPage, 20); RePage(ds); }
//获得职位列表 private void GetJobList() { decimal JobTypeId = ReDecimal("JobTypeId", 0); // decimal WorkYearId = ReDecimal("WorkYearId", 0); //工作年限id decimal JobPayId = ReDecimal("JobPayId", 0); //薪酬待遇ID decimal TownId = ReDecimal("TownId", 0); //城镇ID decimal SchoolExpId = ReDecimal("SchoolExpId", 0); decimal ParentJobTypeId = ReDecimal("ParentJobTypeId", 0); decimal MerchantId = ReDecimal("MerchantId", 0); string inputStr = ReStr("inputStr", ""); int currentPage = ReInt("currentPage"); int PageInt = ReInt("PageInt", 40); bool Invalid = ReBool("Invalid", false); StringBuilder s = new StringBuilder(); s.Append(" 1=1 "); s.Append(" and Invalid='" + Invalid.ToString() + "' "); if (MerchantId == 0) { } else { s.Append(" and MerchantId='" + MerchantId + "' "); } if (inputStr.Trim() != "") { s.Append(" and JobtTitle like '%" + inputStr + "%' or JobMemo like '%" + inputStr + "%' "); } if (JobTypeId != 0) { //如果选择了子类别 s.Append(" and JobTypeId='" + JobTypeId + "' "); } else { //如果没有选择子类别 if (ParentJobTypeId == 0) { } else { //选择的首级类别,则查询首级类别即可 s.Append(" and ParentJobTypeId='" + ParentJobTypeId + "' "); } } if (WorkYearId != 0) { s.Append(" and WorkYearId='" + WorkYearId + "' "); } if (JobPayId != 0) { //选择的子类别 s.Append(" and JobPayId='" + JobPayId + "' "); } if (SchoolExpId != 0) { s.Append(" and SchoolExpId ='" + SchoolExpId + "' "); } if (TownId != 0) { s.Append(" and TownId='" + TownId + "' "); } s.Append(" order by RecommendLv desc, CreateTime desc "); BLL.JobBLL bll = new BLL.JobBLL(); DataSet ds = bll.GetJobPageList(s.ToString(), currentPage, PageInt); RePage(ds); }