public static List <tb_tasksyncmap_model> GetTaskSyncMapList() { using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString)) { tb_tasksyncmap_dal tasksyncdal = new tb_tasksyncmap_dal(); return(tasksyncdal.GetList(PubConn)); } }
public static tb_tasksyncmap_model GetTaskSyncMap(int id) { tb_tasksyncmap_dal dal = new tb_tasksyncmap_dal(); using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString)) { PubConn.Open(); return(dal.Get(PubConn, id)); } }
/// <summary> /// 同步页面 /// </summary> /// <returns></returns> public ActionResult Sync() { return(this.Visit(Core.EnumUserRole.Admin, () => { PagedList <tb_tasksyncmapinfo_model> pageList; var list = new List <tb_tasksyncmap_model>(); using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString)) { PubConn.Open(); tb_tasksyncmap_dal tasksyncdal = new tb_tasksyncmap_dal(); list = tasksyncdal.GetList(PubConn); var modelList = new List <tb_tasksyncmapinfo_model>(); if (list != null && list.Count > 0) { foreach (var item in list) { var fromtaskinfo = TaskHelper.GetTask(item.fromtaskid, PubConn); var fromtasknodeinfo = TaskHelper.GetNode(fromtaskinfo.nodeid, PubConn); var totaskinfo = TaskHelper.GetTask(item.totaskid, PubConn); var totasknodeinfo = TaskHelper.GetNode(totaskinfo.nodeid, PubConn); var fromtaskversioninfo = TaskHelper.GetSimpleVersion(fromtaskinfo.id, fromtaskinfo.taskversion, PubConn); var totaskversioninfo = TaskHelper.GetSimpleVersion(totaskinfo.id, totaskinfo.taskversion, PubConn); modelList.Add(new tb_tasksyncmapinfo_model { id = item.id, fromtask = new tasksyncinfo { taskid = fromtaskinfo.id, taskname = fromtaskinfo.taskname, nodeid = fromtasknodeinfo.id, nodename = fromtasknodeinfo.nodename, version = fromtaskinfo.taskversion.ToString(), assemblyversion = fromtaskversioninfo.assemblyversion, createtime = fromtaskversioninfo.versioncreatetime.ToString("yyyy-MM-dd HH:mm:ss") }, totask = new tasksyncinfo { taskid = totaskinfo.id, taskname = totaskinfo.taskname, nodeid = totasknodeinfo.id, nodename = totasknodeinfo.nodename, version = totaskinfo.taskversion.ToString(), assemblyversion = totaskversioninfo.assemblyversion, createtime = totaskversioninfo.versioncreatetime.ToString("yyyy-MM-dd HH:mm:ss") }, isdiff = true //fromtaskversioninfo.assemblyversion != totaskversioninfo.assemblyversion }); } } pageList = new PagedList <tb_tasksyncmapinfo_model>(modelList.Where(item => item.isdiff), 1, 1000); return View(pageList); } })); }