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