/// <summary> /// 获得cids的分类列表 /// </summary> /// <param name="cids"></param> /// <returns></returns> public List <Category> GetListByIds(string conn, string cids) { List <Category> list = new List <Category>(); string[] cidstr = cids.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); long[] ids = new long[cidstr.Length]; for (int i = 0; i < cidstr.Length; i++) { ids[i] = LibConvert.StrToInt64(cidstr[i]); } string sql = "SELECT Id,CategoryName,Remark,CreateTime FROM Category"; SqlParameter[] paramters = new SqlParameter[] { new SqlParameter("@cdis", cids) }; DataTable dt = SqlServerHelper.Get(conn, sql, paramters); if (dt.Rows.Count > 0) { for (int m = 0; m < dt.Rows.Count; m++) { Category cate = new Category(); cate = Category.CreateModel(dt.Rows[m]); list.Add(cate); } } return(list.Where(c => ids.Contains(c.Id)).ToList()); }
protected override void OnStart(string[] args) { LogHelper.WriteInfo("服务启动"); if (!ConfigurationManager.AppSettings.AllKeys.Contains("NodeID") || !ConfigurationManager.AppSettings.AllKeys.Contains("TaskDataBaseConnectString")) { throw new Exception("请配置NodeID和TaskDataBaseConnectString"); } GlobalConfig.NodeId = LibConvert.StrToInt64(System.Configuration.ConfigurationManager.AppSettings["NodeID"]); GlobalConfig.TaskDataBaseConnectString = System.Configuration.ConfigurationManager.AppSettings["TaskDataBaseConnectString"]; thread = new Thread(new ThreadStart(NodeServiceProcessor.Run)); TaskLogDal.Add(GlobalConfig.TaskDataBaseConnectString, new TaskFramework.Taskmaneger.Model.TaskLog() { LogMsg = "节点启动成功", NodeId = GlobalConfig.NodeId, TaskId = 0, CreateTime = DateTime.Now }); thread.Start(); }