public virtual tb_performance_model CreateModel(DataRow dr) { var o = new tb_performance_model(); // if (dr.Table.Columns.Contains("id")) { o.id = dr["id"].Toint(); } // if (dr.Table.Columns.Contains("nodeid")) { o.nodeid = dr["nodeid"].Toint(); } // if (dr.Table.Columns.Contains("taskid")) { o.taskid = dr["taskid"].Toint(); } // if (dr.Table.Columns.Contains("cpu")) { o.cpu = dr["cpu"].Todouble(); } // if (dr.Table.Columns.Contains("memory")) { o.memory = dr["memory"].Todouble(); } // if (dr.Table.Columns.Contains("installdirsize")) { o.installdirsize = dr["installdirsize"].Todouble(); } // if (dr.Table.Columns.Contains("lastupdatetime")) { o.lastupdatetime = dr["lastupdatetime"].ToDateTime(); } return(o); }
public int AddOrUpdate(DbConn PubConn, tb_performance_model model) { return(SqlHelper.Visit(ps => { ps.Add("@cpu", model.cpu); ps.Add("@memory", model.memory); ps.Add("@installdirsize", model.installdirsize); ps.Add("@taskid", model.taskid); ps.Add("@nodeid", model.nodeid); ps.Add("@lastupdatetime", model.lastupdatetime); ps.Add("@id", model.id); string updatecmd = "update tb_performance set cpu=@cpu,memory=@memory,installdirsize=@installdirsize,nodeid=@nodeid,lastupdatetime=@lastupdatetime where taskid=@taskid"; string insertcmd = @"insert into tb_performance(cpu,memory,installdirsize,taskid,nodeid,lastupdatetime) values(@cpu,@memory,@installdirsize,@taskid,@nodeid,@lastupdatetime)" ; if (PubConn.ExecuteSql(updatecmd, ps.ToParameters()) <= 0) { PubConn.ExecuteSql(insertcmd, ps.ToParameters()); } return 1; })); }
public virtual bool Add(DbConn PubConn, tb_performance_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { // new ProcedureParameter("@nodeid", model.nodeid), // new ProcedureParameter("@taskid", model.taskid), // new ProcedureParameter("@cpu", model.cpu), // new ProcedureParameter("@memory", model.memory), // new ProcedureParameter("@installdirsize", model.installdirsize), // new ProcedureParameter("@lastupdatetime", model.lastupdatetime) }; int rev = PubConn.ExecuteSql(@"insert into tb_performance(nodeid,taskid,cpu,memory,installdirsize,lastupdatetime) values(@nodeid,@taskid,@cpu,@memory,@installdirsize,@lastupdatetime)" , Par); return(rev == 1); }
public virtual bool Edit(DbConn PubConn, tb_performance_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { // new ProcedureParameter("@nodeid", model.nodeid), // new ProcedureParameter("@taskid", model.taskid), // new ProcedureParameter("@cpu", model.cpu), // new ProcedureParameter("@memory", model.memory), // new ProcedureParameter("@installdirsize", model.installdirsize), // new ProcedureParameter("@lastupdatetime", model.lastupdatetime) }; Par.Add(new ProcedureParameter("@id", model.id)); int rev = PubConn.ExecuteSql("update tb_performance set nodeid=@nodeid,taskid=@taskid,cpu=@cpu,memory=@memory,installdirsize=@installdirsize,lastupdatetime=@lastupdatetime where id=@id", Par); return(rev == 1); }