public void BuscaCpf() { int Cod = 0; Dao D = new Dao(); SqlConnection Cn = D.SqlConn(); StringBuilder Sb = new StringBuilder(); Sb.Append("Select Cod_Cliente from tbCliente Where Cpf=@Cpf"); SqlCommand cmd = new SqlCommand(Sb.ToString(), Cn); cmd.Parameters.AddWithValue("@Cpf", txtBuscaCpf.Text); Cod = Convert.ToInt32(cmd.ExecuteScalar()); Cn.Close(); if (Cod <= 0) { lblCpf.Visible = true; hpCadCliente.Visible = true; } else { mManuAr M = new mManuAr(); List <pManuAr> Lc = M.SelManu(Cod); gdvManu.DataSource = Lc; gdvManu.DataBind(); } }
protected void btnBuscar_Click(object sender, EventArgs e) { //string Cpf; int Cod = 0; Dao D = new Dao(); SqlConnection Cn = D.SqlConn(); StringBuilder Sb = new StringBuilder(); Sb.Append("Select Cod_Cliente from tbCliente Where Cpf=@Cpf"); SqlCommand cmd = new SqlCommand(Sb.ToString(), Cn); cmd.Parameters.AddWithValue("@Cpf", txtBuscaCpf.Text); Cod = Convert.ToInt32(cmd.ExecuteScalar()); Cn.Close(); if (Cod <= 0) { lblCpf.Visible = true; hpCadCliente.Visible = true; } else { Form.Visible = true; txtCodCliente.Text = Convert.ToString(Cod); } }
public void RetornaCod() { Dao D = new Dao(); SqlConnection Cn = D.SqlConn(); StringBuilder Sb = new StringBuilder(); Sb.Append("Select MAX(Cod_Pedido) From tbPedido"); SqlCommand cmd = new SqlCommand(Sb.ToString(), Cn); Cod_Pedido = Convert.ToInt32(cmd.ExecuteScalar()); lblCodPedido.Text = Convert.ToString(Cod_Pedido); Cn.Close(); List<pCarrinho> Lp = Session["Carrinho"] as List<pCarrinho>; for (int i = 0; i < Lp.Count; i++) { D.InsItemPedido(Lp[i].Cod_Pecas, Lp[i].Descricao, Lp[i].Valor_Saida, Lp[i].pQuantidade, Lp[i].Total, Cod_Pedido); //D.InsItemPedido(Lp[i].Cod_Pecas, Lp[i].pQuantidade, Cod_Pedido); } }
public void RetornaCod() { Dao D = new Dao(); SqlConnection Cn = D.SqlConn(); StringBuilder Sb = new StringBuilder(); Sb.Append("Select MAX(Cod_Pedido) From tbPedido"); SqlCommand cmd = new SqlCommand(Sb.ToString(), Cn); Cod_Pedido = Convert.ToInt32(cmd.ExecuteScalar()); lblCodPedido.Text = Convert.ToString(Cod_Pedido); Cn.Close(); List <pCarrinho> Lp = Session["Carrinho"] as List <pCarrinho>; for (int i = 0; i < Lp.Count; i++) { D.InsItemPedido(Lp[i].Cod_Pecas, Lp[i].Descricao, Lp[i].Valor_Saida, Lp[i].pQuantidade, Lp[i].Total, Cod_Pedido); //D.InsItemPedido(Lp[i].Cod_Pecas, Lp[i].pQuantidade, Cod_Pedido); } }
public void BuscaCpf() { int Cod = 0; Dao D = new Dao(); SqlConnection Cn = D.SqlConn(); StringBuilder Sb = new StringBuilder(); Sb.Append("Select Cod_Cliente from tbCliente Where Cpf=@Cpf"); SqlCommand cmd = new SqlCommand(Sb.ToString(), Cn); cmd.Parameters.AddWithValue("@Cpf", txtBuscaCpf.Text); Cod = Convert.ToInt32(cmd.ExecuteScalar()); Cn.Close(); if (Cod <= 0) { lblCpf.Visible = true; hpCadCliente.Visible = true; } else { mManuAr M = new mManuAr(); List<pManuAr> Lc = M.SelManu(Cod); gdvManu.DataSource = Lc; gdvManu.DataBind(); } }