datavisit.cs

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

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Runtime.Serialization;
using System.Runtime.Serialization.Formatters.Binary;
/// <summary>
/// DataVisit 的摘要说明
/// </summary>
public class DataVisit
{
	public DataVisit()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public string name;
    public string URL;
    public string Director;
    public string Actor;
    public string Detail;
    public string time;
    public int Hit;
    public string Category;
    public string Region;
    public int playtime;


    //从数据库检验用户登录
    public bool Confirm(string UserName, string UserPwd)
    {
        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
        SqlCommand mycmd = new SqlCommand("Confirm",myconn);
        mycmd.CommandType = CommandType.StoredProcedure;
        
        SqlParameter UserNameparameter = new SqlParameter("@UserName",SqlDbType.VarChar,50);
        UserNameparameter.Value = UserName;

        SqlParameter UserPwdparameter = new SqlParameter("@UserPwd",SqlDbType.VarChar,50);
        UserPwdparameter.Value = UserPwd;

        mycmd.Parameters.Add(UserNameparameter);
        mycmd.Parameters.Add(UserPwdparameter);
  
        myconn.Open();
        
         SqlDataReader mydr = mycmd.ExecuteReader();
        if (mydr.Read())
        {
            myconn.Close();
            mydr.Close();
            mycmd.Dispose();
            return true;
        }
        else
        {

            myconn.Close();
            mydr.Close();
            mycmd.Dispose();
            return false;
        }
        
        
    }
    //从数据库取出用户角色
    public string GetRoles(string UserName)
    {
        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
        SqlCommand mycmd = new SqlCommand("GetRoles",myconn);
        mycmd.CommandType = CommandType.StoredProcedure;

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

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

        myconn.Open();
        SqlDataReader mydr = mycmd.ExecuteReader();
       
        mycmd.Dispose();
        myconn.Close();
        mydr.Close();

        return RoleNameparameter.Value.ToString(); ;

    }
    //从数据库中取出电影点击排行
    public SqlDataReader GetRanked()
    {
        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
        SqlCommand mycmd = new SqlCommand("GetRanked",myconn);
        mycmd.CommandType = CommandType.StoredProcedure;

        myconn.Open();

        SqlDataReader mydr = mycmd.ExecuteReader(CommandBehavior.CloseConnection);
        //myconn.Close();
        mycmd.Dispose();

        return mydr;
            
     }
   //从数据库取最近的出电影
    public SqlDataReader GetNew()
    {
        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
        SqlCommand mycmd = new SqlCommand("GetNew", myconn);
        mycmd.CommandType = CommandType.StoredProcedure;

        myconn.Open();

        SqlDataReader mydr = mycmd.ExecuteReader(CommandBehavior.CloseConnection);
        //myconn.Close();
        mycmd.Dispose();

        return mydr;
    
    }
    //验证用户名
    public bool CheckName(string Name)
    {
        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
        SqlCommand mycmd = new SqlCommand("CheckName", myconn);
        mycmd.CommandType = CommandType.StoredProcedure;

        SqlParameter UserNameparameter = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
        UserNameparameter.Value =Name;
        mycmd.Parameters.Add(UserNameparameter);

        myconn.Open();
        SqlDataReader mydr = mycmd.ExecuteReader();
        if (mydr.Read())
        {
            myconn.Close();
            mydr.Close();
            mycmd.Dispose();
            return true;
        }
        else
        {

            myconn.Close();
            mydr.Close();
            mycmd.Dispose();
            return false;
        }
    }
    //注册用户
    public bool Register(string txtname,string txtpwd,string txtemail,string txtsex,string txtxz,string txtphone,string txtqq)
    {
        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
        SqlCommand mycmd = new SqlCommand("Register", myconn);
        mycmd.CommandType = CommandType.StoredProcedure;

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

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

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

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

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

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

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

        myconn.Open();
        SqlDataReader mydr = mycmd.ExecuteReader();
        mycmd.Dispose();
        mydr.Close();
        myconn.Close();

        return true;
    }
   
   //电影列表
    public DataTable getCategory(string category)
    {
        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ConnectionString);
        SqlCommand mycmd = new SqlCommand("getCategory",myconn);
        mycmd.CommandType = CommandType.StoredProcedure;

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

        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 FilmDetail(int FilmID)
    {
        SqlConnection myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlfilm"].ToString());
        SqlCommand mycmd = new SqlCommand("FilmDetail", myconn);
        mycmd.CommandType = CommandType.StoredProcedure;

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

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

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

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