public Result InsertRecordToDb(InsertSqlRecordModel insertRecord) { using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + dbPath)) { connection.Open(); var sql = insertRecord.CreateSqlInsertCmd(); using (SQLiteCommand cmd = new SQLiteCommand(sql, connection)) { try { cmd.ExecuteNonQuery(); } catch (Exception ex) { return(new Result { success = false, msg = ex.Message }); } } } return(new Result { success = true }); }
public Result InsertSupplyRowsToDb(int app_doc_id, ApplicationDocumentRow[] appDocRows) { using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + dbPath)) { connection.Open(); foreach (var item in appDocRows) { var ins = new SqlFieldModel[] { new SqlFieldModel { fieldName = SUPPLY_DETAIL_TABLE.app_doc_id, fieldValue = app_doc_id }, new SqlFieldModel { fieldName = SUPPLY_DETAIL_TABLE.good_guid, fieldValue = "'" + item.good_guid + "'" }, new SqlFieldModel { fieldName = SUPPLY_DETAIL_TABLE.good_name, fieldValue = "'" + item.good_name + "'" }, new SqlFieldModel { fieldName = SUPPLY_DETAIL_TABLE.barcode, fieldValue = "'" + item.barcode + "'" }, new SqlFieldModel { fieldName = SUPPLY_DETAIL_TABLE.good_count_doc, fieldValue = item.good_count_doc }, new SqlFieldModel { fieldName = SUPPLY_DETAIL_TABLE.good_count_fact, fieldValue = item.good_count_fact }, new SqlFieldModel { fieldName = SUPPLY_DETAIL_TABLE.akcis, fieldValue = item.akcis ? 1 : 0 }, new SqlFieldModel { fieldName = SUPPLY_DETAIL_TABLE.dopis, fieldValue = item.dopis ? 1 : 0 }, new SqlFieldModel { fieldName = SUPPLY_DETAIL_TABLE.roworder, fieldValue = 0 } }; var insertRecord = new InsertSqlRecordModel { tableName = SUPPLY_DETAIL_TABLE.table_name, Fields = ins }; var sql = insertRecord.CreateSqlInsertCmd(); using (SQLiteCommand cmd = new SQLiteCommand(sql, connection)) { try { cmd.ExecuteNonQuery(); } catch (Exception ex) { return(new Result { success = false, msg = "Ошибка добавления в базу:" + Environment.NewLine + item.good_name + Environment.NewLine + ex.Message }); } } } } return(new Result { success = true }); }