private void FormOperator_Load(object sender, EventArgs e)
{
try
{
operatorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
authListAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
operatorAdapter.Fill(m_DataSet.Operator);
authListAdapter.Fill(m_DataSet.OperatorAuthList);
var apartment = new DamaiDataSetTableAdapters.ApartmentTableAdapter();
apartment.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
apartment.Fill(m_DataSet.Apartment);
this.operatorBindingSource.DataSource = m_DataSet;
MyFunction.SetFieldLength(operatorDataGridView, m_DataSet.Operator);
}
catch (Exception ex)
{
MessageBox.Show("載入操作員權限錯誤:" + ex.Message);
}
}
private bool ReadTable()
{
operatorSQLAdapter = new DamaiDataSetTableAdapters.OperatorTableAdapter();
headerSQLAdapter = new DamaiDataSetTableAdapters.VEHeaderTableAdapter();
apartmentSQLAdapter = new DamaiDataSetTableAdapters.ApartmentTableAdapter();
authListSQLAdapter = new DamaiDataSetTableAdapters.OperatorAuthListTableAdapter();
operatorSQLAdapter.Connection.ConnectionString = DB.SqlConnectString(m_Cfg);
apartmentSQLAdapter.Connection.ConnectionString = DB.SqlConnectString(m_Cfg);
authListSQLAdapter.Connection.ConnectionString = DB.SqlConnectString(m_Cfg);
damaiDataSet = new DamaiDataSet();
try
{
operatorSQLAdapter.Fill(damaiDataSet.Operator);
headerSQLAdapter.Fill(damaiDataSet.VEHeader);
apartmentSQLAdapter.Fill(damaiDataSet.Apartment);
authListSQLAdapter.Fill(damaiDataSet.OperatorAuthList);
}
catch (Exception ex)
{
MessageBox.Show("操作員資料庫讀取錯誤<" + ex.Message + ">! 無法登入");
return(false);
}
if (damaiDataSet.Operator.Rows.Count == 0)
{
MessageBox.Show("資料庫內沒有設定任何操作員,無法登入");
Close();
return(false);
}
if (damaiDataSet.Apartment.Rows.Count != 0)
{
string Key = "LordAlex";
foreach (var a in damaiDataSet.Apartment)
{
byte[] buf = Encoder.RC2Decrypt(Convert.FromBase64String(a.DatabaseName.Trim()), Key);
string decoded = Encoding.Unicode.GetString(buf);
if (decoded == m_Cfg.Database.Trim()) // 不使用IsCurrent了
{
m_DefaultApartment = a;
break;
}
}
if (m_DefaultApartment == null)
{
MessageBox.Show("部門資料庫內找不到<" + m_Cfg.Database + ">,設定有誤無法登入,請找IT帥哥!");
#if (DEBUG)
m_DefaultApartment = damaiDataSet.Apartment[9];
#else
Close();
return(false);
#endif
}
}
DamaiDataSet.VEHeaderRow header = null;
string sVersion = "";
if (damaiDataSet.VEHeader.Count > 0)
{
header = damaiDataSet.VEHeader[0];
if (!header.IsVersionNull())
{
sVersion = header.Version.Trim();
}
}
CheckAppVersion(sVersion);
return(true);
}
