开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > OA系统 > 查看源码
addresslistDAL.cs
资源名称：OASystem.rar　[点击查看]
上传用户：lishan0805
上传日期：2019-12-08
资源大小：12048k
文件大小：26k
源码类别：

OA系统

开发平台：

C#

addresslistDAL.cs：源码内容
  1. // =================================================================== 
  2. // 产品(COM.OA.SqlServerDAL)项目
  3. //====================================================================
  4. // wangyp @Copy Right 2006-2008
  5. // 文件：addresslistDAL.cs
  6. // 项目名称：工程项目管理
  7. // 创建时间：2008-9-23
  8. // 负责人：wangyp
  9. // 先创建SqlHelper.cs文件,引用System.Configuration程序集和实体(COM.OA.Entity)、产品规则(COM.OA.IDAL)项目、引用业务逻辑(COM.OA.BLL)项目
  10. // ===================================================================
  11. using System;
  12. using System.Collections;
  13. using System.Collections.Generic;
  14. using System.Data;
  15. using System.Data.SqlClient;
  16. using System.Text;
  17. using COM.OA.Entity;
  18. using COM.OA.IDAL;
  19. using COM.OA.BLL;
  21. namespace COM.OA.SqlServerDAL
  22. {
  23.     /// <summary>
  24.     /// 数据访问层dbo.addresslist
  25.     /// </summary>
  26.     public partial class addresslistDAL : IaddresslistDAL
  27.     {
  28.         #region 构造函数
  29.         /// <summary>
  30.         /// 数据层实例化
  31.         /// </summary>
  32.         public addresslistDAL()
  33.         {
  34.         }
  35.         #endregion
  37.         #region -----------实例化接口函数-----------
  39.         #region 添加
  40.         /// <summary>
  41.         /// 向数据库中插入一条新记录
  42.         /// </summary>
  43.         /// <param name="addresslist">addresslist实体对象</param>
  44.         /// <returns></returns>
  45.         public int Insert(addresslist addresslist)
  46.         {
  47.             string sqlCommand = "addresslistInsert";
  48.             int res;
  49.             SqlParameter[] param ={
  50. new SqlParameter("@al_id",SqlDbType.Int),
  51. new SqlParameter("@al_u_id",SqlDbType.Int),
  52. new SqlParameter("@al_dept_id",SqlDbType.Int),
  53. new SqlParameter("@al_duty",SqlDbType.VarChar),
  54. new SqlParameter("@al_mobile",SqlDbType.VarChar),
  55. new SqlParameter("@al_smallclever",SqlDbType.VarChar),
  56. new SqlParameter("@al_worktelephone",SqlDbType.VarChar),
  57. new SqlParameter("@al_extension",SqlDbType.VarChar),
  58. new SqlParameter("@al_fax",SqlDbType.VarChar),
  59. new SqlParameter("@al_email",SqlDbType.VarChar),
  60. new SqlParameter("@al_qq",SqlDbType.VarChar),
  61. new SqlParameter("@al_msn",SqlDbType.VarChar),
  62. new SqlParameter("@al_address",SqlDbType.VarChar),
  63. new SqlParameter("@al_remark",SqlDbType.VarChar)
  64. };
  65.             param[0].Direction = ParameterDirection.Output;
  66.             param[1].Value = addresslist.al_u_id;
  67.             param[2].Value = addresslist.al_dept_id;
  68.             param[3].Value = addresslist.al_duty;
  69.             param[4].Value = addresslist.al_mobile;
  70.             param[5].Value = addresslist.al_smallclever;
  71.             param[6].Value = addresslist.al_worktelephone;
  72.             param[7].Value = addresslist.al_extension;
  73.             param[8].Value = addresslist.al_fax;
  74.             param[9].Value = addresslist.al_email;
  75.             param[10].Value = addresslist.al_qq;
  76.             param[11].Value = addresslist.al_msn;
  77.             param[12].Value = addresslist.al_address;
  78.             param[13].Value = addresslist.al_remark;
  79.             res = SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
  80.             addresslist.al_id = ((param[0].Value) == DBNull.Value) ? 0 : Convert.ToInt32(param[0].Value);
  81.             return res;
  82.         }
  83.         /// <summary>
  84.         /// 向数据库中插入一条新记录。带事务
  85.         /// </summary>
  86.         /// <param name="sp">事务对象</param>
  87.         /// <param name="addresslist">addresslist实体对象</param>
  88.         /// <returns></returns>
  89.         public int Insert(SqlTransaction sp, addresslist addresslist)
  90.         {
  91.             string sqlCommand = "addresslistInsert";
  92.             int res;
  93.             SqlParameter[] param ={
  94. new SqlParameter("@al_id",SqlDbType.Int),
  95. new SqlParameter("@al_u_id",SqlDbType.Int),
  96. new SqlParameter("@al_dept_id",SqlDbType.Int),
  97. new SqlParameter("@al_duty",SqlDbType.VarChar),
  98. new SqlParameter("@al_mobile",SqlDbType.VarChar),
  99. new SqlParameter("@al_smallclever",SqlDbType.VarChar),
  100. new SqlParameter("@al_worktelephone",SqlDbType.VarChar),
  101. new SqlParameter("@al_extension",SqlDbType.VarChar),
  102. new SqlParameter("@al_fax",SqlDbType.VarChar),
  103. new SqlParameter("@al_email",SqlDbType.VarChar),
  104. new SqlParameter("@al_qq",SqlDbType.VarChar),
  105. new SqlParameter("@al_msn",SqlDbType.VarChar),
  106. new SqlParameter("@al_address",SqlDbType.VarChar),
  107. new SqlParameter("@al_remark",SqlDbType.VarChar)
  108. };
  109.             param[0].Direction = ParameterDirection.Output;
  110.             param[1].Value = addresslist.al_u_id;
  111.             param[2].Value = addresslist.al_dept_id;
  112.             param[3].Value = addresslist.al_duty;
  113.             param[4].Value = addresslist.al_mobile;
  114.             param[5].Value = addresslist.al_smallclever;
  115.             param[6].Value = addresslist.al_worktelephone;
  116.             param[7].Value = addresslist.al_extension;
  117.             param[8].Value = addresslist.al_fax;
  118.             param[9].Value = addresslist.al_email;
  119.             param[10].Value = addresslist.al_qq;
  120.             param[11].Value = addresslist.al_msn;
  121.             param[12].Value = addresslist.al_address;
  122.             param[13].Value = addresslist.al_remark;
  123.             res = SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param);
  124.             addresslist.al_id = ((param[0].Value) == DBNull.Value) ? 0 : Convert.ToInt32(param[0].Value);
  125.             return res;
  126.         }
  127.         #endregion
  129.         #region 更新
  130.         /// <summary>
  131.         /// 向数据表addresslist更新一条记录
  132.         /// </summary>
  133.         /// <param name="addresslist">addresslist实体对象</param>
  134.         /// <returns></returns>
  135.         public int Update(addresslist addresslist)
  136.         {
  137.             string sqlCommand = "addresslistUpdate";
  138.             SqlParameter[] param ={
  139. new SqlParameter("@al_id",SqlDbType.Int),
  140. new SqlParameter("@al_u_id",SqlDbType.Int),
  141. new SqlParameter("@al_dept_id",SqlDbType.Int),
  142. new SqlParameter("@al_duty",SqlDbType.VarChar),
  143. new SqlParameter("@al_mobile",SqlDbType.VarChar),
  144. new SqlParameter("@al_smallclever",SqlDbType.VarChar),
  145. new SqlParameter("@al_worktelephone",SqlDbType.VarChar),
  146. new SqlParameter("@al_extension",SqlDbType.VarChar),
  147. new SqlParameter("@al_fax",SqlDbType.VarChar),
  148. new SqlParameter("@al_email",SqlDbType.VarChar),
  149. new SqlParameter("@al_qq",SqlDbType.VarChar),
  150. new SqlParameter("@al_msn",SqlDbType.VarChar),
  151. new SqlParameter("@al_address",SqlDbType.VarChar),
  152. new SqlParameter("@al_remark",SqlDbType.VarChar)
  153. };
  154.             param[0].Value = addresslist.al_id;
  155.             param[1].Value = addresslist.al_u_id;
  156.             param[2].Value = addresslist.al_dept_id;
  157.             param[3].Value = addresslist.al_duty;
  158.             param[4].Value = addresslist.al_mobile;
  159.             param[5].Value = addresslist.al_smallclever;
  160.             param[6].Value = addresslist.al_worktelephone;
  161.             param[7].Value = addresslist.al_extension;
  162.             param[8].Value = addresslist.al_fax;
  163.             param[9].Value = addresslist.al_email;
  164.             param[10].Value = addresslist.al_qq;
  165.             param[11].Value = addresslist.al_msn;
  166.             param[12].Value = addresslist.al_address;
  167.             param[13].Value = addresslist.al_remark;
  168.             return SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
  169.         }
  170.         /// <summary>
  171.         /// 向数据表addresslist更新一条记录。带事务
  172.         /// </summary>
  173.         /// <param name="sp">事务对象</param>
  174.         /// <param name="addresslist">addresslist实体对象</param>
  175.         /// <returns></returns>
  176.         public int Update(SqlTransaction sp, addresslist addresslist)
  177.         {
  178.             string sqlCommand = "addresslistUpdate";
  179.             SqlParameter[] param ={
  180. new SqlParameter("@al_id",SqlDbType.Int),
  181. new SqlParameter("@al_u_id",SqlDbType.Int),
  182. new SqlParameter("@al_dept_id",SqlDbType.Int),
  183. new SqlParameter("@al_duty",SqlDbType.VarChar),
  184. new SqlParameter("@al_mobile",SqlDbType.VarChar),
  185. new SqlParameter("@al_smallclever",SqlDbType.VarChar),
  186. new SqlParameter("@al_worktelephone",SqlDbType.VarChar),
  187. new SqlParameter("@al_extension",SqlDbType.VarChar),
  188. new SqlParameter("@al_fax",SqlDbType.VarChar),
  189. new SqlParameter("@al_email",SqlDbType.VarChar),
  190. new SqlParameter("@al_qq",SqlDbType.VarChar),
  191. new SqlParameter("@al_msn",SqlDbType.VarChar),
  192. new SqlParameter("@al_address",SqlDbType.VarChar),
  193. new SqlParameter("@al_remark",SqlDbType.VarChar)
  194. };
  195.             param[0].Value = addresslist.al_id;
  196.             param[1].Value = addresslist.al_u_id;
  197.             param[2].Value = addresslist.al_dept_id;
  198.             param[3].Value = addresslist.al_duty;
  199.             param[4].Value = addresslist.al_mobile;
  200.             param[5].Value = addresslist.al_smallclever;
  201.             param[6].Value = addresslist.al_worktelephone;
  202.             param[7].Value = addresslist.al_extension;
  203.             param[8].Value = addresslist.al_fax;
  204.             param[9].Value = addresslist.al_email;
  205.             param[10].Value = addresslist.al_qq;
  206.             param[11].Value = addresslist.al_msn;
  207.             param[12].Value = addresslist.al_address;
  208.             param[13].Value = addresslist.al_remark;
  209.             return SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param);
  210.         }
  211.         #endregion
  213.         #region 删除
  214.         /// <summary>
  215.         /// 删除数据表addresslist中的一条记录
  216.         /// </summary>
  217.         /// <param name="al_id">al_id</param>
  218.         /// <returns></returns>
  219.         public int Delete(int al_id)
  220.         {
  221.             string sqlCommand = "addresslistDelete";
  222.             SqlParameter[] param ={
  223. new SqlParameter("@al_id",SqlDbType.Int)
  224. };
  225.             param[0].Value = al_id;
  226.             return SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
  227.         }
  228.         /// <summary>
  229.         /// 删除数据表addresslist中的一条记录
  230.         /// </summary>
  231.         /// <param name="addresslist">addresslist实体对象</param>
  232.         /// <returns></returns>
  233.         public int Delete(addresslist addresslist)
  234.         {
  235.             string sqlCommand = "addresslistDelete";
  236.             SqlParameter[] param ={
  237. new SqlParameter("@al_id",SqlDbType.Int)
  238. };
  239.             param[0].Value = addresslist.al_id;
  240.             return SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
  241.         }
  242.         /// <summary>
  243.         /// 删除数据表addresslist中的一条记录,带事务
  244.         /// </summary>
  245.         /// <param name="sp">事务对象</param>
  246.         /// <param name="al_id">al_id</param>
  247.         /// <returns></returns>
  248.         public int Delete(SqlTransaction sp, int al_id)
  249.         {
  250.             string sqlCommand = "addresslistDelete";
  251.             SqlParameter[] param ={
  252. new SqlParameter("@al_id",SqlDbType.Int)
  253. };
  254.             param[0].Value = al_id;
  255.             return SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param);
  256.         }
  258.         /// <summary>
  259.         /// 删除数据表addresslist中的一条记录,带事务
  260.         /// </summary>
  261.         /// <param name="sp">事务对象</param>
  262.         /// <param name="addresslist">addresslist实体对象</param>
  263.         /// <returns></returns>
  264.         public int Delete(SqlTransaction sp, addresslist addresslist)
  265.         {
  266.             string sqlCommand = "addresslistDelete";
  267.             SqlParameter[] param ={
  268. new SqlParameter("@al_id",SqlDbType.Int)
  269. };
  270.             param[0].Value = addresslist.al_id;
  271.             return SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param);
  272.         }
  273.         #endregion
  275.         #region 实体对象
  276.         /// <summary>
  277.         /// 得到addresslist实体对象
  278.         /// </summary>
  279.         /// <param name="row">row</param>
  280.         /// <returns>addresslist实体对象</returns>
  281.         public addresslist Select(DataRow row)
  282.         {
  283.             addresslist obj = new addresslist();
  284.             if (row != null)
  285.             {
  286.                 obj.al_id = ((row["al_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["al_id"]);
  287.                 obj.al_u_id = ((row["al_u_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["al_u_id"]);
  288.                 obj.al_dept_id = ((row["al_dept_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["al_dept_id"]);
  289.                 obj.al_duty = row["al_duty"].ToString();
  290.                 obj.al_mobile = row["al_mobile"].ToString();
  291.                 obj.al_smallclever = row["al_smallclever"].ToString();
  292.                 obj.al_worktelephone = row["al_worktelephone"].ToString();
  293.                 obj.al_extension = row["al_extension"].ToString();
  294.                 obj.al_fax = row["al_fax"].ToString();
  295.                 obj.al_email = row["al_email"].ToString();
  296.                 obj.al_qq = row["al_qq"].ToString();
  297.                 obj.al_msn = row["al_msn"].ToString();
  298.                 obj.al_address = row["al_address"].ToString();
  299.                 obj.al_remark = row["al_remark"].ToString();
  300.             }
  301.             else
  302.             {
  303.                 return null;
  304.             }
  305.             return obj;
  306.         }
  308.         /// <summary>
  309.         /// 得到addresslist实体对象
  310.         /// </summary>
  311.         /// <param name="dr">dr</param>
  312.         /// <returns>addresslist实体对象</returns>
  313.         public addresslist Select(IDataReader dr)
  314.         {
  315.             addresslist obj = new addresslist();
  316.             obj.al_id = ((dr["al_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["al_id"]);
  317.             obj.al_u_id = ((dr["al_u_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["al_u_id"]);
  318.             obj.al_dept_id = ((dr["al_dept_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["al_dept_id"]);
  319.             obj.al_duty = dr["al_duty"].ToString();
  320.             obj.al_mobile = dr["al_mobile"].ToString();
  321.             obj.al_smallclever = dr["al_smallclever"].ToString();
  322.             obj.al_worktelephone = dr["al_worktelephone"].ToString();
  323.             obj.al_extension = dr["al_extension"].ToString();
  324.             obj.al_fax = dr["al_fax"].ToString();
  325.             obj.al_email = dr["al_email"].ToString();
  326.             obj.al_qq = dr["al_qq"].ToString();
  327.             obj.al_msn = dr["al_msn"].ToString();
  328.             obj.al_address = dr["al_address"].ToString();
  329.             obj.al_remark = dr["al_remark"].ToString();
  330.             return obj;
  331.         }
  333.         /// <summary>
  334.         /// 根据ID,返回一个addresslist实体对象
  335.         /// </summary>
  336.         /// <param name="al_id">al_id</param>
  337.         /// <returns>addresslist实体对象</returns>
  338.         public addresslist Select(int al_id)
  339.         {
  340.             return this.Select(al_id, false, false);
  341.         }
  342.         /// <summary>
  343.         /// 根据ID,返回一个addresslist实体对象
  344.         /// </summary>
  345.         /// <param name="al_id">al_id</param>
  346.         /// <param name="bParentTable">将addresslist对象设置与父表关联</param>
  347.         /// <param name="bChildrenTable">将addresslist对象设置与子表关联</param>
  348.         /// <returns>addresslist实体对象</returns>
  349.         public addresslist Select(int al_id, bool bParentTable, bool bChildrenTable)
  350.         {
  351.             addresslist obj = null;
  352.             SqlParameter[] param ={
  353. new SqlParameter("@al_id",SqlDbType.Int)
  354. };
  355.             param[0].Value = al_id;
  356.             string sqlCommand = "addresslistSelect";
  357.             using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param))
  358.             {
  359.                 while (dr.Read())
  360.                 {
  361.                     obj = this.Select(dr);
  362.                 }
  363.             }
  364.             this.Select(obj, bParentTable, bChildrenTable);
  365.             return obj;
  366.         }
  367.         /// <summary>
  368.         /// 将addresslist实体对象设置与父表和子表关联
  369.         /// </summary>
  370.         /// <param name="obj">addresslist实体对象</param>
  371.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  372.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  373.         public void Select(addresslist obj, bool bParentTable, bool bChildrenTable)
  374.         {
  375.             //关联的主表
  376.             if (bParentTable)
  377.             {
  378.                 obj.users = usersBLL.Select(obj.al_u_id);
  379.                 obj.department = departmentBLL.Select(obj.al_dept_id);
  380.             }
  381.             //关联的子表集合
  382.             if (bChildrenTable)
  383.             {
  384.             }
  385.         }
  386.         #endregion
  388.         #region 父表
  389.         /// <summary>
  390.         /// 设置实体对象(addresslist)的父表对象
  391.         /// </summary>
  392.         /// <param name="addresslist">实体对象</param>
  393.         public void users(addresslist addresslist)
  394.         {
  395.             addresslist.users = usersBLL.Select(addresslist.al_u_id);
  396.         }
  397.         /// <summary>
  398.         /// 设置实体对象(addresslist)的父表对象
  399.         /// </summary>
  400.         /// <param name="addresslist">实体对象</param>
  401.         public void department(addresslist addresslist)
  402.         {
  403.             addresslist.department = departmentBLL.Select(addresslist.al_dept_id);
  404.         }
  405.         #endregion
  407.         #region 子表
  408.         #endregion
  410.         #region 查询
  411.         /// <summary>
  412.         /// 得到数据表addresslist所有记录
  413.         /// </summary>
  414.         /// <returns>结果集</returns>
  415.         public IList<addresslist> Select()
  416.         {
  417.             return this.Select(false, false);
  418.         }
  419.         /// <summary>
  420.         /// 得到数据表addresslist所有记录
  421.         /// </summary>
  422.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  423.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  424.         /// <returns>结果集</returns>
  425.         public IList<addresslist> Select(bool bParentTable, bool bChildrenTable)
  426.         {
  427.             IList<addresslist> list = new List<addresslist>();
  428.             string sqlCommand = "addresslistSelectAll";
  429.             using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand))
  430.             {
  431.                 while (dr.Read())
  432.                 {
  433.                     list.Add(this.Select(dr));
  434.                 }
  435.             }
  436.             foreach (addresslist obj in list)
  437.             {
  438.                 this.Select(obj, bParentTable, bChildrenTable);
  439.             }
  440.             return list;
  441.         }
  442.         /// <summary>
  443.         /// 得到数据表addresslist满足查询条件的记录
  444.         /// </summary>
  445.         /// <param name="where">查询条件</param>
  446.         /// <returns>结果集</returns>
  447.         public IList<addresslist> Select(string where)
  448.         {
  449.             return this.Select(where, false, false);
  450.         }
  451.         /// <summary>
  452.         /// 得到数据表addresslist满足查询条件的记录
  453.         /// </summary>
  454.         /// <param name="where">查询条件</param>
  455.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  456.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  457.         /// <returns>结果集</returns>
  458.         public IList<addresslist> Select(string where, bool bParentTable, bool bChildrenTable)
  459.         {
  460.             IList<addresslist> list = new List<addresslist>();
  461.             SqlParameter[] param ={
  462. new SqlParameter("@where",SqlDbType.VarChar,8000)
  463. };
  464.             param[0].Value = where;
  465.             string sqlCommand = "addresslistSelectByParams";
  466.             using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param))
  467.             {
  468.                 while (dr.Read())
  469.                 {
  470.                     list.Add(this.Select(dr));
  471.                 }
  472.             }
  473.             foreach (addresslist obj in list)
  474.             {
  475.                 this.Select(obj, bParentTable, bChildrenTable);
  476.             }
  477.             return list;
  478.         }
  479.         /// <summary>
  480.         /// 得到数据表ArticalInfo满足外键字段查询条件的记录
  481.         /// </summary>
  482.         /// <param name="foreignFieldName">外键字段名称</param>
  483.         /// <param name="foreignFieldValue">外键字段值</param>
  484.         /// <returns>结果集</returns>
  485.         public IList<addresslist> Select(string foreignFieldName, int foreignFieldValue)
  486.         {
  487.             return this.Select(foreignFieldName, foreignFieldValue, false, false);
  488.         }
  489.         /// <summary>
  490.         /// 得到数据表ArticalInfo满足外键字段查询条件的记录
  491.         /// </summary>
  492.         /// <param name="foreignFieldName">外键字段名称</param>
  493.         /// <param name="foreignFieldValue">外键字段值</param>
  494.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  495.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  496.         /// <returns>结果集</returns>
  497.         public IList<addresslist> Select(string foreignFieldName, int foreignFieldValue, bool bParentTable, bool bChildrenTable)
  498.         {
  499.             return this.Select(string.Format("{0}='{1}'", foreignFieldName, foreignFieldValue), bParentTable, bChildrenTable);
  500.         }
  501.         /// <summary>
  502.         /// 得到数据表addresslist满足查询条件的记录数
  503.         /// </summary>
  504.         /// <param name="where">查询条件</param>
  505.         /// <param name="recordCount">记录数</param>
  506.         public void Select(string where, out int recordCount)
  507.         {
  508.             string sqlCommand = "addresslistCountByWhere";
  509.             SqlParameter[] param ={
  510. new SqlParameter("@where",SqlDbType.VarChar,8000),
  511. new SqlParameter("@recordCount",SqlDbType.Int)
  512. };
  513.             param[0].Value = where;
  514.             param[1].Direction = ParameterDirection.Output;
  515.             SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
  516.             recordCount = Convert.ToInt32(param[1].Value);
  517.         }
  518.         /// <summary>
  519.         /// 得到数据表addresslist满足查询条件的分页记录
  520.         /// </summary>
  521.         /// <param name="pageSize">每页显示记录数</param>
  522.         /// <param name="pageIndex">当前显示第几页</param>
  523.         /// <param name="where">查询条件</param>
  524.         /// <returns>结果集</returns>
  525.         public IList<addresslist> Select(int pageSize, int pageIndex, string where)
  526.         {
  527.             return this.Select(pageSize, pageIndex, where, false, false);
  528.         }
  529.         /// <summary>
  530.         /// 得到数据表addresslist满足查询条件的分页记录
  531.         /// </summary>
  532.         /// <param name="pageSize">每页显示记录数</param>
  533.         /// <param name="pageIndex">当前显示第几页</param>
  534.         /// <param name="where">查询条件</param>
  535.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  536.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  537.         /// <returns>结果集</returns>
  538.         public IList<addresslist> Select(int pageSize, int pageIndex, string where, bool bParentTable, bool bChildrenTable)
  539.         {
  540.             IList<addresslist> list = new List<addresslist>();
  541.             string sqlCommand = "addresslistSelectByPagerParams";
  542.             SqlParameter[] param ={
  543. new SqlParameter("@pageSize",SqlDbType.Int),
  544. new SqlParameter("@pageIndex",SqlDbType.Int),
  545. new SqlParameter("@where",SqlDbType.VarChar,8000)
  546. };
  547.             param[0].Value = pageSize;
  548.             param[1].Value = pageIndex;
  549.             param[2].Value = where;
  550.             using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param))
  551.             {
  552.                 while (dr.Read())
  553.                 {
  554.                     list.Add(this.Select(dr));
  555.                 }
  556.             }
  557.             foreach (addresslist obj in list)
  558.             {
  559.                 this.Select(obj, bParentTable, bChildrenTable);
  560.             }
  561.             return list;
  562.         }
  563.         /// <summary>
  564.         /// 得到数据表addresslist满足查询条件记录
  565.         /// </summary>
  566.         /// <param name="commandType">命令类型</param>
  567.         /// <param name="sqlCommand">SQL命令</param>
  568.         /// <param name="SqlParameter[]">命令参数数组</param>
  569.         /// <returns>结果集</returns>
  570.         public IList<addresslist> Select(CommandType commandType, string sqlCommand, params SqlParameter[] param)
  571.         {
  572.             return this.Select(false, false, commandType, sqlCommand, param);
  573.         }
  574.         /// <summary>
  575.         /// 得到数据表addresslist满足查询条件记录
  576.         /// </summary>
  577.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  578.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  579.         /// <param name="commandType">命令类型</param>
  580.         /// <param name="sqlCommand">SQL命令</param>
  581.         /// <param name="SqlParameter[]">命令参数数组</param>
  582.         /// <returns>结果集</returns>
  583.         public IList<addresslist> Select(bool bParentTable, bool bChildrenTable, CommandType commandType, string sqlCommand, params SqlParameter[] param)
  584.         {
  585.             IList<addresslist> list = new List<addresslist>();
  586.             using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, commandType, sqlCommand, param))
  587.             {
  588.                 while (dr.Read())
  589.                 {
  590.                     list.Add(this.Select(dr));
  591.                 }
  592.             }
  593.             foreach (addresslist obj in list)
  594.             {
  595.                 this.Select(obj, bParentTable, bChildrenTable);
  596.             }
  597.             return list;
  598.         }
  599.         /// <summary>
  600.         /// 根据主键检测是否存在该条记录
  601.         /// </summary>
  602.         /// <param name="al_id">al_id</param>
  603.         /// <returns>存在/不存在</returns>
  604.         public bool Exists(int al_id)
  605.         {
  606.             SqlParameter[] param ={
  607.                                  new SqlParameter("@al_id",SqlDbType.Int)
  608.                                  };
  609.             param[0].Value = al_id;
  610.             string sqlCommand = "addresslistIsExist";
  611.             int a = Convert.ToInt32(SqlHelper.ExecuteScalar(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param));
  612.             if (a > 0)
  613.             {
  614.                 return true;
  615.             }
  616.             else
  617.             {
  618.                 return false;
  619.             }
  620.         }
  621.         #endregion
  623.         #endregion
  624.     }
  625. }