private void Initialize()
{
dbHost = AppSetting.LoadInitialSetting("DB_IP", "127.0.0.1");
dbUser = AppSetting.LoadInitialSetting("DB_USER", "root");
dbPass = AppSetting.LoadInitialSetting("DB_PASSWORD", "123");
dbName = AppSetting.LoadInitialSetting("DB_NAME", "huachun");
SQL = new MySQL(dbHost, dbUser, dbPass, dbName);
this.comboBoxWeatherMorning.Items.Add("晴");
this.comboBoxWeatherMorning.Items.Add("雨");
this.comboBoxWeatherMorning.Items.Add("豪雨");
this.comboBoxWeatherMorning.Items.Add("颱風");
this.comboBoxWeatherMorning.Items.Add("酷熱");
this.comboBoxWeatherMorning.SelectedIndex = 0;
this.comboBoxWeatherAfternoon.Items.Add("晴");
this.comboBoxWeatherAfternoon.Items.Add("雨");
this.comboBoxWeatherAfternoon.Items.Add("豪雨");
this.comboBoxWeatherAfternoon.Items.Add("颱風");
this.comboBoxWeatherAfternoon.Items.Add("酷熱");
this.comboBoxWeatherAfternoon.SelectedIndex = 0;
this.comboBoxConditionMorning.Items.Add("無");
this.comboBoxConditionMorning.Items.Add("停電");
this.comboBoxConditionMorning.Items.Add("停工");
this.comboBoxConditionMorning.Items.Add("補假");
this.comboBoxConditionMorning.Items.Add("選舉");
this.comboBoxConditionMorning.Items.Add("雨後泥濘");
this.comboBoxConditionMorning.SelectedIndex = 0;
this.comboBoxConditionAfternoon.Items.Add("無");
this.comboBoxConditionAfternoon.Items.Add("停電");
this.comboBoxConditionAfternoon.Items.Add("停工");
this.comboBoxConditionAfternoon.Items.Add("補假");
this.comboBoxConditionAfternoon.Items.Add("選舉");
this.comboBoxConditionAfternoon.Items.Add("雨後泥濘");
this.comboBoxConditionAfternoon.SelectedIndex = 0;
this.comboBoxNoCount.Items.Add("0");
this.comboBoxNoCount.Items.Add("0.5");
this.comboBoxNoCount.Items.Add("1");
this.comboBoxNoCount.SelectedIndex = 0;
this.comboBoxNoCountByType.Items.Add("0");
this.comboBoxNoCountByType.Items.Add("1");
this.comboBoxNoCountByType.SelectedIndex = 0;
ComputeDayOfWeek();
///////////////////////////材料使用//////////////////////////////
dataTableMaterial = new DataTable("MaterialTable");
dataTableMaterial.Columns.Add("廠商編號", typeof(String));
dataTableMaterial.Columns.Add("廠商名稱", typeof(String));
dataTableMaterial.Columns.Add("料號", typeof(String));
dataTableMaterial.Columns.Add("名稱", typeof(String));
dataTableMaterial.Columns.Add("單位", typeof(String));
dataTableMaterial.Columns.Add("位置", typeof(String));
dataTableMaterial.Columns.Add("已進數量", typeof(String));
dataTableMaterial.Columns.Add("本日進量", typeof(String));
dataTableMaterial.Columns.Add("累計進數", typeof(String));
dataTableMaterial.Columns.Add("已使用", typeof(String));
dataTableMaterial.Columns.Add("本日用量", typeof(String));
dataTableMaterial.Columns.Add("累計用量", typeof(String));
dataTableMaterial.Columns.Add("庫存", typeof(String));
dataGridViewMaterial.DataSource = dataTableMaterial;
dataGridViewMaterial.ReadOnly = false;
dataGridViewMaterial.AllowUserToAddRows = false;
dataGridViewMaterial.MultiSelect = false;
dataGridViewMaterial.EditMode = DataGridViewEditMode.EditOnKeystroke;
////////////////////////////////////////////////////////////////
dataTableManPower = new DataTable("ManPowerTable");
dataTableManPower.Columns.Add("廠商編號", typeof(String));
dataTableManPower.Columns.Add("廠商名稱", typeof(String));
dataTableManPower.Columns.Add("工別編號", typeof(String));
dataTableManPower.Columns.Add("工別名稱", typeof(String));
dataTableManPower.Columns.Add("出工人數", typeof(String));
dataTableManPower.Columns.Add("工時", typeof(String));
dataTableManPower.Columns.Add("本日工數", typeof(String));
dataTableManPower.Columns.Add("備註", typeof(String));
dataGridViewManPower.DataSource = dataTableManPower;
dataGridViewManPower.ReadOnly = false;
dataGridViewManPower.AllowUserToAddRows = false;
dataGridViewManPower.MultiSelect = false;
////////////////////////////////////////////////////////////////
dataTableTool = new DataTable("ToolTable");
dataTableTool.Columns.Add("廠商編號", typeof(String));
dataTableTool.Columns.Add("廠商名稱", typeof(String));
dataTableTool.Columns.Add("機具編號", typeof(String));
dataTableTool.Columns.Add("機具名稱", typeof(String));
dataTableTool.Columns.Add("出工數", typeof(String));
dataTableTool.Columns.Add("工時", typeof(String));
dataTableTool.Columns.Add("本日工數", typeof(String));
dataTableTool.Columns.Add("備註", typeof(String));
dataTableTool.Rows.Add(dataTableTool.NewRow());
dataGridViewTool.DataSource = dataTableTool;
dataGridViewTool.ReadOnly = true;
dataGridViewTool.AllowUserToAddRows = false;
dataGridViewTool.MultiSelect = false;
////////////////////////////////////////////////////////////////
dataTableOutsourcing = new DataTable("OutsourcingTable");
dataTableOutsourcing.Columns.Add("廠商編號", typeof(String));
dataTableOutsourcing.Columns.Add("廠商名稱", typeof(String));
dataTableOutsourcing.Columns.Add("施工編號", typeof(String));
dataTableOutsourcing.Columns.Add("施工名稱", typeof(String));
dataTableOutsourcing.Columns.Add("單位", typeof(String));
dataTableOutsourcing.Columns.Add("已出工", typeof(String));
dataTableOutsourcing.Columns.Add("出工", typeof(String));
dataTableOutsourcing.Columns.Add("累計出工", typeof(String));
dataTableOutsourcing.Columns.Add("已施作", typeof(String));
dataTableOutsourcing.Columns.Add("施作", typeof(String));
dataTableOutsourcing.Columns.Add("累計施作", typeof(String));
dataTableOutsourcing.Columns.Add("備註", typeof(String));
dataGridViewOutsourcing.DataSource = dataTableOutsourcing;
dataGridViewOutsourcing.ReadOnly = false;
dataGridViewOutsourcing.AllowUserToAddRows = false;
dataGridViewOutsourcing.MultiSelect = false;
////////////////////////////////////////////////////////////////
dataTableVacation = new DataTable("VacationTable");
dataTableVacation.Columns.Add("員工編號", typeof(String));
dataTableVacation.Columns.Add("姓名", typeof(String));
dataTableVacation.Columns.Add("休假天數", typeof(String));
dataTableVacation.Columns.Add("備註", typeof(String));
dataGridViewVacation.DataSource = dataTableVacation;
dataGridViewVacation.ReadOnly = false;
dataGridViewVacation.AllowUserToAddRows = false;
dataGridViewVacation.MultiSelect = false;
}
