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); } } }