public int UpdateRow(int id, string NoBon, string KodeBarang, string NamaBarang, string KodeRacikan, float QtyRacikan, string Satuan, float HargaJual, float dicount, float discountPersen, string NomorResep, string NamaDokter, DateTime TanggalResep, string NamaPasien, string UmurPasien, float HargaSatuan, string KodePelanggan, string NamaPelanggan)
{
int RowsAffected = 0;
int Result = 0;
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("id",id),
new SqlParameter("NoBon",NoBon),
new SqlParameter("KodeBarang",KodeBarang),
new SqlParameter("NamaBarang",NamaBarang),
new SqlParameter("KodeRacikan",KodeRacikan),
new SqlParameter("QtyRacikan",QtyRacikan),
new SqlParameter("Satuan",Satuan),
new SqlParameter("HargaJual",HargaJual),
new SqlParameter("Discount",dicount),
new SqlParameter("DiscountPers",discountPersen),
new SqlParameter("NomorResep",NomorResep),
new SqlParameter("NamaDokter",NamaDokter),
new SqlParameter("TanggalResep",TanggalResep),
new SqlParameter("NamaPasien",NamaPasien),
new SqlParameter("UmurPasien",UmurPasien),
new SqlParameter("HargaSatuan",HargaSatuan),
new SqlParameter("KodePelanggan",KodePelanggan),
new SqlParameter("NamaPelanggan",NamaPelanggan)
};
Result = dbo.RunProcedure("sp_Racikan_Update", parameters, out RowsAffected);
return Result;
}
public int InsertRow(string NamaPerusahaan, string Alamat, string Kota, string KodePos, string Kode_Area, string Telepon1, string Telepon2, string Fax, string Email, string Web, string KodeBon, string KodeSJ, string Alamat1, bool Cetakan1, string Reg, bool Cetakan2, bool Cetakan3, DateTime TanggalPKP, string NamaPKP, string FakturSign, string NPWP, string Jabatan, bool StatusLogo, string NamaFileGambar1)
{
int RowsAffected = 0;
int Result = 0;
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("NamaPerusahaan",NamaPerusahaan),
new SqlParameter("Alamat",Alamat),
new SqlParameter("Kota",Kota),
new SqlParameter("KodePos",KodePos),
new SqlParameter("Kode_Area",Kode_Area),
new SqlParameter("Telepon1",Telepon1),
new SqlParameter("Telepon2",Telepon2),
new SqlParameter("Fax",Fax),
new SqlParameter("Email",Email),
new SqlParameter("Web",Web),
new SqlParameter("KodeBon",KodeBon),
new SqlParameter("KodeSJ",KodeSJ),
new SqlParameter("Alamat1",Alamat1),
new SqlParameter("Cetakan1",Cetakan1),
new SqlParameter("Reg",Reg),
new SqlParameter("Cetakan2",Cetakan2),
new SqlParameter("Cetakan3",Cetakan3),
new SqlParameter("TanggalPKP",TanggalPKP),
new SqlParameter("NamaPKP",NamaPKP),
new SqlParameter("FakturSign",FakturSign),
new SqlParameter("NPWP",NPWP),
new SqlParameter("Jabatan",Jabatan),
new SqlParameter("StatusLogo",StatusLogo),
new SqlParameter("NamaFileGambar1",NamaFileGambar1)
};
Result = dbo.RunProcedure("sp_OwnerIdentity_Insert", parameters, out RowsAffected);
return Result;
}
public int UpdateRow(string NomorGiro, DateTime TanggalTitipan, string PemberiGiro, float NilaiGiro, DateTime TanggalJT, DateTime TanggalCair1, string NoRekening, string NamaBank, string NamaToko, float SaldoJml, bool StatusGiro, bool StatusCair, bool StatusDibayar, string Keterangan, string KodeSalesman, string No_Bukti)
{
int RowsAffected = 0;
int Result = 0;
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("NomorGiro",NomorGiro),
new SqlParameter("TanggalTitipan",TanggalTitipan),
new SqlParameter("PemberiGiro",PemberiGiro),
new SqlParameter("NilaiGiro",NilaiGiro),
new SqlParameter("TanggalJT",TanggalJT),
new SqlParameter("TanggalCair1",TanggalCair1),
new SqlParameter("NoRekening",NoRekening),
new SqlParameter("NamaBank",NamaBank),
new SqlParameter("NamaToko",NamaToko),
new SqlParameter("SaldoJml",SaldoJml),
new SqlParameter("StatusGiro",StatusGiro),
new SqlParameter("StatusCair",StatusCair),
new SqlParameter("StatusDibayar",StatusDibayar),
new SqlParameter("Keterangan",Keterangan),
new SqlParameter("KodeSalesman",KodeSalesman),
new SqlParameter("No_Bukti",No_Bukti)
};
Result = dbo.RunProcedure("sp_BilyetGiro_Update", parameters, out RowsAffected);
return Result;
}
public Modul_Barang_Pemindahan(Modul_Barang_Data mbd)
{
InitializeComponent();
dbo = new DbObject();
obj = new stockMovement();
this.mdb = mbd;
}
public int UpdateRow(int id, string NomorBukti, float Qty, string KodeBarang, float HargaBeli, float Disc, float DiscRp, float SubJumlah, float Jumlah, string Keterangan, DateTime TglTransaksi, DateTime TglPembukuan, string KodeSupplier, float PPn, float PPnRp, float Bulat, DateTime TglKadaluarsa)
{
int RowsAffected = 0;
int Result = 0;
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("id",id),
new SqlParameter("NomorBukti",NomorBukti),
new SqlParameter("Qty",Qty),
new SqlParameter("KodeBarang",KodeBarang),
new SqlParameter("HargaBeli",HargaBeli),
new SqlParameter("Disc",Disc),
new SqlParameter("DiscRp",DiscRp),
new SqlParameter("SubJumlah",SubJumlah),
new SqlParameter("Jumlah",Jumlah),
new SqlParameter("Keterangan",Keterangan),
new SqlParameter("TglTransaksi",TglTransaksi),
new SqlParameter("TglPembukuan",TglPembukuan),
new SqlParameter("KodeSupplier",KodeSupplier),
new SqlParameter("PPn",PPn),
new SqlParameter("PPnRp",PPnRp),
new SqlParameter("Bulat",Bulat),
new SqlParameter("TglKadaluarsa",TglKadaluarsa)
};
Result = dbo.RunProcedure("sp_SubBeli_Update", parameters, out RowsAffected);
return Result;
}
public int UpdateRow(string KodePelanggan, string NamaPelanggan, string ContactPerson, string Alamat, string Kota, string KodePos, string Telepon1, string Telepon2, string Fax, string KodeArea, float PiutangAwal, string Acc_No, float JmlHari, float DiscTotal, float TotalPoint, string KodeGroup)
{
int RowsAffected = 0;
int Result = 0;
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("KodePelanggan",KodePelanggan),
new SqlParameter("NamaPelanggan",NamaPelanggan),
new SqlParameter("ContactPerson",ContactPerson),
new SqlParameter("Alamat",Alamat),
new SqlParameter("Kota",Kota),
new SqlParameter("KodePos",KodePos),
new SqlParameter("Telepon1",Telepon1),
new SqlParameter("Telepon2",Telepon2),
new SqlParameter("Fax",Fax),
new SqlParameter("KodeArea",KodeArea),
new SqlParameter("PiutangAwal",PiutangAwal),
new SqlParameter("Acc_No",Acc_No),
new SqlParameter("JmlHari",JmlHari),
new SqlParameter("DiscTotal",DiscTotal),
new SqlParameter("TotalPoint",TotalPoint),
new SqlParameter("KodeGroup",KodeGroup)
};
Result = dbo.RunProcedure("sp_Customer_Update", parameters, out RowsAffected);
return Result;
}
public Modul_Barang_Pemindahan(MainForm mf)
{
InitializeComponent();
dbo = new DbObject();
obj = new stockMovement();
this.mf = mf;
}
public int UpdateRow(string NoBG, string NamaBank, string NoRekening, DateTime TJT, DateTime TGLKeluar, string Untuk, string NamaToko, float NilaiGiro, bool StCair, bool StBatal, string Pribadi, float SaldoJml, string No_Bukti, string Keterangan)
{
int RowsAffected = 0;
int Result = 0;
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("NoBG",NoBG),
new SqlParameter("NamaBank",NamaBank),
new SqlParameter("NoRekening",NoRekening),
new SqlParameter("TJT",TJT),
new SqlParameter("TGLKeluar",TGLKeluar),
new SqlParameter("Untuk",Untuk),
new SqlParameter("NamaToko",NamaToko),
new SqlParameter("NilaiGiro",NilaiGiro),
new SqlParameter("StCair",StCair),
new SqlParameter("StBatal",StBatal),
new SqlParameter("Pribadi",Pribadi),
new SqlParameter("SaldoJml",SaldoJml),
new SqlParameter("No_Bukti",No_Bukti),
new SqlParameter("Keterangan",Keterangan)
};
Result = dbo.RunProcedure("sp_Giro_Update", parameters, out RowsAffected);
return Result;
}
public Modul_Akuntansi_TutupBuku()
{
InitializeComponent();
dbo = new DbObject();
obj = new JurnalUmum();
subObj = new SubJurnalUmum();
}
public Modul_Penjualan_PembayaranPiutang(Modul_Penjualan_DaftarPiutang daftarPiutang, DataGridViewRow dgvRow)
{
/*kodesupplier
namasupplier
faktur
tanggal faktur
saldo hutang
*/
InitializeComponent();
this.daftarPiutang = daftarPiutang;
this.dgvRow = dgvRow;
fakturTxt.Text = dgvRow.Cells[2].Value.ToString();
kodeCustomerTextBox.Text = dgvRow.Cells[0].Value.ToString();
namaCustomerTextBox.Text = dgvRow.Cells[1].Value.ToString();
pembayaranTxt.Text = "0" ;
sisaPiutangTxt.Text = allfunc.digit_separated(dgvRow.Cells[3].Value.ToString());
SqlDataReader sdr = dbo.get_single_data(new string[]{"NO_Bukti","TJT"},"FAKTUR",dgvRow.Cells[2].Value.ToString()+"' AND LOWER(posisiperkiraan) = 'debit","piutang");
while(sdr.Read())
{
tJTDateTimePicker.Value = (DateTime)sdr["TJT"];
noBuktiTxt.Text = (string)sdr["NO_Bukti"];
}
DbObject db1 = new DbObject();
SqlDataReader sdr1 = db1.get_single_data(new string[] { "JumlahPenjualan" }, "nobon", fakturTxt.Text, "jual");
while (sdr1.Read())
{
nominalTextBox.Text = allfunc.digit_separated(Convert.ToString((double)sdr1["JumlahPenjualan"]));
}
if(sisaPiutangTxt.Text.CompareTo("0")==0)
{
bayarBtn.Enabled = false;
}
}
public Modul_Pembelian_InputBarangPopup(Modul_Pembelian pembelian)
{
InitializeComponent();
this.pembelian = pembelian;
this.allFunc = new AllFunc();
this.allFunc.Prefix = "Stock";
this.dbo = new DbObject();
}
public SqlDataReader generateNoBukti()
{
SqlDataReader sdr = null;
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]{};
sdr = dbo.RunProcedure("sp_get_noBukti_jurnal_umum", parameters);
return sdr;
}
public Modul_Akuntansi_TutupBuku(MainForm mf)
{
InitializeComponent();
this.mf = mf;
dbo = new DbObject();
obj = new JurnalUmum();
subObj = new SubJurnalUmum();
}
public Modul_Pembelian_PurchaseOrder(MainForm mf)
{
InitializeComponent();
allFunc = new AllFunc("Purchase Order",mf);
dbo = new DbObject();
this.mf = mf;
}
public DataSet SelectRow(string id)
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("id",id)
};
return dbo.RunProcedure("sp_Gudang_SelectRow", parameters, "Gudang");
}
public DataSet SelectRow(int id)
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("id",id)
};
return dbo.RunProcedure("sp_SubJurnalUmum_SelectRow", parameters, "SubJurnalUmum");
}
public DataSet SelectAll()
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
};
return dbo.RunProcedure("sp_SubJurnalUmum_SelectAll", parameters, "SubJurnalUmum");
}
public DataSet SelectAll()
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
};
return dbo.RunProcedure("sp_OwnerIdentity_SelectAll", parameters, "OwnerIdentity");
}
public DataSet SelectRow(string NomorGiro)
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("NomorGiro",NomorGiro)
};
return dbo.RunProcedure("sp_BilyetGiro_SelectRow", parameters, "BilyetGiro");
}
public DataSet SelectAll()
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
};
return dbo.RunProcedure("sp_BilyetGiro_SelectAll", parameters, "BilyetGiro");
}
public DataSet SelectRow(string NomorCek)
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("NomorCek",NomorCek)
};
return dbo.RunProcedure("sp_Cek_SelectRow", parameters, "Cek");
}
public DataSet SelectRow(string NoBon)
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("NoBon",NoBon)
};
return dbo.RunProcedure("sp_Jual_SelectRow", parameters, "Jual");
}
public DataSet SelectRow(string KodeGroup)
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("KodeGroup",KodeGroup)
};
return dbo.RunProcedure("sp_GroupCustomer_SelectRow", parameters, "GroupCustomer");
}
public DataSet SelectRow(int id)
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("id",id)
};
return dbo.RunProcedure("sp_StockHarga_SelectRow", parameters, "StockHarga");
}
public DataSet SelectAll()
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
};
return dbo.RunProcedure("sp_StockHarga_SelectAll", parameters, "StockHarga");
}
public DataSet SelectRow(string NamaPerusahaan)
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("NamaPerusahaan",NamaPerusahaan)
};
return dbo.RunProcedure("sp_OwnerIdentity_SelectRow", parameters, "OwnerIdentity");
}
public DataSet SelectAll()
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
};
return dbo.RunProcedure("sp_Dokter_SelectAll", parameters, "Dokter");
}
public DataSet SelectRow(string NamaSatuan)
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("NamaSatuan",NamaSatuan)
};
return dbo.RunProcedure("sp_Satuan_SelectRow", parameters, "Satuan");
}
public DataSet SelectRow(string KodeDokter)
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("KodeDokter",KodeDokter)
};
return dbo.RunProcedure("sp_Dokter_SelectRow", parameters, "Dokter");
}
public DataSet SelectRow(string KodeSistem)
{
DbObject dbo = new DbObject();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("KodeSistem",KodeSistem)
};
return dbo.RunProcedure("sp_Sistem_SelectRow", parameters, "Sistem");
}
