public static bool prepare_user_setting_file() { bool b_return = false; // source_user_setting_folder = Path.Combine(startup_path, @"mmhis\setting\user_setting_template"); program_setting_folder = Path.Combine(temp_folder, @"mmhis\setting\program_setting"); program_script_folder = Path.Combine(temp_folder, @"mmhis\setting\program_script"); user_setting_folder = Path.Combine(temp_folder, @"mmhis\setting\" + user_id); // sqlite files // source_window_and_data_field_user_setting_pathname = Path.Combine(source_user_setting_folder, "mmhis_window_and_data_field_user_setting"); // source_control_text_user_setting_pathname = Path.Combine(source_user_setting_folder, "mmhis_control_text_user_setting"); pointer_program_setting_pathname = Path.Combine(program_setting_folder, "mmhis_pointer_program_setting"); data_field_format_program_setting_pathname = Path.Combine(program_setting_folder, "mmhis_data_field_format_program_setting"); window_and_data_field_user_setting_pathname = Path.Combine(user_setting_folder, "mmhis_window_and_data_field_user_setting"); control_text_user_setting_pathname = Path.Combine(user_setting_folder, "mmhis_control_text_user_setting"); b_return = load_pointer_and_control_text(); if (b_return) { play_mmhis_data_frameindex_only_script = utility.load_script(script("play_mmhis_data_frameindex_only"))[0]; play_mmhis_data_all_script = utility.load_script(script("play_mmhis_data_all"))[0]; tech_serv_data_processing_modules.traffic_data_processing_general tdpg = new tech_serv_data_processing_modules.traffic_data_processing_general(); try { tdpg.initialize_generic_members("sqlite"); tdpg.construct_connection_string("", "", "", window_and_data_field_user_setting_pathname); tdpg.open_conn_cmd(0); tdpg.cmd[0].CommandText = utility.load_script(setting.script("check_table_validity_mmhis_data_field"))[0]; tdpg.reader[0] = tdpg.cmd[0].ExecuteReader(); tdpg.reader[0].Close(); tdpg.cmd[0].CommandText = utility.load_script(setting.script("check_table_validity_mmhis_window"))[0]; tdpg.reader[0] = tdpg.cmd[0].ExecuteReader(); tdpg.reader[0].Close(); } catch (Exception eee) { Console.WriteLine(eee.Message); tdpg.close_conn_cmd(0); b_return = false; // Directory.CreateDirectory(user_setting_folder); // File.Copy(source_window_and_data_field_user_setting_pathname, window_and_data_field_user_setting_pathname, true); } } if (b_return) { b_return = load_data_field_format("english"); } return(b_return); }
// save contents in d into the "dictionary" table in db public static bool do_save_dictionary( string db, Dictionary <string, string> d ) { bool b_return = false; string the_value = null; tech_serv_data_processing_modules.traffic_data_processing_general tdpg = new tech_serv_data_processing_modules.traffic_data_processing_general(); try { tdpg.initialize_generic_members("sqlite"); tdpg.construct_connection_string("", "", "", db); tdpg.open_conn_cmd(0); tdpg.cmd[0].CommandText = "update dictionary set value=@value, time_stamp=@time_stamp where key=@key and value<>@value"; ((SQLiteCommand)tdpg.cmd[0]).Parameters.Add("key", System.Data.DbType.String); ((SQLiteCommand)tdpg.cmd[0]).Parameters.Add("value", System.Data.DbType.String); ((SQLiteCommand)tdpg.cmd[0]).Parameters.Add("time_stamp", System.Data.DbType.Int64); foreach (string key in d.Keys) { if (d.TryGetValue(key, out the_value)) { ((SQLiteCommand)tdpg.cmd[0]).Parameters["key"].Value = key; ((SQLiteCommand)tdpg.cmd[0]).Parameters["value"].Value = the_value; ((SQLiteCommand)tdpg.cmd[0]).Parameters["time_stamp"].Value = DateTime.Now.Ticks; tdpg.cmd[0].ExecuteNonQuery(); } } b_return = true; } catch { b_return = false; } finally { try { tdpg.reader[0].Close(); } catch { } try { tdpg.close_conn_cmd(0); } catch { } } return(b_return); }
private void choose_field_specifier_Load(object sender, EventArgs e) { tech_serv_data_processing_modules.traffic_data_processing_general tdpg = new tech_serv_data_processing_modules.traffic_data_processing_general(); tdpg.initialize_generic_members("sqlite"); try { if (which_specifier == "field") { tdpg.construct_connection_string("", "", "", setting.data_field_format_program_setting_pathname); tdpg.open_conn_cmd(0); Text = "Choose Field Specifier"; tdpg.cmd[0].CommandText = "select field_specifier as specifier from mmhis_data_field_format"; } else if (which_specifier == "window") { tdpg.construct_connection_string("", "", "", setting.window_and_data_field_user_setting_pathname); tdpg.open_conn_cmd(0); Text = "Choose Window Specifier"; tdpg.cmd[0].CommandText = "select window_specifier as specifier from mmhis_window"; } else { Close(); } tdpg.reader[0] = tdpg.cmd[0].ExecuteReader(); while (tdpg.reader[0].Read()) { listBox_field_specifier.Items.Add(tdpg.reader[0][0].ToString()); } } catch { } finally { try { tdpg.reader[0].Close(); } catch { } try { tdpg.close_conn_cmd(0); } catch { } } }
// load into "dictionary_data_field_format" public static bool load_data_field_format( string unit_system // can only be "english" or "metric" ) { bool b_return = false; dictionary_data_field_format.Clear(); tech_serv_data_processing_modules.traffic_data_processing_general tdpg = new tech_serv_data_processing_modules.traffic_data_processing_general(); tdpg.initialize_generic_members("sqlite"); try { tdpg.construct_connection_string("", "", "", setting.data_field_format_program_setting_pathname); tdpg.open_conn_cmd(0); tdpg.cmd[0].CommandText = "select * from mmhis_data_field_format"; tdpg.reader[0] = tdpg.cmd[0].ExecuteReader(); while (tdpg.reader[0].Read()) { data_field_format the_data_field_format = new data_field_format(); the_data_field_format.field_specifier = tdpg.reader[0]["field_specifier"].ToString(); the_data_field_format.caption_suggestion = tdpg.reader[0]["caption_suggestion"].ToString(); the_data_field_format.value_format = tdpg.reader[0]["value_format_" + unit_system].ToString(); the_data_field_format.unit = tdpg.reader[0]["unit_" + unit_system].ToString(); the_data_field_format.conversion_factor = utility.get_double(tdpg.reader[0]["conversion_factor_" + unit_system], 1.0); dictionary_data_field_format.Add(the_data_field_format.field_specifier, the_data_field_format); } b_return = true; } catch { b_return = false; } finally { try { tdpg.reader[0].Close(); } catch { } try { tdpg.close_conn_cmd(0); } catch { } } return(b_return); }
// load contents in the "dictionary" table in db into d public static bool do_load_dictionary( string db, Dictionary <string, string> d ) { bool b_return = false; tech_serv_data_processing_modules.traffic_data_processing_general tdpg = new tech_serv_data_processing_modules.traffic_data_processing_general(); try { tdpg.initialize_generic_members("sqlite"); tdpg.construct_connection_string("", "", "", db); tdpg.open_conn_cmd(0); tdpg.cmd[0].CommandText = "select key, value from dictionary"; tdpg.reader[0] = tdpg.cmd[0].ExecuteReader(); d.Clear(); while (tdpg.reader[0].Read()) { d.Add( tdpg.reader[0]["key"].ToString(), tdpg.reader[0]["value"].ToString() ); } b_return = true; } catch { b_return = false; } finally { try { tdpg.reader[0].Close(); } catch { } try { tdpg.close_conn_cmd(0); } catch { } } return(b_return); }