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