Пример #1
0
 private void MenuItemDailyReportEdit_Click(object sender, EventArgs e)
 {
     string[] reportDates = SQL.Read1DArray_SQL_Data("date", "dailyreport", "project_no ='" + g_ProjectNo + "' ORDER BY date DESC");
     if (reportDates.Length == 0)//表示這個工程目前並沒有輸入任何日報表
     {
         MessageBox.Show("此工程目前並沒有任何已存在的日報表,\r\n請重新選擇工程或建立日報表", "無法編輯", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
     }
     else
     {
         DailyReportEditForm reportEditForm = new DailyReportEditForm(g_ProjectNo);
         reportEditForm.ShowDialog();
     }
 }
        private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            DateTime dateClick = DTStartDate.AddDays(e.RowIndex);
            string morningWeather = SQL.Read_SQL_data("morning_weather", "dailyreport", "project_no = '" + g_ProjectNo + "' AND date = '" + Functions.TransferDateTimeToSQL(dateClick) + "'");
            if (morningWeather == string.Empty)//表示這天沒有日報表
            {
                DailyReportIncreaseForm reportBuildForm = new DailyReportIncreaseForm(false);
                reportBuildForm.LoadProjectInfo(g_ProjectNo);
                reportBuildForm.SetDateTodayValue(dateClick);
                reportBuildForm.ShowDialog();
                LoadProjectInfo(g_ProjectNo);
            }
            else//表示這天已經有日報表
            {
                DailyReportEditForm reportEditForm = new DailyReportEditForm(g_ProjectNo);
                reportEditForm.LoadProjectInfo(g_ProjectNo);
                reportEditForm.SetDateTodayValue(dateClick);
                reportEditForm.ShowDialog();
                LoadProjectInfo(g_ProjectNo);
            }

        }