Ejemplo n.º 1
0
    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 + ")匹配的";
    }
Ejemplo n.º 2
0
    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 = "最新五条";
    }
Ejemplo n.º 3
0
    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();
      }
     
  }