private void InitializeControlValues()
{
this.baudRateComboBox.Text = this.the_strBaudRate;
this.dataBitsComboBox.Text = this.the_strDataBits;
this.parityComboBox.Items.Clear();
this.parityComboBox.Items.AddRange(Enum.GetNames(typeof(Parity)));
this.parityComboBox.Text = this.the_strParity;
this.stopBitsComboBox.Items.Clear();
this.stopBitsComboBox.Items.AddRange(Enum.GetNames(typeof(StopBits)));
this.stopBitsComboBox.Text = this.the_strStopBits;
this.portNameComboBox.Items.Clear();
string[] portNames = SerialPort.GetPortNames();
for (int i = 0; i < portNames.Length; i++)
{
string item = portNames[i];
this.portNameComboBox.Items.Add(item);
}
if (this.portNameComboBox.Items.Contains(this.the_strPortName))
{
this.portNameComboBox.Text = this.the_strPortName;
}
else
{
if (this.portNameComboBox.Items.Count > 0)
{
this.portNameComboBox.SelectedIndex = 0;
}
else
{
MyMsgBox.MsgErrorTitle("Không có Comport.\nHãy mở Comport và mở lại chương trình.", "Thông báo");
base.Close();
}
}
}
private bool InsertCallDetail(string strRegion, string strRoom, string strBed)
{
bool result;
try
{
this.strSQL = string.Concat(new object[]
{
"INSERT INTO [dbo].[CALL_DETAILS]([bed_id],[room_id],[region_id],[shift_id],[user_id],[start_call],[transaction_date]) VALUES(",
Convert.ToInt32(strBed),
",",
Convert.ToInt32(strRoom),
",",
Convert.ToInt32(strRegion),
",",
clsUtl.SHIFT_ID,
",",
clsUtl.USER_ID,
", getdate(), getdate())"
});
Console.WriteLine(this.strSQL);
this.provider.excuteNonQuery(this.strSQL);
result = true;
}
catch (Exception ex)
{
MyMsgBox.MsgErrorTitle(ex.Message, "InsertCallDetail");
result = false;
}
return(result);
}