private void setDgv1Up()
{
if (txtInput.Text.Equals("0"))
{
dgv1[col1Up, 0].Value = int.Parse(cf.NumberNull(dgv1[col1Up, 0].Value)) + int.Parse(txtUp.Text);
}
else if (txtInput.Text.Equals("1"))
{
dgv1[col1Up, 1].Value = int.Parse(cf.NumberNull(dgv1[col1Up, 1].Value)) + int.Parse(txtUp.Text);
}
else if (txtInput.Text.Equals("2"))
{
dgv1[col1Up, 2].Value = int.Parse(cf.NumberNull(dgv1[col1Up, 2].Value)) + int.Parse(txtUp.Text);
}
else if (txtInput.Text.Equals("3"))
{
dgv1[col1Up, 3].Value = int.Parse(cf.NumberNull(dgv1[col1Up, 3].Value)) + int.Parse(txtUp.Text);
}
else if (txtInput.Text.Equals("4"))
{
dgv1[col1Up, 4].Value = int.Parse(cf.NumberNull(dgv1[col1Up, 4].Value)) + int.Parse(txtUp.Text);
}
else if (txtInput.Text.Equals("5"))
{
dgv1[col1Up, 5].Value = int.Parse(cf.NumberNull(dgv1[col1Up, 5].Value)) + int.Parse(txtUp.Text);
}
else if (txtInput.Text.Equals("6"))
{
dgv1[col1Up, 6].Value = int.Parse(cf.NumberNull(dgv1[col1Up, 6].Value)) + int.Parse(txtUp.Text);
}
else if (txtInput.Text.Equals("7"))
{
dgv1[col1Up, 7].Value = int.Parse(cf.NumberNull(dgv1[col1Up, 7].Value)) + int.Parse(txtUp.Text);
}
else if (txtInput.Text.Equals("8"))
{
dgv1[col1Up, 8].Value = int.Parse(cf.NumberNull(dgv1[col1Up, 8].Value)) + int.Parse(txtUp.Text);
}
else if (txtInput.Text.Equals("9"))
{
dgv1[col1Up, 9].Value = int.Parse(cf.NumberNull(dgv1[col1Up, 9].Value)) + int.Parse(txtUp.Text);
}
}
public List <Reward1> selectByLenNumber(String yearId, String monthId, String periodId, String rateId)
{
List <Reward1> lRew1 = new List <Reward1>();
DataTable dt = lotdb.selectByLenNumber(yearId, monthId, periodId, rateId);
for (int i = 0; i < dt.Rows.Count; i++)
{
Reward1 rew1 = new Reward1();
rew1.number = dt.Rows[i][lotdb.lot.number].ToString();
if (rateId.Equals("up"))
{
rew1.Amt = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.up]));
rew1.PayRate = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.rUpRate]));
rew1.Reward = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.rUp]));
//rew1.AmtReward = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.rUp]));
}
else if (rateId.Equals("down"))
{
rew1.Amt = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.down]));
rew1.PayRate = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.rDownRate]));
rew1.Reward = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.rDown]));
}
else if (rateId.Equals("2down"))
{
rew1.Amt = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.down]));
rew1.PayRate = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.r2DownRate]));
rew1.Reward = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.r2Down]));
}
else if (rateId.Equals("2up"))
{
rew1.Amt = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.up]));
rew1.PayRate = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.r2UpRate]));
rew1.Reward = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.r2Up]));
}
else if (rateId.Equals("3down"))
{
rew1.Amt = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.down]));
rew1.PayRate = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.r3DownRate]));
rew1.Reward = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.r3Down]));
}
else if (rateId.Equals("3tod"))
{
rew1.Amt = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.tod]));
rew1.PayRate = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.r3TodRate]));
rew1.Reward = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.r3Tod]));
}
else if (rateId.Equals("3up"))
{
rew1.Amt = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.up]));
rew1.PayRate = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.r3UpRate]));
rew1.Reward = Double.Parse(cf.NumberNull(dt.Rows[i][lotdb.lot.r3Up]));
}
lRew1.Add(rew1);
}
return(lRew1);
}