private void Btn_Remove_Click(object sender, EventArgs e) { if (dgv_show.RowCount > 0) { int rownumber = dgv_show.SelectedCells[0].RowIndex; string reportname = dgv_show.Rows[rownumber].Cells[0].Value.ToString(); string reportType = dgv_show.Rows[rownumber].Cells[1].Value.ToString(); string minutes = dgv_show.Rows[rownumber].Cells[2].Value.ToString(); string hours = dgv_show.Rows[rownumber].Cells[3].Value.ToString(); string day = dgv_show.Rows[rownumber].Cells[4].Value.ToString(); string date = dgv_show.Rows[rownumber].Cells[5].Value.ToString(); string month = dgv_show.Rows[rownumber].Cells[6].Value.ToString(); StringBuilder sql = new StringBuilder(); sql.Append("delete from t_report_schedule where "); sql.Append("reportname = '" + reportname + "' and "); sql.Append("reporttype = '" + reportType + "' and "); sql.Append("Minutes = '" + minutes + "' and "); sql.Append("hours = '" + hours + "' and "); sql.Append("day = '" + day + "' and "); sql.Append("date = '" + date + "' and "); sql.Append("month = '" + month + "'"); sqlCON connect = new sqlCON(); connect.sqlExecuteNonQuery(sql.ToString(), true); dtScheduleSendMail = new DataTable(); StringBuilder sql2 = new StringBuilder(); sql2.Append("select reportname, reporttype,Minutes ,hours, day, date, month,isBodyHTML, subject,attach, comments from t_report_schedule where 1=1 "); sqlCON tf = new sqlCON(); tf.sqlDataAdapterFillDatatable(sql2.ToString(), ref dtScheduleSendMail); dgv_show.DataSource = dtScheduleSendMail; dgv_show.Refresh(); } }
private bool InsertSendMailtoRecord(ScheduleReportItems schedule, string attachFile) { StringBuilder sqlinsert = new StringBuilder(); sqlinsert.Append("insert into t_email_record "); sqlinsert.Append(@"(reportname,reporttype,Minutes,hours,day,date,month,subject,attach,inputdate) values ('"); sqlinsert.Append(schedule.ReportName + "' , '" + schedule.ReportType + "' , '" + schedule.Minutes + "' , '" + schedule.Hours + "', '" + "" + "' , '" + "" + "', '"); sqlinsert.Append("" + "' , '" + schedule.Subject + "' , '" + attachFile + "' , '" + DateTime.Now + "' )"); sqlCON insert = new sqlCON(); insert.sqlExecuteNonQuery(sqlinsert.ToString(), false); return(true); }