public DataSet getNomorSP(Pesanan request)
{
DataSet ds = new DataSet();
try
{
koneksi.Open();
query = "SELECT MAX(notasp) as notasp FROM ap_pesanbrg " +
"WHERE YEAR(tanggal) ='" + request.Tanggal_akhir + "' AND MONTH(tanggal)='" + request.Tanggal_awal + "'";
command = new SqlCommand(query, koneksi);
adapter = new SqlDataAdapter(command);
adapter.Fill(ds);
koneksi.Close();
}
catch (SqlException)
{
}
return(ds);
}
public DataSet getPesanan(Pesanan request)
{
DataSet ds = new DataSet();
try
{
koneksi.Open();
query = "SELECT pas.nmkasir, psn.tanggal, psn.notasp, psn.jns_obat, psn.nmsuplier, psn.kd_barang, psn.nama_barang," +
"psn.harga, psn.jml, psn.nmsatuan, psn.jmlharga, psn.ttlmasuk, psn.ttlsisa, psn.stspesan FROM ap_pesanbrg as psn " +
"JOIN ap_pas_farmasi as pas ON psn.kdkasir = pas.kdkasir " +
"WHERE psn.nama_barang LIKE '%" + request.Cari + "%' AND tanggal >='" + request.Tanggal_awal + "' AND tanggal <='" + request.Tanggal_akhir + "' AND psn.jns_obat LIKE '%" + request.Jenis_obat + "%'" +
"OR psn.nmsuplier LIKE '%" + request.Cari + "%' AND tanggal >='" + request.Tanggal_awal + "' AND tanggal <='" + request.Tanggal_akhir + "' AND psn.jns_obat LIKE '%" + request.Jenis_obat + "%'" +
"OR psn.notasp LIKE '%" + request.Cari + "%' AND tanggal >='" + request.Tanggal_awal + "' AND tanggal <='" + request.Tanggal_akhir + "' AND psn.jns_obat LIKE '%" + request.Jenis_obat + "%' ORDER BY psn.tanggal";
command = new SqlCommand(query, koneksi);
adapter = new SqlDataAdapter(command);
adapter.Fill(ds);
koneksi.Close();
}
catch (SqlException)
{
}
return(ds);
}