Exemplo n.º 1
0
        /// <summary>
        /// 批量添加tags,并返回添加成功的tagid列表
        /// </summary>
        public XCLNetTools.Entity.MethodResult <Tags_AddMethodResult> Add(List <XCLCMS.Data.Model.Tags> lst)
        {
            var result = new XCLNetTools.Entity.MethodResult <Tags_AddMethodResult>();

            result.Result = new Tags_AddMethodResult()
            {
                AddedTagIdList = new List <long>(),
                ExistTagIdList = new List <long>()
            };
            if (null == lst || lst.Count == 0)
            {
                result.IsSuccess = true;
                return(result);
            }

            lst = lst.Distinct().Where(k => !string.IsNullOrWhiteSpace(k.TagName)).ToList();

            foreach (var m in lst)
            {
                //判断标签是否存在
                var model = this.GetModel((new Tags_NameCondition()
                {
                    FK_MerchantAppID = m.FK_MerchantAppID,
                    FK_MerchantID = m.FK_MerchantID,
                    TagName = m.TagName
                }));
                if (null != model)
                {
                    result.Result.ExistTagIdList.Add(model.TagsID);
                    continue;
                }

                //添加标签
                if (this.Add(m))
                {
                    result.Result.AddedTagIdList.Add(m.TagsID);
                }
            }

            result.IsSuccess = true;

            return(result);
        }
Exemplo n.º 2
0
        /// <summary>
        /// 检查指定的列名是否在 DataTable 的 ColumnName 属性中存在
        /// </summary>
        public static XCLNetTools.Entity.MethodResult <bool> CheckColumnNames(DataTable dt, List <string> mustFindColumnNames)
        {
            var msg = new XCLNetTools.Entity.MethodResult <bool>();

            msg.IsSuccess = false;

            if (null == dt || null == dt.Rows)
            {
                msg.IsSuccess = false;
                msg.Message   = "请指定有效的数据源!";
                return(msg);
            }
            if (mustFindColumnNames.IsNullOrEmpty())
            {
                msg.IsSuccess = false;
                msg.Message   = "请指定需要检查的列名!";
                return(msg);
            }
            var dtColumnNames = new List <string>();

            for (var i = 0; i < dt.Columns.Count; i++)
            {
                dtColumnNames.Add(dt.Columns[i].ColumnName);
            }
            var notFoundNames = mustFindColumnNames.Where(k => !dtColumnNames.Contains(k)).ToList();

            if (notFoundNames.IsNotNullOrEmpty())
            {
                msg.IsSuccess = false;
                msg.Message   = "在数据源中未找到这些列名:" + string.Join("、", notFoundNames);
                return(msg);
            }

            msg.IsSuccess = true;
            return(msg);
        }