当前文件： myCRM/App_Code/EntityDA/EmployeeDA.cs[4K，2009-6-12 11:48:09]，打开代码结构图

		            
  1using System;
  2using System.Text;
  3using System.Data;
  4using System.Data.SqlClient;
  5using System.Configuration;
  6
  7/**//// <summary>
  8/// 员工实体方法
  9/// </summary>
 10public class EmployeeDA
 11...{
 12    //定义常量表示字段名称或SQL语句。
 13    private const string SQL_INSERT_EMPLOYEE = "INSERT INTO employeeinfo VALUES(@departid,@name,@phone, @mail,@birthday,@sex,@note)";
 14    private const string PARM_EMPLOYEE_NAME = "@name";
 15    private const string PARM_EMPLOYEE_PHONE = "@phone";
 16    private const string PARM_EMPLOYEE_MAIL = "@mail";
 17    private const string PARM_EMPLOYEE_BIRTHDAY = "@birthday";
 18    private const string PARM_EMPLOYEE_SEX = "@sex";
 19    private const string PARM_EMPLOYEE_NOTE = "@note";
 20    private const string PARM_DEPART_NAME = "@depart";
 21    private const string PARM_DEPART_ID = "@departid";
 22    private const string SQL_SELECT_DEPARTNAME = "SELECT departid FROM department WHERE departname=@depart";
 23
 24    public EmployeeDA()
 25    ...{
 26    }
 27    /**//// <summary>
 28    /// 添加员工资料
 29    /// </summary>
 30    /// <param name="user">员工资料实体</param>
 31    /// <returns>添加是否成功</returns>
 32    public bool InsertEmployee(EmployeeEntity employee)
 33    ...{
 34        StringBuilder strSQL = new StringBuilder();
 35        SqlParameter[] employeeParms = GetParameters();
 36        SqlCommand cmd = new SqlCommand();
 37
 38        // 依次给实体参数赋值
 39        employeeParms[1].Value = employee.Name;
 40        employeeParms[2].Value = employee.Phone;
 41        employeeParms[3].Value = employee.Mail;
 42        employeeParms[4].Value = employee.Birthday;
 43        employeeParms[5].Value = employee.Sex;
 44        employeeParms[6].Value = employee.Note;
 45        //获取部门的ID
 46        int departid = GetDepartID(employee.Depart);
 47        employeeParms[0].Value = departid;
 48
 49        //遍历所有参数，并将参数添加到SqlCommand命令中
 50        foreach (SqlParameter parm in employeeParms)
 51            cmd.Parameters.Add(parm);
 52
 53        //获取数据库的连接字符串
 54        using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
 55        ...{
 56            strSQL.Append(SQL_INSERT_EMPLOYEE);
 57            //打开数据库连接，执行命令
 58            conn.Open();
 59            //设置Sqlcommand命令的属性
 60            cmd.Connection = conn;
 61            cmd.CommandType = CommandType.Text;
 62            cmd.CommandText = strSQL.ToString();
 63            //执行添加的SqlCommand命令
 64            int val = cmd.ExecuteNonQuery();
 65            //清空SqlCommand命令中的参数
 66            cmd.Parameters.Clear();
 67            //判断是否添加成功，注意返回的是添加是否成功，不是影响的行数
 68            if (val > 0)
 69                return true;
 70            else
 71                return false;
 72        }
 73    }
 74    私有方法#region 私有方法
 75    /**//// <summary>
 76    /// 获取部门ID的方法
 77    /// </summary>
 78    /// <param name="cityname">部门名称</param>
 79    /// <returns>该部门的ID</returns>
 80    private int GetDepartID(string departname)
 81    ...{
 82        int departid = 0;
 83
 84        //创建新参数并给参数赋值，用来指定单位名称
 85        SqlParameter parm = new SqlParameter(PARM_DEPART_NAME, SqlDbType.NVarChar, 20);
 86        parm.Value = departname;
 87
 88        //调用SqlHelper访问组件的方法返回第一行第一列的值
 89        departid = (int)SqlHelper.ExecuteScalar(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_DEPARTNAME, parm);
 90        return departid;
 91    }
 92    private static SqlParameter[] GetParameters()
 93    ...{
 94        //将SQL_INSERT_EMPLOYEE做为哈希表缓存的键值
 95        SqlParameter[] parms = SqlHelper.GetCachedParameters(SQL_INSERT_EMPLOYEE);
 96
 97        //首先判断缓存是否已经存在
 98        if (parms == null)
 99        ...{
100            //缓存不存在的情况下，新建参数列表
101            parms = new SqlParameter[] ...{
102                    new SqlParameter(PARM_DEPART_ID, SqlDbType.Int),
103                    new SqlParameter(PARM_EMPLOYEE_NAME, SqlDbType.NVarChar,20),
104                    new SqlParameter(PARM_EMPLOYEE_PHONE, SqlDbType.NVarChar, 20),
105                    new SqlParameter(PARM_EMPLOYEE_MAIL, SqlDbType.NVarChar, 20),
106                    new SqlParameter(PARM_EMPLOYEE_BIRTHDAY, SqlDbType.DateTime),
107                    new SqlParameter(PARM_EMPLOYEE_SEX, SqlDbType.NVarChar,2),
108                    new SqlParameter(PARM_EMPLOYEE_NOTE, SqlDbType.NVarChar,50) };
109
110            //将新建的参数列表添加到哈希表中缓存起来
111            SqlHelper.CacheParameters(SQL_INSERT_EMPLOYEE, parms);
112        }
113        //返回参数数组
114        return parms;
115    }
116    #endregion
117}
118