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 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 int UpdateCuMan(int CSID, int CSDueID)
{
bool c = new BLL.CustomServices().UpdateOne(CSID, CSDueID);
if (c)
{
return(1);
}
else
{
return(0);
}
}
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 int UPdateStateFoure(Model.CustomServices book)
{
BLL.CustomServices b = new BLL.CustomServices();
bool c = b.
UpdateFoure(book);
if (c)
{
return(1);
}
else
{
return(0);
}
}
public int AddResult(Model.CustomServices book)
{
book.CSDealDate = DateTime.Now;
BLL.CustomServices b = new BLL.CustomServices();
bool c = b.
UpdateTwo(book);
if (c)
{
return(1);
}
else
{
return(0);
}
}
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()));
}
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);
}
public int AddOneBook(Model.CustomServices book)
{
BLL.CustomServices b = new BLL.CustomServices();
return(b.Add(book));
}
