protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
QtyTotal = 0;
if (txtCommodity.Text == "Gunny")
{
e.Row.Cells[3].Text = "परिवहन की मात्रा (Bales)";
}
else
{
e.Row.Cells[3].Text = "परिवहन की मात्रा (मै० टन)";
}
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[0].Text = (e.Row.RowIndex + 1).ToString();
ConvertQtlsToMT = 0;
ConvertQtlsToMT = ((double.Parse(e.Row.Cells[3].Text)));
QtyTotalSubMO += ConvertQtlsToMT;
}
if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[2].Text = "कुल मात्रा";
e.Row.Cells[3].Text = QtyTotalSubMO.ToString("0.00");
RowSpan = 1;
ro = 0;
int j = 0;
for (int i = 0; i < GridView2.Rows.Count - 1; i++)
{
GridViewRow currrow = GridView2.Rows[j];
GridViewRow nextrow = GridView2.Rows[i + 1];
if (currrow.Cells[1].Text == nextrow.Cells[1].Text)
{
nextrow.Cells[1].Visible = false;
RowSpan += 1;
ro++;
}
else
{
currrow.Cells[1].RowSpan = RowSpan;
RowSpan = 1;
j = i + 1;
}
}
GridViewRow currrow1 = GridView2.Rows[j];
currrow1.Cells[1].RowSpan = RowSpan;
}
}
protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
QtyTotal = 0;
if (lblComdty.Text == "Gunny")
{
e.Row.Cells[3].Text = "परिवहन की मात्रा (Bales)";
}
else
{
e.Row.Cells[3].Text = "परिवहन की मात्रा (मै० टन)";
}
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[0].Text = (e.Row.RowIndex + 1).ToString();
ConvertQtlsToMT = 0;
ConvertQtlsToMT = ((double.Parse(e.Row.Cells[3].Text)));
QtyTotalSubMO += ConvertQtlsToMT;
}
if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[2].Text = "महायोग ";
e.Row.Cells[3].Text = QtyTotalSubMO.ToString("0.00");
RowSpan = 1;
ro = 0;
int j = 0;
int z = 1;
double kulyog = 0;
for (int i = 0; i < GridView2.Rows.Count - 1; i++)
{
GridViewRow currrow = GridView2.Rows[j];
GridViewRow nextrow = GridView2.Rows[i + 1];
if (currrow.Cells[1].Text == nextrow.Cells[1].Text)
{
nextrow.Cells[1].Visible = false;
RowSpan += 1;
ro++;
GridView2.Rows[j].Cells[0].Text = "1";
GridView2.Rows[i + 1].Cells[0].Text = RowSpan.ToString();
kulyog += (double.Parse(GridView2.Rows[i].Cells[3].Text));
}
else
{
RowSpan++;
currrow.Cells[1].RowSpan = RowSpan;
z++;
kulyog += (double.Parse(GridView2.Rows[i].Cells[3].Text));
GridViewRow oGridViewRow = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Insert);
TableHeaderCell oTableCell = new TableHeaderCell();
oGridViewRow.Cells.Add(oTableCell);
oTableCell = new TableHeaderCell();
oTableCell.Text = "कुल योग";
oTableCell.ForeColor = System.Drawing.Color.Red;
oTableCell.HorizontalAlign = HorizontalAlign.Right;
oGridViewRow.Cells.Add(oTableCell);
oTableCell = new TableHeaderCell();
oTableCell.Text = kulyog.ToString("0.00");
oTableCell.ForeColor = System.Drawing.Color.Red;
oTableCell.HorizontalAlign = HorizontalAlign.Right;
oGridViewRow.Cells.Add(oTableCell);
int x = (i + z);
GridView2.Controls[0].Controls.AddAt(x, oGridViewRow);
RowSpan = 1;
j = i + 1;
kulyog = 0;
}
}
kulyog += (double.Parse(GridView2.Rows[GridView2.Rows.Count - 1].Cells[3].Text));
GridViewRow currrow1 = GridView2.Rows[j];
currrow1.Cells[1].RowSpan = RowSpan + 1;
GridViewRow oGridViewRow1 = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Insert);
TableHeaderCell oTableCell1 = new TableHeaderCell();
oGridViewRow1.Cells.Add(oTableCell1);
oTableCell1 = new TableHeaderCell();
oTableCell1.Text = "कुल योग";
oTableCell1.ForeColor = System.Drawing.Color.Red;
oTableCell1.HorizontalAlign = HorizontalAlign.Right;
oGridViewRow1.Cells.Add(oTableCell1);
oTableCell1 = new TableHeaderCell();
oTableCell1.Text = kulyog.ToString("0.00");
oTableCell1.ForeColor = System.Drawing.Color.Red;
oTableCell1.HorizontalAlign = HorizontalAlign.Right;
oGridViewRow1.Cells.Add(oTableCell1);
int x1 = (GridView2.Rows.Count + z);
GridView2.Controls[0].Controls.AddAt(x1, oGridViewRow1);
}
}
