public static List <string> CheckLayer(LayerArgs lyrArgs, DicInfoReader dicInfo)
{
List <string> rlts = new List <string>();
TxLayerInfo txLyrInfo = dicInfo.TxLyrList.First(t => t.DataLayer == lyrArgs.DataLayer); //t.TxName == lyrArgs.TxName && t.TjName == lyrArgs.TjName && t.LayerName == lyrArgs.LayerName && t.DataLayer == lyrArgs.DataLayer);
//List<LayerAttInfo> attInfoList = dicInfo.LyrAttList.Where(t => t.TxName == txLyrInfo.TxName).Where(t => t.TjName == txLyrInfo.TjName).Where(t => t.LayerName == txLyrInfo.LayerName).ToList();
List <LayerAttInfo> attInfoList = dicInfo.LyrAttList.Where(t => t.DataLayer == txLyrInfo.DataLayer).ToList();
DataTable tbl = ShpUtility.GetRecords(lyrArgs.LayerPath, null);
// 检查列名是否有特殊字符
for (int i = 0; i < tbl.Columns.Count; i++)
{
if (tbl.Columns[i].ColumnName.IndexOf('?') != -1)
{
string info = string.Format("数据检查：列名长度不符合ArcGIS规范：{0}", tbl.Columns[i].ColumnName);
rlts.Add(info);
}
}
//检查字段及名称是否齐全
List <string> logs = CheckFiledNums(tbl, attInfoList);
if (logs != null && logs.Count > 0)
{
rlts.AddRange(logs);
}
//检查字段值是否溢出（超过限定长度或不在给定阈值范围）
logs = CheckFiledValueRange(tbl, attInfoList);
if (logs != null && logs.Count > 0)
{
rlts.AddRange(logs);
}
//检查字段字典项
for (int i = 0; i < attInfoList.Count; i++)
{
LayerAttInfo lyrAtt = attInfoList[i];
logs = CheckDicAtt(tbl, lyrAtt, dicInfo);
if (logs != null && logs.Count > 0)
{
rlts.AddRange(logs);
}
}
return(rlts);
}
//检查字段字典项
private static List <string> CheckDicAtt(DataTable tbl, LayerAttInfo attInfo, DicInfoReader dicInfo)
{
List <string> rlts = new List <string>();
List <AttValueInfo> attValList = dicInfo.AttValueList.Where(t => t.AttId == attInfo.Guid).ToList();
if (attValList == null || attValList.Count < 1)
{
return(rlts);
}
List <string> cols = new List <string>();
for (int i = 0; i < tbl.Columns.Count; i++)
{
cols.Add(tbl.Columns[i].ColumnName);
}
if (attValList.Count == 1 && string.IsNullOrEmpty(attValList[0].ParentId) == false)
{
AttValueInfo attVal = attValList[0];
//检查大类是符合字典项
AttValueInfo pAttVal = dicInfo.AttValueList.First(t => t.Guid == attVal.ParentId);
LayerAttInfo pAttInfo = dicInfo.LyrAttList.First(t => t.Guid == pAttVal.AttId);
List <string> infoList = CheckDicAtt(tbl, pAttInfo, dicInfo);
if (infoList != null && infoList.Count > 0)
{
rlts.AddRange(infoList.ToArray());
}
}
//检查是否符合字典项
List <string> valueList = GetDicValues(attValList);
for (int i = 0; i < tbl.Rows.Count; i++)
{
object obj = null;
if (cols.Contains(attInfo.DataName))
{
obj = tbl.Rows[i][attInfo.DataName];
}
if (obj == null)
{
continue;
}
string valStr = obj.ToString();
if (attInfo.Constraint.Equals("M", StringComparison.CurrentCultureIgnoreCase) && valueList.Contains(valStr) == false)
{
string info = string.Format("数据检查：第{0}行“{1}”字段值不在字典项({2})里", i, attInfo.DataName, JoinStr(valueList));
rlts.Add(info);
}
else if (attInfo.Constraint.Equals("O", StringComparison.CurrentCultureIgnoreCase))
{
//有待完善
bool ok = false;
for (int j = 0; j < valueList.Count; j++)
{
if (valStr.Contains(valueList[j]))
{
ok = true;
}
}
if (ok == false)
{
string info = string.Format("数据检查：第{0}行{1}字段值不在字典项({2})里", i, attInfo.DataName, JoinStr(valueList));
rlts.Add(info);
}
}
}
return(rlts);
}
