/// <summary> 上传数据
/// </summary>
/// <param name="dbName">帐套信息</param>
/// <param name="time">下次上传数据时间</param>
public static void UpLoadFileTest(string dbName, string time)
{
InitHashtable();
string tableName = string.Empty;
foreach (DictionaryEntry de in htTable)
{
tableName = de.Key.ToString();
ProtocolValue pv = null;
if (de.Value is ProtocolValue)
{
pv = de.Value as ProtocolValue;
}
#region --添加数据
Operation(
DataHelper.GetDataTest(tableName, dbName,
TimeHelper.GetTimeInMillis(GlobalStaticObj_Server.Instance.LastUploadTime),
TimeHelper.GetTimeInMillis(time)),
DataSources.EnumOperationType.Add.ToString("d"), dbName);
#endregion
Thread.Sleep(100);
}
}
/// <summary> 上传数据
/// </summary>
/// <param name="dbName">帐套信息</param>
/// <param name="time">下次上传数据时间</param>
public static void UpLoadDataTest(string dbName, string time)
{
InitHashtable();
string tableName = string.Empty;
foreach (DictionaryEntry de in htTable)
{
tableName = de.Key.ToString();
ProtocolValue pv = null;
if (de.Value is ProtocolValue)
{
pv = de.Value as ProtocolValue;
}
if (tableName == "tb_announcement")
{
// 区分数据来源
Operation(
DataHelper.GetDataTest(tableName, dbName,
TimeHelper.GetTimeInMillis(GlobalStaticObj_Server.Instance.LastUploadTime),
TimeHelper.GetTimeInMillis(time)),
DataSources.EnumOperationType.Add.ToString("d"), dbName);
}
else
{
Operation(
DataHelper.GetDataTest(tableName, dbName,
TimeHelper.GetTimeInMillis(GlobalStaticObj_Server.Instance.LastUploadTime),
TimeHelper.GetTimeInMillis(time)),
DataSources.EnumOperationType.Update.ToString("d"), dbName);
}
Thread.Sleep(1000);
}
}
public static DataTable GetAddDataFromHXC(string tableName, ProtocolValue pv, string dbName, string lastTime, string time)
{
if (pv != null && pv.PreTableName.Length > 0)
{
return(GetAddDataFromHXC(
string.Format("{0} inner join {1} on {0}.{2}={1}.{3}", tableName, pv.PreTableName, pv.Key, pv.PreKey),
tableName, pv.PreTableName, dbName, lastTime, time));
}
return(GetAddDataFromHXC(tableName, dbName, lastTime, time));
}
/// <summary> 上传数据
/// </summary>
/// <param name="dbName">帐套信息</param>
/// <param name="time">下次上传数据时间</param>
public static void UpLoadFile(string dbName, string time)
{
InitHashtable();
foreach (DictionaryEntry de in htTable)
{
var tableName = de.Key.ToString();
if (DataHelper.TableIsExists(dbName, tableName))
{
continue;
}
ProtocolValue pv = null;
if (de.Value is ProtocolValue)
{
pv = de.Value as ProtocolValue;
}
if (pv == null)
{
return;
}
var lastTime = TimeHelper.GetTimeInMillis(GlobalStaticObj_Server.Instance.LastUploadTime);
var currTime = TimeHelper.GetTimeInMillis(time);
switch (pv.Operate)
{
case OperateType.A:
Operation(DataHelper.GetAddData(tableName, dbName, lastTime, currTime), DataSources.EnumOperationType.Add.ToString("d"), dbName);
break;
case OperateType.D:
Operation(DataHelper.GetDeleteData(tableName, dbName, lastTime, currTime), DataSources.EnumOperationType.Delete.ToString("d"), dbName);
break;
case OperateType.AU:
Operation(DataHelper.GetAddData(tableName, dbName, lastTime, currTime), DataSources.EnumOperationType.Add.ToString("d"), dbName);
Operation(DataHelper.GetUpdateData(tableName, dbName, lastTime, currTime), DataSources.EnumOperationType.Update.ToString("d"), dbName);
break;
case OperateType.AD:
Operation(DataHelper.GetAddData(tableName, dbName, lastTime, currTime), DataSources.EnumOperationType.Add.ToString("d"), dbName);
Operation(DataHelper.GetDeleteData(tableName, dbName, lastTime, currTime), DataSources.EnumOperationType.Delete.ToString("d"), dbName);
break;
case OperateType.PK:
break;
case OperateType.AUD:
Operation(DataHelper.GetAddData(tableName, dbName, lastTime, currTime), DataSources.EnumOperationType.Add.ToString("d"), dbName);
Operation(DataHelper.GetUpdateData(tableName, dbName, lastTime, currTime), DataSources.EnumOperationType.Update.ToString("d"), dbName);
Operation(DataHelper.GetDeleteData(tableName, dbName, lastTime, currTime), DataSources.EnumOperationType.Delete.ToString("d"), dbName);
break;
}
Thread.Sleep(1000);
}
}
public static DataTable GetAddData(string tableName, ProtocolValue pv, string dbName, string lastTime, string time)
{
return(null);
//if (pv == null) return null;
//if (!String.IsNullOrEmpty(pv.PreTableName))
//{
// return GetAddData(
// string.Format("{0} inner join {1} on {0}.{2}={1}.{3}", tableName, pv.PreTableName, pv.Key, pv.PreKey),
// tableName, pv.PreTableName, dbName, lastTime, time, pv.Operate);
//}
//return GetAddData(tableName, dbName, lastTime, time, pv.Operate);
}
public static DataTable GetDeleteData(string tableName, ProtocolValue pv, string dbName, string lastTime, string time)
{
if (pv == null)
{
return(null);
}
if (pv.PreTableName.Length > 0)
{
return(GetDeleteData(
string.Format("{0} inner join {1} on {0}.{2}={1}.{3}", tableName, pv.PreTableName, pv.Key, pv.PreKey),
tableName, pv.PreTableName, dbName, lastTime, time, pv.Operate));
}
return(GetDeleteData(tableName, tableName, tableName, dbName, lastTime, time, pv.Operate));
}
/// <summary> 上传数据
/// </summary>
/// <param name="dbName">帐套信息</param>
/// <param name="time">下次上传数据时间</param>
public static void UpLoadData(string dbName, string time)
{
InitHashtable();
foreach (DictionaryEntry de in htTable)
{
var tableName = de.Key.ToString();
if (!DataHelper.TableIsExists(dbName, tableName))
{
continue;
}
ProtocolValue pv = null;
if (de.Value is ProtocolValue)
{
pv = de.Value as ProtocolValue;
}
if (pv == null)
{
return;
}
var lastTime = TimeHelper.GetTimeInMillis(GlobalStaticObj_Server.Instance.LastUploadTime);
var currTime = TimeHelper.GetTimeInMillis(time);
if (tableName == "sys_announcement")
{
// 区分数据来源
#region --添加数据
Operation(
DataHelper.GetAddDataFromHXC(tableName, pv, dbName,
TimeHelper.GetTimeInMillis(GlobalStaticObj_Server.Instance.LastUploadTime),
TimeHelper.GetTimeInMillis(time)),
DataSources.EnumOperationType.Add.ToString("d"), dbName);
#endregion
Thread.Sleep(100);
#region --修改数据
Operation(
DataHelper.GetUpdateDataFormHXC(tableName, pv, dbName,
TimeHelper.GetTimeInMillis(GlobalStaticObj_Server.Instance.LastUploadTime),
TimeHelper.GetTimeInMillis(time)),
DataSources.EnumOperationType.Update.ToString("d"), dbName);
#endregion
Thread.Sleep(100);
#region --删除数据
Operation(
DataHelper.GetUpdateDataFormHXC(tableName, pv, dbName,
TimeHelper.GetTimeInMillis(GlobalStaticObj_Server.Instance.LastUploadTime),
TimeHelper.GetTimeInMillis(time)),
DataSources.EnumOperationType.Delete.ToString("d"), dbName);
#endregion
}
else
{
switch (pv.Operate)
{
case OperateType.A:
Operation(DataHelper.GetAddData(tableName, dbName, lastTime, currTime),
DataSources.EnumOperationType.Add.ToString("d"), dbName);
break;
case OperateType.D:
Operation(DataHelper.GetDeleteData(tableName, dbName, lastTime, currTime),
DataSources.EnumOperationType.Delete.ToString("d"), dbName);
break;
case OperateType.AU:
Operation(DataHelper.GetAddData(tableName, dbName, lastTime, currTime),
DataSources.EnumOperationType.Add.ToString("d"), dbName);
Operation(DataHelper.GetUpdateData(tableName, dbName, lastTime, currTime),
DataSources.EnumOperationType.Update.ToString("d"), dbName);
break;
case OperateType.AD:
Operation(DataHelper.GetAddData(tableName, dbName, lastTime, currTime),
DataSources.EnumOperationType.Add.ToString("d"), dbName);
Operation(DataHelper.GetDeleteData(tableName, dbName, lastTime, currTime),
DataSources.EnumOperationType.Delete.ToString("d"), dbName);
break;
case OperateType.PK:
break;
case OperateType.AUD:
Operation(DataHelper.GetAddData(tableName, dbName, lastTime, currTime),
DataSources.EnumOperationType.Add.ToString("d"), dbName);
Operation(DataHelper.GetUpdateData(tableName, dbName, lastTime, currTime),
DataSources.EnumOperationType.Update.ToString("d"), dbName);
Operation(DataHelper.GetDeleteData(tableName, dbName, lastTime, currTime),
DataSources.EnumOperationType.Delete.ToString("d"), dbName);
break;
}
}
Thread.Sleep(1000);
}
}
/// <summary> 上传数据
/// </summary>
/// <param name="dbName">帐套信息</param>
/// <param name="time">下次上传数据时间</param>
public static void UpLoadData(string dbName, string time)
{
InitHashtable();
string tableName = string.Empty;
foreach (DictionaryEntry de in htTable)
{
tableName = de.Key.ToString();
ProtocolValue pv = null;
if (de.Value is ProtocolValue)
{
pv = de.Value as ProtocolValue;
}
if (pv.Operate == OperateType.PK)
{
//关系表处理
continue;
}
if (tableName == "tb_announcement")
{
// 区分数据来源
#region --添加数据
Operation(
DataHelper.GetAddDataFromHXC(tableName, pv, dbName,
TimeHelper.GetTimeInMillis(GlobalStaticObj_Server.Instance.LastUploadTime),
TimeHelper.GetTimeInMillis(time)),
DataSources.EnumOperationType.Add.ToString("d"), dbName);
#endregion
Thread.Sleep(100);
#region --修改数据
Operation(
DataHelper.GetUpdateDataFormHXC(tableName, pv, dbName,
TimeHelper.GetTimeInMillis(GlobalStaticObj_Server.Instance.LastUploadTime),
TimeHelper.GetTimeInMillis(time)),
DataSources.EnumOperationType.Update.ToString("d"), dbName);
#endregion
Thread.Sleep(100);
#region --删除数据
Operation(
DataHelper.GetUpdateDataFormHXC(tableName, pv, dbName,
TimeHelper.GetTimeInMillis(GlobalStaticObj_Server.Instance.LastUploadTime),
TimeHelper.GetTimeInMillis(time)),
DataSources.EnumOperationType.Delete.ToString("d"), dbName);
#endregion
}
else
{
#region --添加数据
Operation(
DataHelper.GetAddData(tableName, pv, dbName,
TimeHelper.GetTimeInMillis(GlobalStaticObj_Server.Instance.LastUploadTime),
TimeHelper.GetTimeInMillis(time)),
DataSources.EnumOperationType.Add.ToString("d"), dbName);
#endregion
Thread.Sleep(100);
#region --修改数据
Operation(
DataHelper.GetUpdateData(tableName, pv, dbName,
TimeHelper.GetTimeInMillis(GlobalStaticObj_Server.Instance.LastUploadTime),
TimeHelper.GetTimeInMillis(time)),
DataSources.EnumOperationType.Update.ToString("d"), dbName);
#endregion
Thread.Sleep(100);
#region --删除数据
Operation(
DataHelper.GetDeleteData(tableName, pv, dbName,
TimeHelper.GetTimeInMillis(GlobalStaticObj_Server.Instance.LastUploadTime),
TimeHelper.GetTimeInMillis(time)),
DataSources.EnumOperationType.Delete.ToString("d"), dbName);
#endregion
}
Thread.Sleep(1000);
}
}
