protected void ServiesBind(string Servies) { string len = ""; string[] str = Servies.Split(','); for (int i = 0; i < str.Length; i++) { if (i == 0) { len = "(ServiesBID like '%" + str[i].Trim() + "%'"; } else if (!string.IsNullOrEmpty(str[i])) { if (len != "") { len += "or ServiesBID like '%" + str[i].Trim() + "%'"; } else { len = "(ServiesBID like '%" + str[i].Trim() + "%'"; } } } len += ")"; Tz888.BLL.Conn dal = new Tz888.BLL.Conn(); DataTable dt = dal.GetList("ReleaseTabViw", "InfoID,ServiesBID,ServiesMID,Title,CreateDate,Price,AuditStatus,AuditStatus", "CreateDate ", 5, 1, 0, 1, "DelStatus=0 and AuditStatus=1 and UserName!= '" + Page.User.Identity.Name.ToString() + "' and " + len + " "); ServiesList.DataSource = dt; ServiesList.DataBind(); string s = Request.QueryString["company"].ToString(); Literal1.Text = "与(" + s + ")匹配的"; }
protected void ServiesBind() { Tz888.BLL.Conn dal = new Tz888.BLL.Conn(); DataTable dt = dal.GetList("ReleaseTabViw", "InfoID,ServiesBID,ServiesMID,Title,CreateDate,Price,AuditStatus,AuditStatus", "CreateDate ", 5, 1, 0, 1, "DelStatus=0 and AuditStatus=1 and UserName!='" + Page.User.Identity.Name.ToString() + "'"); ServiesList.DataSource = dt; ServiesList.DataBind(); Literal1.Text = "最新五条"; }
protected void ServiesBind(string Servies) { Tz888.BLL.Conn dal = new Tz888.BLL.Conn(); DataTable dt = dal.GetList("ReleaseTabViw", "InfoID,ServiesBID,ServiesMID,Title,CreateDate,Price,AuditStatus,AuditStatus", "CreateDate ", 5, 1, 0, 1, "AuditStatus=1 and UserName!='" + Page.User.Identity.Name.ToString() + "' and ServiesBID like '%" + Servies + "%'"); ServiesList.DataSource = dt; //Tz888.BLL.Union dal = new Tz888.BLL.Union(); //DataTable dt = dal.GetList("ServiesBID,ServiesMID,CompanyName,CreateDate,Price,AuditStatus,BID,AuditStatus", "BusinesProcessTab", "where AuditStatus=1 and ServiesBID like '%" + Servies + "%' order by CreateDate desc", 5); ServiesList.DataSource = dt; ServiesList.DataBind(); Literal1.Text = "与'" + getsetServiesBigName(Servies) + "'匹配的"; }
protected void ServiesBind(string name) { long PageSize = Convert.ToInt64(AspNetPager.PageSize); long CurrPage = Convert.ToInt64(AspNetPager.CurrentPageIndex); long TotalCount = 0; Tz888.BLL.Conn dal = new Conn(); DataTable dt = dal.GetList("ReleaseTabViw", "InfoID", "InfoID,Title,CreateDate,AuditStatus,ServiesBID", " DelStatus=0 and UserName='******'", "CreateDate desc ", ref CurrPage, PageSize, ref TotalCount); // DataTable dt = dal.GetList("BusinesProcessTab", "BID", "BID,Title,CreateDate,AuditStatus,ServiesBID", "AuditStatus=1" , "CreateDate desc ", ref CurrPage, PageSize, ref TotalCount); if (dt != null) { AspNetPager.RecordCount = Convert.ToInt32(TotalCount); lblCount.Text = TotalCount.ToString(); lblCurrPage.Text = CurrPage.ToString(); lblPageCount.Text = AspNetPager.PageCount.ToString(); ServiesList.DataSource = dt; ServiesList.DataBind(); } }