private void FormAccVoucher_Load(object sender, EventArgs e)
{
SetupBindingSource();
var HRAdapter = new VoucherExpense.DamaiDataSetTableAdapters.HRTableAdapter();
var operatorAdapter = new VoucherExpense.DamaiDataSetTableAdapters.OperatorTableAdapter();
var accTitleAdapter = new VoucherExpense.DamaiDataSetTableAdapters.AccountingTitleTableAdapter();
operatorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
accTitleAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
HRAdapter.Fill(m_DataSet.HR);
operatorAdapter.Fill(m_DataSet.Operator);
accTitleAdapter.Fill(m_DataSet.AccountingTitle);
accVoucherAdapter.Fill(m_DataSet.AccVoucher);
dateTimePicker1.MaxDate = new DateTime(MyFunction.IntHeaderYear, 12, 31);
dateTimePicker1.MinDate = new DateTime(MyFunction.IntHeaderYear, 1, 1);
if (CheckMode)
{
this.Text = "傳票查核";
blockEdit();
columnCheck.ReadOnly = false; // DataGridView裏的columnCheck
ckBoxAllowEdit.Visible = true;
}
else
{
ckBoxAllowEdit.Visible = false;
}
if (MyFunction.LockAll)
{
blockEdit();
ckBoxAllowEdit.Visible = false;
}
}
private void FormOnDutyEmployee_Load(object sender, EventArgs e)
{
var apartmentAdapter = new VoucherExpense.DamaiDataSetTableAdapters.ApartmentTableAdapter();
var HRAdapter = new VoucherExpense.DamaiDataSetTableAdapters.HRTableAdapter();
apartmentAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
try
{
apartmentAdapter.Fill(m_DataSet.Apartment);
HRAdapter.Fill(m_DataSet.HR);
OnDutyDataAdapter.Fill(m_DataSet.OnDutyData);
}
catch (Exception ex)
{
MessageBox.Show("Ex:" + ex.Message);
}
SetupBindingSource();
int index = DateTime.Now.Month - 2;
if (index < 0)
{
index = 0;
}
this.comboBoxMonth.SelectedIndex = index;
ckBoxShowAll_CheckedChanged(null, null);
//comboBoxApartment.DataSource = GetApartmentList();
}
private void FormShift_Load(object sender, EventArgs e)
{
SetupBindingSource();
var shiftDetailAdapter = new VoucherExpense.DamaiDataSetTableAdapters.ShiftDetailTableAdapter();
var hRAdapter = new VoucherExpense.DamaiDataSetTableAdapters.HRTableAdapter();
var operatorAdapter = new VoucherExpense.DamaiDataSetTableAdapters.OperatorTableAdapter();
operatorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
try
{
ShiftAdapter.Fill(m_DataSet.ShiftTable);
shiftDetailAdapter.Fill(m_DataSet.ShiftDetail);
hRAdapter.Fill(m_DataSet.HR);
operatorAdapter.Fill(m_DataSet.Operator);
}
catch (Exception ex)
{
MessageBox.Show("Ex:" + ex.Message);
}
m_MonthList.Add(new CMonthForCombo(0, " "));
for (int mon = 1; mon <= 12; mon++)
{
m_MonthList.Add(new CMonthForCombo(mon, mon.ToString() + "月"));
}
cMonthForComboBindingSource.DataSource = m_MonthList;
m_CodeList.Add(new CCodeForCombo(' '));
for (char c = 'A'; c <= 'Z'; c++)
{
m_CodeList.Add(new CCodeForCombo(c));
}
cCodeForComboBindingSource.DataSource = m_CodeList;
for (int h = 0; h < 16; h++)
{
m_HourList.Add(new CHourForCombo(h));
}
cHourForComboBindingSource.DataSource = m_HourList;
LoadCfg();
cShiftCodeBindingSource.DataSource = m_ShiftCodeList;
columnLocked.ReadOnly = !MyFunction.LockHR;
}
private void Expense_Load(object sender, EventArgs e)
{
SetupBindingSource();
var bankAccountAdapter = new VoucherExpense.DamaiDataSetTableAdapters.BankAccountTableAdapter();
var operatorAdapter = new VoucherExpense.DamaiDataSetTableAdapters.OperatorTableAdapter();
var accTitleAdapter = new VoucherExpense.DamaiDataSetTableAdapters.AccountingTitleTableAdapter();
var HRAdapter = new VoucherExpense.DamaiDataSetTableAdapters.HRTableAdapter();
operatorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
accTitleAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
bankAccountAdapter.Fill(m_DataSet.BankAccount);
operatorAdapter.Fill(m_DataSet.Operator);
accTitleAdapter.Fill(m_DataSet.AccountingTitle);
HRAdapter.Fill(m_DataSet.HR);
expenseAdapter.Fill(m_DataSet.Expense);
MyFunction.SetControlLengthFromDB(this, m_DataSet.Expense);
if (checkMode)
{
this.Text = "查核費用";
blockEdit();
expenseDataGridView.Columns["columnCheck"].ReadOnly = false;
ckBoxAllowEdit.Visible = true;
}
else
{
ckBoxAllowEdit.Visible = false;
}
if (!零用金mode)
{
bankAccountIDComboBox.Visible = true;
labelBank.Visible = true;
cbSelectBank.Enabled = true;
}
cbSelectBank.Items.Clear();
cbSelectBank.Items.Add("全部");
foreach (var r in m_DataSet.BankAccount)
{
cbSelectBank.Items.Add(r.ShowName);
}
// 資料準備好,再加上EventHandler
this.cbSelectBank.SelectedIndexChanged += new System.EventHandler(this.cbSelectBank_SelectedIndexChanged);
if (cbSelectBank.Items.Count > 1)
{
cbSelectBank.SelectedIndex = 1;
}
comboBoxMonth.SelectedIndex = DateTime.Now.Month;
if (MyFunction.LockAll)
{
blockEdit();
ckBoxAllowEdit.Visible = false;
}
// comboBoxMonth.SelectedIndex = DateTime.Now.Month;
dateTimePicker1.MaxDate = new DateTime(MyFunction.IntHeaderYear, 12, 31);
dateTimePicker1.MinDate = new DateTime(MyFunction.IntHeaderYear, 1, 1);
}
