void CDlgBulkRegister::SaveData( ) { QStringList lstDuplication; QStringList lstTotalSql; switch ( cardType ) { case CommonDataType::MonthlyCard : SaveMonthData( lstDuplication, lstTotalSql ); break; case CommonDataType::ValueCard : SaveValueData( lstDuplication, lstTotalSql ); break; case CommonDataType::TimeCard : SaveTimeData( lstDuplication, lstTotalSql ); break; } if ( 0 < lstDuplication.count( ) ) { CCommonFunction::MsgBox( NULL, "提示", "下列卡号已存在:\r\n" + lstDuplication.join( "," ), QMessageBox::Information ); } if ( 0 < lstTotalSql.count( ) ) { ExecuteSql( lstTotalSql ); } }
void SQLCommandPanel::OnScintilaKeyDown(wxKeyEvent& event) { if ( (event.ControlDown()) && (event.GetKeyCode() == WXK_RETURN || event.GetKeyCode() == WXK_NUMPAD_ENTER)) { ExecuteSql(); } event.Skip(); }
MYSQL_RES * CMyDataBase::OpenRecordset(const char* chSql) { MYSQL_RES *rs = NULL; if (ExecuteSql(chSql)) { if ((rs = mysql_store_result(dbConn)) == NULL) { // g_log.Log(LEVEL_ERROR,"%s, [%s][%d]","µ÷ÓÃmysql_store_resultº¯Êýʧ°Ü",__FILE__,__LINE__); //g_log.Log(LEVEL_ERROR,"%s, [%s][%d]",mysql_error(&mysql),__FILE__,__LINE__); } } return rs; }
//====================================================================================================================== DatabaseResult* Database::ExecuteSynchSql(const int8* sql, ...) { int8 message[8192]; // format our sql string va_list args; va_start(args, sql); int8 localSql[8192]; /*int32 len = */vsnprintf(localSql, sizeof(localSql), sql, args); sprintf(message, "WARNING: SYNCHRONOUS SQL STATEMENT: %s",localSql); gLogger->logMsg(message, FOREGROUND_RED | FOREGROUND_GREEN | FOREGROUND_BLUE | BACKGROUND_RED); va_end(args); return ExecuteSql(localSql); }
void CDBStepNC::CreateToolDbTable() { // ExecuteSql("DROP TABLE milling_cutter"); ExecuteSql("DROP TABLE millingtooltype"); ExecuteSql("DROP TABLE materialtype"); CString sqlCreateToolTable = "CREATE TABLE milling_cutter( " "[toolid] SMALLINT NOT NULL, " "[name] TEXT(50), " "[tooltypeid] INTEGER, " "[materialid] INTEGER, " "[chuckid] INTEGER, " "[manufacturer] TEXT(50), " "[sku] TEXT(50), " "[number_of_teeth] INT, " "[hand_of_cut] TEXT(50), " "[coolant_through_tool] SMALLINT, " "[cutting_edge_length] FLOAT, " "[flute_length] FLOAT, " "[overall_length] FLOAT, " "[shoulder_length] FLOAT, " "[tip_diameter] FLOAT, " "[tool_tip_half_angle] FLOAT, " "[tool_circumference_angle] FLOAT, " "[tool_holder_diameter_for_spindle_orientation] FLOAT, " "[arbor_diameter] FLOAT, " "[pilot_diameter] FLOAT, " "[pilot_length] FLOAT, " "[edge_radius] FLOAT, " "[edge_center_vertical] FLOAT, " "[edge_center_horizontal] FLOAT, " "[sfm] FLOAT, " "[fpt] FLOAT, " "[metric] SMALLINT, " "[timeunit] SMALLINT, " "[Image] TEXT(120), " "[thread_root_diameter] FLOAT, " "[thread_angle] FLOAT, " "[direction_for_spindle_orientation] INTEGER, " "[countersink_radius] FLOAT, " "[tapered_drill_angle] FLOAT, " "[tapered_endmill_angle] FLOAT, " "[t_slot_mill_cutting_thickness] FLOAT, " "[dovetail_mill_included_angle] FLOAT, " "[woodruff_keyseat_mill_cutter_width] FLOAT, " "[side_mill_cutter_width] FLOAT, " "[tapered_tap_angle] FLOAT, " "[combined_drill_and_tap_length] FLOAT, " "[tapered_reamer_taper_angle] FLOAT, " "[combined_drill_and_reamer_length] FLOAT, " "[boring_tool_retract_movement_forbidden] SMALLINT, " "PRIMARY KEY (toolid));" ; #if 1 ExecuteSql(sqlCreateToolTable); //ExecuteSql("INSERT INTO milling_cutter ( toolid , name, tooltypeid, tip_diameter, number_of_teeth, metric) VALUES ( 1, '1/4 END MILL FLAT', 10, 0.25, 2, 0)"); //ExecuteSql("INSERT INTO milling_cutter ( toolid , name, tooltypeid, tip_diameter, number_of_teeth, metric) VALUES ( 2, '1/2 END MILL FLAT', 10, 0.5, 2, 0)"); //ExecuteSql("INSERT INTO milling_cutter ( toolid , name, tooltypeid, tip_diameter, number_of_teeth, metric) VALUES ( 3, '1/2 CENTER DRILL', 1, 0.5, 2, 0)"); CString sqlCreateToolTableType = "CREATE TABLE millingtooltype( " "[tooltypeid] INTEGER CONSTRAINT PK_ToolType PRIMARY KEY, " "[description] TEXT(50), " "[bitmask] SMALLINT " " );" ; ExecuteSql(sqlCreateToolTableType); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 1, 'CENTER DRILL')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 2, 'SPOT')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 3, 'DRILL')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 4, 'TAP-RH')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 5, 'TAP-LH')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 6, 'REAMER')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 7, 'BORING BAR')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 8, 'COUNTER BORE')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 9, 'COUNTER SINK')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 10, 'END MILL FLAT')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 11, 'END MILL SPHERE')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 12, 'END MILL BULL')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 13, 'CHAMFER MILL')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 14, 'FACE MILL')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 15, 'SLOT MILL')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 16, 'CORNER RAD MILL')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 17, 'DOVETAIL MILL')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 18, 'TAPER MILL')"); ExecuteSql("INSERT INTO millingtooltype ( tooltypeid , description) VALUES ( 19, 'LOLLIPOP MILL')"); #endif ExecuteSql("ALTER TABLE milling_cutter ADD CONSTRAINT ToolTypeRelationship FOREIGN KEY (tooltypeid) REFERENCES millingtooltype (tooltypeid))"); CString sqlCreateMaterialTable = "CREATE TABLE materialtype( " "[materialid] INTEGER CONSTRAINT PK_MaterialType PRIMARY KEY, " "[description] TEXT(50), " "[bitmask] SMALLINT, " "[hardness] FLOAT " " );" ; ExecuteSql(sqlCreateMaterialTable); //tool material (1-HSS, 2-CARBIDE, 3-COATED CAR, 4-CERAMIC, 5-BORZON, 10-UNKNOWN) ExecuteSql("INSERT INTO materialtype ( materialid , description) VALUES ( 1, 'HSS')"); ExecuteSql("INSERT INTO materialtype ( materialid , description) VALUES ( 2, 'CARBIDE')"); ExecuteSql("INSERT INTO materialtype ( materialid , description) VALUES ( 3, 'COATED CAR')"); ExecuteSql("INSERT INTO materialtype ( materialid , description) VALUES ( 4, 'CERAMIC')"); ExecuteSql("INSERT INTO materialtype ( materialid , description) VALUES ( 5, 'BORZON')"); ExecuteSql("INSERT INTO materialtype ( materialid , description) VALUES ( 10, 'UNKONWN')"); }
void SQLCommandPanel::OnExecuteSQL(wxCommandEvent& e) { wxUnusedVar(e); ExecuteSql(); }
void SQLCommandPanel::OnExecuteClick(wxCommandEvent& event) { ExecuteSql(); }