/// <summary>
/// 查询功能
/// </summary>
/// <returns></returns>
public DataSet GetAllBook(Model.CustomServices b)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select * from CustomServices a
inner join Users b on a.CSDueID =b.UserID
inner join ServiceType c on a.STID=c.STID
inner join Customers d on a.CusID=d.CusID INNER JOIN Users b on a.CSCreateID = b.UserID where 1>0");
if (!string.IsNullOrEmpty(b.CusName))
{
strSql.AppendFormat(" and d.CusName like '%{0}%'", b.CusName);
}
if (b.STID > 0)
{
strSql.Append(" and a.STID = '" + b.STID + "'");
}
if (b.ChanDueMan > 0)
{
strSql.Append(" and d.CSCreateID = '" + b.CSCreateID + "'");
}
return(DBUtility.DbHelperSQL.Query(strSql.ToString()));
}
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 AddOneBook(Model.CustomServices book)
{
BLL.CustomServices b = new BLL.CustomServices();
return(b.Add(book));
}
/// <summary>
/// 查询功能
/// </summary>
/// <returns></returns>
public List <Model.CustomServices> GetAllBook(Model.CustomServices b)
{
DataSet ds = dal.GetAllBook(b);
return(DataTableToList(ds.Tables[0]));
}
