C# (CSharp) SlnArCond Dao.SqlConn示例

示例#1

        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();
            }
        }

示例#2

文件： CadastroManu.aspx.cs 项目： renancosta7/SGMAC

        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);
            }
        }

示例#3

文件： ResumoVenda.aspx.cs 项目： renancosta7/SGMAC

 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);
     }
 }

示例#4

        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);
            }
        }

示例#5

文件： CadastroManu.aspx.cs 项目： renancosta7/SGMAC

        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);

            }
        }

示例#6

文件： ConsManuAr.aspx.cs 项目： renancosta7/SGMAC

 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();
     }
 }