public virtual bool Add(DbConn PubConn, tb_timewatchlog_api_model model)
{
List <ProcedureParameter> Par = new List <ProcedureParameter>()
{
//
new ProcedureParameter("@sqlservercreatetime", model.sqlservercreatetime),
//
new ProcedureParameter("@logcreatetime", model.logcreatetime),
//
new ProcedureParameter("@time", model.time),
//
new ProcedureParameter("@projectname", model.projectname),
//
new ProcedureParameter("@url", model.url),
//
new ProcedureParameter("@msg", model.msg),
//
new ProcedureParameter("@fromip", model.fromip),
//
new ProcedureParameter("@tag", model.tag)
};
int rev = PubConn.ExecuteSql(@"insert into tb_timewatchlog_api(sqlservercreatetime,logcreatetime,time,projectname,url,msg,fromip,tag)
values(@sqlservercreatetime,@logcreatetime,@time,@projectname,@url,@msg,@fromip,@tag)" , Par);
return(rev == 1);
}
public virtual bool Edit(DbConn PubConn, tb_timewatchlog_api_model model)
{
List <ProcedureParameter> Par = new List <ProcedureParameter>()
{
//
new ProcedureParameter("@sqlservercreatetime", model.sqlservercreatetime),
//
new ProcedureParameter("@logcreatetime", model.logcreatetime),
//
new ProcedureParameter("@time", model.time),
//
new ProcedureParameter("@projectname", model.projectname),
//
new ProcedureParameter("@url", model.url),
//
new ProcedureParameter("@msg", model.msg),
//
new ProcedureParameter("@fromip", model.fromip),
//
new ProcedureParameter("@tag", model.tag)
};
Par.Add(new ProcedureParameter("@id", model.id));
int rev = PubConn.ExecuteSql("update tb_timewatchlog_api set sqlservercreatetime=@sqlservercreatetime,logcreatetime=@logcreatetime,time=@time,projectname=@projectname,url=@url,msg=@msg,fromip=@fromip,tag=@tag where id=@id", Par);
return(rev == 1);
}
public virtual tb_timewatchlog_api_model CreateModel(DataRow dr)
{
var o = new tb_timewatchlog_api_model();
//
if (dr.Table.Columns.Contains("id"))
{
o.id = dr["id"].Toint();
}
//
if (dr.Table.Columns.Contains("sqlservercreatetime"))
{
o.sqlservercreatetime = dr["sqlservercreatetime"].ToDateTime();
}
//
if (dr.Table.Columns.Contains("logcreatetime"))
{
o.logcreatetime = dr["logcreatetime"].ToDateTime();
}
//
if (dr.Table.Columns.Contains("time"))
{
o.time = dr["time"].Todouble();
}
//
if (dr.Table.Columns.Contains("projectname"))
{
o.projectname = dr["projectname"].Tostring();
}
//
if (dr.Table.Columns.Contains("url"))
{
o.url = dr["url"].Tostring();
}
//
if (dr.Table.Columns.Contains("msg"))
{
o.msg = dr["msg"].Tostring();
}
//
if (dr.Table.Columns.Contains("fromip"))
{
o.fromip = dr["fromip"].Tostring();
}
//
if (dr.Table.Columns.Contains("tag"))
{
o.tag = dr["tag"].Tostring();
}
return(o);
}