public bool UpdateSerialInfo(SerialInfo info)
{
string strSql = string.Format("update serialInfo set portName='{0}',baudRate={1},parity={2},databits={3},stopbits={4},timeOut={5}",
info.PortName, info.BaudRate, info.Parity, info.DataBits, info.StopBits, info.TimeOut);
return(SQLiteHelper.ExecuteNonQuery(STR_CONNECTION, strSql) > 0);
}
public void InsertSerialInfo(SerialInfo info)
{
string strSql = string.Format("insert into serialInfo (portName,baudRate,parity,databits,stopbits,timeOut) values ('{0}',{1},{2},{3},{4},{5})",
info.PortName, info.BaudRate, info.Parity, info.DataBits, info.StopBits, info.TimeOut);
SQLiteHelper.ExecuteNonQuery(STR_CONNECTION, strSql);
}
public SerialInfo DecodeSerialInfo(DataSet ds)
{
DataRow dr = ds.Tables[0].Rows[0];
SerialInfo info = new SerialInfo()
{
PortName = dr["portName"].ToString(),
BaudRate = Convert.ToInt32(dr["baudRate"]),
DataBits = Convert.ToInt32(dr["databits"]),
Parity = Convert.ToInt32(dr["parity"]),
StopBits = Convert.ToInt32(dr["stopbits"]),
TimeOut = Convert.ToInt32(dr["timeOut"])
};
return(info);
}
public FormSetSerial(SerialCom com)
{
this.serial = com;
InitializeComponent();
this.serialInfo = dbhandler.GetSerialInfo();
//用配置中的连接信息初始化界面展示
this.cbPorts.Text = this.serialInfo.PortName;
this.tbDatabits.Text = this.serialInfo.DataBits.ToString();
this.cbParity.SelectedIndex = this.serialInfo.Parity;;
this.cbStopbits.SelectedIndex = this.serialInfo.StopBits;
this.tbTimeout.Text = this.serialInfo.TimeOut.ToString();
for (int i = 0; i < this.cbBaudrate.Items.Count; i++)
{
if (this.serialInfo.BaudRate != Convert.ToInt32(this.cbBaudrate.Items[i]))
{
continue;
}
this.cbBaudrate.SelectedIndex = i; break;
}
this.btnFresh_Click(null, null);
}
private void InitialSeiralInfo()
{
this.serialInfo = new DBUtility(true).GetSerialInfo();
this.btnFresh_Click(null, null);
//用配置中的连接信息初始化界面展示
this.cbPorts.Text = this.serialInfo.PortName;
this.tbDatabits.Text = this.serialInfo.DataBits.ToString();
this.cbParity.SelectedIndex = this.serialInfo.Parity;;
this.cbStopbits.SelectedIndex = this.serialInfo.StopBits;
this.tbTimeout.Text = this.serialInfo.TimeOut.ToString();
for (int i = 0; i < this.cbBaudrate.Items.Count; i++)
{
if (this.serialInfo.BaudRate != Convert.ToInt32(this.cbBaudrate.Items[i]))
{
continue;
}
this.cbBaudrate.SelectedIndex = i; break;
}
this.serial = new SerialCom();
this.DisableSendComponent(true);
}