//修改处理结果 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)); }