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();
}
private DataTable GetData()
{
SettlementDB db = new SettlementDB();
return(null);// db.GetBranchApproval(Int32.Parse(Request.Cookies["RoutingNo"].Value));
}
