/// <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); } }