datavisit.cs

.net的一个很经典很普通的实例

        SqlParameter Actorparameter = new SqlParameter("@Actor", SqlDbType.VarChar, 50);
        Actorparameter.Direction = ParameterDirection.Output;
        mycmd.Parameters.Add(Actorparameter);

        SqlParameter Detailparameter = new SqlParameter("@Detail", SqlDbType.VarChar, 4000);
        Detailparameter.Direction = ParameterDirection.Output;
        mycmd.Parameters.Add(Detailparameter);

        SqlParameter timeparameter = new SqlParameter("@time", SqlDbType.VarChar, 50);
        timeparameter.Direction = ParameterDirection.Output;
        mycmd.Parameters.Add(timeparameter);

        SqlParameter Hitparameter = new SqlParameter("@Hit", SqlDbType.Int, 4);
        Hitparameter.Direction = ParameterDirection.Output;
        mycmd.Parameters.Add(Hitparameter);

        SqlParameter Categoryparameter = new SqlParameter("@Category", SqlDbType.VarChar, 50);
        Categoryparameter.Direction = ParameterDirection.Output;
        mycmd.Parameters.Add(Categoryparameter);

        SqlParameter Regionparameter = new SqlParameter("@Region", SqlDbType.VarChar, 50);
        Regionparameter.Direction = ParameterDirection.Output;
        mycmd.Parameters.Add(Regionparameter);

        SqlParameter playtimeparameter = new SqlParameter("@playtime", SqlDbType.Int, 4);
        playtimeparameter.Direction = ParameterDirection.Output;
        mycmd.Parameters.Add(playtimeparameter);

        myconn.Open();
        mycmd.ExecuteNonQuery();


        name = nameparameter.Value.ToString();
        URL = URLparameter.Value.ToString();
        Director =Directorparameter.Value.ToString();
        Actor = Actorparameter.Value.ToString();
        Detail = Detailparameter.Value.ToString();
        time = timeparameter.Value.ToString();
        Hit =Convert.ToInt32( Hitparameter.Value);
        Category = Categoryparameter.Value.ToString();
        Region = Regionparameter.Value.ToString();
        playtime =Convert.ToInt32( playtimeparameter.Value);

        myconn.Close();
        mycmd.Dispose();
    }
    //获取电影地址
    public string getURL(int filmid)
    {
        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ConnectionString);
        SqlCommand mycmd = new SqlCommand("getURL", myconn);
        mycmd.CommandType = CommandType.StoredProcedure;


        SqlParameter playurlparameter = new SqlParameter("@playurl", SqlDbType.VarChar, 50);
        playurlparameter.Direction=ParameterDirection.Output;
        mycmd.Parameters.Add(playurlparameter);
        
        SqlParameter idparemeter = new SqlParameter("@filmid",SqlDbType.Int,4);
        idparemeter.Value = filmid;
        mycmd.Parameters.Add(idparemeter);

        myconn.Open();
        mycmd.ExecuteNonQuery();

        myconn.Close();
        mycmd.Dispose();

        return playurlparameter.Value.ToString();
    
    }
    //查询结果
    public DataTable seachFilm(string FilmName,string ActorName,string Director,string timeOn)
    {
        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ConnectionString);
        SqlCommand mycmd = new SqlCommand("getResult", myconn);
        mycmd.CommandType = CommandType.StoredProcedure;

        SqlParameter FilmNameparameter = new SqlParameter("@FilmName", SqlDbType.VarChar, 50);
        FilmNameparameter.Value = FilmName;
        mycmd.Parameters.Add(FilmNameparameter);
        
        SqlParameter ActorNameparameter = new SqlParameter("@ActorName", SqlDbType.VarChar, 50);
        ActorNameparameter.Value = ActorName;
        mycmd.Parameters.Add(ActorNameparameter);

        SqlParameter Directorparameter = new SqlParameter("@Director", SqlDbType.VarChar, 50);
        Directorparameter.Value = Director;
        mycmd.Parameters.Add(Directorparameter);

        SqlParameter timeOnparameter = new SqlParameter("@timeOn", SqlDbType.VarChar, 50);
        timeOnparameter.Value =timeOn;
        mycmd.Parameters.Add(timeOnparameter);

        SqlDataAdapter myda = new SqlDataAdapter();
        myda.SelectCommand = mycmd;

        DataSet myds = new DataSet();
        myda.Fill(myds);

        myconn.Close();
        mycmd.Dispose();
        myda.Dispose();


        return myds.Tables[0];
    }
    //修改用户信息
    public void change(string name,string pwd,string email,string phone,string qq)
    {
        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
        SqlCommand mycmd = new SqlCommand("change", myconn);
        mycmd.CommandType = CommandType.StoredProcedure;

        SqlParameter txtpwdparameter = new SqlParameter("@pwd", SqlDbType.VarChar, 50);
        txtpwdparameter.Value = pwd;
        mycmd.Parameters.Add(txtpwdparameter);

        SqlParameter txtemailparameter = new SqlParameter("@email", SqlDbType.VarChar, 50);
        txtemailparameter.Value = email;
        mycmd.Parameters.Add(txtemailparameter);

        SqlParameter txtphoneparameter = new SqlParameter("@phone", SqlDbType.VarChar, 50);
        txtphoneparameter.Value = phone;
        mycmd.Parameters.Add(txtphoneparameter);

        SqlParameter txtqqparameter = new SqlParameter("@qq", SqlDbType.VarChar, 50);
        txtqqparameter.Value = qq;
        mycmd.Parameters.Add(txtqqparameter);

        SqlParameter nameparameter = new SqlParameter("@name", SqlDbType.VarChar, 50);
        nameparameter.Value = name;
        mycmd.Parameters.Add(nameparameter);

     

        myconn.Open();
        mycmd.ExecuteNonQuery();

        myconn.Close();
        mycmd.Dispose();

    }
    //获取用户收藏
    public DataSet getfavor(string name)
    {
        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
        SqlCommand mycmd = new SqlCommand("getfavor", myconn);
        mycmd.CommandType = CommandType.StoredProcedure;

        SqlParameter nameparameter = new SqlParameter("@name", SqlDbType.VarChar, 50);
        nameparameter.Value = name;
        mycmd.Parameters.Add(nameparameter);

        SqlDataAdapter myda = new SqlDataAdapter();
        myda.SelectCommand=mycmd;
        DataSet myds = new DataSet();
        myda.Fill(myds);

       

        myconn.Close();
        mycmd.Dispose();
        myda.Dispose();

        return myds;

    }
    //用户删除收藏的电影
    public void deletefilm(int filmid,string name)
    {
        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
        SqlCommand mycmd = new SqlCommand("deletefilm", myconn);
        mycmd.CommandType = CommandType.StoredProcedure;

        SqlParameter filmidparameter = new SqlParameter("@filmid", SqlDbType.VarChar, 50);
        filmidparameter.Value = filmid;
        mycmd.Parameters.Add(filmidparameter);

        SqlParameter nameparameter = new SqlParameter("@name", SqlDbType.VarChar, 50);
        nameparameter.Value = name;
        mycmd.Parameters.Add(nameparameter);

        myconn.Open();
        mycmd.ExecuteNonQuery();

        myconn.Close();
        mycmd.Dispose();

    }
    //增加用户收藏的电影
    public void addfilm(int filmid,string name)
    {
        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
        SqlCommand mycmd = new SqlCommand("addfilm", myconn);
        mycmd.CommandType = CommandType.StoredProcedure;

        SqlParameter filmidparameter = new SqlParameter("@filmid", SqlDbType.Int, 4);
        filmidparameter.Value = filmid;
        mycmd.Parameters.Add(filmidparameter);

        SqlParameter nameparameter = new SqlParameter("@name", SqlDbType.VarChar, 50);
        nameparameter.Value = name;
        mycmd.Parameters.Add(nameparameter);

        myconn.Open();
        mycmd.ExecuteNonQuery();

        myconn.Close();
        mycmd.Dispose();

    }
    //判断用户电影是否的唯一
    public bool comfirmfilm(int filmid, string name)
    {

        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
        SqlCommand mycmd = new SqlCommand("comfirmfilm", myconn);
        mycmd.CommandType = CommandType.StoredProcedure;

        SqlParameter filmidparameter = new SqlParameter("@filmid", SqlDbType.Int, 4);
        filmidparameter.Value = filmid;
        mycmd.Parameters.Add(filmidparameter);

        SqlParameter nameparameter = new SqlParameter("@name", SqlDbType.VarChar, 50);
        nameparameter.Value = name;
        mycmd.Parameters.Add(nameparameter);

        myconn.Open();

        SqlDataReader mydr = mycmd.ExecuteReader();

        if (mydr.Read())
        {
            myconn.Close();
            mycmd.Dispose();
            return false;
        }
        else
        {

            myconn.Close();
            mycmd.Dispose();
            return true;
        }
    }
}