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

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

OA系统

开发平台：

C#

usersDAL.cs：源码内容
  1. // =================================================================== 
  2. // 产品(COM.OA.SqlServerDAL)项目
  3. //====================================================================
  4. // wangyp @Copy Right 2006-2008
  5. // 文件：usersDAL.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.users
  25.     /// </summary>
  26.     public partial class usersDAL : IusersDAL
  27.     {
  28.         #region 构造函数
  29.         /// <summary>
  30.         /// 数据层实例化
  31.         /// </summary>
  32.         public usersDAL()
  33.         {
  34.         }
  35.         #endregion
  37.         #region -----------实例化接口函数-----------
  39.         #region 添加
  40.         /// <summary>
  41.         /// 向数据库中插入一条新记录
  42.         /// </summary>
  43.         /// <param name="users">users实体对象</param>
  44.         /// <returns></returns>
  45.         public int Insert(users users)
  46.         {
  47.             string sqlCommand = "usersInsert";
  48.             int res;
  49.             SqlParameter[] param ={
  50. new SqlParameter("@u_id",SqlDbType.Int),
  51. new SqlParameter("@u_username",SqlDbType.VarChar),
  52. new SqlParameter("@u_password",SqlDbType.VarChar),
  53. new SqlParameter("@u_dept_id",SqlDbType.Int),
  54. new SqlParameter("@u_em_id",SqlDbType.Int),
  55. new SqlParameter("@u_state",SqlDbType.Int),
  56. new SqlParameter("@u_logintime",SqlDbType.DateTime),
  57. new SqlParameter("@u_logindegree",SqlDbType.Int),
  58. new SqlParameter("@u_pwdbind",SqlDbType.VarChar),
  59. new SqlParameter("@u_g_id",SqlDbType.Int),
  60. new SqlParameter("@u_landip",SqlDbType.VarChar)
  61. };
  62.             param[0].Direction = ParameterDirection.Output;
  63.             param[1].Value = users.u_username;
  64.             param[2].Value = users.u_password;
  65.             param[3].Value = users.u_dept_id;
  66.             param[4].Value = users.u_em_id;
  67.             param[5].Value = users.u_state;
  68.             param[6].Value = users.u_logintime;
  69.             param[7].Value = users.u_logindegree;
  70.             param[8].Value = users.u_pwdbind;
  71.             param[9].Value = users.u_g_id;
  72.             param[10].Value = users.u_landip;
  73.             res = SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
  74.             users.u_id = ((param[0].Value) == DBNull.Value) ? 0 : Convert.ToInt32(param[0].Value);
  75.             return res;
  76.         }
  77.         /// <summary>
  78.         /// 向数据库中插入一条新记录。带事务
  79.         /// </summary>
  80.         /// <param name="sp">事务对象</param>
  81.         /// <param name="users">users实体对象</param>
  82.         /// <returns></returns>
  83.         public int Insert(SqlTransaction sp, users users)
  84.         {
  85.             string sqlCommand = "usersInsert";
  86.             int res;
  87.             SqlParameter[] param ={
  88. new SqlParameter("@u_id",SqlDbType.Int),
  89. new SqlParameter("@u_username",SqlDbType.VarChar),
  90. new SqlParameter("@u_password",SqlDbType.VarChar),
  91. new SqlParameter("@u_dept_id",SqlDbType.Int),
  92. new SqlParameter("@u_em_id",SqlDbType.Int),
  93. new SqlParameter("@u_state",SqlDbType.Int),
  94. new SqlParameter("@u_logintime",SqlDbType.DateTime),
  95. new SqlParameter("@u_logindegree",SqlDbType.Int),
  96. new SqlParameter("@u_pwdbind",SqlDbType.VarChar),
  97. new SqlParameter("@u_g_id",SqlDbType.Int),
  98. new SqlParameter("@u_landip",SqlDbType.VarChar)
  99. };
  100.             param[0].Direction = ParameterDirection.Output;
  101.             param[1].Value = users.u_username;
  102.             param[2].Value = users.u_password;
  103.             param[3].Value = users.u_dept_id;
  104.             param[4].Value = users.u_em_id;
  105.             param[5].Value = users.u_state;
  106.             param[6].Value = users.u_logintime;
  107.             param[7].Value = users.u_logindegree;
  108.             param[8].Value = users.u_pwdbind;
  109.             param[9].Value = users.u_g_id;
  110.             param[10].Value = users.u_landip;
  111.             res = SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param);
  112.             users.u_id = ((param[0].Value) == DBNull.Value) ? 0 : Convert.ToInt32(param[0].Value);
  113.             return res;
  114.         }
  115.         #endregion
  117.         #region 更新
  118.         /// <summary>
  119.         /// 向数据表users更新一条记录
  120.         /// </summary>
  121.         /// <param name="users">users实体对象</param>
  122.         /// <returns></returns>
  123.         public int Update(users users)
  124.         {
  125.             string sqlCommand = "usersUpdate";
  126.             SqlParameter[] param ={
  127. new SqlParameter("@u_id",SqlDbType.Int),
  128. new SqlParameter("@u_username",SqlDbType.VarChar),
  129. new SqlParameter("@u_password",SqlDbType.VarChar),
  130. new SqlParameter("@u_dept_id",SqlDbType.Int),
  131. new SqlParameter("@u_em_id",SqlDbType.Int),
  132. new SqlParameter("@u_state",SqlDbType.Int),
  133. new SqlParameter("@u_logintime",SqlDbType.DateTime),
  134. new SqlParameter("@u_logindegree",SqlDbType.Int),
  135. new SqlParameter("@u_pwdbind",SqlDbType.VarChar),
  136. new SqlParameter("@u_g_id",SqlDbType.Int),
  137. new SqlParameter("@u_landip",SqlDbType.VarChar)
  138. };
  139.             param[0].Value = users.u_id;
  140.             param[1].Value = users.u_username;
  141.             param[2].Value = users.u_password;
  142.             param[3].Value = users.u_dept_id;
  143.             param[4].Value = users.u_em_id;
  144.             param[5].Value = users.u_state;
  145.             param[6].Value = users.u_logintime;
  146.             param[7].Value = users.u_logindegree;
  147.             param[8].Value = users.u_pwdbind;
  148.             param[9].Value = users.u_g_id;
  149.             param[10].Value = users.u_landip;
  150.             return SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
  151.         }
  152.         /// <summary>
  153.         /// 向数据表users更新一条记录。带事务
  154.         /// </summary>
  155.         /// <param name="sp">事务对象</param>
  156.         /// <param name="users">users实体对象</param>
  157.         /// <returns></returns>
  158.         public int Update(SqlTransaction sp, users users)
  159.         {
  160.             string sqlCommand = "usersUpdate";
  161.             SqlParameter[] param ={
  162. new SqlParameter("@u_id",SqlDbType.Int),
  163. new SqlParameter("@u_username",SqlDbType.VarChar),
  164. new SqlParameter("@u_password",SqlDbType.VarChar),
  165. new SqlParameter("@u_dept_id",SqlDbType.Int),
  166. new SqlParameter("@u_em_id",SqlDbType.Int),
  167. new SqlParameter("@u_state",SqlDbType.Int),
  168. new SqlParameter("@u_logintime",SqlDbType.DateTime),
  169. new SqlParameter("@u_logindegree",SqlDbType.Int),
  170. new SqlParameter("@u_pwdbind",SqlDbType.VarChar),
  171. new SqlParameter("@u_g_id",SqlDbType.Int),
  172. new SqlParameter("@u_landip",SqlDbType.VarChar)
  173. };
  174.             param[0].Value = users.u_id;
  175.             param[1].Value = users.u_username;
  176.             param[2].Value = users.u_password;
  177.             param[3].Value = users.u_dept_id;
  178.             param[4].Value = users.u_em_id;
  179.             param[5].Value = users.u_state;
  180.             param[6].Value = users.u_logintime;
  181.             param[7].Value = users.u_logindegree;
  182.             param[8].Value = users.u_pwdbind;
  183.             param[9].Value = users.u_g_id;
  184.             param[10].Value = users.u_landip;
  185.             return SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param);
  186.         }
  187.         #endregion
  189.         #region 删除
  190.         /// <summary>
  191.         /// 删除数据表users中的一条记录
  192.         /// </summary>
  193.         /// <param name="u_id">u_id</param>
  194.         /// <returns></returns>
  195.         public int Delete(int u_id)
  196.         {
  197.             string sqlCommand = "usersDelete";
  198.             SqlParameter[] param ={
  199. new SqlParameter("@u_id",SqlDbType.Int)
  200. };
  201.             param[0].Value = u_id;
  202.             return SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
  203.         }
  204.         /// <summary>
  205.         /// 删除数据表users中的一条记录
  206.         /// </summary>
  207.         /// <param name="users">users实体对象</param>
  208.         /// <returns></returns>
  209.         public int Delete(users users)
  210.         {
  211.             string sqlCommand = "usersDelete";
  212.             SqlParameter[] param ={
  213. new SqlParameter("@u_id",SqlDbType.Int)
  214. };
  215.             param[0].Value = users.u_id;
  216.             return SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
  217.         }
  218.         /// <summary>
  219.         /// 删除数据表users中的一条记录,带事务
  220.         /// </summary>
  221.         /// <param name="sp">事务对象</param>
  222.         /// <param name="u_id">u_id</param>
  223.         /// <returns></returns>
  224.         public int Delete(SqlTransaction sp, int u_id)
  225.         {
  226.             string sqlCommand = "usersDelete";
  227.             SqlParameter[] param ={
  228. new SqlParameter("@u_id",SqlDbType.Int)
  229. };
  230.             param[0].Value = u_id;
  231.             return SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param);
  232.         }
  234.         /// <summary>
  235.         /// 删除数据表users中的一条记录,带事务
  236.         /// </summary>
  237.         /// <param name="sp">事务对象</param>
  238.         /// <param name="users">users实体对象</param>
  239.         /// <returns></returns>
  240.         public int Delete(SqlTransaction sp, users users)
  241.         {
  242.             string sqlCommand = "usersDelete";
  243.             SqlParameter[] param ={
  244. new SqlParameter("@u_id",SqlDbType.Int)
  245. };
  246.             param[0].Value = users.u_id;
  247.             return SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param);
  248.         }
  249.         #endregion
  251.         #region 实体对象
  252.         /// <summary>
  253.         /// 得到users实体对象
  254.         /// </summary>
  255.         /// <param name="row">row</param>
  256.         /// <returns>users实体对象</returns>
  257.         public users Select(DataRow row)
  258.         {
  259.             users obj = new users();
  260.             if (row != null)
  261.             {
  262.                 obj.u_id = ((row["u_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["u_id"]);
  263.                 obj.u_username = row["u_username"].ToString();
  264.                 obj.u_password = row["u_password"].ToString();
  265.                 obj.u_dept_id = ((row["u_dept_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["u_dept_id"]);
  266.                 obj.u_em_id = ((row["u_em_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["u_em_id"]);
  267.                 obj.u_state = ((row["u_state"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["u_state"]);
  268.                 obj.u_logintime = ((row["u_logintime"]) == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(row["u_logintime"]);
  269.                 obj.u_logindegree = ((row["u_logindegree"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["u_logindegree"]);
  270.                 obj.u_pwdbind = row["u_pwdbind"].ToString();
  271.                 obj.u_g_id = ((row["u_g_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["u_g_id"]);
  272.                 obj.u_landip = row["u_landip"].ToString();
  273.             }
  274.             else
  275.             {
  276.                 return null;
  277.             }
  278.             return obj;
  279.         }
  281.         /// <summary>
  282.         /// 得到users实体对象
  283.         /// </summary>
  284.         /// <param name="dr">dr</param>
  285.         /// <returns>users实体对象</returns>
  286.         public users Select(IDataReader dr)
  287.         {
  288.             users obj = new users();
  289.             obj.u_id = ((dr["u_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["u_id"]);
  290.             obj.u_username = dr["u_username"].ToString();
  291.             obj.u_password = dr["u_password"].ToString();
  292.             obj.u_dept_id = ((dr["u_dept_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["u_dept_id"]);
  293.             obj.u_em_id = ((dr["u_em_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["u_em_id"]);
  294.             obj.u_state = ((dr["u_state"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["u_state"]);
  295.             obj.u_logintime = ((dr["u_logintime"]) == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dr["u_logintime"]);
  296.             obj.u_logindegree = ((dr["u_logindegree"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["u_logindegree"]);
  297.             obj.u_pwdbind = dr["u_pwdbind"].ToString();
  298.             obj.u_g_id = ((dr["u_g_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["u_g_id"]);
  299.             obj.u_landip = dr["u_landip"].ToString();
  300.             return obj;
  301.         }
  303.         /// <summary>
  304.         /// 根据ID,返回一个users实体对象
  305.         /// </summary>
  306.         /// <param name="u_id">u_id</param>
  307.         /// <returns>users实体对象</returns>
  308.         public users Select(int u_id)
  309.         {
  310.             return this.Select(u_id, false, false);
  311.         }
  312.         /// <summary>
  313.         /// 根据ID,返回一个users实体对象
  314.         /// </summary>
  315.         /// <param name="u_id">u_id</param>
  316.         /// <param name="bParentTable">将users对象设置与父表关联</param>
  317.         /// <param name="bChildrenTable">将users对象设置与子表关联</param>
  318.         /// <returns>users实体对象</returns>
  319.         public users Select(int u_id, bool bParentTable, bool bChildrenTable)
  320.         {
  321.             users obj = null;
  322.             SqlParameter[] param ={
  323. new SqlParameter("@u_id",SqlDbType.Int)
  324. };
  325.             param[0].Value = u_id;
  326.             string sqlCommand = "usersSelect";
  327.             using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param))
  328.             {
  329.                 while (dr.Read())
  330.                 {
  331.                     obj = this.Select(dr);
  332.                 }
  333.             }
  334.             this.Select(obj, bParentTable, bChildrenTable);
  335.             return obj;
  336.         }
  337.         /// <summary>
  338.         /// 将users实体对象设置与父表和子表关联
  339.         /// </summary>
  340.         /// <param name="obj">users实体对象</param>
  341.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  342.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  343.         public void Select(users obj, bool bParentTable, bool bChildrenTable)
  344.         {
  345.             //关联的主表
  346.             if (bParentTable)
  347.             {
  348.                 obj.employee = employeeBLL.Select(obj.u_em_id);
  349.                 obj.groups = groupsBLL.Select(obj.u_g_id);
  350.                 obj.department = departmentBLL.Select(obj.u_dept_id);
  351.             }
  352.             //关联的子表集合
  353.             if (bChildrenTable)
  354.             {
  355.                 obj.addresslist = addresslistBLL.Select("al_u_id=" + obj.u_id.ToString());
  356.                 foreach (addresslist item in obj.addresslist)
  357.                 {
  358.                     item.users = obj;
  359.                 }
  360.                 obj.attendance = attendanceBLL.Select("att_u_id=" + obj.u_id.ToString());
  361.                 foreach (attendance item in obj.attendance)
  362.                 {
  363.                     item.users = obj;
  364.                 }
  365.                 obj.bbsrevert = bbsrevertBLL.Select("br_u_id=" + obj.u_id.ToString());
  366.                 foreach (bbsrevert item in obj.bbsrevert)
  367.                 {
  368.                     item.users = obj;
  369.                 }
  370.                 obj.document = documentBLL.Select("doc_u_id=" + obj.u_id.ToString());
  371.                 foreach (document item in obj.document)
  372.                 {
  373.                     item.users = obj;
  374.                 }
  375.                 obj.examine = examineBLL.Select("ex_u_id=" + obj.u_id.ToString());
  376.                 foreach (examine item in obj.examine)
  377.                 {
  378.                     item.users = obj;
  379.                 }
  380.                 obj.filerevert = filerevertBLL.Select("fre_u_id=" + obj.u_id.ToString());
  381.                 foreach (filerevert item in obj.filerevert)
  382.                 {
  383.                     item.users = obj;
  384.                 }
  385.                 obj.files = filesBLL.Select("f_takeu_id=" + obj.u_id.ToString());
  386.                 foreach (files item in obj.files)
  387.                 {
  388.                     item.users = obj;
  389.                 }
  390.                 obj.message = messageBLL.Select("m_u_id=" + obj.u_id.ToString());
  391.                 foreach (message item in obj.message)
  392.                 {
  393.                     item.users = obj;
  394.                 }
  395.                 obj.news = newsBLL.Select("n_u_id=" + obj.u_id.ToString());
  396.                 foreach (news item in obj.news)
  397.                 {
  398.                     item.users = obj;
  399.                 }
  400.                 obj.operate = operateBLL.Select("op_u_id=" + obj.u_id.ToString());
  401.                 foreach (operate item in obj.operate)
  402.                 {
  403.                     item.users = obj;
  404.                 }
  405.                 obj.sendword = sendwordBLL.Select("sw_u_id=" + obj.u_id.ToString());
  406.                 foreach (sendword item in obj.sendword)
  407.                 {
  408.                     item.users = obj;
  409.                 }
  410.                 obj.timeorder = timeorderBLL.Select("to_u_id=" + obj.u_id.ToString());
  411.                 foreach (timeorder item in obj.timeorder)
  412.                 {
  413.                     item.users = obj;
  414.                 }
  415.                 obj.worklog = worklogBLL.Select("w_u_id=" + obj.u_id.ToString());
  416.                 foreach (worklog item in obj.worklog)
  417.                 {
  418.                     item.users = obj;
  419.                 }
  420.                 obj.worksumup = worksumupBLL.Select("ws_u_id=" + obj.u_id.ToString());
  421.                 foreach (worksumup item in obj.worksumup)
  422.                 {
  423.                     item.users = obj;
  424.                 }
  425.             }
  426.         }
  427.         #endregion
  429.         #region 父表
  430.         /// <summary>
  431.         /// 设置实体对象(users)的父表对象
  432.         /// </summary>
  433.         /// <param name="users">实体对象</param>
  434.         public void employee(users users)
  435.         {
  436.             users.employee = employeeBLL.Select(users.u_em_id);
  437.         }
  438.         /// <summary>
  439.         /// 设置实体对象(users)的父表对象
  440.         /// </summary>
  441.         /// <param name="users">实体对象</param>
  442.         public void groups(users users)
  443.         {
  444.             users.groups = groupsBLL.Select(users.u_g_id);
  445.         }
  446.         /// <summary>
  447.         /// 设置实体对象(users)的父表对象
  448.         /// </summary>
  449.         /// <param name="users">实体对象</param>
  450.         public void department(users users)
  451.         {
  452.             users.department = departmentBLL.Select(users.u_dept_id);
  453.         }
  454.         #endregion
  456.         #region 子表
  457.         /// <summary>
  458.         /// 设置实体对象(users)的子表对象
  459.         /// </summary>
  460.         /// <param name="users">实体对象</param>
  461.         public void addresslist(users users)
  462.         {
  463.             users.addresslist = addresslistBLL.Select("al_u_id=" + users.u_id.ToString());
  464.         }
  465.         /// <summary>
  466.         /// 设置实体对象(users)的子表对象
  467.         /// </summary>
  468.         /// <param name="users">实体对象</param>
  469.         public void attendance(users users)
  470.         {
  471.             users.attendance = attendanceBLL.Select("att_u_id=" + users.u_id.ToString());
  472.         }
  473.         /// <summary>
  474.         /// 设置实体对象(users)的子表对象
  475.         /// </summary>
  476.         /// <param name="users">实体对象</param>
  477.         public void bbsrevert(users users)
  478.         {
  479.             users.bbsrevert = bbsrevertBLL.Select("br_u_id=" + users.u_id.ToString());
  480.         }
  481.         /// <summary>
  482.         /// 设置实体对象(users)的子表对象
  483.         /// </summary>
  484.         /// <param name="users">实体对象</param>
  485.         public void document(users users)
  486.         {
  487.             users.document = documentBLL.Select("doc_u_id=" + users.u_id.ToString());
  488.         }
  489.         /// <summary>
  490.         /// 设置实体对象(users)的子表对象
  491.         /// </summary>
  492.         /// <param name="users">实体对象</param>
  493.         public void examine(users users)
  494.         {
  495.             users.examine = examineBLL.Select("ex_u_id=" + users.u_id.ToString());
  496.         }
  497.         /// <summary>
  498.         /// 设置实体对象(users)的子表对象
  499.         /// </summary>
  500.         /// <param name="users">实体对象</param>
  501.         public void filerevert(users users)
  502.         {
  503.             users.filerevert = filerevertBLL.Select("fre_u_id=" + users.u_id.ToString());
  504.         }
  505.         /// <summary>
  506.         /// 设置实体对象(users)的子表对象
  507.         /// </summary>
  508.         /// <param name="users">实体对象</param>
  509.         public void files(users users)
  510.         {
  511.             users.files = filesBLL.Select("f_takeu_id=" + users.u_id.ToString());
  512.         }
  513.         /// <summary>
  514.         /// 设置实体对象(users)的子表对象
  515.         /// </summary>
  516.         /// <param name="users">实体对象</param>
  517.         public void message(users users)
  518.         {
  519.             users.message = messageBLL.Select("m_u_id=" + users.u_id.ToString());
  520.         }
  521.         /// <summary>
  522.         /// 设置实体对象(users)的子表对象
  523.         /// </summary>
  524.         /// <param name="users">实体对象</param>
  525.         public void news(users users)
  526.         {
  527.             users.news = newsBLL.Select("n_u_id=" + users.u_id.ToString());
  528.         }
  529.         /// <summary>
  530.         /// 设置实体对象(users)的子表对象
  531.         /// </summary>
  532.         /// <param name="users">实体对象</param>
  533.         public void operate(users users)
  534.         {
  535.             users.operate = operateBLL.Select("op_u_id=" + users.u_id.ToString());
  536.         }
  537.         /// <summary>
  538.         /// 设置实体对象(users)的子表对象
  539.         /// </summary>
  540.         /// <param name="users">实体对象</param>
  541.         public void sendword(users users)
  542.         {
  543.             users.sendword = sendwordBLL.Select("sw_u_id=" + users.u_id.ToString());
  544.         }
  545.         /// <summary>
  546.         /// 设置实体对象(users)的子表对象
  547.         /// </summary>
  548.         /// <param name="users">实体对象</param>
  549.         public void timeorder(users users)
  550.         {
  551.             users.timeorder = timeorderBLL.Select("to_u_id=" + users.u_id.ToString());
  552.         }
  553.         /// <summary>
  554.         /// 设置实体对象(users)的子表对象
  555.         /// </summary>
  556.         /// <param name="users">实体对象</param>
  557.         public void worklog(users users)
  558.         {
  559.             users.worklog = worklogBLL.Select("w_u_id=" + users.u_id.ToString());
  560.         }
  561.         /// <summary>
  562.         /// 设置实体对象(users)的子表对象
  563.         /// </summary>
  564.         /// <param name="users">实体对象</param>
  565.         public void worksumup(users users)
  566.         {
  567.             users.worksumup = worksumupBLL.Select("ws_u_id=" + users.u_id.ToString());
  568.         }
  569.         #endregion
  571.         #region 查询
  572.         /// <summary>
  573.         /// 得到数据表users所有记录
  574.         /// </summary>
  575.         /// <returns>结果集</returns>
  576.         public IList<users> Select()
  577.         {
  578.             return this.Select(false, false);
  579.         }
  580.         /// <summary>
  581.         /// 得到数据表users所有记录
  582.         /// </summary>
  583.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  584.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  585.         /// <returns>结果集</returns>
  586.         public IList<users> Select(bool bParentTable, bool bChildrenTable)
  587.         {
  588.             IList<users> list = new List<users>();
  589.             string sqlCommand = "usersSelectAll";
  590.             using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand))
  591.             {
  592.                 while (dr.Read())
  593.                 {
  594.                     list.Add(this.Select(dr));
  595.                 }
  596.             }
  597.             foreach (users obj in list)
  598.             {
  599.                 this.Select(obj, bParentTable, bChildrenTable);
  600.             }
  601.             return list;
  602.         }
  603.         /// <summary>
  604.         /// 得到数据表users满足查询条件的记录
  605.         /// </summary>
  606.         /// <param name="where">查询条件</param>
  607.         /// <returns>结果集</returns>
  608.         public IList<users> Select(string where)
  609.         {
  610.             return this.Select(where, false, false);
  611.         }
  612.         /// <summary>
  613.         /// 得到数据表users满足查询条件的记录
  614.         /// </summary>
  615.         /// <param name="where">查询条件</param>
  616.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  617.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  618.         /// <returns>结果集</returns>
  619.         public IList<users> Select(string where, bool bParentTable, bool bChildrenTable)
  620.         {
  621.             IList<users> list = new List<users>();
  622.             SqlParameter[] param ={
  623. new SqlParameter("@where",SqlDbType.VarChar,8000)
  624. };
  625.             param[0].Value = where;
  626.             string sqlCommand = "usersSelectByParams";
  627.             using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param))
  628.             {
  629.                 while (dr.Read())
  630.                 {
  631.                     list.Add(this.Select(dr));
  632.                 }
  633.             }
  634.             foreach (users obj in list)
  635.             {
  636.                 this.Select(obj, bParentTable, bChildrenTable);
  637.             }
  638.             return list;
  639.         }
  640.         /// <summary>
  641.         /// 得到数据表ArticalInfo满足外键字段查询条件的记录
  642.         /// </summary>
  643.         /// <param name="foreignFieldName">外键字段名称</param>
  644.         /// <param name="foreignFieldValue">外键字段值</param>
  645.         /// <returns>结果集</returns>
  646.         public IList<users> Select(string foreignFieldName, int foreignFieldValue)
  647.         {
  648.             return this.Select(foreignFieldName, foreignFieldValue, false, false);
  649.         }
  650.         /// <summary>
  651.         /// 得到数据表ArticalInfo满足外键字段查询条件的记录
  652.         /// </summary>
  653.         /// <param name="foreignFieldName">外键字段名称</param>
  654.         /// <param name="foreignFieldValue">外键字段值</param>
  655.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  656.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  657.         /// <returns>结果集</returns>
  658.         public IList<users> Select(string foreignFieldName, int foreignFieldValue, bool bParentTable, bool bChildrenTable)
  659.         {
  660.             return this.Select(string.Format("{0}='{1}'", foreignFieldName, foreignFieldValue), bParentTable, bChildrenTable);
  661.         }
  662.         /// <summary>
  663.         /// 得到数据表users满足查询条件的记录数
  664.         /// </summary>
  665.         /// <param name="where">查询条件</param>
  666.         /// <param name="recordCount">记录数</param>
  667.         public void Select(string where, out int recordCount)
  668.         {
  669.             string sqlCommand = "usersCountByWhere";
  670.             SqlParameter[] param ={
  671. new SqlParameter("@where",SqlDbType.VarChar,8000),
  672. new SqlParameter("@recordCount",SqlDbType.Int)
  673. };
  674.             param[0].Value = where;
  675.             param[1].Direction = ParameterDirection.Output;
  676.             SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
  677.             recordCount = Convert.ToInt32(param[1].Value);
  678.         }
  679.         /// <summary>
  680.         /// 得到数据表users满足查询条件的分页记录
  681.         /// </summary>
  682.         /// <param name="pageSize">每页显示记录数</param>
  683.         /// <param name="pageIndex">当前显示第几页</param>
  684.         /// <param name="where">查询条件</param>
  685.         /// <returns>结果集</returns>
  686.         public IList<users> Select(int pageSize, int pageIndex, string where)
  687.         {
  688.             return this.Select(pageSize, pageIndex, where, false, false);
  689.         }
  690.         /// <summary>
  691.         /// 得到数据表users满足查询条件的分页记录
  692.         /// </summary>
  693.         /// <param name="pageSize">每页显示记录数</param>
  694.         /// <param name="pageIndex">当前显示第几页</param>
  695.         /// <param name="where">查询条件</param>
  696.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  697.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  698.         /// <returns>结果集</returns>
  699.         public IList<users> Select(int pageSize, int pageIndex, string where, bool bParentTable, bool bChildrenTable)
  700.         {
  701.             IList<users> list = new List<users>();
  702.             string sqlCommand = "usersSelectByPagerParams";
  703.             SqlParameter[] param ={
  704. new SqlParameter("@pageSize",SqlDbType.Int),
  705. new SqlParameter("@pageIndex",SqlDbType.Int),
  706. new SqlParameter("@where",SqlDbType.VarChar,8000)
  707. };
  708.             param[0].Value = pageSize;
  709.             param[1].Value = pageIndex;
  710.             param[2].Value = where;
  711.             using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param))
  712.             {
  713.                 while (dr.Read())
  714.                 {
  715.                     list.Add(this.Select(dr));
  716.                 }
  717.             }
  718.             foreach (users obj in list)
  719.             {
  720.                 this.Select(obj, bParentTable, bChildrenTable);
  721.             }
  722.             return list;
  723.         }
  724.         /// <summary>
  725.         /// 得到数据表users满足查询条件记录
  726.         /// </summary>
  727.         /// <param name="commandType">命令类型</param>
  728.         /// <param name="sqlCommand">SQL命令</param>
  729.         /// <param name="SqlParameter[]">命令参数数组</param>
  730.         /// <returns>结果集</returns>
  731.         public IList<users> Select(CommandType commandType, string sqlCommand, params SqlParameter[] param)
  732.         {
  733.             return this.Select(false, false, commandType, sqlCommand, param);
  734.         }
  735.         /// <summary>
  736.         /// 得到数据表users满足查询条件记录
  737.         /// </summary>
  738.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  739.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  740.         /// <param name="commandType">命令类型</param>
  741.         /// <param name="sqlCommand">SQL命令</param>
  742.         /// <param name="SqlParameter[]">命令参数数组</param>
  743.         /// <returns>结果集</returns>
  744.         public IList<users> Select(bool bParentTable, bool bChildrenTable, CommandType commandType, string sqlCommand, params SqlParameter[] param)
  745.         {
  746.             IList<users> list = new List<users>();
  747.             using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, commandType, sqlCommand, param))
  748.             {
  749.                 while (dr.Read())
  750.                 {
  751.                     list.Add(this.Select(dr));
  752.                 }
  753.             }
  754.             foreach (users obj in list)
  755.             {
  756.                 this.Select(obj, bParentTable, bChildrenTable);
  757.             }
  758.             return list;
  759.         }
  760.         /// <summary>
  761.         /// 根据主键检测是否存在该条记录
  762.         /// </summary>
  763.         /// <param name="u_id">u_id</param>
  764.         /// <returns>存在/不存在</returns>
  765.         public bool Exists(int u_id)
  766.         {
  767.             SqlParameter[] param ={
  768.                                  new SqlParameter("@u_id",SqlDbType.Int)
  769.                                  };
  770.             param[0].Value = u_id;
  771.             string sqlCommand = "usersIsExist";
  772.             int a = Convert.ToInt32(SqlHelper.ExecuteScalar(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param));
  773.             if (a > 0)
  774.             {
  775.                 return true;
  776.             }
  777.             else
  778.             {
  779.                 return false;
  780.             }
  781.         }
  782.         #endregion
  784.         #endregion
  785.     }
  786. }
  787. //５1ａｓpｘ