public virtual bool Edit(DbConn PubConn, tb_task_model model)
{
List<ProcedureParameter> Par = new List<ProcedureParameter>()
{
//
new ProcedureParameter("@taskname", model.taskname),
//
new ProcedureParameter("@categoryid", model.categoryid),
//
new ProcedureParameter("@nodeid", model.nodeid),
//
new ProcedureParameter("@taskcreatetime", model.taskcreatetime),
//
new ProcedureParameter("@taskupdatetime", model.taskupdatetime),
//
new ProcedureParameter("@tasklaststarttime", model.tasklaststarttime),
//
new ProcedureParameter("@tasklastendtime", model.tasklastendtime),
//
new ProcedureParameter("@tasklasterrortime", model.tasklasterrortime),
//
new ProcedureParameter("@taskerrorcount", model.taskerrorcount),
//
new ProcedureParameter("@taskruncount", model.taskruncount),
//
new ProcedureParameter("@taskcreateuserid", model.taskcreateuserid),
//
new ProcedureParameter("@taskstate", model.taskstate),
//
new ProcedureParameter("@taskversion", model.taskversion),
//
new ProcedureParameter("@taskappconfigjson", model.taskappconfigjson),
//
new ProcedureParameter("@taskcron", model.taskcron),
//
new ProcedureParameter("@taskmainclassnamespace", model.taskmainclassnamespace),
//
new ProcedureParameter("@taskremark", model.taskremark)
};
Par.Add(new ProcedureParameter("@id", model.id));
int rev = PubConn.ExecuteSql("update tb_task set taskname=@taskname,categoryid=@categoryid,nodeid=@nodeid,taskcreatetime=@taskcreatetime,taskupdatetime=@taskupdatetime,tasklaststarttime=@tasklaststarttime,tasklastendtime=@tasklastendtime,tasklasterrortime=@tasklasterrortime,taskerrorcount=@taskerrorcount,taskruncount=@taskruncount,taskcreateuserid=@taskcreateuserid,taskstate=@taskstate,taskversion=@taskversion,taskappconfigjson=@taskappconfigjson,taskcron=@taskcron,taskmainclassnamespace=@taskmainclassnamespace,taskremark=@taskremark where id=@id", Par);
return rev == 1;
}
public virtual bool Add(DbConn PubConn, tb_task_model model)
{
List<ProcedureParameter> Par = new List<ProcedureParameter>()
{
//
new ProcedureParameter("@taskname", model.taskname),
//
new ProcedureParameter("@categoryid", model.categoryid),
//
new ProcedureParameter("@nodeid", model.nodeid),
//
new ProcedureParameter("@taskcreatetime", model.taskcreatetime),
//
new ProcedureParameter("@taskupdatetime", model.taskupdatetime),
//
new ProcedureParameter("@tasklaststarttime", model.tasklaststarttime),
//
new ProcedureParameter("@tasklastendtime", model.tasklastendtime),
//
new ProcedureParameter("@tasklasterrortime", model.tasklasterrortime),
//
new ProcedureParameter("@taskerrorcount", model.taskerrorcount),
//
new ProcedureParameter("@taskruncount", model.taskruncount),
//
new ProcedureParameter("@taskcreateuserid", model.taskcreateuserid),
//
new ProcedureParameter("@taskstate", model.taskstate),
//
new ProcedureParameter("@taskversion", model.taskversion),
//
new ProcedureParameter("@taskappconfigjson", model.taskappconfigjson),
//
new ProcedureParameter("@taskcron", model.taskcron),
//
new ProcedureParameter("@taskmainclassnamespace", model.taskmainclassnamespace),
//
new ProcedureParameter("@taskremark", model.taskremark)
};
int rev = PubConn.ExecuteSql(@"insert into tb_task(taskname,categoryid,nodeid,taskcreatetime,taskupdatetime,tasklaststarttime,tasklastendtime,tasklasterrortime,taskerrorcount,taskruncount,taskcreateuserid,taskstate,taskversion,taskappconfigjson,taskcron,taskmainclassnamespace,taskremark)
values(@taskname,@categoryid,@nodeid,@taskcreatetime,@taskupdatetime,@tasklaststarttime,@tasklastendtime,@tasklasterrortime,@taskerrorcount,@taskruncount,@taskcreateuserid,@taskstate,@taskversion,@taskappconfigjson,@taskcron,@taskmainclassnamespace,@taskremark)", Par);
return rev == 1;
}
public virtual tb_task_model CreateModel(DataRow dr)
{
var o = new tb_task_model();
//
if(dr.Table.Columns.Contains("id"))
{
o.id = dr["id"].Toint();
}
//
if(dr.Table.Columns.Contains("taskname"))
{
o.taskname = dr["taskname"].Tostring();
}
//
if(dr.Table.Columns.Contains("categoryid"))
{
o.categoryid = dr["categoryid"].Toint();
}
//
if(dr.Table.Columns.Contains("nodeid"))
{
o.nodeid = dr["nodeid"].Toint();
}
//
if(dr.Table.Columns.Contains("taskcreatetime"))
{
o.taskcreatetime = dr["taskcreatetime"].ToDateTime();
}
//
if(dr.Table.Columns.Contains("taskupdatetime"))
{
o.taskupdatetime = dr["taskupdatetime"].ToDateTime();
}
//
if(dr.Table.Columns.Contains("tasklaststarttime"))
{
o.tasklaststarttime = dr["tasklaststarttime"].ToDateTime();
}
//
if(dr.Table.Columns.Contains("tasklastendtime"))
{
o.tasklastendtime = dr["tasklastendtime"].ToDateTime();
}
//
if(dr.Table.Columns.Contains("tasklasterrortime"))
{
o.tasklasterrortime = dr["tasklasterrortime"].ToDateTime();
}
//
if(dr.Table.Columns.Contains("taskerrorcount"))
{
o.taskerrorcount = dr["taskerrorcount"].Toint();
}
//
if(dr.Table.Columns.Contains("taskruncount"))
{
o.taskruncount = dr["taskruncount"].Toint();
}
//
if(dr.Table.Columns.Contains("taskcreateuserid"))
{
o.taskcreateuserid = dr["taskcreateuserid"].Toint();
}
//
if(dr.Table.Columns.Contains("taskstate"))
{
o.taskstate = dr["taskstate"].ToByte();
}
//
if(dr.Table.Columns.Contains("taskversion"))
{
o.taskversion = dr["taskversion"].Toint();
}
//
if(dr.Table.Columns.Contains("taskappconfigjson"))
{
o.taskappconfigjson = dr["taskappconfigjson"].Tostring();
}
//
if(dr.Table.Columns.Contains("taskcron"))
{
o.taskcron = dr["taskcron"].Tostring();
}
//
if(dr.Table.Columns.Contains("taskmainclassnamespace"))
{
o.taskmainclassnamespace = dr["taskmainclassnamespace"].Tostring();
}
//
if (dr.Table.Columns.Contains("taskmainclassdllfilename"))
{
o.taskmainclassdllfilename = dr["taskmainclassdllfilename"].ToString();
}
//
if(dr.Table.Columns.Contains("taskremark"))
{
o.taskremark = dr["taskremark"].Tostring();
}
return o;
}
public int UpdateTask(DbConn PubConn, tb_task_model model)
{
return SqlHelper.Visit<int>(ps =>
{
ps.Add("@id", model.id);
ps.Add("@taskname", model.taskname);
ps.Add("@categoryid", model.categoryid);
ps.Add("@nodeid", model.nodeid);
ps.Add("@taskupdatetime", model.taskupdatetime);
ps.Add("@taskcreateuserid", model.taskcreateuserid);
ps.Add("@taskappconfigjson", model.taskappconfigjson.NullToEmpty());
ps.Add("@taskcron", model.taskcron);
ps.Add("@taskmainclassnamespace", model.taskmainclassnamespace);
ps.Add("@taskremark", model.taskremark);
ps.Add("@taskmainclassdllfilename", model.taskmainclassdllfilename);
ps.Add("@taskversion", model.taskversion);
string sql = "Update tb_task Set taskname=@taskname,categoryid=@categoryid,nodeid=@nodeid,taskupdatetime=@taskupdatetime,";
sql += "taskappconfigjson=@taskappconfigjson,taskcron=@taskcron,taskcreateuserid=@taskcreateuserid,";
sql += "taskmainclassnamespace=@taskmainclassnamespace,taskremark=@taskremark,taskmainclassdllfilename=@taskmainclassdllfilename,taskversion=@taskversion";
sql += " where id=@id";
int i = PubConn.ExecuteSql(sql, ps.ToParameters());
return i;
});
}
public int AddTask(DbConn PubConn, tb_task_model model)
{
return SqlHelper.Visit<int>(ps =>
{
ps.Add("@taskname", model.taskname);
ps.Add("@categoryid", model.categoryid);
ps.Add("@nodeid", model.nodeid);
ps.Add("@taskcreatetime", model.taskcreatetime);
ps.Add("@taskupdatetime", model.taskcreatetime);
ps.Add("@taskerrorcount", 0);
ps.Add("@taskruncount", 0);
ps.Add("@taskcreateuserid", model.taskcreateuserid);
ps.Add("@taskstate",0);
ps.Add("@taskversion", 1);
ps.Add("@taskappconfigjson", model.taskappconfigjson.NullToEmpty());
ps.Add("@taskcron", model.taskcron);
ps.Add("@taskmainclassnamespace", model.taskmainclassnamespace);
ps.Add("@taskremark", model.taskremark);
ps.Add("@taskmainclassdllfilename", model.taskmainclassdllfilename);
int rev = Convert.ToInt32(PubConn.ExecuteScalar(@"insert into tb_task(taskname,categoryid,nodeid,taskcreatetime,taskruncount,taskcreateuserid,taskstate,taskversion,taskappconfigjson,taskcron,taskmainclassnamespace,taskremark,taskmainclassdllfilename)
values(@taskname,@categoryid,@nodeid,@taskcreatetime,@taskruncount,@taskcreateuserid,@taskstate,@taskversion,@taskappconfigjson,@taskcron,@taskmainclassnamespace,@taskremark,@taskmainclassdllfilename) select @@IDENTITY", ps.ToParameters()));
return rev;
});
}
