public Object_Discount_Card(ProkardModel model) { try { this._model = model; this._config.Add("tableName", "Discount_Card"); this._fields.Add("races", 0); this._fields.Add("discount", 0); this._fields.Add("owner", String.Empty); this._fields.Add("number", String.Empty); this._fields.Add("seller", String.Empty); this._fields.Add("referent", String.Empty); this._fields.Add("salePlace", String.Empty); this._fields.Add("createDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); } catch (Exception e) { Console.WriteLine(e.Message); } }
public void testClass11() { Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); string connStr = config.AppSettings.Settings["crazykartConnectionString"].Value; string[] connstStrings = connStr.Trim().Split(';'); string connNew = ""; if (connstStrings.Length == 4) { connNew = String.Format("{0};{1};", connstStrings[0], connstStrings[2]); } SqlConnection myConnection = new SqlConnection(connNew); string dbname = myConnection.Database; try { myConnection.Open(); } catch (Exception e) { MessageBox.Show(e.ToString()); } var dblist = myConnection.GetSchema("Databases"); string[] sysdbs = new[] { "master", "model", "msdb", "tempdb" }; foreach (DataRow database in dblist.Rows) { String databaseName = database.Field <String>("database_name"); if (!sysdbs.Contains(databaseName)) { //comboBox6. } short dbID = database.Field <short>("dbid"); DateTime creationDate = database.Field <DateTime>("create_date"); } ProkardModel form = new ProkardModel(); Hashtable sett = form.LoadSettings(); //Console.WriteLine(sett["decoder"]); // настройки транспондеров string path = "transetts.xml"; if (File.Exists(path)) { DataSet ds = new DataSet(); ds.ReadXml(path); foreach (DataRow row in ds.Tables[0].Rows) { if (row.ItemArray[0].ToString().Trim() == sett["decoder"].ToString().Trim()) { decoderSetts = row.ItemArray; } } } // 0 - name protokol // 1 - bytes (32) // 2 - hours 1 // 3 - minutes 1 // 4 - seconds 1 // 5 - transponder // 6 - mseconds // 7 - hits // 8 - port speed // 9 - bits // 10 - StopBits int portSpeed = Convert.ToInt32(decoderSetts[8]); int bits = Convert.ToInt32(decoderSetts[9]); // var stopBits = null; //if (Convert.ToInt32(decoderSetts[9]) == 1) // { // stopBits = StopBits.One; // } // string stopBits = decoderSetts[10].ToString(); RS232 = new SerialPort(Convert.ToString("COM4"), portSpeed, Parity.None, bits, StopBits.One); // RS232.ReadBufferSize = 32; // RS232.RtsEnable = true; RS232.DataReceived += new SerialDataReceivedEventHandler(RS232_DataReceived); RS232.Open(); }