public virtual bool Add2(DbConn PubConn, tb_producter_model model)
{
return SqlHelper.Visit((ps) =>
{
List<ProcedureParameter> Par = new List<ProcedureParameter>()
{
//��������ʱid(�����������Ψһ,Guidתlong)
new ProcedureParameter("@tempid", model.tempid),
//����������
new ProcedureParameter("@productername", model.productername),
//ip��ַ
new ProcedureParameter("@ip", model.ip),
//����id
new ProcedureParameter("@mqpathid", model.mqpathid),
////�������������ʱ��
//new ProcedureParameter("@lastheartbeat", model.lastheartbeat),
////�����ߴ���ʱ��
//new ProcedureParameter("@createtime", model.createtime)
};
int rev = PubConn.ExecuteSql(@"insert into tb_producter(tempid,productername,ip,mqpathid,lastheartbeat,createtime)
values(@tempid,@productername,@ip,@mqpathid,getdate(),getdate())", Par);
return rev == 1;
});
}
public virtual tb_producter_model CreateModel(DataRow dr)
{
var o = new tb_producter_model();
//
if(dr.Table.Columns.Contains("id"))
{
o.id = dr["id"].Toint();
}
//��������ʱid(�����������Ψһ,Guidתlong)
if(dr.Table.Columns.Contains("tempid"))
{
o.tempid = dr["tempid"].Tolong();
}
//����������
if(dr.Table.Columns.Contains("productername"))
{
o.productername = dr["productername"].Tostring();
}
//ip��ַ
if(dr.Table.Columns.Contains("ip"))
{
o.ip = dr["ip"].Tostring();
}
//����id
if(dr.Table.Columns.Contains("mqpathid"))
{
o.mqpathid = dr["mqpathid"].Toint();
}
//�������������ʱ��
if(dr.Table.Columns.Contains("lastheartbeat"))
{
o.lastheartbeat = dr["lastheartbeat"].ToDateTime();
}
//�����ߴ���ʱ��
if(dr.Table.Columns.Contains("createtime"))
{
o.createtime = dr["createtime"].ToDateTime();
}
return o;
}
