/// <summary>
/// 删除消息。
/// </summary>
/// <param name="type"></param>
/// <param name="xxbh"></param>
/// <param name="userId"></param>
/// <returns></returns>
public bool DelMessage(int type, string xxbh, string userId)
{
DataTableOperation dtOperation = new DataTableOperation();
OracleDbOperation dbOperation = new OracleDbOperation(OracleHelper.ConnectionString);
dbOperation.BeginTransaction();
string tableName;
string sql;
List <OracleParameter> parameters = new List <OracleParameter>();
tableName = "xtxx";
sql = "select * from " + tableName + " a where a.xxbh = :xxbh";
parameters.Clear();
parameters.Add(new OracleParameter("xxbh", xxbh));
DataTable dtXtxx = dbOperation.ExecuteDataTable(sql, tableName, parameters);
if (dtXtxx.Rows.Count > 0)
{
DataRow drXtxx = dtXtxx.Rows[0];
tableName = "xtxxjs";
sql = "select * from " + tableName + " a where a.jsxxbh = :jsxxbh";
parameters.Clear();
parameters.Add(new OracleParameter("jsxxbh", xxbh));
DataTable dtXtxxjs = dbOperation.ExecuteDataTable(sql, tableName, parameters);
switch (type)
{
case 0:
var drXtxxjs = (from DataRow dr in dtXtxxjs.Rows
where dr["JSR"].ToString() == userId
select dr).First();
drXtxxjs["jsrsc"] = "1";
break;
case 1:
drXtxx["fsrsc"] = "1";
break;
}
int xtxxjsUndeleteCount = (from DataRow dr in dtXtxxjs.Rows
where dr["jsrsc"].ToString() == "0"
select dr).Count();
string xtxxDeleteState = drXtxx["fsrsc"].ToString();
if (xtxxjsUndeleteCount == 0 && xtxxDeleteState == "1")
{
dtOperation.ClearDbDataTable(dtXtxx);
dtOperation.ClearDbDataTable(dtXtxxjs);
DeleteMessageFile(xxbh, null);
}
dbOperation.UpdateDataTable(dtXtxx);
dbOperation.UpdateDataTable(dtXtxxjs);
dbOperation.Commit();
}
else
{
dbOperation.Rollback();
return(false);
}
return(true);
}
/// <summary>
/// 同步。
/// </summary>
/// <param name="setting">同步配置。</param>
/// <param name="log">日志信息。</param>
/// <returns>同步是否成功。</returns>
public bool Sync(SyncConfig syncConfig, SyncConfigTarget targetConfig, SyncConfigLocal localConfig, ref StringBuilder sbLog)
{
bool result = false;
LogOperation.Append(sbLog, string.Format("开始同步数据：{0}({1}) 开始时间：{2}", targetConfig.Name, targetConfig.Code, DateTime.Now));
OracleDbOperation localDb = new OracleDbOperation(localConfig.DbConfig.ConnStr);
FtpHelper localFtp = new FtpHelper(localConfig.FtpConfig.Ip, localConfig.FtpConfig.Port, localConfig.FtpConfig.Username, localConfig.FtpConfig.Password);
OracleDbOperation targetDb = new OracleDbOperation(targetConfig.DbConfig.ConnStr);
FtpHelper targetFtp = new FtpHelper(targetConfig.FtpConfig.Ip, targetConfig.FtpConfig.Port, targetConfig.FtpConfig.Username, targetConfig.FtpConfig.Password);
try
{
targetDb.BeginTransaction();
localDb.BeginTransaction();
List <SyncData> syncDataList = new List <SyncData>();
////系统数据
syncDataList.Add(new SyncDataSystemInfo(targetDb, localDb, targetConfig.Code, localConfig.Code, targetFtp, localFtp, sbLog));
////项目数据
syncDataList.Add(new SyncDataItem(syncConfig, targetDb, localDb, targetConfig.Code, localConfig.Code, targetFtp, localFtp, sbLog));
////流程数据
syncDataList.Add(new SyncDataWorkflow(targetDb, localDb, targetConfig.Code, localConfig.Code, targetFtp, localFtp, sbLog));
////Syncs.Add(new SyncXtxx(targetDbOperation, localDbOperation, targetSetting.Code, localSetting.Code, targetFtpOperation, localFtpOperation, sbLog));
foreach (var syncData in syncDataList)
{
syncData.Sync();
}
targetDb.Commit();
localDb.Commit();
result = true;
}
catch (Exception e)
{
targetDb.Rollback();
localDb.Rollback();
LogOperation.WriteExceptionLog(sbLog, e);
}
sbLog.AppendLine();
sbLog.AppendLine("结束时间：" + DateTime.Now);
return(result);
}
/// <summary>
/// 删除消息。
/// </summary>
/// <param name="type"></param>
/// <param name="xxbh"></param>
/// <param name="userId"></param>
/// <returns></returns>
public bool DelMessage(int type, string xxbh, string userId)
{
DataTableOperation dtOperation = new DataTableOperation();
OracleDbOperation dbOperation = new OracleDbOperation(OracleHelper.ConnectionString);
dbOperation.BeginTransaction();
string tableName;
string sql;
List<OracleParameter> parameters = new List<OracleParameter>();
tableName = "xtxx";
sql = "select * from " + tableName + " a where a.xxbh = :xxbh";
parameters.Clear();
parameters.Add(new OracleParameter("xxbh", xxbh));
DataTable dtXtxx = dbOperation.ExecuteDataTable(sql, tableName, parameters);
if (dtXtxx.Rows.Count > 0)
{
DataRow drXtxx = dtXtxx.Rows[0];
tableName = "xtxxjs";
sql = "select * from " + tableName + " a where a.jsxxbh = :jsxxbh";
parameters.Clear();
parameters.Add(new OracleParameter("jsxxbh", xxbh));
DataTable dtXtxxjs = dbOperation.ExecuteDataTable(sql, tableName, parameters);
switch (type)
{
case 0:
var drXtxxjs = (from DataRow dr in dtXtxxjs.Rows
where dr["JSR"].ToString() == userId
select dr).First();
drXtxxjs["jsrsc"] = "1";
break;
case 1:
drXtxx["fsrsc"] = "1";
break;
}
int xtxxjsUndeleteCount = (from DataRow dr in dtXtxxjs.Rows
where dr["jsrsc"].ToString() == "0"
select dr).Count();
string xtxxDeleteState = drXtxx["fsrsc"].ToString();
if (xtxxjsUndeleteCount == 0 && xtxxDeleteState == "1")
{
dtOperation.ClearDbDataTable(dtXtxx);
dtOperation.ClearDbDataTable(dtXtxxjs);
DeleteMessageFile(xxbh, null);
}
dbOperation.UpdateDataTable(dtXtxx);
dbOperation.UpdateDataTable(dtXtxxjs);
dbOperation.Commit();
}
else
{
dbOperation.Rollback();
return false;
}
return true;
}
/// <summary>
/// 同步。
/// </summary>
/// <param name="setting">同步配置。</param>
/// <param name="log">日志信息。</param>
/// <returns>同步是否成功。</returns>
public bool Sync(SyncConfig syncConfig, SyncConfigTarget targetConfig, SyncConfigLocal localConfig, ref StringBuilder sbLog)
{
bool result = false;
LogOperation.Append(sbLog, string.Format("开始同步数据：{0}({1}) 开始时间：{2}", targetConfig.Name, targetConfig.Code, DateTime.Now));
OracleDbOperation localDb = new OracleDbOperation(localConfig.DbConfig.ConnStr);
FtpHelper localFtp = new FtpHelper(localConfig.FtpConfig.Ip, localConfig.FtpConfig.Port, localConfig.FtpConfig.Username, localConfig.FtpConfig.Password);
OracleDbOperation targetDb = new OracleDbOperation(targetConfig.DbConfig.ConnStr);
FtpHelper targetFtp = new FtpHelper(targetConfig.FtpConfig.Ip, targetConfig.FtpConfig.Port, targetConfig.FtpConfig.Username, targetConfig.FtpConfig.Password);
try
{
targetDb.BeginTransaction();
localDb.BeginTransaction();
List<SyncData> syncDataList = new List<SyncData>();
////系统数据
syncDataList.Add(new SyncDataSystemInfo(targetDb, localDb, targetConfig.Code, localConfig.Code, targetFtp, localFtp, sbLog));
////项目数据
syncDataList.Add(new SyncDataItem(syncConfig, targetDb, localDb, targetConfig.Code, localConfig.Code, targetFtp, localFtp, sbLog));
////流程数据
syncDataList.Add(new SyncDataWorkflow(targetDb, localDb, targetConfig.Code, localConfig.Code, targetFtp, localFtp, sbLog));
////Syncs.Add(new SyncXtxx(targetDbOperation, localDbOperation, targetSetting.Code, localSetting.Code, targetFtpOperation, localFtpOperation, sbLog));
foreach (var syncData in syncDataList)
{
syncData.Sync();
}
targetDb.Commit();
localDb.Commit();
result = true;
}
catch (Exception e)
{
targetDb.Rollback();
localDb.Rollback();
LogOperation.WriteExceptionLog(sbLog, e);
}
sbLog.AppendLine();
sbLog.AppendLine("结束时间：" + DateTime.Now);
return result;
}