// ....
// rest of your form Code
private void txtCarga_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F1)
{
this.Hide();
frmPesquisa frmP = new frmPesquisa(this); // Pass a reference to this form
frmP.Show();
con = new SqlConnection(cs.DBConnP);
con.Open();
string querySelect = @"SELECT CL.Cargs
FROM CargsCab CC (NOLOCK)
INNER JOIN CargsLin CL (NOLOCK) ON CC.Cargs = CL.Cargs
INNER JOIN Stock S (NOLOCK) ON CL.Code = S.Code
WHERE CC.Date >= GETDATE() - 120 AND CL.State NOT IN ('F', 'A') AND S.Type = 'P'
AND CC.TypeB = 'OCS' AND CL.Cargs LIKE '%" + txtCargs.Text + "%' GROUP BY CL.Cargs ORDER BY CL.Cargs DESC";
cmd = new SqlCommand(querySelect);
cmd.Connection = con;
cmd.Parameters.Add(new SqlParameter("@Cargs", SqlDbType.NChar, 20, "CL.Cargs"));
cmd.Parameters["@Cargs"].Value = txtCargs.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "CargsCab");
frmP.dataGridView1.DataSource = ds.Tables["CargsCab"].DefaultView;
txtCarga.SelectAll();
con.Close();
}
}
public override void DoPesquisa()
{
frmPesquisa form = new frmPesquisa();
form.Bind<gestor>(DataContext, new Search[] {
new Search { Campo = "nome", Tipo = typeof(string), Titulo = "nome" }});
if (form.ShowDialog() == DialogResult.OK)
{
this.gestorBindingSource.DataSource = form.Selected;
}
}
public override void DoPesquisa()
{
frmPesquisa form = new frmPesquisa();
string defaultFilter = string.Format("and departamento_id in (select departamento_id from departamento where empresa_id={0})", DataContext.EmpresaAtual.empresa_id);
form.Bind<setor>(DataContext, new Search[] {
new Search { Campo = "descricao", Tipo = typeof(string), Titulo = "Descrição" },
new Search { Campo = "codigo", Tipo = typeof(int), Titulo = "Código" } },defaultFilter);
if (form.ShowDialog() == DialogResult.OK)
{
this.setorBindingSource.DataSource = form.Selected;
}
}
public override void DoPesquisa()
{
frmPesquisa form = new frmPesquisa();
string defaultFilter = string.Format("and empresa_id={0}",DataContext.EmpresaAtual.empresa_id);
form.Bind<funcionario>(DataContext, new Search[] {
new Search { Campo = "nome", Tipo = typeof(string), Titulo = "Nome" },
new Search { Campo = "matricula", Tipo = typeof(int), Titulo = "Matrícula" } }, defaultFilter);
if (form.ShowDialog() == DialogResult.OK)
{
this.funcionarioBindingSource.DataSource = form.Selected;
}
}
private void btnProduto_Click(object sender, EventArgs e)
{
frmPesquisa frm = new frmPesquisa(ETabela.PRODUTO);
frm.ShowDialog();
}
private void btnDepartamento_Click(object sender, EventArgs e)
{
frmPesquisa frm = new frmPesquisa(ETabela.DEPARTAMENTO);
frm.ShowDialog();
}
