private void btnSave_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                YearForecastBEL objBEL = new YearForecastBEL();
                for (int i = 0; i < dgCustomerDatai1.Items.Count; i++)
                {
                    DataGridCell cell0      = FunctionClass.GetCell(dgCustomerDatai1, i, 0);
                    DataGridCell cell2      = FunctionClass.GetCell(dgCustomerDatai1, i, 2);
                    TextBlock    tb0        = cell0.Content as TextBlock;
                    TextBlock    tb1        = cell2.Content as TextBlock;
                    string       customerId = tb0.Text.Trim();
                    string       forecast   = tb1.Text.Trim() == "" ? "0" : tb1.Text.Trim();
                    objBEL.CustomerId = tb0.Text.Trim();
                    objBEL.Forecast   = Convert.ToDecimal(tb1.Text.Trim());
                    objBEL.Year       = cbYear.SelectedValue.ToString();
                    YearForecastBLL.insertCustomer(objBEL);
                }

                System.Windows.Forms.MessageBox.Show("設定完畢", "Message");
            }
            catch
            {
            }
        }
 private void SetCustomerDg()
 {
     try
     {
         // Set customer year forecast datagrid
         string    selectedYear  = cbYear.SelectedValue.ToString();
         string    selectedSales = (cbSales.SelectedValue.ToString().Split('-'))[0].ToString();
         DataTable dt            = YearForecastBLL.getYearForecastByYearSales(selectedYear, selectedSales);
         dgCustomerDatai1.ItemsSource = dt.DefaultView;
         dt = null;
     }
     catch
     {
     }
 }