public void loadReportDef()
{
string record = this.Request["record"]; //rpcd
rpexrpdpBll bll = new rpexrpdpBll();
trpexrpdf def = bll.GetSelectedObject <trpexrpdf>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "rpcd", ColumnValue = record
}
});
List <trpexrpdd> lstDtl = bll.GetSelectedRecords <trpexrpdd>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "rpcd", ColumnValue = record
},
new ColumnInfo()
{
ColumnName = "isqr", ColumnValue = "Y"
}
});
string message = "{status:'success',msg:'" + responseJson(def, lstDtl).Replace("'", "\\'") + "'}";
Response.Write(message);
}
private void LoadData(string rpcd, List <ColumnInfo> lstParameters)
{
BaseBll bll = new BaseBll();
trpexrpdf def = bll.GetSelectedObject <trpexrpdf>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "rpcd", ColumnValue = rpcd
}
});
List <trpexrpdd> lstDtl = bll.GetSelectedRecords <trpexrpdd>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "rpcd", ColumnValue = rpcd
}
});
rpexrpdpBll rpbll = new rpexrpdpBll();
DataSet ds = null;
switch (def.rpty)
{
case "Personnel":
ds = rpbll.GetPersonalData(rpcd, lstDtl, lstParameters);
break;
case "Payroll":
ds = rpbll.GetPayrollData(rpcd, lstDtl, lstParameters);
break;
case "PayrollBankAlloc":
ds = rpbll.GetPayrollBankAllocData(rpcd, lstDtl, lstParameters);
break;
}
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//Title
this.GridView1.Caption = "<B>" + def.rptt + "</B>";
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
//Merge Column
MergeGridView mergeGV = new MergeGridView();
for (int i = 0; i < lstDtl.Count; i++)
{
if (lstDtl[i].isme == "Y")
{
mergeGV.Merge(this.GridView1, i);
}
}
//Summary
var q = (from p in lstDtl
where p.issu == "Y"
select p).ToList();
for (int i = 0; i < q.Count; i++)
{
//GridViewSummary sum = new GridViewSummary(q[i].itnm, SummaryOperation.Sum);
}
}
else
{
}
}
