public int GetCountThree() { StringBuilder str = new StringBuilder(); str.Append(" AND CSState=3"); BLL.CustomServices bookinfoBLL = new BLL.CustomServices(); return(bookinfoBLL.GetRecordCountTwo("1>0" + str.ToString())); }
public int GetCount(string CusName, int STID) { StringBuilder str = new StringBuilder(); if (!string.IsNullOrEmpty(CusName)) { str.AppendFormat(" and d.CusName like '%{0}%' ", CusName); } if (STID > 0) { str.AppendFormat(" and a.STID ={0} ", STID); } str.Append("CSState=1"); BLL.CustomServices bookinfoBLL = new BLL.CustomServices(); return(bookinfoBLL.GetRecordCountTwo(" 1 > 0" + str.ToString())); }