public ActionResult AddOvd(string ovd)
{
try
{
Ovd ovdOdj = new Ovd();
int ovdId = ovdOdj.AddOvd(ovd);
return(Json(ovdId, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
string err = "Ошибка БД " + ex.Message;
return(Json(err, JsonRequestBehavior.AllowGet));
}
}
private void frmPlafonPosISA_Load(object sender, EventArgs e)
{
rdbPenuh.Checked = true;
string noACCDO;
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_OrderPenjualan_GetHrgNet"));
//db.Commands[0].Parameters.Add(new Parameter("@headerID", SqlDbType.UniqueIdentifier, _headerID));
//_RpDO = Convert.ToDouble(db.Commands[0].ExecuteScalar());
//txtNilaiDO.Text = _RpDO.ToString("#,##0");
db.Commands.Add(db.CreateCommand("usp_ACCDOPos_LIST"));
db.Commands[0].Parameters.Add(new Parameter("@HeaderID", SqlDbType.UniqueIdentifier, _headerID));
dtOP = db.Commands[0].ExecuteDataTable();
_RpDO = Convert.ToDouble(dtOP.Rows[0]["HrgNet"]);
noNota = Tools.isNull(dtOP.Rows[0]["NoACCPiutang"], "").ToString();
_RpNet3 = Convert.ToDouble(Tools.isNull(dtOP.Rows[0]["RpACCPiutang"], "0").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"]);
}
if (noNota != "")
{
noACCDO = Tools.isNull(dtOP.Rows[0]["NoACCPiutang"], "").ToString();
_RpGiroTolak = Convert.ToDouble(Tools.isNull(dtOP.Rows[0]["RpGiroTolakTerakhir"], "0").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;
txtNilaiDO.Text = _RpDO.ToString("#,##0");
}
else
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_fnCekPlafon"));
db.Commands[0].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, _kodeToko));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _headerID));
Plafon = Convert.ToDouble(db.Commands[0].ExecuteScalar());
db.Commands.Add(db.CreateCommand("usp_RpJualkartuPiutang"));
db.Commands[1].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, _kodeToko));
RpJual = Convert.ToDouble(db.Commands[1].ExecuteScalar());
DataTable dtG = new DataTable();
db.Commands.Add(db.CreateCommand("[usp_GetNominalgiro]"));
db.Commands[2].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, _kodeToko));
dtG = db.Commands[2].ExecuteDataTable();
Gbc = Convert.ToDouble(dtG.Rows[0]["RpGiro"]);
Tolak = Convert.ToDouble(dtG.Rows[0]["RpGiroTolakDebet"]) - Convert.ToDouble(dtG.Rows[0]["RpGiroTolakKredit"]);
db.Commands.Add(db.CreateCommand("[usp_GetOVD]"));
db.Commands[3].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, _kodeToko));
db.Commands[3].Parameters.Add(new Parameter("@tgljatuhTempo", SqlDbType.DateTime, _tglDo));
Ovd = Convert.ToDouble(db.Commands[3].ExecuteScalar());
RpJual = RpJual + Gbc;
txtPlafon.Text = Plafon.ToString("#,##0");
txtSaldoAkhir.Text = (RpJual + Tolak).ToString("#,##0");
txtSisaPlafon.Text = (Plafon - RpJual).ToString("#,##0");
txtNilaiDO.Text = _RpDO.ToString("#,##0");
txtACCOleh.Text = SecurityManager.UserID;
txtNilaiOverdue.Text = Ovd.ToString("#,##0");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
//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);
}
}
}
