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

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

OA系统

开发平台：

C#

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