public virtual bool Add(DbConn PubConn, tb_consumer_client_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { //客户端(消费者client,相同业务消费者注册必须一致) new ProcedureParameter("@client", model.client), //当前消费者创建时间(以当前库时间为准) new ProcedureParameter("@createtime", model.createtime) }; int rev = PubConn.ExecuteSql(@"insert into tb_consumer_client(client,createtime) values(@client,@createtime)" , Par); return(rev == 1); }
public virtual bool Edit(DbConn PubConn, tb_consumer_client_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { //客户端(消费者client,相同业务消费者注册必须一致) new ProcedureParameter("@client", model.client), //当前消费者创建时间(以当前库时间为准) new ProcedureParameter("@createtime", model.createtime) }; Par.Add(new ProcedureParameter("@id", model.id)); int rev = PubConn.ExecuteSql("update tb_consumer_client set client=@client,createtime=@createtime where id=@id", Par); return(rev == 1); }
public virtual tb_consumer_client_model CreateModel(DataRow dr) { var o = new tb_consumer_client_model(); // if (dr.Table.Columns.Contains("id")) { o.id = dr["id"].Toint(); } //客户端(消费者client,相同业务消费者注册必须一致) if (dr.Table.Columns.Contains("client")) { o.client = dr["client"].Tostring(); } //当前消费者创建时间(以当前库时间为准) if (dr.Table.Columns.Contains("createtime")) { o.createtime = dr["createtime"].ToDateTime(); } return(o); }