/// <summary> /// 查询应聘公司列表 /// </summary> /// <param name="searchInfo"></param> /// <returns></returns> public DataTable CompanieQry(CompanieSearchInfo searchInfo) { IList<SqlParameter> arrParameter = new List<SqlParameter>(); //设置参数 arrParameter.Add(new SqlParameter("@name", searchInfo.Name)); arrParameter.Add(new SqlParameter("@user_to_state", searchInfo.UserToState)); arrParameter.Add(new SqlParameter("@page_index", searchInfo.PageIndex)); arrParameter.Add(new SqlParameter("@page_size", searchInfo.PageSize)); arrParameter.Add(new SqlParameter { ParameterName = "@rows_count", Direction = ParameterDirection.Output, SqlDbType=SqlDbType.Int }); DataTable dtCompanieQry = SqlHelper.GetTableProducts("companies_qry_sp", arrParameter.ToArray())[0]; searchInfo.RowsCount = Convert.ToInt32(arrParameter.First(p => p.ParameterName == "@rows_count").SqlValue.ToString()); return dtCompanieQry; }
/// <summary> /// 查询应聘公司列表 /// </summary> /// <param name="searchInfo"></param> /// <returns></returns> public IList<Company> CompanieQry(CompanieSearchInfo searchInfo) { DataTable dtCompanieQry = dal.CompanieQry(searchInfo); IList<Company> list = new List<Company>(); foreach (DataRow dr in dtCompanieQry.Rows) { list.Add(new Company { Id = Functions.ToConvert<int>(dr["Id"]), Name = Functions.ToConvert<string>(dr["Name"]), Address = Functions.ToConvert<string>(dr["Address"]), UserToState = (UserToState)Enum.Parse(typeof(UserToState), Functions.ToConvert<string>(dr["UserToState"]), true), WorkToDate = Functions.ToConvert<string>(dr["WorkToDate"]), CreateDate = Functions.ToConvert<DateTime>(dr["CreateDate"]) }); } return list; }
public DataTable CompanieQry(CompanieSearchInfo searchInfo) { throw new NotImplementedException(); }
/// <summary> /// 分页查询 /// </summary> /// <param name="PageIndex">当前页</param> /// <param name="Name">公司</param> /// <param name="createdateFlag">按日期排序</param> /// <returns></returns> public ActionResult Index(int PageIndex = 1, string Name = "",int UserToState=-1) { CompanieSearchInfo searchInfo = new CompanieSearchInfo { Name = Name, UserToState=UserToState, PageIndex = PageIndex, PageSize = MyBlogConfiguration.PagerSize }; IList<Company> ltCompany = Biz.CompanieQry(searchInfo); if (ltCompany != null) { ViewBag.VBCompanieSearchInfo = searchInfo; return View(ltCompany); } return HttpNotFound(); }