private void frmPinMd5_FormClosed(object sender, FormClosedEventArgs e)
{
if (this.Caller is Penjualan.TabelDO)
{
if (_bagian != PinId.Bagian.Harga)
{
Penjualan.TabelDO frmCaller = (Penjualan.TabelDO) this.Caller;
frmCaller.RefreshDataDO();
try
{
frmCaller.FindHeader("RowID", _rowID.ToString());
}
catch { };
}
else
{
Penjualan.TabelDO frm = (Penjualan.TabelDO)Caller;
frm.RefreshDataDetailDO();
}
}
else if (this.Caller is Penjualan.frmNotaJualBrowser)
{
Penjualan.frmNotaJualBrowser frmCaller = (Penjualan.frmNotaJualBrowser) this.Caller;
frmCaller.RefreshDataDO();
}
else if (this.Caller is Penjualan.frmNotaReturJualBrowse)
{
Penjualan.frmNotaReturJualBrowse frmCaller = (Penjualan.frmNotaReturJualBrowse) this.Caller;
frmCaller.RefreshDataReturJual();
}
else if (this.Caller is Penjualan.frmNotaJualUpdate)
{
Penjualan.frmNotaJualUpdate frmCaller = (Penjualan.frmNotaJualUpdate) this.Caller;
frmCaller.RefreshDataNota();
}
else if (this.Caller is Penjualan.frmPotonganNotaBrowse)
{
Penjualan.frmPotonganNotaBrowse frmCaller = (Penjualan.frmPotonganNotaBrowse) this.Caller;
frmCaller.RefreshData();
frmCaller.FindHeader("RowID", _rowID.ToString());
}
}
private void commandButton1_Click(object sender, EventArgs e)
{
if (txtPin.Text.ToString().Length != 8)
{
MessageBox.Show("Pin Yang anda masukan salah, silhakan Ulangi");
txtPin.Text = "";
return;
}
if (ISA.Pin.key.cek(txtKey.Text, txtPin.Text, _bagian))
{
//GlobalVar.pinResult = true;
if (this.Caller is Rekon.frmrekonclosing)
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_Rekon_Clstrans_update"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _RowID));
db.Commands[0].Parameters.Add(new Parameter("@pin", SqlDbType.VarChar, txtPin.Text));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
dt = db.Commands[0].ExecuteDataTable();
db.Commands[0].ExecuteNonQuery();
MessageBox.Show("Pin Benar, Proses Rekons Sudah Selesai");
}
}
if (this.Caller is Penjualan.frmNotaJualBrowser)
{
if (_bagian != 6)
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_OrderPenjualan_updateACCPiutang"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _RowID));
db.Commands[0].Parameters.Add(new Parameter("@bagian", SqlDbType.Int, _bagian));
db.Commands[0].Parameters.Add(new Parameter("@pin", SqlDbType.VarChar, txtPin.Text));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
dt = db.Commands[0].ExecuteDataTable();
db.Commands[0].ExecuteNonQuery();
}
}
else
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_OrderPenjualanDetail_UPDATE_ACC"));
db.Commands[0].Parameters.Add(new Parameter("@headerID", SqlDbType.UniqueIdentifier, _RowID));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
dt = db.Commands[0].ExecuteDataTable();
db.Commands[0].ExecuteNonQuery();
}
}
MessageBox.Show("DO sudah diACC, silahkan insert kembali di Browse Nota");
}
if (this.Caller is Penjualan.frmNotaReturJualBrowse)
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_ReturPenjualanDetail_UPDATE_RowID"));
db.Commands[0].Parameters.Add(new Parameter("@HeaderID", SqlDbType.UniqueIdentifier, _RowID));
db.Commands[0].Parameters.Add(new Parameter("@noACC", SqlDbType.VarChar, txtPin.Text.Substring(0, 6)));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
dt = db.Commands[0].ExecuteDataTable();
db.Commands[0].ExecuteNonQuery();
MessageBox.Show("Retur sudah diACC, silahkan insert kembali di Browse Nota Retur");
}
}
if (this.Caller is Penjualan.TabelDO)
{
if (_bagian != 6)
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_OrderPenjualan_updateACCPiutang"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _RowID));
db.Commands[0].Parameters.Add(new Parameter("@bagian", SqlDbType.Int, _bagian));
db.Commands[0].Parameters.Add(new Parameter("@pin", SqlDbType.VarChar, txtPin.Text));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
dt = db.Commands[0].ExecuteDataTable();
db.Commands[0].ExecuteNonQuery();
}
MessageBox.Show("DO sudah diACC, silahkan cetak kembali di Browse DO");
Penjualan.TabelDO frm = (Penjualan.TabelDO)Caller;
frm.RefreshDataDO();
}
else
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_OrderPenjualanDetail_UPDATE_ACC"));
db.Commands[0].Parameters.Add(new Parameter("@headerID", SqlDbType.UniqueIdentifier, _RowID));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
dt = db.Commands[0].ExecuteDataTable();
db.Commands[0].ExecuteNonQuery();
}
MessageBox.Show("DO sudah diACC, silahkan cetak kembali di Browse DO");
Penjualan.TabelDO frm = (Penjualan.TabelDO)Caller;
frm.RefreshDataDetailDO();
}
}
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_pin_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@keyNumber", SqlDbType.VarChar, txtKey.Text));
db.Commands[0].Parameters.Add(new Parameter("@PinNummber", SqlDbType.VarChar, txtPin.Text));
db.Commands[0].Parameters.Add(new Parameter("@id", SqlDbType.Int, _bagian));
db.Commands[0].Parameters.Add(new Parameter("@ket", SqlDbType.Text, txtKet.Text));
dt = db.Commands[0].ExecuteDataTable();
}
//if (GlobalVar.pinResult)
//{
// using (Database db = new Database())
// {
// db.Commands.Add(db.CreateCommand("usp_PINUnlockLog"));
// db.Commands[0].Parameters.Add(new Parameter("@ModulID", SqlDbType.Int, _modulId));
// db.Commands[0].Parameters.Add(new Parameter("@MingguKe", SqlDbType.Int, _MingguKe));
// db.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.DateTime2, _tanggal));
// db.Commands[0].Parameters.Add(new Parameter("@PublicKey", SqlDbType.VarChar, txtKey.Text));
// db.Commands[0].Parameters.Add(new Parameter("@PINEntered", SqlDbType.VarChar, txtPin.Text));
// db.Commands[0].Parameters.Add(new Parameter("@Periode", SqlDbType.Int, _periode));
// db.Commands[0].ExecuteDataTable();
// }
//}
this.Close();
}
else
{
MessageBox.Show("Pin yang anda masukan salah, cek kembali");
}
}
private void frmDODetailUpdate_Load(object sender, EventArgs e)
{
if (this.Caller is TabelDO)
{
Penjualan.TabelDO frmCaller = (Penjualan.TabelDO) this.Caller;
//namatoko = convert.ToString(frmCaller.lblnamatoko);
// jenistrans = frmCaller.lbljenistransaksi.ToString();
}
try
{
//MessageBox.Show(namatoko + "--" + jenistrans);
dtDO = new DataTable();
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_OrderPenjualan_LIST")); // 27042013
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _headerID));
dtDO = db.Commands[0].ExecuteDataTable();
}
if (dtDO.Rows.Count > 0)
{
_tglDO = (DateTime)dtDO.Rows[0]["TglDO"];
_kodeToko = Tools.isNull(dtDO.Rows[0]["KodeToko"], "").ToString();
_c1 = Tools.isNull(dtDO.Rows[0]["Cabang1"], "").ToString();
_htrID = Tools.isNull(dtDO.Rows[0]["HtrID"], "").ToString();
// MessageBox.Show((dtDO.Rows[0]["StsToko"]).ToString());
_stsToko = Tools.isNull(dtDO.Rows[0]["StsToko"], "").ToString();
//MessageBox.Show(_stsToko.ToString());
}
if (formMode == enumFormMode.Update)
{
//retrieving data
dtDODetail = new DataTable();
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_OrderPenjualanDetail_LIST")); // 27042013
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
dtDODetail = db.Commands[0].ExecuteDataTable();
}
//display data
lookupStock.NamaStock = Tools.isNull(dtDODetail.Rows[0]["NamaStok"], "").ToString();
lookupStock.BarangID = Tools.isNull(dtDODetail.Rows[0]["BarangID"], "").ToString();
_barangID = lookupStock.BarangID;
lookupStock.Enabled = false;
txtQtyRQ.Text = Tools.isNull(dtDODetail.Rows[0]["QtyRequest"], "").ToString();
//jika QtyDO = 0 maka QtyDO akan terisi = QtyRequest
int JDO = Convert.ToInt32(Tools.isNull(dtDODetail.Rows[0]["QtyDO"], "0").ToString());
if (JDO == 0)
{
txtQtyDO.Text = Tools.isNull(dtDODetail.Rows[0]["QtyRequest"], "").ToString();
}
else
{
txtQtyDO.Text = Tools.isNull(dtDODetail.Rows[0]["QtyDO"], "").ToString();
}
txtSelisih.Text = ((txtQtyRQ.GetIntValue) - (txtQtyDO.GetIntValue)).ToString();
txtSatuan.Text = Tools.isNull(dtDODetail.Rows[0]["SatSolo"], "").ToString();
txtHrgJual.Text = Tools.isNull(dtDODetail.Rows[0]["HrgJual"], "").ToString();
_hrgJualAwal = double.Parse(txtHrgJual.Text);
txtJmlHrg.Text = HitungJmlHrg().ToString();
txtNoACC.Text = Tools.isNull(dtDODetail.Rows[0]["NoACC"], "").ToString();
_noACC = txtNoACC.Text;
if (_noACC.Trim() == "")
{
lookupStock.Enabled = true;
}
txtDisc1.Text = Tools.isNull(dtDODetail.Rows[0]["Disc1"], "0").ToString();
txtDisc2.Text = Tools.isNull(dtDODetail.Rows[0]["Disc2"], "0").ToString();
txtDisc3.Text = Tools.isNull(dtDODetail.Rows[0]["Disc3"], "0").ToString();
txtDisc.Text = HitungJmlDisc().ToString();
txtPotongan.Text = Tools.isNull(dtDODetail.Rows[0]["Pot"], "").ToString();
txtTotalPotongan.Text = HitungTotalPot().ToString();
txtNetto.Text = HitungHrgNetto().ToString();
txtDiscKompensasi.Text = Tools.isNull(dtDODetail.Rows[0]["DiscKompensasi"], "").ToString();
txtCatatan.Text = Tools.isNull(dtDODetail.Rows[0]["Catatan"], "").ToString();
_discFormula = Tools.isNull(dtDODetail.Rows[0]["DiscFormula"], "").ToString();
GetHrgBMK();
if (SecurityManager.HasRight("TRD.ACC_HARGA"))
{
//txtHrgJual.Enabled = true;
//txtHrgJual.ReadOnly = false;
txtNoACC.Enabled = true;
txtNoACC.ReadOnly = false;
}
else
{
//txtHrgJual.Enabled = false;
//txtHrgJual.ReadOnly = true;
txtNoACC.Enabled = false;
txtNoACC.ReadOnly = true;
}
if (_noAccPusat == "BONUSAN")
{
SetTextBoxBasedOnBONUSAN(true);
}
}
else
{
txtQtyRQ.Text = "0";
txtQtyDO.Text = "0";
txtSelisih.Text = "0";
txtHrgJual.Text = "0";
txtJmlHrg.Text = "0";
txtDisc1.Text = "0";
txtDisc2.Text = "0";
txtDisc3.Text = "0";
txtDisc.Text = "0";
txtPotongan.Text = "0";
txtTotalPotongan.Text = "0";
txtNetto.Text = "0";
txtDiscKompensasi.Text = "0";
PopulateExistingStok();
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
