public static bool Save_Palette(ctrlPalette PalettenUserControl) { bool bRet = false; cDB_SQL_CE qry = null; try { qry = new cDB_SQL_CE(cDB_Settings.CE_ConnectionString); qry.ADD("Wiegung_Sum_Kg", PalettenUserControl.objBeladungsDaten.dWiegung_Gesamtgewicht); qry.ADD("Wiegung_Sum_Stk", PalettenUserControl.objBeladungsDaten.iWiegung_Gesamtanzahl); qry.UPDATE_THROW("SMT_WIEGUNG", "Wiegung_PalNr", PalettenUserControl.objBeladungsDaten.iPalettenNr, "Save_Palette", 99); } catch (Exception ex) { SiAuto.LogException("cWiegung_Handling.Save_Palette", ex); throw; } finally { if (qry != null) { qry.FREE(); } } return(bRet); }
private static void CreateKey(string sName) { cDB_SQL_CE qry = null; try { qry = new cDB_SQL_CE(cDB_Settings.CE_ConnectionString); qry.ADD("Reihenfolge", 0); qry.ADD("Fieldname", sName); qry.ADD("Value_Type", "TX"); qry.ADD("Field_Value", "0"); qry.INSERT_THROW("SMT_SETTINGS", false, "", 1); } catch (Exception ex) { } finally { if (qry != null) { qry.FREE(); } } }