public virtual tb_tempdata_model CreateModel(DataRow dr)
{
var o = new tb_tempdata_model();
//
if (dr.Table.Columns.Contains("id"))
{
o.id = dr["id"].Toint();
}
//
if (dr.Table.Columns.Contains("taskid"))
{
o.taskid = dr["taskid"].Toint();
}
//
if (dr.Table.Columns.Contains("tempdatajson"))
{
o.tempdatajson = dr["tempdatajson"].Tostring();
}
//
if (dr.Table.Columns.Contains("tempdatalastupdatetime"))
{
o.tempdatalastupdatetime = dr["tempdatalastupdatetime"].ToDateTime();
}
return(o);
}
public tb_tempdata_model GetByTaskID(DbConn PubConn, int taskid)
{
return(SqlHelper.Visit(ps =>
{
ps.Add("taskid", taskid);
string sql = "select * from tb_tempdata where taskid=@taskid";
DataSet ds = new DataSet();
PubConn.SqlToDataSet(ds, sql, ps.ToParameters());
tb_tempdata_model model = CreateModel(ds.Tables[0].Rows[0]);
return model;
}));
}
public int UpdateByTaskID(DbConn PubConn, tb_tempdata_model model)
{
return(SqlHelper.Visit <int>(ps =>
{
ps.Add("@taskid", model.taskid);
ps.Add("@tempdatajson", model.tempdatajson);
ps.Add("@tempdatalastupdatetime", model.tempdatalastupdatetime);
ps.Add("@id", model.id);
int rev = PubConn.ExecuteSql("update tb_tempdata set tempdatajson=@tempdatajson,tempdatalastupdatetime=@tempdatalastupdatetime where taskid=@taskid", ps.ToParameters());
return rev;
}));
}
public virtual bool Add(DbConn PubConn, tb_tempdata_model model)
{
List <ProcedureParameter> Par = new List <ProcedureParameter>()
{
//
new ProcedureParameter("@taskid", model.taskid),
//
new ProcedureParameter("@tempdatajson", model.tempdatajson.NullToEmpty()),
//
new ProcedureParameter("@tempdatalastupdatetime", model.tempdatalastupdatetime)
};
int rev = PubConn.ExecuteSql(@"insert into tb_tempdata(taskid,tempdatajson,tempdatalastupdatetime)
values(@taskid,@tempdatajson,@tempdatalastupdatetime)" , Par);
return(rev == 1);
}
public JsonResult Copy(int id)
{
tb_task_model model = new tb_task_model();
tb_version_model vermodel = new tb_version_model();
tb_tempdata_model tempdatamodel = new tb_tempdata_model();
return(this.Visit(Core.EnumUserRole.Admin, () =>
{
try
{
tb_task_dal dal = new tb_task_dal();
tb_version_dal dalversion = new tb_version_dal();
tb_tempdata_dal tempdatadal = new tb_tempdata_dal();
using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString))
{
PubConn.Open();
//取出需要复制的数据
model = dal.GetOneTask(PubConn, id);
tempdatamodel = tempdatadal.GetByTaskID(PubConn, id);
vermodel = dalversion.GetCurrentVersion(PubConn, id, model.taskversion);
//分别插入
model.taskstate = 0;
model.taskcreatetime = DateTime.Now;
model.taskversion = 1;
int taskid = dal.AddTask(PubConn, model);
vermodel.taskid = taskid;
vermodel.version = 1;
vermodel.versioncreatetime = DateTime.Now;
vermodel.commit_id = string.Empty;
dalversion.Add(PubConn, vermodel);
tempdatamodel.taskid = taskid;
tempdatamodel.tempdatalastupdatetime = DateTime.Now;
tempdatadal.Add(PubConn, tempdatamodel);
}
return Json(new { code = 1, state = "复制成功" });
}
catch (Exception ex)
{
return Json(new { code = -1, msg = ex.Message });
}
}));
}
public virtual bool Edit(DbConn PubConn, tb_tempdata_model model)
{
List <ProcedureParameter> Par = new List <ProcedureParameter>()
{
//
new ProcedureParameter("@taskid", model.taskid),
//
new ProcedureParameter("@tempdatajson", model.tempdatajson),
//
new ProcedureParameter("@tempdatalastupdatetime", model.tempdatalastupdatetime)
};
Par.Add(new ProcedureParameter("@id", model.id));
int rev = PubConn.ExecuteSql("update tb_tempdata set taskid=@taskid,tempdatajson=@tempdatajson,tempdatalastupdatetime=@tempdatalastupdatetime where id=@id", Par);
return(rev == 1);
}
