private void LoadData()
{
DataTableReader dr = null;
TCommonType ctype;
cbbInType1.Items.Clear();
cbbInType2.Items.Clear();
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (SystemInfo.AdvTimeGroup)
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "103" }));
}
else
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "102" }));
}
while (dr.Read())
{
ctype = new TCommonType(dr["TimeInTypeSysID"].ToString(), dr["TimeInTypeID"].ToString(),
dr["TimeInTypeName"].ToString(), true);
cbbInType1.Items.Add(ctype);
cbbInType2.Items.Add(ctype);
}
if (SysID == "")
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "101" }));
if (dr.Read())
{
int no = 0;
int.TryParse(dr[0].ToString(), out no);
if (no > SystemInfo.MaxTimeNo)
{
no = SystemInfo.MaxTimeNo;
}
txtID.Text = no.ToString();
}
cbbInType1.SelectedIndex = 0;
cbbInType2.SelectedIndex = 0;
if (SystemInfo.AdvTimeGroup)
{
cbbInType1.SelectedIndex = 1;
cbbInType2.SelectedIndex = 1;
}
}
else
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003003, new string[] { "6", SysID }));
if (dr.Read())
{
txtID.Text = dr["MacTimeNo"].ToString();
txtName.Text = dr["MacTimeName"].ToString();
MaskedTextBox txt;
for (int i = 1; i <= 3; i++)
{
txt = (MaskedTextBox)groupBox1.Controls["txtBeginTime" + i.ToString()];
txt.Text = dr["MacTimeBeginTime" + i.ToString()].ToString();
txt = (MaskedTextBox)groupBox1.Controls["txtEndTime" + i.ToString()];
txt.Text = dr["MacTimeEndTime" + i.ToString()].ToString();
}
for (int i = 4; i <= 6; i++)
{
txt = (MaskedTextBox)groupBox2.Controls["txtBeginTime" + i.ToString()];
txt.Text = dr["MacTimeBeginTime" + i.ToString()].ToString();
txt = (MaskedTextBox)groupBox2.Controls["txtEndTime" + i.ToString()];
txt.Text = dr["MacTimeEndTime" + i.ToString()].ToString();
}
SetInTypeIndex(cbbInType1, dr["MacTimeInType1"].ToString());
SetInTypeIndex(cbbInType2, dr["MacTimeInType2"].ToString());
string binStr = Pub.DecToBin(dr["MacTimeWeekIndex"].ToString(), 7);
if (binStr.Length == 7)
{
checkBox1.Checked = binStr.Substring(6, 1) == "1";
checkBox2.Checked = binStr.Substring(0, 1) == "1";
checkBox3.Checked = binStr.Substring(1, 1) == "1";
checkBox4.Checked = binStr.Substring(2, 1) == "1";
checkBox5.Checked = binStr.Substring(3, 1) == "1";
checkBox6.Checked = binStr.Substring(4, 1) == "1";
checkBox7.Checked = binStr.Substring(5, 1) == "1";
}
if (dr["MacTimeLimit"].ToString() == "1")
{
rbLimitOne.Checked = true;
}
}
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
}
