/// <summary>
/// 执行命令
/// </summary>
/// <param name="commandInfo"></param>
public static void Execute(tb_command_model commandInfo)
{
string namespacestr = typeof(BaseCommand).Namespace;
var obj = Assembly.GetAssembly(typeof(BaseCommand)).CreateInstance(namespacestr + "." + commandInfo.commandname.ToString() + "Command", true);
if (obj != null && obj is BaseCommand)
{
var command = (obj as BaseCommand);
command.CommandInfo = commandInfo;
command.Execute();
}
}
public ActionResult Add(tb_command_model model)
{
return this.Visit(Core.EnumUserRole.Admin, () =>
{
tb_command_dal dal = new tb_command_dal();
using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString))
{
PubConn.Open();
model.commandcreatetime = DateTime.Now;
dal.Add(PubConn, model);
}
return RedirectToAction("index");
});
}
public virtual bool Edit(DbConn PubConn, tb_command_model model)
{
List<ProcedureParameter> Par = new List<ProcedureParameter>()
{
//命令json
new ProcedureParameter("@command", model.command),
//命令名，参考代码枚举
new ProcedureParameter("@commandname", model.commandname),
//命令执行状态，参考代码枚举
new ProcedureParameter("@commandstate", model.commandstate),
//任务id
new ProcedureParameter("@taskid", model.taskid),
//节点id
new ProcedureParameter("@nodeid", model.nodeid),
//命令创建时间
new ProcedureParameter("@commandcreatetime", model.commandcreatetime)
};
Par.Add(new ProcedureParameter("@id", model.id));
int rev = PubConn.ExecuteSql("update tb_command set command=@command,commandname=@commandname,commandstate=@commandstate,taskid=@taskid,nodeid=@nodeid,commandcreatetime=@commandcreatetime where id=@id", Par);
return rev == 1;
}
public virtual bool Add(DbConn PubConn, tb_command_model model)
{
List<ProcedureParameter> Par = new List<ProcedureParameter>()
{
//命令json
new ProcedureParameter("@command", model.command),
//命令名，参考代码枚举
new ProcedureParameter("@commandname", model.commandname),
//命令执行状态，参考代码枚举
new ProcedureParameter("@commandstate", model.commandstate),
//任务id
new ProcedureParameter("@taskid", model.taskid),
//节点id
new ProcedureParameter("@nodeid", model.nodeid),
//命令创建时间
new ProcedureParameter("@commandcreatetime", model.commandcreatetime)
};
int rev = PubConn.ExecuteSql(@"insert into tb_command(command,commandname,commandstate,taskid,nodeid,commandcreatetime)
values(@command,@commandname,@commandstate,@taskid,@nodeid,@commandcreatetime)", Par);
return rev == 1;
}
public int UpdateCommand(DbConn PubConn, tb_command_model model)
{
return SqlHelper.Visit(ps =>
{
ps.Add("command", model.command);
ps.Add("commandstate", model.commandstate);
ps.Add("nodeid", model.nodeid);
ps.Add("commandname", model.commandname);
ps.Add("id", model.id);
string sql = "update tb_command set command=@command,commandstate=@commandstate,commandname=@commandname,nodeid=@nodeid where id=@id";
return PubConn.ExecuteSql(sql, ps.ToParameters());
});
}
public virtual tb_command_model CreateModel(DataRow dr)
{
var o = new tb_command_model();
//
if(dr.Table.Columns.Contains("id"))
{
o.id = dr["id"].Toint();
}
//命令json
if(dr.Table.Columns.Contains("command"))
{
o.command = dr["command"].Tostring();
}
//命令名，参考代码枚举
if(dr.Table.Columns.Contains("commandname"))
{
o.commandname = dr["commandname"].Tostring();
}
//命令执行状态，参考代码枚举
if(dr.Table.Columns.Contains("commandstate"))
{
o.commandstate = dr["commandstate"].ToByte();
}
//任务id
if(dr.Table.Columns.Contains("taskid"))
{
o.taskid = dr["taskid"].Toint();
}
//节点id
if(dr.Table.Columns.Contains("nodeid"))
{
o.nodeid = dr["nodeid"].Toint();
}
//命令创建时间
if(dr.Table.Columns.Contains("commandcreatetime"))
{
o.commandcreatetime = dr["commandcreatetime"].ToDateTime();
}
return o;
}
