//修改处理结果
public static int UpdateCSResult(CustomServices c)
{
string sql = "update CustomServices set CSResult=@CSResult,CSState=4,CSSatisfy=@CSSatisfy where CSID=@CSID";
List<SqlParameter> list = new List<SqlParameter>() {
new SqlParameter("@CSResult",c.CSResult),
new SqlParameter("@CSSatisfy",c.CSSatisfy),
new SqlParameter("@CSID",c.CSID)
};
return DBHelp.ExecuteCUD(sql,list);
}
//创建一个服务
public static int Insert(CustomServices c)
{
string sql = "insert into CustomServices values(@STID,@CusID,@CSTitle,1,@CSDesc,@CSCreateID,getdate(),NULL,NULL,NULL,NULL,NULL,NULL)";
List<SqlParameter> list = new List<SqlParameter>() {
new SqlParameter("@STID",c.STID),
new SqlParameter("@CusID",c.CusID),
new SqlParameter("@CSTitle",c.CSTitle),
new SqlParameter("@CSDesc",c.CSDesc),
new SqlParameter("@CSCreateID",c.CSCreateID)
};
return DBHelp.ExecuteCUD(sql,list);
}
//创建一个服务
public static int Insert(CustomServices c)
{
return CustomServicesBLL.Insert(c);
}
public int UpdSer(Model.CustomServices service)
{
service.CSDueDate = DateTime.Now;
return(DalBase.Updata(service));
}
public int InsertSer(Model.CustomServices customser)
{
customser.CSState = 1;
customser.CSCreateDate = DateTime.Now;
return(DalBase.Insert(customser));
}
public int UpdResult(Model.CustomServices service)
{
service.CSState = 4;
return(DalBase.Updata(service));
}
public int UpdDeal(Model.CustomServices service)
{
service.CSState = 3;
service.CSDealDate = DateTime.Now;
return(DalBase.Updata(service));
}