private void frmLapKasOpnameVSSaldoInput_Load(object sender, EventArgs e)
{
rangeDateBox1.FromDate = GlobalVar.GetServerDate;
rangeDateBox1.ToDate = GlobalVar.GetServerDate;
fcbo.fillComboKas(cboKas, GlobalVar.PerusahaanRowID);
if (cboKas.Items.Count > 1)
{
cboKas.SelectedIndex = 1;
}
}
private void frmKasOpnameUpdate_Load(object sender, EventArgs e)
{
if (mode == "NEW")
{
dateTextBox1.DateValue = GlobalVar.GetServerDate;
fcbo.fillComboKas(cboKas, GlobalVar.PerusahaanRowID);
if (cboKas.Items.Count > 1)
{
cboKas.SelectedIndex = 1;
}
else if (cboKas.Items.Count > 0)
{
cboKas.SelectedIndex = 0;
}
txt100000.Text = zero.ToString("N2");
txt50000.Text = zero.ToString("N2");
txt20000.Text = zero.ToString("N2");
txt10000.Text = zero.ToString("N2");
txt5000.Text = zero.ToString("N2");
txt2000.Text = zero.ToString("N2");
txt1000.Text = zero.ToString("N2");
txt500.Text = zero.ToString("N2");
txt200.Text = zero.ToString("N2");
txt100.Text = zero.ToString("N2");
txt50.Text = zero.ToString("N2");
txt25.Text = zero.ToString("N2");
sum100000.Text = zero.ToString("N2");
sum50000.Text = zero.ToString("N2");
sum20000.Text = zero.ToString("N2");
sum10000.Text = zero.ToString("N2");
sum5000.Text = zero.ToString("N2");
sum2000.Text = zero.ToString("N2");
sum1000.Text = zero.ToString("N2");
sum500.Text = zero.ToString("N2");
sum200.Text = zero.ToString("N2");
sum100.Text = zero.ToString("N2");
sum50.Text = zero.ToString("N2");
sum25.Text = zero.ToString("N2");
lblsum.Text = zero.ToString("N2");
}
else if (mode == "UPDATE")
{
DataTable dt = new DataTable();
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_KasOpname_LIST_ALL"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _rowID));
dt = db.Commands[0].ExecuteDataTable();
}
if (dt.Rows.Count > 0)
{
dateTextBox1.DateValue = Convert.ToDateTime(Tools.isNull(dt.Rows[0]["Tanggal"], GlobalVar.GetServerDate.Date));
fcbo.fillComboKas(cboKas, GlobalVar.PerusahaanRowID);
txt100000.Text = Convert.ToDouble(Tools.isNull(dt.Rows[0]["p100000"], 0)).ToString();
txt50000.Text = Convert.ToDouble(Tools.isNull(dt.Rows[0]["p50000"], 0)).ToString();
txt20000.Text = Convert.ToDouble(Tools.isNull(dt.Rows[0]["p20000"], 0)).ToString();
txt10000.Text = Convert.ToDouble(Tools.isNull(dt.Rows[0]["p10000"], 0)).ToString();
txt5000.Text = Convert.ToDouble(Tools.isNull(dt.Rows[0]["p5000"], 0)).ToString();
txt2000.Text = Convert.ToDouble(Tools.isNull(dt.Rows[0]["p2000"], 0)).ToString();
txt1000.Text = Convert.ToDouble(Tools.isNull(dt.Rows[0]["p1000"], 0)).ToString();
txt500.Text = Convert.ToDouble(Tools.isNull(dt.Rows[0]["p500"], 0)).ToString();
txt200.Text = Convert.ToDouble(Tools.isNull(dt.Rows[0]["p200"], 0)).ToString();
txt100.Text = Convert.ToDouble(Tools.isNull(dt.Rows[0]["p100"], 0)).ToString();
txt50.Text = Convert.ToDouble(Tools.isNull(dt.Rows[0]["p50"], 0)).ToString();
txt25.Text = Convert.ToDouble(Tools.isNull(dt.Rows[0]["p25"], 0)).ToString();
Double tempSum = recalculateALL();
Double fromDB = Convert.ToDouble(Tools.isNull(dt.Rows[0]["Nominal"], 0));
lblsum.Text = tempSum.ToString("N2");
}
}
else
{
MessageBox.Show("No mode selected, aborting!");
this.Close();
}
}
