private void btnBrowseKodePembelian_Click(object sender, EventArgs e)
{
frmBrowse browse = new frmBrowse("pembelian");
browse.ShowDialog();
Dictionary <string, string> datas = browse.getData();
if (datas.Count > 0)
{
Supplier supplier = Supplier.FindOneById(Convert.ToInt32(datas["id_supplier"]));
id_supplier = supplier.getId();
txtKodePembelian.Text = datas["kode"];
txtSupplier.Text = supplier.getNama();
DataTable dt = PembelianDetail.FindByIdPembelian(Convert.ToInt32(datas["id"]));
dgvPembelianDetail.DataSource = dt;
dgvPembelianDetail.Refresh();
decimal sum = 0;
foreach (DataRow dr in dt.Rows)
{
sum += Convert.ToDecimal(dr["harga_barang"]) * Convert.ToInt32(dr["kuantitas"]);
}
txtTotalHargaPembelian.Text = sum.ToString();
}
}
private void buttonBrowse_Click(object sender, EventArgs e)
{
if (CurrentDocSet == null)
{
return;
}
GlobalsDocDB.frmBrowse browser = new frmBrowse();
browser.InitForDocSet(CurrentDocSet);
browser.ShowDialog();
}
private void btnBrowseCustomer_Click(object sender, EventArgs e)
{
frmBrowse browse = new frmBrowse("customer");
browse.ShowDialog();
Dictionary <string, string> datas = browse.getData();
if (datas.Count > 0)
{
id_customer = Convert.ToInt32(datas["id"]);
txtCustomer.Text = String.Concat(datas["nama"]);
}
}
private void btnBrowseBarangPembelian_Click(object sender, EventArgs e)
{
frmBrowse browse = new frmBrowse("barang");
browse.ShowDialog();
Dictionary <string, string> datas = browse.getData();
if (datas.Count > 0)
{
id_barang_pembelian = Convert.ToInt32(datas["id"]);
txtBarangPembelian.Text = String.Concat(datas["kode"], " - ", datas["nama"]);
txtHargaBarangPembelian.Text = datas["harga_jual"];
}
}
private void btnBrowseSupplier_Click(object sender, EventArgs e)
{
frmBrowse browse = new frmBrowse("supplier");
browse.ShowDialog();
Dictionary <string, string> datas = browse.getData();
if (datas.Count > 0)
{
txtIdSupplier.Text = datas["id"];
txtNamaSupplier.Text = datas["nama"];
txtAlamatSupplier.Text = datas["alamat"];
txtTeleponSupplier.Text = datas["nomor_telepon"];
}
}
private void btnBrowseBarang_Click(object sender, EventArgs e)
{
frmBrowse browse = new frmBrowse("barang");
browse.ShowDialog();
Dictionary <string, string> datas = browse.getData();
if (datas.Count > 0)
{
txtIdBarang.Text = datas["id"];
txtKode.Text = datas["kode"];
txtNamaBarang.Text = datas["nama"];
txtJumlahAwal.Text = datas["jumlah"];
txtHargaHpp.Text = datas["harga_hpp"];
txtHargaJual.Text = datas["harga_jual"];
}
}
private void lblBrowse_Click(object sender, EventArgs e)
{
frmBrowse frmBrowse = new frmBrowse();
frmBrowse._ObjTable = "OITM";
frmBrowse._ObjName = "Item List";
frmBrowse._sqlQuery = @"SELECT A.ItemCode, A.ItemName FROM OITM A";
frmBrowse.ShowDialog();
txtCode.Text = frmBrowse._Code;
txtName.Text = frmBrowse._Name;
frmBrowse._Code = "";
frmBrowse._Name = "";
}
private void lblBrowse_Click(object sender, EventArgs e)
{
frmBrowse frmBrowse = new frmBrowse();
frmBrowse._ObjTable = "OWHS";
frmBrowse._ObjName = "Branch List";
frmBrowse._sqlQuery = @" SELECT A.WhsCode AS Code, A.WhsName AS Name,B.Location AS Area
FROM OWHS A
LEFT OUTER JOIN OLCT B ON A.Location = B.Code
WHERE A.WhsCode NOT IN (SELECT DISTINCT Z.Code FROM [@OBPL] Z)";
frmBrowse.ShowDialog();
txtCode.Text = frmBrowse._Code;
txtName.Text = frmBrowse._Name;
txtArea.Text = frmBrowse._Area;
frmBrowse._Code = "";
frmBrowse._Name = "";
frmBrowse._Area = "";
}
