public static ldbUpdStatus GetLdbUpdateStatus() { try { LiteDatabase db; db = new LiteDatabase(ldbConfig.ldbUpdateStatusConnectionString); // get old ldb ps lst LiteCollection <ldbUpdStatus> result = db.GetCollection <ldbUpdStatus>("ldbUpdStatus"); if ((result != null) && (result.Count() != 0)) { ldbUpdStatus First = new ldbUpdStatus(); foreach (var item in result.FindAll()) { return(item); } ldbUpdStatus lus = new ldbUpdStatus(); lus.Id = "1"; return(lus); } else { ldbUpdStatus lus = new ldbUpdStatus(); lus.Id = "1"; return(lus); } //db.Dispose(); } catch (Exception ex) { LogManager.SetCommonLog("GetLdbUpdateStatus:" + ex.Message.ToString()); return(null); } }
public static bool RefreshLdbQCStatistics(bool JustTodayStatistics) { try { string strToday = CommonUtility.GetNowDateFaNum(); ldbUpdStatus l = ldbRefresh.GetLdbUpdateStatus(); if ((!JustTodayStatistics) && (l.ArchiveQCStatistics_UDate == strToday)) { return(true); } //LogManager.SetCommonLog("RefreshLdbQCStatistics starting... just today="+ JustTodayStatistics); // generate new statistic List <QCStatistics> lstNewPS = StatisticsActs.GetArchiveQCStatistics(JustTodayStatistics); if (lstNewPS != null) { // get instanse of ldb LiteDatabase db; if (JustTodayStatistics) { db = new LiteDatabase(ldbConfig.ldbQCStatisticsConnectionString); } else { db = new LiteDatabase(ldbConfig.ldbArchiveQCStatisticsConnectionString); } // get old ldb ps lst LiteCollection <QCStatistics> dbPS = db.GetCollection <QCStatistics>("QCStatistics"); // delete old lst dbPS.Delete(Query.All()); // insetr new lst dbPS.Insert(lstNewPS); //LogManager.SetCommonLog("RefreshLdbQCStatistics insert successfully" + lstNewPS.Count); db.Dispose(); if (!JustTodayStatistics) { l.ArchiveQCStatistics_UDate = strToday; bool result = ldbRefresh.SetLdbUpdateStatus(l); } return(true); } else { return(false); } } catch (Exception ex) { LogManager.SetCommonLog("RefreshArchiveLdbQCStatistics_err:" + ex.Message.ToString()); return(false); } }
public static bool SetLdbUpdateStatus(ldbUpdStatus _ldbupdStause) { try { string strNow = CommonUtility.GetNowDateFaNum(); LiteDatabase db; db = new LiteDatabase(ldbConfig.ldbUpdateStatusConnectionString); // get old ldb ps lst LiteCollection <ldbUpdStatus> result = db.GetCollection <ldbUpdStatus>("ldbUpdStatus"); result.Delete(Query.All()); result.Insert(_ldbupdStause); db.Dispose(); return(true); } catch (Exception ex) { LogManager.SetCommonLog("SetLdbUpdateStatus:" + ex.Message.ToString()); return(false); } }
public static bool GenerateQCMdDPU() { try { string strToday = CommonUtility.GetNowDateFaNum(); ldbUpdStatus l = ldbRefresh.GetLdbUpdateStatus(); if (l.ArchiveGenerateQCmdDPU == strToday) { return(true); } if (DBHelper.DBConnectionIns.State == ConnectionState.Open) { DBHelper.DBConnectionIns.Close(); } if (DBHelper.DBConnectionIns.State == ConnectionState.Closed) { DBHelper.DBConnectionIns.ConnectionString = DBHelper.CnStrInsLive; DBHelper.DBConnectionIns.Open(); } OracleCommand cmd = new OracleCommand(); OracleDataAdapter da = new OracleDataAdapter(); cmd.Connection = DBHelper.DBConnectionIns; da.SelectCommand = cmd; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_GenerateQCmdDPU"; cmd.ExecuteNonQuery(); l.ArchiveGenerateQCmdDPU = strToday; bool result = ldbRefresh.SetLdbUpdateStatus(l); return(true); } catch (Exception ex) { return(false); } finally { DBHelper.DBConnectionIns.Close(); } }
public static bool RefreshLdbAuditStatisticsMDTrend() { try { string strToday = CommonUtility.GetNowDateFaNum(); ldbUpdStatus l = ldbRefresh.GetLdbUpdateStatus(); //if (l.ArchiveAuditStatisticsMDTrend_UDate == strToday) //{ // return true; //} //LogManager.SetCommonLog("RefreshLdbQCStatistics starting... just today="+ JustTodayStatistics); // generate new statistic List <AuditStatisticsMDTrend> lstNewPS = StatisticsActs.GetArchiveMDTrendAuditStatistics("841,961,962,963"); if (lstNewPS == null) { // get instanse of ldb LiteDatabase db; db = new LiteDatabase(ldbConfig.ldbArchiveAuditStatisticsConnectionString); // get old ldb ps lst LiteCollection <AuditStatisticsMDTrend> dbPS = db.GetCollection <AuditStatisticsMDTrend>("AuditStatisticsMDTrend"); // delete old lst dbPS.Delete(Query.All()); // insetr new lst dbPS.Insert(lstNewPS); //LogManager.SetCommonLog("RefreshLdbQCStatistics insert successfully" + lstNewPS.Count); db.Dispose(); l.ArchiveAuditStatisticsMDTrend_UDate = strToday; bool result = ldbRefresh.SetLdbUpdateStatus(l); } return(true); } catch (Exception ex) { LogManager.SetCommonLog("RefreshLdbAuditStatisticsMDTrend:" + ex.Message.ToString()); return(false); } }
public static bool RefreshArchiveLdbCompanyProductStatistics() { try { string strToday = CommonUtility.GetNowDateFaNum(); ldbUpdStatus l = ldbRefresh.GetLdbUpdateStatus(); if (l.ArchiveCompanyProductStatistics_UDate != strToday) { //LogManager.SetCommonLog("RefreshLdbProductStatistics_ starting..." ); // generate new statistic List <CompanyProductStatistics> lstNewPS = StatisticsActs.GetArchiveCompanyProdStatistics(); // get instanse of ldb LiteDatabase db = new LiteDatabase(ldbConfig.ldbArchiveConnectionString); // get old ldb ps lst LiteCollection <CompanyProductStatistics> dbPS = db.GetCollection <CompanyProductStatistics>("CompanyProductStatistics"); // delete old lst dbPS.Delete(Query.All()); // insetr new lst dbPS.Insert(lstNewPS); //LogManager.SetCommonLog("RefreshLdbCompanyProductStatistics_ insert successfully" + lstNewPS.Count); db.Dispose(); l.ArchiveCompanyProductStatistics_UDate = strToday; bool result = ldbRefresh.SetLdbUpdateStatus(l); return(true); } else { return(true); } } catch (Exception ex) { LogManager.SetCommonLog("RefreshArchiveLdbCompanyProductStatistics" + ex.Message.ToString()); return(false); } }
public static bool RefreshLdbASPQCCASTT(bool JustTodayStatistics) { int trc = 1; try { string strToday = CommonUtility.GetNowDateFaNum(); trc = 2; ldbUpdStatus l = ldbRefresh.GetLdbUpdateStatus(); trc = 3; if ((!JustTodayStatistics) && (l.ArchiveASPQCCASTT == strToday)) { trc = 4; return(true); } trc = 5; List <Qccastt> lstNewPS = StatisticsActs.GetASPQccastt(JustTodayStatistics); if (lstNewPS != null) { trc = 6; // get instanse of ldb LiteDatabase db; trc = 7; if (JustTodayStatistics) { db = new LiteDatabase(ldbConfig.ldbQccasttConnectionString); } else { db = new LiteDatabase(ldbConfig.ldbQCArchiveQccasttConnectionString); } trc = 8; // get old ldb ps lst LiteCollection <Qccastt> dbPS = db.GetCollection <Qccastt>("QCCASTT"); trc = 81; // delete old lst if (dbPS != null) { trc = 82; dbPS.Delete(Query.All()); trc = 83; // insetr new lst dbPS.Insert(lstNewPS); trc = 9; //LogManager.SetCommonLog("RefreshLdbQCStatistics insert successfully" + lstNewPS.Count); db.Dispose(); trc = 10; if (!JustTodayStatistics) { trc = 10; l.ArchiveASPQCCASTT = strToday; bool result = ldbRefresh.SetLdbUpdateStatus(l); trc = 11; } trc = 12; return(true); } else { return(false); } } else { return(false); } } catch (TimeoutException ex) { return(false); } catch (Exception ex) { //if (!ex.Message.Contains("timed out")) LogManager.SetCommonLog(trc.ToString() + "RefreshLdbASPQCCASTT_Err:" + JustTodayStatistics + ex.Message.ToString()); return(false); } }