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();
}
}