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