public Mail()
{
Config config = new Config();
_smtp=config.GetValue("SMTP");
_toList = config.GetValue("MailTo");
_isTest = false;
_dbName=config.GetValue("DBName");
_enableMail = config.GetValue("EnableMail") == "Y" ? true : false;
}
private void IniConfigSetting()
{
Config config = new Config();
dsArchiveID = new DataSet();
string arcConnString = config.GetConnectionString("ArcConnectionString");
string copyConnString = config.GetConnectionString("CopyConnectionString");
string deleteConnString = config.GetConnectionString("DeleteConnectionString");
bool isTest = config.GetValue("IsTest") == "Y" ? true : false;
if (isTest)
{
arcConnString = config.GetConnectionString("TestArcConnectionString");
copyConnString = config.GetConnectionString("TestCopyConnectionString");
deleteConnString = config.GetConnectionString("TestDeleteConnectionString");
}
_arcSqlCon = new SqlConnection(arcConnString);
_copySqlCon = new SqlConnection(copyConnString);
_deleteSqlCon = new SqlConnection(deleteConnString);
_archiveDay = int.Parse(config.GetValue("Day"));
_cdtDay = int.Parse(config.GetValue("CdtDay"));
_logDay = int.Parse(config.GetValue("KeepLogDay"));
_deleteRows = int.Parse(config.GetValue("DeleteRows"));
_selepTime = config.GetValue("SelepTime");
_deleteTimeOut = int.Parse(config.GetValue("DeleteTimeOut"));
// _checkMinDiffCount = int.Parse(config.GetValue("CheckMinDiffCount"));
string logPath = config.GetValue("LogPath");
_xmlPath = config.GetValue("XMLPath");
_continuteDeleteDay = int.Parse(config.GetValue("ContinueDeleteDay"));
_infoLog = new Log(logPath, LogType.Info);
_errorLog = new Log(logPath, LogType.Error);
_timeStamp = DateTime.Now.ToString("yyyyMMddHHmm");
// _isNeedExportXML = config.GetValue("IsNeedExportToXML") == "Y" ? true : false;
_isDeletSrcData = config.GetValue("IsDeleteSrcData") == "Y" ? true : false;
_mail = new Mail();
_dbName = config.GetValue("DBName");
_mailErrTitle = "Archive " + _dbName + " Error :";
string ddlPath = System.AppDomain.CurrentDomain.BaseDirectory + _dbName + ".dll";
Assembly asmb = Assembly.LoadFrom(ddlPath);
_objDBSetting = (IArchiveInterface)asmb.CreateInstance("DBSetting." + _dbName);
}
static string[] paramArr = { "P", "M","PM","MAIL","FK","?"}; //P:Prepare data ; M:Move data ; PM: P+M ; Mail : Test mail
static void Main(string[] args)
{
//TEST
//DBAcess d = new DBAcess();
//d.MoveSubData();
//TEST
//Check the ap is aleardy running...
bool is_createdNew;
Mutex mu = null;
string mutexName1 = Process.GetCurrentProcess().MainModule.FileName
.Replace(Path.DirectorySeparatorChar, '_');
mu = new Mutex(true, "Global\\" + mutexName1, out is_createdNew);
if (!is_createdNew)
{
Console.WriteLine("Archive is running, can not run again.........");
Console.WriteLine("Application will exit after 5 seconds.........");
Thread.Sleep(5000);
return;
}
//Check the ap is aleardy running...
System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();//引用stopwatch物件
sw.Start();//開始計時
mailObj = new Mail();
config = new Config();
DateTime startTime = DateTime.Now;
string param="";
// param = "P";
//IF TEST MARKED THESE
if (args.Length == 0)
{
Console.Write("Wrong parameter!!"); Console.Read(); return;
}
else
{ param = args[0].ToUpper().Replace("/", "").Replace("-", ""); }
if (Array.IndexOf(paramArr, param) == -1)
{ Console.Write("Wrong parameter!!"); Console.Read(); return; }
//IF TEST MARKED THESE
if (param.Replace("/", "").Replace("-", "") == "?")
{
Console.WriteLine(ShowHelp());
return;
}
if (param == "MAIL")
{
try
{
Console.WriteLine("Begin test mail function.... ");
mailObj.IsTest = true;
// string testBody="";
// string errMsg = errMsg + "Retry :" + i.ToString() + " ; Error Message :" + exp.Message + "<BR>";
mailObj.Send("Archive HB DB Error:" + "[DeleteDataRetry] Delete data " + "PizzaTEST" + " Error:",
"Retry :" + "1" + " <BR>Error Message:<BR>" + "Error Message" + "<BR> Delete SQL :" + "<BR>" + "deleteSql");
Console.WriteLine("Mail test successfully");
}
catch (Exception exp)
{
Console.WriteLine("Mail fail,error :" + exp.Message);
}
finally
{
Console.WriteLine("Application will exit after 5 seconds.........");
Thread.Sleep(5000);
}
return;
}
bool IsTest = config.GetValue("IsTest") == "Y" ? true : false;
string logPath = config.GetValue("LogPath");
string xmlPath = config.GetValue("XMLPath");
string dbName = config.GetValue("DBName");
if (IsTest) Console.WriteLine("Test Mode ");
Console.WriteLine("The delete source data setting is " + config.GetValue("IsDeleteSrcData"));
Console.WriteLine("Application will start after 10 seconds.........");
Thread.Sleep(1000); // prompt user the Delete DB setting, the ap will run after 10 seconds....
int intCdtDay = int.Parse(config.GetValue("CdtDay"));
int intDay = int.Parse(config.GetValue("Day"));
int intInterval = int.Parse(config.GetValue("DeleteTimeStampInterval"));
bool IsDeleteSrcData = config.GetValue("IsDeleteSrcData") == "Y" ? true : false;
if (!Directory.Exists(logPath)) Directory.CreateDirectory(logPath);
if (!Directory.Exists(xmlPath)) Directory.CreateDirectory(xmlPath);
logInfo = new Log(logPath, LogType.Info);
logError = new Log(logPath, LogType.Error); //DBName
if (config.GetValue("DBName") == "HPEDI")
{
if (IsDeleteSrcData && (intDay <15 || intCdtDay < 15)) // If the delete source data setting is Y, day must >90 (不可刪除2個月內data,防止user設定錯誤..)
{
Console.WriteLine("The delete source data setting is " + config.GetValue("IsDeleteSrcData") + ", and the day can not less then 15 ");
Console.WriteLine("Press any key to exit!! ");
Console.Read();
return;
}
}
else
{
if (IsDeleteSrcData && (intDay < 7 || intCdtDay < 7)) // If the delete source data setting is Y, day must >90 (不可刪除2個月內data,防止user設定錯誤..)
{
Console.WriteLine("The delete source data setting is " + config.GetValue("IsDeleteSrcData") + ", and the day can not less then 30 ");
Console.WriteLine("Press any key to exit!! ");
Console.Read();
return;
}
}
string strStartTime = startTime.ToString("yyyyMMddHHmm");
logInfo.WriteLog(" *************** Begin to Archive DB *************** ");
try
{
dbacess = new DBAcess();
IArchiveInterface ia = dbacess.GetDBSettingObj();
if (ia == null)
{
string err = "[Inital DBAcess error] Error : Build IArchiveInterface object error";
Console.WriteLine(err);
logError.WriteLog(err);
mailObj.Send("Warning!! Archive HP DB fail,Inital DBAcess error ", "Inital DBAcess error " + "<BR>" + err);
return;
}
}
catch(Exception exp)
{
Console.WriteLine(exp.Message);
logError.WriteLog("[Inital DBAcess error] Error :" + exp.Message);
string title = string.Format("Warning!! Archive {0} DB fail,Inital DBAcess error", dbName);
mailObj.Send(title, "Inital DBAcess error " + "\r\n" + exp.Message);
return;
}
if (param == "FK")//获取数据库所有表的外键关系 ，并存入 ArchiveAllFKConstraint
{
Console.WriteLine("Begin to get all FK table list and insert data to ArchiveAllFKConstraint.....");
dbacess.IniArchiveAllFKConstraint();
Console.WriteLine("End get all FK table successfully.....");
Console.WriteLine("Application will exit after 5 seconds.....");
Thread.Sleep(5000);
return;
}
Console.WriteLine("Begin to Archive....");
if (param == "P")
{
dbacess.InitiaIDListTable();
Console.WriteLine("Application will exit after 5 seconds.........");
Thread.Sleep(5000);
return;
}
if (param == "M" || param=="PM")
{
// dbacess.TestBulkCopy();
try
{
if (param == "PM")
{
if (!dbacess.InitiaIDListTable())// insert ArchiveIDList
{
return;
}
}
if (param == "M" && !dbacess.SetNewstTimeStamp(intInterval)) // if param=M, it means the InitiaIDListTable had been excuted before, so need not run it agian
{
Console.WriteLine("Error :Can not get newst Time Stamp!!");
mailObj.Send("Error :Can not get newst Time Stamp!!", "Error :Can not get newst Time Stamp!! Move Data can not run");
return;
}
dbacess.BeforeArchiveTableRowCount();//ArchiveTableLog ArchiveLog
dbacess.MoveOtherData();
dbacess.MoveSubData();
dbacess.MoveCdtData();
dbacess.MoveMainData();
Console.WriteLine("Finish to archive..");
Console.WriteLine("Application will exit after 5 seconds.........");
Thread.Sleep(5000);
}
catch (Exception exp)
{
mailObj.Send("Archive HB DB Error:MoveData",exp.Message);
Console.WriteLine(exp.Message);
dbacess.InsertArchiveLog("MoveData", exp.Message, LogType.Error, null);
dbacess.IsHaveError = true;
}
}
TimeSpan copyTime = DateTime.Now - startTime;
// int cost = copyTime.Minutes * 60 + copyTime.Seconds;
sw.Stop();
string cost = sw.Elapsed.TotalMinutes.ToString("f2") + "min";
dbacess.EndArchive(cost);
return;
}