Ejemplo n.º 1
0
        public void CountThreadProc()
        {
            string    strLog = string.Empty;
            bu_Joch   bu     = new bu_Joch();
            DataTable dt     = new DataTable();

            try
            {
                int intRowNo = 0;

                if (this.running == true)
                {
                    dt = bu.GetDataTableFromEXFO(this.strConnectString, this.strDatatableName);

                    strLog = string.Format("GetSPCData开始,{0}", dtStartTime.ToString("yyyy-MM-dd HH:mm:ss") + "~" + dtEndTime.ToString("yyyy-MM-dd HH:mm:ss"));
                    //log.WriteLog(strLog, ThreadName);
                    AppLogHelp.WriteLog(LogFileFormate.MES, ThreadName + strLog);

                    dt = bu.GetSPCDataForEXFO(this.strConnectString, this.strDatatableName, dtStartTime, dtEndTime);
                    if (dt != null)
                    {
                        intRowNo = dt.Rows.Count;
                        strLog   = string.Format("GetSPCData结束,共获取{1}日期之前下的{0}条记录", intRowNo, dtStartTime.ToString("yyyy-MM-dd HH:mm:ss") + "~" + dtEndTime.ToString("yyyy-MM-dd HH:mm:ss"));
                        //log.WriteLog(strLog, ThreadName);
                        AppLogHelp.WriteLog(LogFileFormate.MES, ThreadName + strLog);
                        if (intRowNo > 0)
                        {
                            bu.BulkToDB(this.strConnectString, dt, null);
                            strLog = string.Format("Insert  SPCData结束,共同步{1}日期之前下的{0}条记录", intRowNo, dtStartTime.ToString("yyyy-MM-dd HH:mm:ss") + "~" + dtEndTime.ToString("yyyy-MM-dd HH:mm:ss"));
                            //log.WriteLog(strLog, ThreadName);
                            AppLogHelp.WriteLog(LogFileFormate.MES, ThreadName + strLog);
                        }
                    }
                    else
                    {
                        strLog = "GetSPCData结束, NULL ";
                        //log.WriteLog(strLog, ThreadName);
                        AppLogHelp.WriteLog(LogFileFormate.MES, ThreadName + strLog);
                    }
                }
            }
            catch (Exception ex)
            {
                //log.WriteErr("错误 ! " + ex.ToString(), ThreadName);
                AppLogHelp.WriteLog(LogFileFormate.MES, ThreadName + "错误 ! " + ex.ToString());
            }
            finally
            {
                //log.WriteLog("线程EXFO结束!", ThreadName);
                AppLogHelp.WriteLog(LogFileFormate.MES, ThreadName + strLog);
            }
        }
Ejemplo n.º 2
0
        public void CountThreadProc()
        {
            string strLog = string.Empty;

            try
            {
                bu_Joch bu       = new bu_Joch();
                int     intRowNo = 0;
                AutoAPP.MainForm._runnerDeleteProcess = this;
                if (this.running == true)
                {
                    intRowNo = bu.DeleteAndBackupDataByDays(dtStartTime, dtEndTime, 2, strConnectString, blnBackupData, strBackFilePath, blnDeleteEveryHour, _iPCBLimit);
                    strLog   = string.Format("删除结束,共删除{1}日期之前下的{0}条记录", intRowNo, dtStartTime.ToString("yyyy-MM-dd HH:mm:ss") + "~" + dtEndTime.ToString("yyyy-MM-dd HH:mm:ss"));
                    if (blnBackupData)
                    {
                        strLog += "\r\n  数据备份目录:" + strBackFilePath;
                    }
                    else
                    {
                        strLog += "\r\n 无数据备份!";
                    }

                    //log.WriteLog(strLog, ThreadName);
                    AppLogHelp.WriteLog(LogFileFormate.Delete, ThreadName + " :" + strLog);
                }
            }
            catch (Exception ex)
            {
                //log.WriteErr("错误 ! " + ex.ToString(), ThreadName);
                AppLogHelp.WriteError(LogFileFormate.Delete, ThreadName + "错误 ! " + ex.ToString());
                return;
            }
            finally
            {
                AppLogHelp.WriteLog(LogFileFormate.Delete, ThreadName + " :结束");
                this.running = false;
            }
        }