public tb_command_model_Ex GetOneCommand(DbConn PubConn, int id)
{
return(SqlHelper.Visit(ps =>
{
ps.Add("id", id);
string sql = "select C.*,T.taskname from tb_command C LEFT JOIN tb_task T on C.taskid=T.id where C.id=@id";
DataSet ds = new DataSet();
PubConn.SqlToDataSet(ds, sql, ps.ToParameters());
tb_command_model_Ex model = CreateModelEX(ds.Tables[0].Rows[0]);
return model;
}));
}
public virtual tb_command_model_Ex CreateModelEX(DataRow dr)
{
var o = new tb_command_model_Ex();
//
if (dr.Table.Columns.Contains("id"))
{
o.id = dr["id"].Toint();
}
//
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();
}
//
if (dr.Table.Columns.Contains("taskid"))
{
o.taskid = dr["taskid"].Toint();
}
//
if (dr.Table.Columns.Contains("nodeid"))
{
o.nodeid = dr["nodeid"].Toint();
}
//
if (dr.Table.Columns.Contains("commandcreatetime"))
{
o.commandcreatetime = dr["commandcreatetime"].ToDateTime();
}
//
if (dr.Table.Columns.Contains("taskname"))
{
o.taskname = dr["taskname"].ToString();
}
if (dr.Table.Columns.Contains("nodename"))
{
o.nodename = dr["nodename"].ToString();
}
return(o);
}
public ActionResult Update(int id)
{
return(this.Visit(Core.EnumUserRole.Admin, () =>
{
using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString))
{
PubConn.Open();
tb_command_dal dal = new tb_command_dal();
tb_command_model_Ex model = dal.GetOneCommand(PubConn, id);
List <tb_node_model> Node = new tb_node_dal().GetListAll(PubConn);
ViewBag.Node = Node;
return View(model);
}
}));
}
public List <tb_command_model_Ex> GetList(DbConn PubConn, int commandstate, int taskid, int nodeid, int pagesize, int pageindex, out int count)
{
int _count = 0;
List <tb_command_model_Ex> Model = new List <tb_command_model_Ex>();
DataSet dsList = SqlHelper.Visit <DataSet>(ps =>
{
string sqlwhere = "";
//string sql = "select ROW_NUMBER() over(order by C.id desc) as rownum,C.*,T.taskname,n.nodename from tb_command C LEFT JOIN tb_task T on C.taskid=T.id left join tb_node n on C.nodeid=n.id where 1=1 ";
string sql = "select C.ID as rownum,C.*,T.taskname,n.nodename from tb_command C LEFT JOIN tb_task T on C.taskid=T.id left join tb_node n on C.nodeid=n.id where 1=1 ";
if (taskid != -1)
{
ps.Add("taskid", taskid);
sqlwhere = " and C.taskid=@taskid ";
}
if (nodeid != -1)
{
ps.Add("nodeid", nodeid);
sqlwhere = " and C.nodeid=@nodeid ";
}
if (commandstate != -1)
{
ps.Add("commandstate", commandstate);
sqlwhere = " and C.commandstate=@commandstate ";
}
_count = Convert.ToInt32(PubConn.ExecuteScalar("select count(1) from tb_command C where 1=1 " + sqlwhere, ps.ToParameters()));
DataSet ds = new DataSet();
string sqlSel = "select * from (" + sql + sqlwhere + ") A order by rownum desc limit " + ((pageindex - 1) * pagesize) + "," + pagesize;
PubConn.SqlToDataSet(ds, sqlSel, ps.ToParameters());
return(ds);
});
foreach (DataRow dr in dsList.Tables[0].Rows)
{
tb_command_model_Ex n = CreateModelEX(dr);
Model.Add(n);
}
count = _count;
return(Model);
}
