private void FillPageHeaderUI()
{
this.FillddlQueryNames();
DataTable mydtCategory = WebHelper.bllcategory.GetList(me.ID, 100000, "DATABASEID='" + me.DatabaseID + "'", "NAME").Tables[0];
this.ddlCategory.DataSource = mydtCategory;
this.ddlCategory.DataTextField = "NAME";
this.ddlCategory.DataValueField = "ID";
this.ddlCategory.DataBind();
//v1.2.0 - Cheong - 2016/06/23 - Do not allow people to select report groups that they can't see
//DataTable mydtRPGROUP = WebHelper.bllrpGroup.GetList(100000, "DATABASEID='" + me.DatabaseID + "'", "NAME").Tables[0];
DataTable mydtRPGROUP = WebHelper.bllrpGroup.GetList(me.ID, 100000, "DATABASEID='" + me.DatabaseID + "' AND ID IN (" + me.ReportGroup + ")", "NAME").Tables[0];
this.ddlReportGroup.DataSource = mydtRPGROUP;
this.ddlReportGroup.DataTextField = "NAME";
this.ddlReportGroup.DataValueField = "ID";
this.ddlReportGroup.DataBind();
CUSTOMRP.BLL.SOURCEVIEW bllsv = new CUSTOMRP.BLL.SOURCEVIEW();
CUSTOMRP.Model.SOURCEVIEW sv = null;
if (myReport != null)
{
sv = bllsv.GetModel(me.ID, myReport.SVID);
this.txtReportName.Text = myReport.REPORTNAME;
this.txtReportTitle.Text = myReport.RPTITLE;
this.ddlFormat.SelectedValue = myReport.DEFAULTFORMAT.ToString();
this.ddlQueryName.SelectedValue = myReport.SVID.ToString();
//v1.2.0 - Cheong - 2016/07/04 - Add option to hide duplicate items
this.chkHideDuplicate.Checked = myReport.fHideDuplicate;
this.ddlCategory.SelectedValue = myReport.CATEGORY.ToString();
this.ddlReportGroup.SelectedValue = myReport.REPORTGROUPLIST.ToString();
//this.ddlPrintType.SelectedValue = myReport.EXTENDFIELD.ToString().Split(',')[0].ToString();
}
if (this.ddlQueryName.SelectedItem != null)
{
int svid = this.ddlQueryNameChange();
sv = WebHelper.bllSOURCEVIEW.GetModel(me.ID, svid);
}
else
{
this.ddlQueryName.Items.Add(new ListItem("N/A", ""));
}
}
private bool p_fSuppressRender = false; // Whether to render page contents
#region Event Handlers
protected void Page_Init(object sender, EventArgs e)
{
if (Session[rpexcel.strSessionKeyColumnInfo] != null)
{
columninfos = (List <CUSTOMRP.Model.ColumnInfo>)Session[rpexcel.strSessionKeyColumnInfo];
}
if (Session[rpexcel.strSessionKeyFormulaFields] != null)
{
formulaFields = (List <CUSTOMRP.Model.REPORTCOLUMN>)Session[rpexcel.strSessionKeyFormulaFields];
}
else
{
formulaFields = new List <CUSTOMRP.Model.REPORTCOLUMN>();
Session[rpexcel.strSessionKeyFormulaFields] = formulaFields;
}
if ((myReport == null) && (Session[rpexcel.strSessionKeyMyReport] != null))
{
myReport = (CUSTOMRP.Model.REPORT)Session[rpexcel.strSessionKeyMyReport];
}
if (!this.IsPostBack)
{
if (!String.IsNullOrEmpty(Request.QueryString["id"]))
{
int id = Int32.Parse(Request.QueryString["id"]);
myReport = WebHelper.bllReport.GetModel(me.ID, id);
this.btnDelete.Visible = true;
if (myReport == null)
{
Common.JScript.AlertAndRedirect(AppNum.ErrorMsg.parameter_error, "rplist.aspx");
Response.End();
}
else
{
Session[rpexcel.strSessionKeyMyReport] = myReport;
CUSTOMRP.BLL.SOURCEVIEW svBLL = new CUSTOMRP.BLL.SOURCEVIEW();
mySV = svBLL.GetModel(me.ID, myReport.SVID);
}
}
else
{
// creating new report
myReport = (CUSTOMRP.Model.REPORT)Session[rpexcel.strSessionKeyMyReport];
columninfos = (List <CUSTOMRP.Model.ColumnInfo>)Session[rpexcel.strSessionKeyColumnInfo];
}
}
else
{
// v1.2.0 Kim 2016.11.22 do this both IsPostBack or not
//if ((myReport == null) && (Session[rpexcel.strSessionKeyMyReport] != null))
//{
// myReport = (CUSTOMRP.Model.REPORT)Session[rpexcel.strSessionKeyMyReport];
//}
if (!String.IsNullOrEmpty(Request.QueryString["id"]))
{
int id = Int32.Parse(Request.QueryString["id"]);
if (Session[rpexcel.strSessionKeyReportParameterContainer] != null)
{
ReportParameterContainer container = (ReportParameterContainer)Session[rpexcel.strSessionKeyReportParameterContainer];
CUSTOMRP.Model.REPORT rptFromContainer = container.GetReportModel(me, columninfos, id);
//v1.7.0 - Cheong - 2016/07/04 - Since we also need to receive setting data from rpword.aspx, instead of directly assigning
// report object decoded, we try to merge settings here instead.
#region Merge myReport data
if (myReport == null)
{
myReport = rptFromContainer;
}
else
{
myReport.REPORTNAME = rptFromContainer.REPORTNAME;
myReport.CATEGORY = rptFromContainer.CATEGORY;
myReport.REPORTGROUPLIST = rptFromContainer.REPORTGROUPLIST;
myReport.RPTITLE = rptFromContainer.RPTITLE;
myReport.EXTENDFIELD = rptFromContainer.EXTENDFIELD;
}
#endregion Merge myReport data
}
}
}
if (!IsPostBack)
{
if (myReport != null)
{
selectedColumns = myReport.ReportColumns;
}
else
{
selectedColumns = new List <CUSTOMRP.Model.REPORTCOLUMN>();
}
}
}
