protected void StructBind() { Tz888.BLL.Conn dal = new Conn(); DataTable dt = dal.GetList("OfferInfoTabVIW", "CompanyName,SubmitDate,AuditStatus,InfoID", "SubmitDate", 5, 1, 0, 1, "DelStatus=0 and AuditStatus=1 and UserName!='" + Page.User.Identity.Name.ToString() + "' "); StructList.DataSource = dt; StructList.DataBind(); Literal1.Text = "最新五条"; }
protected void StructBind(string ServiesBig) { if (!string.IsNullOrEmpty(ServiesBig)) { Tz888.BLL.Conn dal = new Conn(); DataTable dt = dal.GetList("OfferInfoTabVIW", "CompanyName,SubmitDate,AuditStatus,InfoID", "SubmitDate", 5, 1, 0, 1, "DelStatus=0 and AuditStatus=1 and UserName!='" + Page.User.Identity.Name.ToString() + "' and ServiesBID like '%" + ServiesBig.Trim() + "%' "); StructList.DataSource = dt; StructList.DataBind(); string str = Request.QueryString["Title"].ToString(); Literal1.Text = "与(" + str + ")匹配的"; } }
protected void StructBind(string name) { long PageSize = Convert.ToInt64(AspNetPager.PageSize); long CurrPage = Convert.ToInt64(AspNetPager.CurrentPageIndex); long TotalCount = 0; Tz888.BLL.Conn dal = new Tz888.BLL.Conn(); DataTable dt = dal.GetList("OfferInfoTabVIW", "InfoID", "InfoID,CompanyName,SubmitDate,AuditStatus,ServiesBID", "DelStatus=0 and UserName='******'", "SubmitDate desc ", ref CurrPage, PageSize, ref TotalCount); AspNetPager.RecordCount = Convert.ToInt32(TotalCount); lblCount.Text = TotalCount.ToString(); lblCurrPage.Text = CurrPage.ToString(); lblPageCount.Text = AspNetPager.PageCount.ToString(); StructList.DataSource = dt; StructList.DataBind(); }