deptmanage.cs

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

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

namespace Server
{
    public  class DeptManage
    {
        public static DataSet ShowApplyingClass(string dept_id)
        {
            SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["strConn"].Trim());
        string strCmd = "SELECT applyClass_tb.class_id, class_tb.class_name, teacher_tb.teach_name,  teacher_tb.teach_post, teacher_tb.teach_info, teacher_tb.teach_id FROM class_tb INNER JOIN applyClass_tb ON class_tb.class_id = applyClass_tb.class_id INNER JOIN teacher_tb ON applyClass_tb.teacher_id = teacher_tb.teach_id where class_tb.class_teach_id is null and applyClass_tb.dept_id=@dept_id";
            SqlCommand cmd = new SqlCommand(strCmd,conn );
            cmd.Parameters.Add("@dept_id", SqlDbType.Int).Value = Convert.ToInt32(dept_id);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            conn.Open();
            da.Fill(ds);
            da.Dispose();
            conn.Close();
            return ds;
        }
        public static string  ApplyedClass(string class_id,string teacher_id,string dept_id)
        {
            //@class_id bigint,
            //@teacher_id bigint,
            //@dept_id bigint,
            //@anwer varchar(10) output
            SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["strConn"].Trim());
            SqlCommand cmd = new SqlCommand("ApplyedClass", conn);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@class_id", SqlDbType.BigInt).Value = Convert.ToInt32(class_id );
            cmd.Parameters.Add("@teacher_id", SqlDbType.BigInt).Value = Convert.ToInt32(teacher_id );
            cmd.Parameters.Add("@dept_id", SqlDbType.BigInt).Value = Convert.ToInt32(dept_id );

            SqlParameter pm = new SqlParameter("@anwer", SqlDbType.VarChar, 10);
            pm.Direction = ParameterDirection.Output;
            cmd.Parameters.Add(pm);
            try
            {
                conn.Open();
                cmd.ExecuteNonQuery();

                return pm.Value.ToString();

            }
            catch
            {
                return "审批失败";
            }
            finally
            {
                conn.Close();
            }
                        
        }
    }
}