private void setGrd2()
{
Font font = new Font("Microsoft Sans Serif", 12, FontStyle.Bold);
Font fontStrike = new Font("Microsoft Sans Serif", 12, FontStyle.Strikeout);
double up = 0, tod = 0, down = 0, amt = 0;
DataTable dt = new DataTable();
Thoo t = new Thoo();
dt = lc.lotdb.selectApprovedByPeriod(cboYear.Text, cboMonth.SelectedValue.ToString(), cboPeriod.SelectedValue.ToString());
if (dt.Rows.Count > 0)
{
dgv1.RowCount = dt.Rows.Count;
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
setDataGrid1(dgv1, i, dt.Rows[i][lc.lotdb.lot.number].ToString(), Double.Parse(dt.Rows[i][lc.lotdb.lot.up].ToString()),
Double.Parse(dt.Rows[i][lc.lotdb.lot.tod].ToString()), Double.Parse(dt.Rows[i][lc.lotdb.lot.down].ToString()),
dt.Rows[i][lc.lotdb.lot.rowId].ToString(), dt.Rows[i][lc.lotdb.lot.lottoId].ToString(), dt.Rows[i][lc.lotdb.lot.use1].ToString(),
dt.Rows[i][lc.lotdb.lot.statusOverLimit].ToString(), dt.Rows[i][lc.lotdb.lot.OLUp].ToString(), dt.Rows[i][lc.lotdb.lot.OLTod].ToString(), dt.Rows[i][lc.lotdb.lot.OLDown].ToString(),
dt.Rows[i][lc.lotdb.lot.thooTranferId].ToString());
up += Double.Parse(lc.cf.NumberNull(dt.Rows[i][lc.lotdb.lot.up]));
tod += Double.Parse(lc.cf.NumberNull(dt.Rows[i][lc.lotdb.lot.tod]));
down += Double.Parse(lc.cf.NumberNull(dt.Rows[i][lc.lotdb.lot.down]));
//amt += up + tod + down;
t = lc.getThoo(dt.Rows[i][lc.lotdb.lot.thooTranferId].ToString());
if (dgv1[colThooTranferId, i].Value.ToString().Length > 0)
{
dgv1.Rows[i].DefaultCellStyle.Font = fontStrike;
}
if (dgv1[colStatusOL, i].Value.ToString().Equals("1"))
{
dgv1[colOLUp, i].Style.Font = font;
dgv1[colOLUp, i].Style.ForeColor = Color.Red;
dgv1[colOLTod, i].Style.Font = font;
dgv1[colOLTod, i].Style.ForeColor = Color.Red;
dgv1[colOLDown, i].Style.Font = font;
dgv1[colOLDown, i].Style.ForeColor = Color.Red;
}
if (dgv1[colNumber, i].Value.ToString().Length == 1)
{
dgv1.Rows[i].DefaultCellStyle.BackColor = ColorTranslator.FromHtml("#174e75");
}
else if (dgv1[colNumber, i].Value.ToString().Length == 2)
{
dgv1.Rows[i].DefaultCellStyle.BackColor = ColorTranslator.FromHtml("#789640");
}
else if (dgv1[colNumber, i].Value.ToString().Length == 3)
{
dgv1.Rows[i].DefaultCellStyle.BackColor = ColorTranslator.FromHtml("#788540");
}
//c = ColorTranslator.FromHtml(t.Color);
//dgv1.Rows[i].DefaultCellStyle.BackColor = ColorTranslator.FromHtml(lc.getThooBackColor(t.Color));
}
catch (Exception ex)
{
}
}
}
txtUp.Text = String.Format("{0:#,###,###.00}", up);
txtTod.Text = String.Format("{0:#,###,###.00}", tod);
txtDown.Text = String.Format("{0:#,###,###.00}", down);
txtAmt.Text = String.Format("{0:#,###,###.00}", (up + tod + down));
setThooAmount();
setRateAmount();
}