public virtual bool Add(DbConn PubConn, DbModels.certcenterlog model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { new ProcedureParameter("@url", model.url), // new ProcedureParameter("@reqdata", model.reqdata), // new ProcedureParameter("@userid", model.userid), new ProcedureParameter("@username", model.username), // new ProcedureParameter("@reqtime", model.reqtime), // new ProcedureParameter("@ip", model.ip), // new ProcedureParameter("@opecontent", model.opecontent) }; int rev = PubConn.ExecuteSql(@"insert into certcenterlog(url,reqdata,userid,username,reqtime,ip,opecontent) values(@url,@reqdata,@userid,@username,@reqtime,@ip,@opecontent)" , Par); return(rev == 1); }
public virtual bool Edit(DbConn PubConn, DbModels.certcenterlog model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { new ProcedureParameter("@url", model.url), // new ProcedureParameter("@reqdata", model.reqdata), // new ProcedureParameter("@userid", model.userid), new ProcedureParameter("@username", model.username), // new ProcedureParameter("@reqtime", model.reqtime), // new ProcedureParameter("@ip", model.ip), // new ProcedureParameter("@opecontent", model.opecontent) }; Par.Add(new ProcedureParameter("@id", model.id)); int rev = PubConn.ExecuteSql("update certcenterlog set url=@url,reqdata=@reqdata,userid=@userid,username =@username,reqtime=@reqtime,ip=@ip,opecontent=@opecontent where id=@id", Par); return(rev == 1); }