Beispiel #1
0
        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;
        }