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);
                }
            }));
        }