public List <Model.CustomServices> SelectMsgByCSID(int cusid)
{
StringBuilder str = new StringBuilder();
str.Append(" and a.CSID=" + cusid);
BLL.CustomServices bllbookinfo = new BLL.CustomServices();
List <Model.CustomServices> list = bllbookinfo.GetModelList(str.ToString(), str.ToString(), 1, 1);
return(list);
}
public List <Model.CustomServices> SlectAllMsgTwo(int size, int pageindex)
{
StringBuilder str = new StringBuilder();
str.Append("and CSState=2");
BLL.Customers bookinfoBLL = new BLL.Customers();
BLL.CustomServices bllbookinfo = new BLL.CustomServices();
List <Model.CustomServices> list = bllbookinfo.GetModelList(str.ToString(), str.ToString(), size, pageindex);
return(list);
}
public List <Model.CustomServices> SlectAllMsg(string CusName, int STID, int size, int pageindex)
{
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(" and CSState=1");
BLL.Customers bookinfoBLL = new BLL.Customers();
BLL.CustomServices bllbookinfo = new BLL.CustomServices();
List <Model.CustomServices> list = bllbookinfo.GetModelList(str.ToString(), str.ToString(), size, pageindex);
return(list);
}
