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 { } }
public static Int32 insertCustomer(YearForecastBEL objBel) { YearForecastDAL objDal = new YearForecastDAL(); try { return(objDal.insertYearForecast(objBel)); } catch (Exception ex) { throw; } finally { objDal = null; } }
public Int32 insertYearForecast(YearForecastBEL objBEL) { int result; try { SqlCommand cmd = new SqlCommand("dbo.sp_insertYearForecast", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CustomerId", objBEL.CustomerId); cmd.Parameters.AddWithValue("@Year", objBEL.Year); cmd.Parameters.AddWithValue("@Forecast", objBEL.Forecast); if (con.State == ConnectionState.Closed) { con.Open(); } result = cmd.ExecuteNonQuery(); cmd.Dispose(); if (result > 0) { return(result); } else { return(0); } } catch (Exception ex) { throw; } finally { if (con.State != ConnectionState.Closed) { con.Close(); } } }