student.cs

asp.net连带c++技术开发

using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;


namespace Server
{
    public  class Student
    {
        //选退课-->更新已选人数
        public static string SelectOrCancelClass(string class_id, string class_dep_id, string kind)
        {
            SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["strConn"].Trim());
            SqlCommand cmd = new SqlCommand("SelectClassPeople", conn);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@class_id", SqlDbType.BigInt).Value = Convert.ToInt32(class_id);
            cmd.Parameters.Add("@class_dep_id", SqlDbType.BigInt).Value = Convert.ToInt32(class_dep_id);
            cmd.Parameters.Add("@kind", SqlDbType.VarChar, 10).Value = kind;

            SqlParameter anwer = new SqlParameter("@anwer",SqlDbType.Int);
            anwer.Direction = ParameterDirection.Output;
            cmd.Parameters.Add(anwer);
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
            return anwer.Value.ToString();

        }
        public static string SelectClass(string class_id,string stud_id,string dept_id)
        { 
            SqlConnection conn=new SqlConnection (ConfigurationManager.AppSettings["strConn"].Trim());
            string strCmd = "select count(*) from select_class_tb where class_id=@class_id and stud_id=@stud_id";
            SqlCommand cmd = new SqlCommand(strCmd, conn);
            cmd.Parameters.Add("@class_id", SqlDbType.BigInt).Value = Convert.ToInt32(class_id);
            cmd.Parameters.Add("@stud_id", SqlDbType.BigInt).Value = Convert.ToInt32(stud_id);
            
            conn.Open();
            if (1 == (int)cmd.ExecuteScalar())
            {
                conn.Close();
                return "此课程你已选中";
            }
            else if ("1"==SelectOrCancelClass(class_id, dept_id, "选课"))
            {
                strCmd = "insert into select_class_tb (class_id,stud_id) values(@class_id,@stud_id)";
                SqlCommand insertCmd = new SqlCommand(strCmd, conn);
                insertCmd.Parameters.Add("@class_id", SqlDbType.BigInt).Value = Convert.ToInt32(class_id);
                insertCmd.Parameters.Add("@stud_id", SqlDbType.BigInt).Value = Convert.ToInt32(stud_id);
                insertCmd.ExecuteNonQuery();
                conn.Close();
                return "选课成功";
            }
            else 
            {
                return "课程人数已满";
            }
        }
        public static string CancelClass(string class_id, string stud_id, string dept_id)
        {
            SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["strConn"].Trim());
            string strCmd = "delete from select_class_tb where class_id=@class_id and stud_id=@stud_id";
            SqlCommand cmd = new SqlCommand(strCmd, conn);
            cmd.Parameters.Add("@class_id", SqlDbType.BigInt).Value = Convert.ToInt32(class_id);
            cmd.Parameters.Add("@stud_id", SqlDbType.BigInt).Value = Convert.ToInt32(stud_id);

            try
            {
               
                conn.Open();
                if ("1" == SelectOrCancelClass(class_id, dept_id, "退课"))
                {
                    cmd.ExecuteNonQuery();
                    return "退课成功";
                }
                else
                {
                    return "退课失败请重新登录后再试";
                }
            }
            catch
            {
                return "退课失败请重新登录后再试";
            }
            finally
            {
                conn.Close();
            }
        }
        public static DataSet SeeMyClass(string stud_id)
        { 
            SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["strConn"].Trim());
            string  strCmd="select class_id from select_class_tb where stud_id=@stud_id";
            SqlCommand cmd = new SqlCommand(strCmd, conn);
            cmd.Parameters.Add("@stud_id", SqlDbType.BigInt).Value = Convert.ToInt32(stud_id);

            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            conn.Open();
            da.Fill(ds);
            da.Dispose();
            if (ds.Tables[0].Rows.Count == 0)
            {
                return null;
            }
            else
            {
                strCmd = "SELECT class_id, class_name, class_kind, class_dep_id, class_credit, class_hour,class_long, class_teach_id,class_big FROM class_tb where class_id=" + Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString().Trim());
                for (int i = 1; i < ds.Tables[0].Rows.Count; i++)
                {
                    strCmd += " or class_id=" + Convert.ToInt32(ds.Tables[0].Rows[i][0].ToString().Trim());
                }
                
                DataSet dsOut = new DataSet();
                SqlCommand cmdOut = new SqlCommand(strCmd, conn);
                SqlDataAdapter daOut = new SqlDataAdapter(cmdOut);
                daOut.Fill(dsOut);
                daOut.Dispose();
                return dsOut;
            }
        }
    }
}