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

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

OA系统

开发平台：

C#

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