public int Insert(TableMatchInfo tableMatchInfo)
{
const string sqlString = "INSERT INTO siteserver_TableMatch (ConnectionString, TableName, ConnectionStringToMatch, TableNameToMatch, ColumnsMap) VALUES (@ConnectionString, @TableName, @ConnectionStringToMatch, @TableNameToMatch, @ColumnsMap)";
var insertParms = new IDataParameter[]
{
GetParameter(ParmConnectionString, DataType.VarChar, 200, tableMatchInfo.ConnectionString),
GetParameter(ParmTableName, DataType.VarChar, 200, tableMatchInfo.TableName),
GetParameter(ParmConnectionStringToMatch, DataType.VarChar, 200, tableMatchInfo.ConnectionStringToMatch),
GetParameter(ParmTableNameToMatch, DataType.VarChar, 200, tableMatchInfo.TableNameToMatch),
GetParameter(ParmColumnsMap, DataType.Text, TranslateUtils.NameValueCollectionToString(tableMatchInfo.ColumnsMap))
};
return(ExecuteNonQueryAndReturnId(TableName, nameof(TableMatchInfo.Id), sqlString, insertParms));
}
public void Update(TableMatchInfo tableMatchInfo)
{
var updateParms = new IDataParameter[]
{
GetParameter(ParmConnectionString, DataType.VarChar, 200, tableMatchInfo.ConnectionString),
GetParameter(ParmTableName, DataType.VarChar, 200, tableMatchInfo.TableName),
GetParameter(ParmConnectionStringToMatch, DataType.VarChar, 200, tableMatchInfo.ConnectionStringToMatch),
GetParameter(ParmTableNameToMatch, DataType.VarChar, 200, tableMatchInfo.TableNameToMatch),
GetParameter(ParmColumnsMap, DataType.Text, TranslateUtils.NameValueCollectionToString(tableMatchInfo.ColumnsMap)),
GetParameter(ParmId, DataType.Integer, tableMatchInfo.Id)
};
using (var conn = GetConnection())
{
conn.Open();
ExecuteNonQuery(conn, SqlUpdateTableMatch, updateParms);
}
}
public TableMatchInfo GetTableMatchInfo(int id)
{
TableMatchInfo tableMatchInfo = null;
var parms = new IDataParameter[]
{
GetParameter(ParmId, DataType.Integer, id)
};
using (var rdr = ExecuteReader(SqlSelectTableMatch, parms))
{
if (rdr.Read())
{
var i = 0;
tableMatchInfo = new TableMatchInfo(GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), TranslateUtils.ToNameValueCollection(GetString(rdr, i)));
}
rdr.Close();
}
return(tableMatchInfo);
}
public int Insert(TableMatchInfo tableMatchInfo)
{
int tableMatchId;
var sqlString = "INSERT INTO bairong_TableMatch (ConnectionString, TableName, ConnectionStringToMatch, TableNameToMatch, ColumnsMap) VALUES (@ConnectionString, @TableName, @ConnectionStringToMatch, @TableNameToMatch, @ColumnsMap)";
var insertParms = new IDataParameter[]
{
GetParameter(ParmConnectionString, EDataType.VarChar, 200, tableMatchInfo.ConnectionString),
GetParameter(ParmTableName, EDataType.VarChar, 200, tableMatchInfo.TableName),
GetParameter(ParmConnectionStringToMatch, EDataType.VarChar, 200, tableMatchInfo.ConnectionStringToMatch),
GetParameter(ParmTableNameToMatch, EDataType.VarChar, 200, tableMatchInfo.TableNameToMatch),
GetParameter(ParmColumnsMap, EDataType.NText, TranslateUtils.NameValueCollectionToString(tableMatchInfo.ColumnsMap))
};
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
tableMatchId = ExecuteNonQueryAndReturnId(trans, sqlString, insertParms);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(tableMatchId);
}
private bool Validate_InsertGatherDatabaseRule(out string errorMessage)
{
try
{
var isNeedAdd = false;
if (_isEdit)
{
if (_theGatherRuleName != GatherRuleName.Text)
{
isNeedAdd = true;
DataProvider.GatherDatabaseRuleDao.Delete(_theGatherRuleName, PublishmentSystemId);
}
else
{
var gatherDatabaseRuleInfo = DataProvider.GatherDatabaseRuleDao.GetGatherDatabaseRuleInfo(_theGatherRuleName, PublishmentSystemId);
gatherDatabaseRuleInfo.ConnectionString = GetDatabaseConnectionString();
gatherDatabaseRuleInfo.RelatedTableName = TableName.Text;
gatherDatabaseRuleInfo.RelatedIdentity = RelatedIdentity.SelectedValue;
gatherDatabaseRuleInfo.RelatedOrderBy = RelatedOrderBy.SelectedValue;
gatherDatabaseRuleInfo.WhereString = WhereString.Text;
if (NodeIDDropDownList.SelectedValue != null)
{
gatherDatabaseRuleInfo.NodeId = int.Parse(NodeIDDropDownList.SelectedValue);
}
gatherDatabaseRuleInfo.GatherNum = int.Parse(GatherNum.Text);
gatherDatabaseRuleInfo.IsChecked = TranslateUtils.ToBool(IsChecked.SelectedValue);
gatherDatabaseRuleInfo.IsAutoCreate = TranslateUtils.ToBool(IsAutoCreate.SelectedValue);
gatherDatabaseRuleInfo.IsOrderByDesc = TranslateUtils.ToBool(IsOrderByDesc.SelectedValue);
gatherDatabaseRuleInfo.LastGatherDate = DateUtils.SqlMinValue;
var tableMatchInfo =
BaiRongDataProvider.TableMatchDao.GetTableMatchInfo(gatherDatabaseRuleInfo.TableMatchId);
if (tableMatchInfo == null)
{
tableMatchInfo =
new TableMatchInfo(0, gatherDatabaseRuleInfo.ConnectionString, TableName.Text,
WebConfigUtils.ConnectionString, TableNameToMatch.Text,
GetColumnsMap());
gatherDatabaseRuleInfo.TableMatchId =
BaiRongDataProvider.TableMatchDao.Insert(tableMatchInfo);
}
else
{
tableMatchInfo.ConnectionString = gatherDatabaseRuleInfo.ConnectionString;
tableMatchInfo.TableName = TableName.Text;
tableMatchInfo.ConnectionStringToMatch = WebConfigUtils.ConnectionString;
tableMatchInfo.TableNameToMatch = TableNameToMatch.Text;
tableMatchInfo.ColumnsMap = GetColumnsMap();
BaiRongDataProvider.TableMatchDao.Update(tableMatchInfo);
}
DataProvider.GatherDatabaseRuleDao.Update(gatherDatabaseRuleInfo);
}
}
else
{
isNeedAdd = true;
}
if (isNeedAdd)
{
var gatherDatabaseRuleInfo = new GatherDatabaseRuleInfo();
gatherDatabaseRuleInfo.GatherRuleName = GatherRuleName.Text;
gatherDatabaseRuleInfo.PublishmentSystemId = PublishmentSystemId;
gatherDatabaseRuleInfo.ConnectionString = GetDatabaseConnectionString();
gatherDatabaseRuleInfo.RelatedTableName = TableName.Text;
gatherDatabaseRuleInfo.RelatedIdentity = RelatedIdentity.SelectedValue;
gatherDatabaseRuleInfo.RelatedOrderBy = RelatedOrderBy.SelectedValue;
gatherDatabaseRuleInfo.WhereString = WhereString.Text;
if (NodeIDDropDownList.SelectedValue != null)
{
gatherDatabaseRuleInfo.NodeId = int.Parse(NodeIDDropDownList.SelectedValue);
}
gatherDatabaseRuleInfo.GatherNum = int.Parse(GatherNum.Text);
gatherDatabaseRuleInfo.IsChecked = TranslateUtils.ToBool(IsChecked.SelectedValue);
gatherDatabaseRuleInfo.IsAutoCreate = TranslateUtils.ToBool(IsAutoCreate.SelectedValue);
gatherDatabaseRuleInfo.IsOrderByDesc = TranslateUtils.ToBool(IsOrderByDesc.SelectedValue);
gatherDatabaseRuleInfo.LastGatherDate = DateUtils.SqlMinValue;
var tableMatchInfo = new TableMatchInfo(0, gatherDatabaseRuleInfo.ConnectionString, TableName.Text, WebConfigUtils.ConnectionString, TableNameToMatch.Text, GetColumnsMap());
gatherDatabaseRuleInfo.TableMatchId = BaiRongDataProvider.TableMatchDao.Insert(tableMatchInfo);
DataProvider.GatherDatabaseRuleDao.Insert(gatherDatabaseRuleInfo);
}
if (isNeedAdd)
{
Body.AddSiteLog(PublishmentSystemId, "添加数据库采集规则", $"采集规则:{GatherRuleName.Text}");
}
else
{
Body.AddSiteLog(PublishmentSystemId, "编辑数据库采集规则", $"采集规则:{GatherRuleName.Text}");
}
errorMessage = string.Empty;
return(true);
}
catch
{
errorMessage = "操作失败！";
return(false);
}
}
