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);
}
