public void saveRecord(int issId, ssRecord ssR) { string sqlStr = "Update Saldostand set Saldostand_StatusId=@2, Saldostand_DispStatus=@3, Saldostand_JgegIdg=@4, Saldostand_BgnrId=@5, " + "Saldostand_Datum=@6, SaldosStand_Saldo=@7, Saldostand_Mutatiedatum=@8, Saldostand_Opmerking=@9 Where Saldostand_Id=@1"; string sCs = "Data Source=" + gv.sDataFilePad + ";Version=3;New=False;"; using (SQLiteConnection dbcDa = new SQLiteConnection(sCs)) { dbcDa.Open(); try { using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa)) { sqlCmd.Parameters.AddWithValue("@1", issId); sqlCmd.Parameters.AddWithValue("@2", ssR.Saldostand_StatusId); sqlCmd.Parameters.AddWithValue("@3", ssR.Saldostand_DispStatus); sqlCmd.Parameters.AddWithValue("@4", ssR.Saldostand_JgegId); sqlCmd.Parameters.AddWithValue("@5", ssR.Saldostand_BgnrId); sqlCmd.Parameters.AddWithValue("@6", ssR.Saldostand_Datum); sqlCmd.Parameters.AddWithValue("@7", ssR.Saldostand_Saldo); sqlCmd.Parameters.AddWithValue("@8", ssR.Saldostand_Mutatiedatum); sqlCmd.Parameters.AddWithValue("@9", ssR.Saldostand_Opmerking); sqlCmd.ExecuteNonQuery(); } } catch (Exception) { } dbcDa.Close(); } }
private void recordsInList(SQLiteDataReader r) { ssRecord ssr = new ssRecord(); lstSaldoStandRecord.Clear(); while (r.Read()) { //Maak list van geselecteerde rijen ssr.Saldostand_Id = r.GetInt32(r.GetOrdinal("Saldostand_Id")); ssr.Saldostand_StatusId = r.GetInt32(r.GetOrdinal("Saldostand_StatusId")); ssr.Saldostand_DispStatus = r.GetString(r.GetOrdinal("Saldostand_DispStatus")); ssr.Saldostand_JgegId = r.GetInt32(r.GetOrdinal("Saldostand_JgegId")); ssr.Saldostand_BgnrId = r.GetInt32(r.GetOrdinal("Saldostand_BgnrId")); ssr.Saldostand_Datum = r.GetDateTime(r.GetOrdinal("Saldostand_Datum")); ssr.Saldostand_Saldo = r.GetDecimal(r.GetOrdinal("Saldostand_Saldo")); ssr.Saldostand_Mutatiedatum = r.GetDateTime(r.GetOrdinal("Saldostand_Mutatiedatum")); ssr.Saldostand_Opmerking = ""; try { ssr.Saldostand_Opmerking = r.GetString(r.GetOrdinal("Saldostand_Opmerking")); } catch (Exception) { } lstSaldoStandRecord.Add(ssr); } }
public int newssRecord() { pf pf = new pf(); ssRecord dss = new ssRecord(); dss = vulDefaultSs(); int newssId = new int(); string sCs = "Data Source=" + gv.sDataFilePad + ";Version=3;New=False;"; using (SQLiteConnection dbcDa = new SQLiteConnection(sCs)) { dbcDa.Open(); string findstring = pf.randomString(6); string sqlStr = "Insert Into Saldostand (Saldostand_StatusId, Saldostand_DispStatus, Saldostand_JgegId, " + "Saldostand_BgnrId, Saldostand_Datum, Saldostand_Saldo, Saldostand_Mutatiedatum, Saldostand_Opmerking) Values " + "(@2, @3, @4, @5, @6, @7, @8, @9)"; using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa)) { SQLiteParameter p2 = new SQLiteParameter(); p2.ParameterName = "@2"; p2.Value = 165009; sqlCmd.Parameters.Add(p2); SQLiteParameter p3 = new SQLiteParameter(); p3.ParameterName = "@3"; p3.Value = "Saldostand-record is leeg / Tabelinitrecord"; sqlCmd.Parameters.Add(p3); SQLiteParameter p4 = new SQLiteParameter(); p4.ParameterName = "@4"; p4.Value = 1; sqlCmd.Parameters.Add(p4); SQLiteParameter p5 = new SQLiteParameter(); p5.ParameterName = "@5"; p5.Value = 1; sqlCmd.Parameters.Add(p5); SQLiteParameter p6 = new SQLiteParameter(); p6.ParameterName = "@6"; p6.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p6); SQLiteParameter p7 = new SQLiteParameter(); p7.ParameterName = "@7"; p7.Value = 0; sqlCmd.Parameters.Add(p7); SQLiteParameter p8 = new SQLiteParameter(); p8.ParameterName = "@8"; p8.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p8); SQLiteParameter p9 = new SQLiteParameter(); p9.ParameterName = "@9"; p9.Value = findstring; sqlCmd.Parameters.Add(p9); sqlCmd.ExecuteNonQuery(); dbcDa.Close(); } // Zoek toegevoegde record tblSs ss = new tblSs(); ss.zoekSaldoStandRecord("Saldostand_Opmerking = " + "\"" + findstring + "\""); newssId = ss.lstSaldoStandRecord[0].Saldostand_Id; // Verwijder infor uit Opmerking-veld dbcDa.Open(); sqlStr = "Update Saldostand set Saldostand_Opmerking=@8 where Saldostand_Id = @1;"; using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa)) { sqlCmd.Parameters.AddWithValue("@1", newssId); sqlCmd.Parameters.AddWithValue("@8", ""); sqlCmd.ExecuteNonQuery(); } dbcDa.Close(); return(newssId); } }
public ssRecord vulDefaultSs() { pf pf = new pf(); ssRecord ssRec = new ssRecord(); ssRec.Saldostand_StatusId = 165009; ssRec.Saldostand_DispStatus = "Saldostand-record is leeg / Tabelinitrecord"; ssRec.Saldostand_JgegId = 1; ssRec.Saldostand_BgnrId = 1; ssRec.Saldostand_Datum = DateTime.Parse("2000-01-01 00:00:00"); ssRec.Saldostand_Saldo = 0; ssRec.Saldostand_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00"); ssRec.Saldostand_Opmerking = ""; return(ssRec); }
public ssRecord vanRecord(int recNr) { ssRecord ssRec = new ssRecord(); ssRec.Saldostand_Id = lstSaldoStandRecord[recNr].Saldostand_Id; ssRec.Saldostand_StatusId = lstSaldoStandRecord[recNr].Saldostand_StatusId; ssRec.Saldostand_DispStatus = lstSaldoStandRecord[recNr].Saldostand_DispStatus; ssRec.Saldostand_JgegId = lstSaldoStandRecord[recNr].Saldostand_JgegId; ssRec.Saldostand_BgnrId = lstSaldoStandRecord[recNr].Saldostand_BgnrId; ssRec.Saldostand_Datum = lstSaldoStandRecord[recNr].Saldostand_Datum; ssRec.Saldostand_Saldo = lstSaldoStandRecord[recNr].Saldostand_Saldo; ssRec.Saldostand_Mutatiedatum = lstSaldoStandRecord[recNr].Saldostand_Mutatiedatum; ssRec.Saldostand_Opmerking = lstSaldoStandRecord[recNr].Saldostand_Opmerking; return(ssRec); }