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