protected void Page_Load(object sender, EventArgs e)
{
((MasterPage.SaleLead) this.Master).ShowReportMenu();
((Label)Page.Master.FindControl("lblTopic")).Text = "สรุปผลการต่อประกันเทียบ Port รายเดือน";
if (!IsPostBack)
{
//cmbTelesalesTeam.DataSource = SlmScr053Biz.GetTeamTelesaleList();
//cmbTelesalesTeam.DataBind();
//cmbTelesalesTeam.Items.Insert(0, new ListItem("ทั้งหมด", "-1"));
AppUtil.BuildCombo(cmbTelesalesTeam, SlmScr053Biz.GetTeamTelesaleList(), "ทั้งหมด", "-1");
//for(int i = -5; i <= 5; i++)
//{
// string year = DateTime.Today.AddYears(i).Year.ToString();
// cmbYear.Items.Add(new ListItem(year, year));
// cmbMonth.Items.Add(new ListItem(year, year));
//}
cmbMonth.DataSource = SlmScr053Biz.GetMonthList();
cmbMonth.DataBind();
cmbMonth.Items.Insert(0, new ListItem("ระบุ", "0"));
cmbYear.Items.Clear();
cmbYear.Items.Add(new ListItem("ระบุ", "0"));
int curyear = DateTime.Now.Year;
for (int i = 0; i < 5; i++)
{
int yr = curyear - i;
cmbYear.Items.Add(new ListItem(yr.ToString(), yr.ToString()));
}
}
}
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);
}
}
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 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);
}
