teachermanager.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>
/// TeacherManager 的摘要说明
/// </summary>
public class TeacherManager
{

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

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

    public void TeacherReg(Teacher teacher)
    {
        try
        {
            con.Open();
            string insertstr = "INSERT INTO [Teacher] (Name , Sex , Phone , Mobile , Email , [Size] , Address , Code, TeamID) VALUES (@Name , @Sex , @Phone , @Mobile , @Email , @Size , @Address , @Code, @TeamID)";
            cmd = new SqlCommand(insertstr, con);
            cmd.Parameters.Add("@Name", SqlDbType.VarChar, 50).Value = teacher.Name;
            cmd.Parameters.Add("@Sex", SqlDbType.Char, 5).Value = teacher.Sex.Trim();
            cmd.Parameters.Add("@Phone", SqlDbType.VarChar, 50).Value = teacher.Phone;
            cmd.Parameters.Add("@Mobile", SqlDbType.VarChar, 50).Value = teacher.Mobile;
            cmd.Parameters.Add("@Email", SqlDbType.VarChar, 50).Value = teacher.Email;
            cmd.Parameters.Add("@Size", SqlDbType.Char, 2).Value = teacher.Size;
            cmd.Parameters.Add("@Address", SqlDbType.VarChar, 50).Value = teacher.Address;
            cmd.Parameters.Add("@Code", SqlDbType.VarChar, 50).Value = teacher.Code.Trim();
            cmd.Parameters.Add("@TeamID", SqlDbType.Int).Value = teacher.TeamID;

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

        }
    }

    public void TeacherDelete(Teacher teacher)
    {
        try
        {
            con.Open();
            string detelestr = "DELETE FROM [Teacher] WHERE TeacherID=@ID";
            cmd = new SqlCommand(detelestr, con);
            cmd.Parameters.Add("@ID", SqlDbType.Int).Value = teacher.TeacherID;
            cmd.ExecuteNonQuery();
        }
        catch (SqlException e)
        {
            e.ToString();
        }
        finally
        {
            con.Close();
        }
    }

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

        if (ds.Tables[0].Rows.Count != 0)
        {
            teacher.Name = ds.Tables[0].Rows[0][1].ToString();
            teacher.Sex = ds.Tables[0].Rows[0][2].ToString();
            teacher.Phone = ds.Tables[0].Rows[0][3].ToString();
            teacher.Mobile = ds.Tables[0].Rows[0][4].ToString();
            teacher.Email = ds.Tables[0].Rows[0][5].ToString();
            teacher.Size = ds.Tables[0].Rows[0][6].ToString();
            teacher.Address = ds.Tables[0].Rows[0][7].ToString();
            teacher.Code = ds.Tables[0].Rows[0][8].ToString();
            teacher.TeamID = Convert.ToInt32(ds.Tables[0].Rows[0][9]);
        }
        else
        {
            teacher.TeacherID = 0;
        }

        return teacher;

    }

    /*public void TeacherInfoUpdate(Teacher teacher)
    {
        ArrayList Content = new ArrayList();
        ArrayList Values = new ArrayList();

        if (teacher.Name != null)
        {
            Content.Add(1);
            Values.Add(teacher.Name);
        }
        if (teacher.Sex != null)
        {
            Content.Add(2);
            Values.Add(teacher.Sex);
        }
        
        if (teacher.Phone != null)
        {
            Content.Add(3);
            Values.Add(teacher.Phone);
        }
        if (teacher.Mobile != null)
        {
            Content.Add(4);
            Values.Add(teacher.Mobile);
        }
        if (teacher.Email != null)
        {
            Content.Add(5);
            Values.Add(teacher.Email);
        }
        if (teacher.Size != null)
        {
            Content.Add(6);
            Values.Add(teacher.Size);
        }
        if (teacher.Address != null)
        {
            Content.Add(7);
            Values.Add(teacher.Address);
        }
        if (teacher.Code != null)
        {
            Content.Add(8);
            Values.Add(teacher.Code);
        }
      
        try
        {
            string updatesql = "UPDATE [Teacher] 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 += "Phone = '" + Convert.ToDateTime(Values[i]) + "'";
                        break;
                    case 4:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Mobile = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 5:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Email = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 6:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Size = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 7:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Address = '" + Convert.ToString(Values[i]) + "'";
                        break;
                    case 8:
                        if (i != 0)
                            updateString += ", ";
                        updateString += "Code = '" + Convert.ToString(Values[i]) + "'";
                        break;

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

}