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