private void BindData()
{
DataTable dt = GetData();
if (dt.Rows.Count > 0)
{
SettlementGrid.DataSource = dt;
SettlementGrid.Columns[0].FooterText = "Total";
SettlementGrid.Columns[1].FooterText = dt.Compute("SUM(iOCE)", "").ToString();
SettlementGrid.Columns[2].FooterText = dt.Compute("SUM(OCE)", "").ToString();
SettlementGrid.Columns[3].FooterText = dt.Compute("SUM(iICE)", "").ToString();
SettlementGrid.Columns[4].FooterText = dt.Compute("SUM(ICE)", "").ToString();
SettlementGrid.Columns[5].FooterText = dt.Compute("SUM(iORE)", "").ToString();
SettlementGrid.Columns[6].FooterText = dt.Compute("SUM(ORE)", "").ToString();
SettlementGrid.Columns[7].FooterText = dt.Compute("SUM(iIRE)", "").ToString();
SettlementGrid.Columns[8].FooterText = dt.Compute("SUM(IRE)", "").ToString();
SettlementGrid.Columns[9].FooterText = dt.Compute("SUM(OCEApr)", "").ToString();
SettlementGrid.Columns[10].FooterText = dt.Compute("SUM(ICEApr)", "").ToString();
SettlementGrid.Columns[11].FooterText = dt.Compute("SUM(Net)", "").ToString();
SettlementGrid.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
SettlementViewDiv.Style["height"] = sHeight;
SettlementDB db = new SettlementDB();
DataTable dt;
if (sECEType == 1)
{
dt = db.GetBranchSettlementRV();
}
else
{
dt = db.GetBranchSettlementHV();
}
//DataTable dt = db.GetBranchSettlement(sECEType);
SettlementGrid.DataSource = dt;
SettlementGrid.DataBind();
string HRV;
if (sECEType > 1)
{
HRV = "HV";
SettlementGrid.RowStyle.BackColor = System.Drawing.ColorTranslator.FromHtml("#dee9fc");
}
else
{
HRV = "RV";
SettlementGrid.RowStyle.BackColor = System.Drawing.Color.LightYellow;
}
LblTotal.Text = "Total -" + HRV;
try
{
OCE.Text = dt.Compute("SUM(OCE)", "").ToString();
ICE.Text = dt.Compute("SUM(ICE)", "").ToString();
ORE.Text = dt.Compute("SUM(ORE)", "").ToString();
IRE.Text = dt.Compute("SUM(IRE)", "").ToString();
iOCE.Text = dt.Compute("SUM(iOCE)", "").ToString();
iICE.Text = dt.Compute("SUM(iICE)", "").ToString();
iORE.Text = dt.Compute("SUM(iORE)", "").ToString();
iIRE.Text = dt.Compute("SUM(iIRE)", "").ToString();
}
catch
{
}
//dt.Dispose();
SettlementGrid.Dispose();
}
