private void LoadData(string hccd) { pshctcfgBll bll = new pshctcfgBll(); tpshctcfg cfg = bll.GetSelectedObject <tpshctcfg>(new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "hccd", ColumnValue = hccd } }); tstdefcfg xdef = bll.GetSelectedObject <tstdefcfg>(new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "dfnm", ColumnValue = cfg.xdef } }); tstdefcfg ydef = bll.GetSelectedObject <tstdefcfg>(new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "dfnm", ColumnValue = cfg.ydef } }); ValueInfoBll dd = new ValueInfoBll(); List <ValueInfo> lstX = typeof(ValueInfoBll).GetMethod(xdef.dasc).Invoke(dd, new object[] { }) as List <ValueInfo>; List <ValueInfo> lstY = typeof(ValueInfoBll).GetMethod(ydef.dasc).Invoke(dd, new object[] { }) as List <ValueInfo>; //Build Grid Header //BuildGridHeader(lstX); rphctctlBll rpbll = new rphctctlBll(); string strXML = rpbll.GetData(hccd, cfg, xdef, ydef, lstX, lstY); DataSet ds = new DataSet(); XmlReader reader = XmlReader.Create(new System.IO.StringReader(strXML)); ds.ReadXml(reader); this.GridView1.DataSource = ds; this.GridView1.DataBind(); //GroupRows(this.GridView1, 0); MergeGridView mergeGV = new MergeGridView(); mergeGV.Merge(this.GridView1, 0); }
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 { } }