DAL/DBDepartment.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

//  @ Project : TestOnline
//  @ File Name : DBDepartment.cs
//  @ Date : 2009-3-12
//  @ Author : ruimingde

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

using Entity;

namespace DAL
{
    public class DBDepartment : DBOperation<Department>
    {
        public void Insert(Department obj)
        {
            SqlParameter[] parameters = {
					new SqlParameter("@deptID", SqlDbType.SmallInt,2),
					new SqlParameter("@deptName", SqlDbType.NVarChar,50)};
            parameters[0].Direction = ParameterDirection.Output;
            parameters[1].Value = obj.DeptName;

            DBHelper.Insert("UP_T_Department_ADD", parameters);
        }
        public void Update(Department obj)
        {
            SqlParameter[] parameters = {
					new SqlParameter("@deptID", SqlDbType.SmallInt,2),
					new SqlParameter("@deptName", SqlDbType.NVarChar,50)};
            parameters[0].Value = obj.DeptID;
            parameters[1].Value = obj.DeptName;

            DBHelper.Update("UP_T_Department_Update", parameters);
        }
        public void Delete(string id)
        {
            SqlParameter[] parameters = {
					new SqlParameter("@deptID", SqlDbType.SmallInt)};
            parameters[0].Value = id;

            DBHelper.Delete("UP_T_Department_Delete", parameters);
        }
        public Department SelectByID(string id)
        {
            SqlParameter[] parameters = {
					new SqlParameter("@deptID", SqlDbType.SmallInt)};
            parameters[0].Value = id;

            Department dept=new Department();

            using(SqlDataReader dr=DBHelper.Select("UP_T_Department_GetModel",parameters))
            {
                if (dr.Read())
                {
                    dept.DeptID =Convert.ToInt16(id);
                    dept.DeptName = dr.GetString(dr.GetOrdinal("deptName"));