private void SetDataList(int page) { try { var mn = SLMUtil.SafeInt(cmbMonth.SelectedValue); gvResult.Columns[5].HeaderText = SlmScr053Biz.GetMonthName(mn - 5); gvResult.Columns[6].HeaderText = SlmScr053Biz.GetMonthName(mn - 4); gvResult.Columns[7].HeaderText = SlmScr053Biz.GetMonthName(mn - 3); gvResult.Columns[8].HeaderText = SlmScr053Biz.GetMonthName(mn - 2); gvResult.Columns[9].HeaderText = SlmScr053Biz.GetMonthName(mn - 1); gvResult.Columns[10].HeaderText = SlmScr053Biz.GetMonthName(mn); gvResult.Columns[11].HeaderText = SlmScr053Biz.GetMonthName(mn + 1); gvResult.Columns[12].HeaderText = SlmScr053Biz.GetMonthName(mn + 2); SlmScr053Biz bz = new SlmScr053Biz(); var lst = SlmScr053Biz.GetSearchResult(SLMUtil.SafeInt(cmbYear.SelectedValue), SLMUtil.SafeInt(cmbMonth.SelectedValue), SLMUtil.SafeInt(cmbTelesalesTeam.SelectedValue), cmbTelesales.SelectedValue); BindGridview(pcTop, gvResult, lst.ToArray(), page); } catch (Exception ex) { AppUtil.ClientAlert(this, ex.InnerException == null ? ex.Message : ex.InnerException.Message); } upResult.Update(); }
protected void btnExportExcel_Click(object sender, EventArgs e) { try { if (!ValidInput()) { return; } //DataSet resultDs; //Coment by Pom 04/07/2016 - Warning variable is never used int teleTeam = 0; int.TryParse(cmbTelesalesTeam.SelectedValue, out teleTeam); int year, month; int.TryParse(cmbYear.SelectedValue, out year); int.TryParse(cmbMonth.SelectedValue, out month); var filename = Path.GetTempPath() + "\\tmpexcel_053_" + Page.User.Identity.Name + ".xls";// Path.GetTempFileName(); var bz = new SlmScr053Biz(); if (bz.CreateExcelV2(filename, year, month, teleTeam, cmbTelesales.SelectedValue.ToString())) { // สรุปผลการต่อประกันเทียบกับ Lead รายเดือน[กรกฎาคม]_[58]_ string destFilename = string.Format("สรุปผลการต่อประกันเทียบกับ_Lead_รายเดือน[{0}]_[{1}]_{2:yyyyMMdd_HHmmss}.xls", SlmScr053Biz.GetMonthName(month), year.ToString().Substring(2, 2), DateTime.Now); ExportExcel(filename, destFilename); } else { AppUtil.ClientAlert(this, bz.ErrorMessage); } } catch (Exception ex) { string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message; // _log.Debug(message); AppUtil.ClientAlert(Page, message); } }
protected void gvResult_DataBound(object sender, EventArgs e) { if (gvResult.HeaderRow != null) { gvResult.HeaderRow.Visible = false; } var mn = SLMUtil.SafeInt(cmbMonth.SelectedValue); if (gvResult.Rows.Count == 0) { return; } GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal); TableHeaderCell cell = new TableHeaderCell(); cell.Text = "Team Code"; cell.RowSpan = 3; row.Controls.Add(cell); cell = new TableHeaderCell(); cell.RowSpan = 3; cell.Text = "Telesales"; row.Controls.Add(cell); cell = new TableHeaderCell(); cell.ColumnSpan = 13; cell.Text = string.Format("Lead คุ้มครองเดือน {0}-{1}", SlmScr053Biz.GetMonthName(mn - 5), SlmScr053Biz.GetMonthName(mn + 2)); row.Controls.Add(cell); gvResult.Controls[0].Controls.AddAt(0, row); row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal); cell = new TableHeaderCell(); cell.Text = "Port ตั้งต้น"; cell.RowSpan = 2; row.Controls.Add(cell); cell = new TableHeaderCell(); cell.RowSpan = 2; cell.Text = "Port คงค้าง"; row.Controls.Add(cell); cell = new TableHeaderCell(); cell.RowSpan = 2; cell.Text = "Port ที่ไม่ต่อประกัน"; row.Controls.Add(cell); cell = new TableHeaderCell(); cell.ColumnSpan = 8; cell.Text = "เดือนที่ชำระประกัน"; row.Controls.Add(cell); cell = new TableHeaderCell(); cell.RowSpan = 2; cell.Text = "Grand Total"; row.Controls.Add(cell); cell = new TableHeaderCell(); cell.RowSpan = 2; cell.Text = "%Success"; row.Controls.Add(cell); gvResult.Controls[0].Controls.AddAt(1, row); int month; int.TryParse(cmbMonth.SelectedValue, out month); row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal); for (int mnz = month - 5; mnz <= month + 2; mnz++) { cell = new TableHeaderCell(); cell.Text = SlmScr053Biz.GetMonthName(mnz); row.Controls.Add(cell); } gvResult.Controls[0].Controls.AddAt(2, row); }