Web/Model/DepartmentExtend.cs

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

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

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;
using System.Web.UI.WebControls;//Please add references

namespace StudentExamination.Model
{
    //扩展Department类，增加自定义的方法

    public partial class Department
    {
        /// <summary>
        /// 是否存在相同的名称
        /// </summary>
        public bool ExitDpt(string DptCode, string DptName)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from [Department]");
            strSql.Append(" where DptCode=@DptCode   or  DptName=@DptName");

            SqlParameter[] parameters = {
					new SqlParameter("@DptCode", SqlDbType.NVarChar,20),
                    new SqlParameter("@DptName", SqlDbType.NVarChar,50)
                                        };
            parameters[0].Value = DptCode;
            parameters[0].Value = DptName;
            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }

        /// <summary>
        /// 获取绑定Department的数据集
        /// </summary>
        public void BindDepartment(DropDownList ddl)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select DptID,DptName from [Department] ");
            strSql.Append(" where IsUsed >= 1");
      
            ddl.DataSource = DbHelperSQL.Query(strSql.ToString());
            ddl.DataTextField = "dptName";
            ddl.DataValueField = "dptID";
            ddl.DataBind();
        }

        /// <summary>
        ///批量删除数据
        /// </summary>
        public bool DeleteList(string DptIDlist)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from Department ");
            strSql.Append(" where DptID in (" + DptIDlist + ")  ");
            int rows = DbHelperSQL.ExecuteSql(strSql.ToString());
            if (rows > 0)
            {
                return true;
            }
            else