private void btn_lov_po_Click(object sender, EventArgs e)
{
var sql = "select a.PO_id,a.PO_date,a.PO_Number,case when a.status = 1 then 'Close' else 'Open' end from TPurchaseOrder as a where a.PSupplierId =" + txt_supplier_id.Text + " and a.status=0";
FormLov = new LOVForm(sql, this, txt_Po_show, txt_po_id, "a.PO_Number", new string[] { "ID", "Tanggal PO", "Nomor PO", "Status" }, "a.PO_id");
FormLov.ShowDialog();
}
private void btn_search_LOV_Click_1(object sender, EventArgs e)
{
var sql = "select a.Items_Id,a.Items_number,a.Items_Name,a.Stock " +
"FROM dbo.TInventory AS a " +
" where 1=1 ";
FormLov = new LOVForm(sql, this, txt_items_show, txt_items_id, "a.Items_Name", new string[] { "ID", "Kode Item", "Nama Item", "stock" }, "a.Items_Id");
FormLov.ShowDialog();
}
private void btn_LovSupp_Click(object sender, EventArgs e)
{
var sql = "select a.Supplier_id,a.contact_Person,a.supplier_name,a.supplier_address " +
"FROM dbo.PSupplier AS a " +
" where 1=1 ";
FormLov = new LOVForm(sql, this, txt_supplier_show, txt_supplier_id, "a.supplier_name", new string[] { "ID", "Kontak Person", "Nama Supplier", "Alamat" }, "a.Supplier_id");
FormLov.ShowDialog();
}