public static object ExecuteScalar(OleDbConnection connection, string sqlText)
{
try
{
if (connection != null)
{
if (connection.State == System.Data.ConnectionState.Broken)
{
connection.Close();
connection.Open();
}
if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Close();
}
using (var command = connection.CreateCommand())
{
command.CommandText = sqlText;
var val = command.ExecuteScalar();
return(val);
}
}
}
catch (SqlException ex)
{
var info = string.Format("执行SQL语句：{0}发生错误，错误信息：{1}", sqlText, ex.Message);
Console.WriteLine(info);
QuestionManager.Add(new Models.Question {
Code = "1201", Project = Models.CheckProject.数据有效性, Description = info
});
}
return(null);
}
public static void Program()
{
foreach (var key in _keys)
{
if (!_dict.ContainsKey(key))
{
Console.WriteLine(string.Format("未读取表{0}中的图斑面积，无法进行核对图斑面积信息", key));
}
}
if (_messages == null)
{
_messages = new List <string>();
}
else
{
_messages.Clear();
}
foreach (var item in _list)
{
Console.WriteLine(string.Format("正在验证行政区代码【{0}】行政区名称：【{1}】图斑编号：【{2}】的面积一致性；", item.XZCDM, item.XZCMC, item.TBBH));
var currentSum = TB.Where(e => e.XZCDM == item.XZCDM && e.TBBH == item.TBBH).Sum(e => e.MJ);
if (item.MJ < currentSum)
{
var str = string.Format("行政区代码：【{0}】行政村名称：【{1}】图斑编号：【{2}】面积：【{3}】在表：【{4}】中面积和不符", item.XZCDM, item.XZCMC, item.TBBH, item.MJ, string.Join(",", _keys));
Console.WriteLine(str);
QuestionManager.Add(new Question()
{
Code = "3401", Name = "面积一致性", Project = CheckProject.面积一致性, TableName = "DCDYTB", BSM = item.TBBH, Description = str
});
_messages.Add(str);
}
}
}
private static void Program(List <DCDYTB> list)
{
foreach (var item in list)
{
Console.WriteLine(string.Format("正在验证行政区代码【{0}】行政区名称：【{1}】图斑编号：【{2}】的面积一致性；", item.XZCDM, item.XZCMC, item.TBBH));
var key = string.Format("{0}#{1}", item.XZCDM, item.TBBH);
if (Dict.ContainsKey(key))
{
var currentSum = Dict[key];
if (item.Area + 1 <= currentSum)//面积容差率 不能超过1平方米
{
var str = string.Format("行政区代码：【{0}】行政村名称：【{1}】图斑编号：【{2}】面积：【{3}】平方米 在表：【{4}】中面积和【{5}】平方米不符", item.XZCDM, item.XZCMC, item.TBBH, item.MJ, string.Join(",", _keys), currentSum);
LogManager.Log(str);
QuestionManager.Add(
new Question()
{
Code = "3401",
Name = "面积一致性",
Project = CheckProject.面积一致性,
TableName = "DCDYTB",
BSM = item.BSM,
Description = str,
RelationClassName = "DCDYTB",
ShowType = ShowType.Space,
WhereClause = string.Format("[BSM] = {0}", item.BSM)
});
AddMessage(str);
}
}
}
}
public static int ExecuteNoQuery(OleDbConnection connection, string sqlText)
{
lock (_syncRoot)
{
try
{
if (connection != null)
{
if (connection.State == System.Data.ConnectionState.Broken)
{
connection.Close();
connection.Open();
}
if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
using (var command = connection.CreateCommand())
{
command.CommandText = sqlText;
var rows = command.ExecuteNonQuery();
return(rows);
}
}
}
catch (SqlException ex)
{
var info = string.Format("执行SQL语句：{0}发生错误，错误信息：{1}", sqlText, ex.Message);
LogManager.Log(info);
QuestionManager.Add(new Models.Question {
Code = "1201", Project = Models.CheckProject.数据库查询, Description = info
});
}
catch (OleDbException ex)
{
var info = string.Format("执行SQL语句:{0}发生错误，错误信息：{1}", sqlText, ex.Message);
LogManager.Log(info);
QuestionManager.Add(new Models.Question {
Code = "1201", Project = Models.CheckProject.数据库查询, Description = info
});
}
return(0);
}
}
