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