Esempio n. 1
0
        public void UpdateHDN(EC_CTHD et)
        {
            string sql = "SuaHDN";
            SqlConnection con = new SqlConnection(KetNoiDB.getconnect());
            con.Open();
            SqlCommand cmd = new SqlCommand(sql, con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@mahd", et.MaHD);
            cmd.Parameters.AddWithValue("@masp", et.MaSP);
            cmd.Parameters.AddWithValue("@soluong", et.SoLuong);
            cmd.Parameters.AddWithValue("@dongia", et.GiaNhap);
            cmd.Parameters.AddWithValue("@thanhtien", et.ThanhTien);

            cmd.ExecuteNonQuery();
            cmd.Dispose();
            con.Close();
        }
Esempio n. 2
0
        public void UpdateHDN(EC_CTHD et)
        {
            string        sql = "SuaHDN";
            SqlConnection con = new SqlConnection(KetNoiDB.getconnect());

            con.Open();
            SqlCommand cmd = new SqlCommand(sql, con);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@mahd", et.MaHD);
            cmd.Parameters.AddWithValue("@masp", et.MaSP);
            cmd.Parameters.AddWithValue("@soluong", et.SoLuong);
            cmd.Parameters.AddWithValue("@dongia", et.GiaNhap);
            cmd.Parameters.AddWithValue("@thanhtien", et.ThanhTien);

            cmd.ExecuteNonQuery();
            cmd.Dispose();
            con.Close();
        }