teammanager.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>
/// TeamManager 的摘要说明
/// </summary>
public class TeamManager
{
    //public Team thisTeam;
    private string constr = ConfigurationManager.AppSettings["constr"].ToString();
    private SqlConnection con;
    private SqlCommand cmd;
    private SqlDataAdapter adapter;
    private DataSet ds;

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

    public bool TeamNameCheck(Team team)
    {
        try
        {
            con.Open();
            string selectstr = "select * from [Team] where TeamName = @teamName";
            cmd = new SqlCommand(selectstr, con);
            cmd.Parameters.Add("@teamName", SqlDbType.VarChar, 50).Value = team.TeamName;
            adapter.SelectCommand = cmd;
            ds = new DataSet();
            adapter.Fill(ds);
        }
        catch (SqlException e)
        {
            e.ToString();
        }
        finally
        {
            con.Close();
        }

        if (ds.Tables[0].Rows.Count > 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }

    public void TeamReg(Team team)
    {

        try
        {
            con.Open();
            string selectstr = "INSERT INTO [Team] (TeamName,CSchoolName,ESchoolName,Lodging,Amount,LodgingDay) VALUES ( @TeamName, @CSchoolName , @ESchoolName , @Lodging ,@Amount , @LodgingDay)";
            cmd = new SqlCommand(selectstr, con);
            cmd.Parameters.Add("@TeamName", SqlDbType.VarChar, 50).Value = team.TeamName;
            cmd.Parameters.Add("@CSchoolName", SqlDbType.VarChar, 50).Value = team.CSchoolName;
            cmd.Parameters.Add("@ESchoolName", SqlDbType.VarChar, 50).Value = team.ESchoolName;
            cmd.Parameters.Add("@Lodging", SqlDbType.Bit).Value = team.Lodging;
            cmd.Parameters.Add("@Amount", SqlDbType.Int).Value = team.Amount;
            cmd.Parameters.Add("@LodgingDay", SqlDbType.Int).Value = team.LodgingDay;
          
            cmd.ExecuteNonQuery();
        }
        catch (SqlException e)
        {
            e.ToString();
        }
        finally
        {
            con.Close();

        }

    }

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

        if (ds.Tables[0].Rows.Count != 0)
        {
            team.TeamName = ds.Tables[0].Rows[0][1].ToString();
            team.Lodging = Convert.ToBoolean(ds.Tables[0].Rows[0][4]);
            team.CSchoolName = ds.Tables[0].Rows[0][2].ToString();
            team.ESchoolName = ds.Tables[0].Rows[0][3].ToString();
            team.Amount = Convert.ToInt32(ds.Tables[0].Rows[0][5]);
            team.LodgingDay = Convert.ToInt32(ds.Tables[0].Rows[0][6]);
        }
        else
        {
            team.TeamID = -1;
        }

        return team;

    }

    public Team TeamInfoLoadbyName(Team team)
    {
        try
        {
            con.Open();
            string selectstr = "select * from [Team] where TeamName = @name";
            cmd = new SqlCommand(selectstr, con);
            cmd.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = team.TeamName;
            adapter.SelectCommand = cmd;
            ds = new DataSet();
            adapter.Fill(ds);
        }
        catch (SqlException e)
        {
            e.ToString();
        }
        finally
        {
            con.Close();
        }

        if (ds.Tables[0].Rows.Count != 0)
        {
            team.TeamID = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            team.Lodging = Convert.ToBoolean(ds.Tables[0].Rows[0][4]);
            team.CSchoolName = ds.Tables[0].Rows[0][2].ToString();
            team.ESchoolName = ds.Tables[0].Rows[0][3].ToString();
            team.Amount = Convert.ToInt32(ds.Tables[0].Rows[0][5]);
            team.LodgingDay = Convert.ToInt32(ds.Tables[0].Rows[0][6]);
        }
        else
        {
            team.TeamID = -1;
        }

        return team;

    }


    /*public void TeamInfoUpdate(Team team)
    {
        ArrayList Content = new ArrayList();
        ArrayList Values = new ArrayList();

      
        if (team.CSchoolName != null)
        {
            Content.Add(1);
            Values.Add(team.CschoolName);
        }
        if (team.ESchoolName != null)
        {
            Content.Add(2);
            Values.Add(team.EschoolName);
        }
        if (team.Lodging != null)
        {
            Content.Add(3);
            Values.Add(team.Lodging);
        }
        if (team.Amount>0)
        {
            Content.Add(4);
            Values.Add(team.Amount);
        }
        if (team.LodgingDay>0)
        {
            Content.Add(5);
            Values.Add(team.LodgingDay);
        }
        
        try
        {
            string updatesql = "UPDATE [Team] 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 += "CSchoolName = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 2:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "ESchoolName = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 3:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Lodging = '" + Convert.ToDateTime(Values[i]) + "'";
                        break;
                    case 4:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Amount = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 5:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "LodgingDay = '" + Convert.ToString(Values[i]) + "'";
                        break;             

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

    public void TeamDelete(Team team)
    {
        try
        {
            con.Open();
            string deletestr = "DELETE FROM [Team] WHERE TeamID=@ID";
            cmd = new SqlCommand(deletestr, con);
            cmd.Parameters.Add("@ID", SqlDbType.VarChar, 50).Value = team.TeamID;
            cmd.ExecuteNonQuery();
        }
        catch (SqlException e)
        {
            e.ToString();
        }
        finally
        {
            con.Close();
        }
    }
}