playermanager.cs

B/S asp.net的C#编的网站

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;

/// <summary>
/// PlayerManager 的摘要说明
/// </summary>
public class PlayerManager
{

    //public Player thisPlayer;
    private string constr = ConfigurationManager.AppSettings["constr"].ToString();
    private SqlConnection con;
    private SqlCommand cmd;
    private SqlDataAdapter adapter;
    private DataSet ds;

	public PlayerManager()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
        con = new SqlConnection(constr);
        adapter = new SqlDataAdapter();       

	}
    

    public int ReturnAmount(string teamID)
    {
        try
        {
            con.Open();
            string selectstr = "select * from Team  where TeamID = @teamID";
            cmd = new SqlCommand(selectstr, con);
            cmd.Parameters.Add("@teamID", SqlDbType.Char, 20).Value = teamID;
            adapter.SelectCommand = cmd;
            ds = new DataSet();
            adapter.Fill(ds);
        }
        catch (SqlException e)
        {
            e.ToString();
        }
        finally
        {
            con.Close();
        }
        return Convert.ToInt32(ds.Tables[0].Rows[0][4]);
    }

    public Player PlayerInfoLoadbyID(Player player)
    {
        try
        {
            con.Open();
            string selectstr = "select * from [Player] where PlayerID = @PlayerID";
            cmd = new SqlCommand(selectstr, con);
            cmd.Parameters.Add("@PlayerID", SqlDbType.Int).Value = player.PlayerID;
            adapter.SelectCommand = cmd;
            ds = new DataSet();
            adapter.Fill(ds);
        }
        catch (SqlException e)
        {
            e.ToString();
        }
        finally
        {
            con.Close();
        }

        if (ds.Tables[0].Rows.Count != 0)
        {            
            player.PlayerName = ds.Tables[0].Rows[0][1].ToString();
            player.PlayerSex = ds.Tables[0].Rows[0][2].ToString();
            player.PlayerAge = Convert.ToInt32(ds.Tables[0].Rows[0][3]);
            player.PlayerSize = ds.Tables[0].Rows[0][4].ToString();
            player.PlayerPhone = ds.Tables[0].Rows[0][5].ToString();
            player.PlayerMobile = ds.Tables[0].Rows[0][6].ToString();
            player.PlayerMail = ds.Tables[0].Rows[0][7].ToString();
            player.PlayerAddress = ds.Tables[0].Rows[0][8].ToString();
            player.PlayerCode = ds.Tables[0].Rows[0][9].ToString();
            player.PlayerMSchool = ds.Tables[0].Rows[0][10].ToString();
            player.PlayerHSchool = ds.Tables[0].Rows[0][11].ToString();
            player.PlayerTeamID = Convert.ToInt32(ds.Tables[0].Rows[0][12]);
            player.PlayerMerit = ds.Tables[0].Rows[0][13].ToString();

        }
        else
        {
            player.PlayerID = -1;
        }

        return player;

    }

      
    public void PlayerReg(Player player)
    {

        try
        {
            con.Open();
            string insertstr = "INSERT INTO [Player] ( Name , Sex , Age ,[Size] , Phone , Mobile, Email , Address,Code,HSchool,MSchool,TeamID,Merit) VALUES ( @Name , @Sex , @Age ,@Size , @Phone , @Mobile, @Email , @Address,@Code,@HSchool,@MSchool,@TeamID,@Merit)";
            cmd = new SqlCommand(insertstr, con);
            cmd.Parameters.Add("@Name", SqlDbType.VarChar, 50).Value = player.PlayerName;
            cmd.Parameters.Add("@Sex", SqlDbType.Char, 5).Value = player.PlayerSex;
            cmd.Parameters.Add("@Age", SqlDbType.SmallInt).Value = player.PlayerAge;
            cmd.Parameters.Add("@Size", SqlDbType.Char, 2).Value = player.PlayerSize;
            cmd.Parameters.Add("@Phone", SqlDbType.VarChar, 50).Value = player.PlayerPhone;
            cmd.Parameters.Add("@Mobile", SqlDbType.VarChar, 50).Value = player.PlayerMobile;
            cmd.Parameters.Add("@Email", SqlDbType.VarChar, 50).Value = player.PlayerMail;
            cmd.Parameters.Add("@Address", SqlDbType.VarChar, 50).Value = player.PlayerAddress;
            cmd.Parameters.Add("@Code", SqlDbType.VarChar,50).Value = player.PlayerCode;
            cmd.Parameters.Add("@MSchool", SqlDbType.VarChar, 50).Value = player.PlayerMSchool;
            cmd.Parameters.Add("@HSchool", SqlDbType.VarChar, 50).Value = player.PlayerHSchool;
            cmd.Parameters.Add("@TeamID", SqlDbType.Int).Value = player.PlayerTeamID;
            cmd.Parameters.Add("@Merit", SqlDbType.Char, 50).Value = player.PlayerMerit;
            

            cmd.ExecuteNonQuery();
        }
        catch (SqlException e)
        {
            e.ToString();
        }
        finally
        {
            con.Close();

        }

    }

    
    /*public void PlayerInfoUpdate(Player player)
    {
        ArrayList Content = new ArrayList();
        ArrayList Values = new ArrayList();

        if (player.PlayerName != null)
        {
            Content.Add(1);
            Values.Add(player.PlayerName);
        }
        if (player.PlayerSex != null)
        {
            Content.Add(2);
            Values.Add(player.PlayerSex);
        }
        if (player.PlayerAge >0)
        {
            Content.Add(3);
            Values.Add(player.PlayerAge);
        }
        
        if (player.PlayerSize != null)
        {
            Content.Add(4);
            Values.Add(player.PlayerSize);
        }
        if (player.PlayerPhone != null)
        {
            Content.Add(5);
            Values.Add(player.PlayerPhone);
        }
        if (player.PlayerMobile != null)
        {
            Content.Add(6);
            Values.Add(player.PlayerMobile);
        }
        if (player.PlayerMail != null)
        {
            Content.Add(7);
            Values.Add(player.PlayerMail);
        }
        if (player.PlayerAddress != null)
        {
            Content.Add(8);
            Values.Add(player.PlayerAddress);
        }
        if (player.PlayerCode != null)
        {
            Content.Add(9);
            Values.Add(player.PlayerCode);
        }
        if (player.PlayerMSchool != null)
        {
            Content.Add(10);
            Values.Add(player.PlayerMSchool);
        }
        if (player.PlayerHSchool != null)
        {
            Content.Add(11);
            Values.Add(player.PlayerHSchool);
        }
        if (player.PlayerMerit != null)
        {
            Content.Add(12);
            Values.Add(player.PlayerMerit);
        }

        try
        {
            string updatesql = "UPDATE [Player] SET ";
            string updateString = new string(updatesql.ToCharArray());
            for (int i = 0; i < Content.Count; i++)
            {
                switch (Convert.ToInt32(Content[i]))
                {
                    case 1:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Name =  '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 2:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Sex = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 3:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Age = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 4:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Size = '" + Convert.ToDateTime(Values[i]) + "'";
                        break;
                    case 5:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Phone = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 6:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Mobile = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 7:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Email = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 8:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Address = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 9:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Code = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 10:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "MSchool = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 11:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "HSchool = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 12:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Merit = '" + Convert.ToString(Values[i]) + "'";
                        break;

                    default:
                        break;
                }
            }
            updateString += " WHERE PlayerID = '" + player.PlayerID + "'";
            cmd = new SqlCommand(updateString, con);
            con.Open();
            cmd.ExecuteNonQuery();
        }
        catch (SqlException e)
        {
            e.ToString();
        }
        finally
        {
            con.Close();
        }
    }*/

    public void PlayerDelete(Player player)
    {
        try
        {
            con.Open();
            string deletestr = "DELETE FROM [Player] WHERE PlayerID = @ID";
            cmd = new SqlCommand(deletestr, con);
            cmd.Parameters.Add("@ID", SqlDbType.Int).Value = player.PlayerID;
            cmd.ExecuteNonQuery();
        }
        catch (SqlException e)
        {
            e.ToString();
        }
        finally
        {
            con.Close();
        }
    }
}