protected void Page_Load(object sender, EventArgs e) { ((MasterPage.SaleLead) this.Master).ShowReportMenu(); ((Label)Page.Master.FindControl("lblTopic")).Text = "สรุปข้อมูลการชำระ"; if (!IsPostBack) { cmbTelesalesTeam.DataSource = SlmScr052Biz.GetTeamTelesaleList(); cmbTelesalesTeam.DataBind(); cmbTelesalesTeam.Items.Insert(0, new ListItem("ทั้งหมด", "-1")); cmbInsuranceCom.DataSource = SlmScr052Biz.GetInsuranceComList(); cmbInsuranceCom.DataBind(); cmbInsuranceCom.Items.Insert(0, new ListItem("ทั้งหมด", "-1")); cmbCoverageType.DataSource = SlmScr052Biz.GetCoverageTypeList(); cmbCoverageType.DataBind(); cmbCoverageType.Items.Insert(0, new ListItem("ทั้งหมด", "-1")); } }
protected void PageSearchChange(object sender, EventArgs e) { try { if (!ValidInput()) { AppUtil.ClientAlert(Page, "กรุณาเลือกวันที่กดรับเลขรับแจ้งเริ่มต้น และ วันที่กดรับเลขรับแจ้งสิ้นสุด"); return; } //DataSet resultDs; decimal teleTeam = -1, telesale = -1, insComId = -1;; decimal.TryParse(cmbTelesalesTeam.SelectedValue, out teleTeam); decimal.TryParse(cmbTelesales.SelectedValue, out telesale); decimal.TryParse(cmbInsuranceCom.SelectedValue, out insComId); int coverTypeId = -1; int.TryParse(cmbCoverageType.SelectedValue, out coverTypeId); //var resultList = SlmScr052Biz.GetSearchResult(tdStartDate.DateValue, tdEndDate.DateValue, tdIncentiveStartDate.DateValue, tdIncentiveEndDate.DateValue, tdProtectStartDate.DateValue, tdProtectEndDate.DateValue, teleTeam, cmbTelesales.SelectedValue, insComId, coverTypeId, txtCustomerName.Text, txtCustomerLastName.Text, txtContractNo.Text , out resultDs); SlmScr052Biz bz = new SlmScr052Biz(); var resultList = bz.GetSearchResult2(tdStartDate.DateValue, tdEndDate.DateValue, tdIncentiveStartDate.DateValue, tdIncentiveEndDate.DateValue, tdProtectStartDate.DateValue, tdProtectEndDate.DateValue, teleTeam, cmbTelesales.SelectedValue, insComId, coverTypeId, txtCustomerName.Text, txtCustomerLastName.Text, txtContractNo.Text); if (sender == null) { BindGridview(pcTop, gvResult, resultList.ToArray(), 1); } else { BindGridview(pcTop, gvResult, resultList.ToArray(), pcTop.SelectedPageIndex); } } catch (Exception ex) { string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message; // _log.Debug(message); AppUtil.ClientAlert(Page, message); } upResult.Update(); }
protected void btnExportExcel_Click(object sender, EventArgs e) { try { if (!ValidInput()) { AppUtil.ClientAlert(Page, "กรุณาเลือกวันที่กดรับเลขรับแจ้งเริ่มต้น และ วันที่กดรับเลขรับแจ้งสิ้นสุด"); return; } //DataSet resultDs; //Coment by Pom 04/07/2016 - Warning variable is never used decimal teleTeam = -1, telesale = -1, insComId = -1;; decimal.TryParse(cmbTelesalesTeam.SelectedValue, out teleTeam); decimal.TryParse(cmbTelesales.SelectedValue, out telesale); decimal.TryParse(cmbInsuranceCom.SelectedValue, out insComId); int coverTypeId = -1; int.TryParse(cmbCoverageType.SelectedValue, out coverTypeId); var filename = Path.GetTempPath() + "\\tmpexcel_052_" + Page.User.Identity.Name + ".xls";// Path.GetTempFileName(); var bz = new SlmScr052Biz(); if (bz.CreateExcel2(tdStartDate.DateValue, tdEndDate.DateValue, tdIncentiveStartDate.DateValue, tdIncentiveEndDate.DateValue, tdProtectStartDate.DateValue, tdProtectEndDate.DateValue, teleTeam, cmbTelesales.SelectedValue, insComId, coverTypeId, txtCustomerName.Text, txtCustomerLastName.Text, txtContractNo.Text, filename)) { ExportExcel(filename, "สรุปข้อมูลการชำระ_" + DateTime.Now.ToString("yyyyMMdd_HHmm") + ".xls"); } 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); } }