private void cmdApprove_Click(object sender, EventArgs e)
{
Guid doID = (Guid)dataGridView1.SelectedCells[0].OwningRow.Cells["RowID"].Value;
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_NotaPenjualan_LIST_FILTER_DOID"));
db.Commands[0].Parameters.Add(new Parameter("@doID", SqlDbType.UniqueIdentifier, doID));
dt = db.Commands[0].ExecuteDataTable();
}
if (dt.Rows.Count > 0 && !SecurityManager.AskPasswordManager())
{
MessageBox.Show("Anda tidak berwenang untuk ACC ulang");
return;
}
Guid headerID = (Guid)dataGridView1.SelectedCells[0].OwningRow.Cells["RowID"].Value;
string kodeToko = dataGridView1.SelectedCells[0].OwningRow.Cells["KodeToko"].Value.ToString();
DateTime tglDo = (DateTime)dataGridView1.SelectedCells[0].OwningRow.Cells["TglDO"].Value;
string noNota, noACCDO, ACCOleh, lokasiDatabase, lokasiDataKasir, lokasiApp, nPrint;
double Plafon, Gbc = 0, dDibayar, NilaiDO, dDebet;
lokasiDatabase = LookupInfo.GetValue("VACCDO", "PIUTANG_PATH");
lokasiDataKasir = LookupInfo.GetValue("VACCDO", "KASIR_PATH");
//lokasiApp = LookupInfo.GetValue("VACCDO", "STOK_PATH");
lokasiApp = Application.StartupPath + "\\v_accdo_ISA\\";
///////////////////// Fefe Part //////////////////////
DataTable dtPL = new DataTable();
DataTable dtOP = new DataTable();
DataTable dtT = new DataTable();
if (initPerusahaan.Substring(1, 0) == "0")
{
initPerusahaan = "C";
}
else
{
initPerusahaan = "0";
}
using (Database db = new Database())
{
//db.Commands.Add(db.CreateCommand("usp_OrderPenjualanDetailPos_LIST"));
//db.Commands[0].Parameters.Add(new Parameter("@headerID", SqlDbType.UniqueIdentifier, headerID));
//dtPL = db.Commands[0].ExecuteDataTable();
//if (dtPL.Rows.Count == 0)
//{
// NilaiDO = 0;
//}
//else
//{
// NilaiDO = double.Parse(dtPL.Compute("SUM(HrgNet)", "").ToString());//Tools.isNull(dt.Rows[0]["HrgNet"], "").ToString();
//}
db.Commands.Add(db.CreateCommand("usp_OrderPenjualanPos_LIST"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, headerID));
dtOP = db.Commands[0].ExecuteDataTable();
noNota = Tools.isNull(dtOP.Rows[0]["NoACCPiutang"], "").ToString();
nPrint = dtOP.Rows[0]["NPrint"].ToString();
NilaiDO = double.Parse(dtOP.Rows[0]["RpNet"].ToString());
db.Commands.Add(db.CreateCommand("usp_Toko_LIST"));
db.Commands[1].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, kodeToko));
dtT = db.Commands[1].ExecuteDataTable();
Plafon = Convert.ToDouble(dtT.Rows[0]["Plafon"]);
}
//GENERATE Nomor Acc
DataTable dtNum = Tools.GetGeneralNumerator(docNO);
int lebar = int.Parse(dtNum.Rows[0]["Lebar"].ToString());
int iNomor = int.Parse(dtNum.Rows[0]["Nomor"].ToString());
string depan = Tools.GeneralInitial();
string belakang = dtNum.Rows[0]["Belakang"].ToString();
iNomor++;
string strNoACC = Tools.FormatNumerator(iNomor, lebar, depan, belakang);
strNoACC = strNoACC.Substring(3, 6);
DataTable dt1 = new DataTable();
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_Toko_LIST"));
db.Commands[0].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, kodeToko));
dt1 = db.Commands[0].ExecuteDataTable();
if (dt1.Rows.Count > 0)
{
db.Commands.Add(db.CreateCommand("usp_fnCekPlafon"));
db.Commands[1].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, kodeToko));
db.Commands[1].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, headerID));
dt1 = db.Commands[1].ExecuteDataTable();
if (dt1.Rows.Count > 0)
{
Plafon = Convert.ToDouble(dt1.Rows[0]["Plafon"]);
}
}
db.Commands.Add(db.CreateCommand("usp_vwDebetDibayarbankGiroTolak"));
db.Commands[2].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, kodeToko));
dt1 = db.Commands[2].ExecuteDataTable();
if (dt1.Rows.Count > 0)
{
dDebet = Convert.ToDouble(dt1.Rows[0]["Debet"]);
dDibayar = Convert.ToDouble(dt1.Rows[0]["Dibayar"]);
}
else
{
dDebet = 0;
dDibayar = 0;
}
if (dDebet - dDibayar > 0)
{
Gbc = Gbc + dDebet;
}
noACCDO = string.Empty;
ACCOleh = SecurityManager.UserID;
}
System.Diagnostics.Process proc = new System.Diagnostics.Process();
proc.EnableRaisingEvents = false;
proc.StartInfo.FileName = lokasiApp + "v_accdo_ISA_Pos.exe";
proc.StartInfo.Arguments = Plafon.ToString() + " " + kodeToko + " " + ACCOleh + " " + NilaiDO.ToString() + " " + headerID.ToString() + " " + strNoACC + " " + initPerusahaan + " " + tglDo.ToString("dd/MM/yyyy") + " " + lokasiDatabase + " " + lokasiDataKasir + " " + lokasiApp + " " + host + " " + nPrint;
proc.Start();
proc.WaitForExit();
//RefreshDataSeluruhnya();
//dataGridView1.FindRow("RowID", doID.ToString());
RefreshRowDataDO(doID.ToString());
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
//public frmPlafon(Form caller,Guid headerID)
//{
// InitializeComponent();
// formMode = enumFormMode.Update;
// _headerID=headerID;
// this.Caller = caller;
//}
private void frmPlafon_Load(object sender, EventArgs e)
{
rdbPenuh.Checked = true;
string noNota;
string noACCDO;
double Plafon, RpJual, Saldo, Gbc, Tolak, Ovd, Debet, Kredit;
if (formMode == enumFormMode.New)
{
try
{
DataTable dt = new DataTable();
DataTable dtOP = new DataTable();
DataTable dtT = new DataTable();
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_OrderPenjualanDetail_LIST_FILTER_HEADERID"));
db.Commands[0].Parameters.Add(new Parameter("@headerID", SqlDbType.UniqueIdentifier, _headerID));
dt = db.Commands[0].ExecuteDataTable();
if (dt.Rows.Count == 0)
{
txtNilaiDO.Text = "0";
}
else
{
txtNilaiDO.Text = dt.Compute("SUM(HrgNet)", "").ToString();//Tools.isNull(dt.Rows[0]["HrgNet"], "").ToString();
}
db.Commands.Add(db.CreateCommand("usp_OrderPenjualan_LIST"));
db.Commands[1].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _headerID));
dtOP = db.Commands[1].ExecuteDataTable();
noNota = Tools.isNull(dtOP.Rows[0]["NoACCPiutang"], "").ToString();
db.Commands.Add(db.CreateCommand("usp_Toko_LIST"));
db.Commands[2].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, _kodeToko));
dtT = db.Commands[2].ExecuteDataTable();
Plafon = Convert.ToDouble(dtT.Rows[0]["Plafon"]);
}
if (noNota != "")
{
noACCDO = Tools.isNull(dtOP.Rows[0]["NoACCPiutang"], "").ToString();
Plafon = Convert.ToDouble(dtOP.Rows[0]["RpPlafonToko"]);
Saldo = Convert.ToDouble(dtOP.Rows[0]["RpPiutangTerakhir"]);
Tolak = Convert.ToDouble(dtOP.Rows[0]["RpGiroTolakTerakhir"]);
Ovd = Convert.ToDouble(dtOP.Rows[0]["RpOverdue"]);
txtPlafon.Text = Plafon.ToString();
txtSaldoAkhir.Text = (Saldo + Tolak).ToString();
txtSisaPlafon.Text = (Plafon - Saldo).ToString();
txtNilaiOverdue.Text = Ovd.ToString();
txtACCOleh.Text = SecurityManager.UserID;
}
else
{
Tolak = 0;
DataTable dt1 = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_Toko_LIST"));
db.Commands[0].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, _kodeToko));
dt1 = db.Commands[0].ExecuteDataTable();
if (dt1.Rows.Count > 0)
{
db.Commands.Add(db.CreateCommand("usp_fnCekPlafon"));
db.Commands[1].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, _kodeToko));
db.Commands[1].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _headerID));
dt1 = db.Commands[1].ExecuteDataTable();
if (dt1.Rows.Count > 0)
{
Plafon = Convert.ToDouble(dt1.Rows[0]["Plafon"]);
}
//Plafon = 2000000;
}
db.Commands.Add(db.CreateCommand("usp_vwRpJualkartuPiutang"));
db.Commands[2].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, _kodeToko));
dt1 = db.Commands[2].ExecuteDataTable();
if (dt1.Rows.Count > 0)
{//RpJual
RpJual = Convert.ToDouble(dt1.Rows[0]["RpJual"]);
}
else
{
RpJual = 0;
}
db.Commands.Add(db.CreateCommand("usp_vwDebetKreditDetailPiutang"));
db.Commands[3].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, _kodeToko));
dt1 = db.Commands[3].ExecuteDataTable();
if (dt1.Rows.Count > 0)
{
Debet = Convert.ToDouble(dt1.Rows[0]["Debet"]);
Kredit = Convert.ToDouble(dt1.Rows[0]["Kredit"]);
}
else
{
Debet = 0;
Kredit = 0;
}
//Saldo
Saldo = (RpJual + Debet) - Kredit;
db.Commands.Add(db.CreateCommand("usp_vwNominalgiro"));
db.Commands[4].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, _kodeToko));
dt1 = db.Commands[4].ExecuteDataTable();
if (dt1.Rows.Count > 0)
{
Gbc = Convert.ToDouble(dt1.Rows[0]["Gbc"]);
}
else
{
Gbc = 0;
}
db.Commands.Add(db.CreateCommand("usp_vwDebetDibayarbankGiroTolak"));
db.Commands[5].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, _kodeToko));
dt1 = db.Commands[5].ExecuteDataTable();
double dDebet, dDibayar;
if (dt1.Rows.Count > 0)
{
dDebet = Convert.ToDouble(dt1.Rows[0]["Debet"]);
dDibayar = Convert.ToDouble(dt1.Rows[0]["Dibayar"]);
}
else
{
dDebet = 0;
dDibayar = 0;
}
if (dDebet - dDibayar > 0)
{
Gbc = Gbc + dDebet;
}
//Saldo
Saldo = Saldo + (Gbc - dDibayar);
db.Commands.Add(db.CreateCommand("usp_vwOVD"));
db.Commands[6].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, _kodeToko));
db.Commands[6].Parameters.Add(new Parameter("@tgljatuhTempo", SqlDbType.VarChar, _tglDo));
dt1 = db.Commands[6].ExecuteDataTable();
if (dt1.Rows.Count > 0)
{
Ovd = Convert.ToDouble(dt1.Rows[0]["OVD"]);
}
else
{
Ovd = 0;
}
//Ovd
Ovd = Ovd + (RpJual - Kredit);
//else
//{
// Plafon = 2000000;
// Saldo = 2000000;
// Tolak = 0;
// Ovd = 0;
//}
txtPlafon.Text = Plafon.ToString();
txtSaldoAkhir.Text = (Saldo + Tolak).ToString();
txtSisaPlafon.Text = (Plafon - Saldo).ToString();
txtNilaiOverdue.Text = Ovd.ToString();
txtACCOleh.Text = SecurityManager.UserID;
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}