public WS_KPISubMethod()
{
m_RTDataAccess = DBAccess.GetRealTime();
m_KPIVar = new WS_KPIVar();
m_ExpressionParse = new ExpDone();
m_DBClient = new WS_KPIDBClient();
m_KPIValueTable = m_DBClient.GetTableSchema("kpivalue");
m_TagValueTable = m_DBClient.GetTableSchema("tagvalue");
}
private static void BulkTable()
{
string BulkTable = "KPI_ECSSSnapshot";
WS_KPIDBClient DBClient = new WS_KPIDBClient();
DataTable dt = DBClient.GetTableSchema("kpivalue");
for (int i = 0; i < 10; i++) {
DataRow dr = dt.NewRow();
dr["SSID"] = i + "";
dr["UnitID"] = i + "";
dr["SeqID"] = i + "";
dr["KpiID"] = i + "";
dr["ECID"] = i + "";
dr["ECName"] = i + "";
dr["ECTime"] = i + "";
dr["ECValue"] = i;
dr["ECOpt"] = i;// System.DBNull.Value;
dr["ECOptExp"] = "ha";
dr["ECExpression"] = i;// kpiECV.ECExpression;
dr["ECScore"] = i;
dr["ECQulity"] = 0;
dr["ECPeriod"] = i + "";
dr["ECShift"] = 1 + "";
dr["ECIsRemove"] = 1;
dt.Rows.Add(dr);
ECSSValueEntity kpiECV = new ECSSValueEntity();
}
DBClient.Connection();
DBClient.DeleteData("", "", "", BulkTable);
//insert
DBClient.BulkToDB(dt, BulkTable);
DBClient.DisConnection();
}
