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

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

OA系统

开发平台：

C#

employeeDAL.cs：源码内容
  1. // =================================================================== 
  2. // 产品(COM.OA.SqlServerDAL)项目
  3. //====================================================================
  4. // wangyp @Copy Right 2006-2008
  5. // 文件：employeeDAL.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.employee
  25.     /// </summary>
  26.     public partial class employeeDAL : IemployeeDAL
  27.     {
  28.         #region 构造函数
  29.         /// <summary>
  30.         /// 数据层实例化
  31.         /// </summary>
  32.         public employeeDAL()
  33.         {
  34.         }
  35.         #endregion
  37.         #region -----------实例化接口函数-----------
  39.         #region 添加
  40.         /// <summary>
  41.         /// 向数据库中插入一条新记录
  42.         /// </summary>
  43.         /// <param name="employee">employee实体对象</param>
  44.         /// <returns></returns>
  45.         public int Insert(employee employee)
  46.         {
  47.             string sqlCommand = "employeeInsert";
  48.             int res;
  49.             SqlParameter[] param ={
  50. new SqlParameter("@em_id",SqlDbType.Int),
  51. new SqlParameter("@em_number",SqlDbType.VarChar),
  52. new SqlParameter("@em_name",SqlDbType.VarChar),
  53. new SqlParameter("@em_evername",SqlDbType.VarChar),
  54. new SqlParameter("@em_gender",SqlDbType.Int),
  55. new SqlParameter("@em_birth",SqlDbType.DateTime),
  56. new SqlParameter("@em_marriage",SqlDbType.VarChar),
  57. new SqlParameter("@em_n_id",SqlDbType.Int),
  58. new SqlParameter("@em_na_id",SqlDbType.Int),
  59. new SqlParameter("@em_p_id",SqlDbType.Int),
  60. new SqlParameter("@em_stature",SqlDbType.VarChar),
  61. new SqlParameter("@em_avoirdupois",SqlDbType.VarChar),
  62. new SqlParameter("@em_v_id",SqlDbType.Int),
  63. new SqlParameter("@em_statuscard",SqlDbType.VarChar),
  64. new SqlParameter("@em_health",SqlDbType.VarChar),
  65. new SqlParameter("@em_bloodtype",SqlDbType.VarChar),
  66. new SqlParameter("@em_phone",SqlDbType.VarChar),
  67. new SqlParameter("@em_mobile",SqlDbType.VarChar),
  68. new SqlParameter("@em_email",SqlDbType.VarChar),
  69. new SqlParameter("@em_finishschool",SqlDbType.VarChar),
  70. new SqlParameter("@em_speciality",SqlDbType.VarChar),
  71. new SqlParameter("@em_l_id",SqlDbType.Int),
  72. new SqlParameter("@em_graduatetime",SqlDbType.DateTime),
  73. new SqlParameter("@em_degree",SqlDbType.VarChar),
  74. new SqlParameter("@em_language",SqlDbType.VarChar),
  75. new SqlParameter("@em_languagelevel",SqlDbType.VarChar),
  76. new SqlParameter("@em_languageletter",SqlDbType.VarChar),
  77. new SqlParameter("@em_computerlevel",SqlDbType.VarChar),
  78. new SqlParameter("@em_computerletter",SqlDbType.VarChar),
  79. new SqlParameter("@em_computergood",SqlDbType.VarChar),
  80. new SqlParameter("@em_mandarinlevel",SqlDbType.VarChar),
  81. new SqlParameter("@em_familyaddress",SqlDbType.VarChar),
  82. new SqlParameter("@em_postalcode",SqlDbType.VarChar),
  83. new SqlParameter("@em_address",SqlDbType.VarChar),
  84. new SqlParameter("@em_familyphone",SqlDbType.VarChar),
  85. new SqlParameter("@em_addresspostalcode",SqlDbType.VarChar),
  86. new SqlParameter("@em_familycircs",SqlDbType.VarChar),
  87. new SqlParameter("@em_recordlocus",SqlDbType.VarChar),
  88. new SqlParameter("@em_jobname",SqlDbType.VarChar),
  89. new SqlParameter("@em_whenjoinwork",SqlDbType.VarChar),
  90. new SqlParameter("@em_whenthiswork",SqlDbType.VarChar),
  91. new SqlParameter("@em_addlength",SqlDbType.VarChar),
  92. new SqlParameter("@em_thisunitlength",SqlDbType.VarChar),
  93. new SqlParameter("@em_dept_id",SqlDbType.Int),
  94. new SqlParameter("@em_duty",SqlDbType.VarChar),
  95. new SqlParameter("@em_remark",SqlDbType.VarChar),
  96. new SqlParameter("@em_bookerid",SqlDbType.Int),
  97. new SqlParameter("@em_registertime",SqlDbType.DateTime),
  98. new SqlParameter("@em_photo",SqlDbType.VarChar)
  99. };
  100.             param[0].Direction = ParameterDirection.Output;
  101.             param[1].Value = employee.em_number;
  102.             param[2].Value = employee.em_name;
  103.             param[3].Value = employee.em_evername;
  104.             param[4].Value = employee.em_gender;
  105.             param[5].Value = employee.em_birth;
  106.             param[6].Value = employee.em_marriage;
  107.             param[7].Value = employee.em_n_id;
  108.             param[8].Value = employee.em_na_id;
  109.             param[9].Value = employee.em_p_id;
  110.             param[10].Value = employee.em_stature;
  111.             param[11].Value = employee.em_avoirdupois;
  112.             param[12].Value = employee.em_v_id;
  113.             param[13].Value = employee.em_statuscard;
  114.             param[14].Value = employee.em_health;
  115.             param[15].Value = employee.em_bloodtype;
  116.             param[16].Value = employee.em_phone;
  117.             param[17].Value = employee.em_mobile;
  118.             param[18].Value = employee.em_email;
  119.             param[19].Value = employee.em_finishschool;
  120.             param[20].Value = employee.em_speciality;
  121.             param[21].Value = employee.em_l_id;
  122.             param[22].Value = employee.em_graduatetime;
  123.             param[23].Value = employee.em_degree;
  124.             param[24].Value = employee.em_language;
  125.             param[25].Value = employee.em_languagelevel;
  126.             param[26].Value = employee.em_languageletter;
  127.             param[27].Value = employee.em_computerlevel;
  128.             param[28].Value = employee.em_computerletter;
  129.             param[29].Value = employee.em_computergood;
  130.             param[30].Value = employee.em_mandarinlevel;
  131.             param[31].Value = employee.em_familyaddress;
  132.             param[32].Value = employee.em_postalcode;
  133.             param[33].Value = employee.em_address;
  134.             param[34].Value = employee.em_familyphone;
  135.             param[35].Value = employee.em_addresspostalcode;
  136.             param[36].Value = employee.em_familycircs;
  137.             param[37].Value = employee.em_recordlocus;
  138.             param[38].Value = employee.em_jobname;
  139.             param[39].Value = employee.em_whenjoinwork;
  140.             param[40].Value = employee.em_whenthiswork;
  141.             param[41].Value = employee.em_addlength;
  142.             param[42].Value = employee.em_thisunitlength;
  143.             param[43].Value = employee.em_dept_id;
  144.             param[44].Value = employee.em_duty;
  145.             param[45].Value = employee.em_remark;
  146.             param[46].Value = employee.em_bookerid;
  147.             param[47].Value = employee.em_registertime;
  148.             param[48].Value = employee.em_photo;
  149.             res = SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
  150.             employee.em_id = ((param[0].Value) == DBNull.Value) ? 0 : Convert.ToInt32(param[0].Value);
  151.             return res;
  152.         }
  153.         /// <summary>
  154.         /// 向数据库中插入一条新记录。带事务
  155.         /// </summary>
  156.         /// <param name="sp">事务对象</param>
  157.         /// <param name="employee">employee实体对象</param>
  158.         /// <returns></returns>
  159.         public int Insert(SqlTransaction sp, employee employee)
  160.         {
  161.             string sqlCommand = "employeeInsert";
  162.             int res;
  163.             SqlParameter[] param ={
  164. new SqlParameter("@em_id",SqlDbType.Int),
  165. new SqlParameter("@em_number",SqlDbType.VarChar),
  166. new SqlParameter("@em_name",SqlDbType.VarChar),
  167. new SqlParameter("@em_evername",SqlDbType.VarChar),
  168. new SqlParameter("@em_gender",SqlDbType.Int),
  169. new SqlParameter("@em_birth",SqlDbType.DateTime),
  170. new SqlParameter("@em_marriage",SqlDbType.VarChar),
  171. new SqlParameter("@em_n_id",SqlDbType.Int),
  172. new SqlParameter("@em_na_id",SqlDbType.Int),
  173. new SqlParameter("@em_p_id",SqlDbType.Int),
  174. new SqlParameter("@em_stature",SqlDbType.VarChar),
  175. new SqlParameter("@em_avoirdupois",SqlDbType.VarChar),
  176. new SqlParameter("@em_v_id",SqlDbType.Int),
  177. new SqlParameter("@em_statuscard",SqlDbType.VarChar),
  178. new SqlParameter("@em_health",SqlDbType.VarChar),
  179. new SqlParameter("@em_bloodtype",SqlDbType.VarChar),
  180. new SqlParameter("@em_phone",SqlDbType.VarChar),
  181. new SqlParameter("@em_mobile",SqlDbType.VarChar),
  182. new SqlParameter("@em_email",SqlDbType.VarChar),
  183. new SqlParameter("@em_finishschool",SqlDbType.VarChar),
  184. new SqlParameter("@em_speciality",SqlDbType.VarChar),
  185. new SqlParameter("@em_l_id",SqlDbType.Int),
  186. new SqlParameter("@em_graduatetime",SqlDbType.DateTime),
  187. new SqlParameter("@em_degree",SqlDbType.VarChar),
  188. new SqlParameter("@em_language",SqlDbType.VarChar),
  189. new SqlParameter("@em_languagelevel",SqlDbType.VarChar),
  190. new SqlParameter("@em_languageletter",SqlDbType.VarChar),
  191. new SqlParameter("@em_computerlevel",SqlDbType.VarChar),
  192. new SqlParameter("@em_computerletter",SqlDbType.VarChar),
  193. new SqlParameter("@em_computergood",SqlDbType.VarChar),
  194. new SqlParameter("@em_mandarinlevel",SqlDbType.VarChar),
  195. new SqlParameter("@em_familyaddress",SqlDbType.VarChar),
  196. new SqlParameter("@em_postalcode",SqlDbType.VarChar),
  197. new SqlParameter("@em_address",SqlDbType.VarChar),
  198. new SqlParameter("@em_familyphone",SqlDbType.VarChar),
  199. new SqlParameter("@em_addresspostalcode",SqlDbType.VarChar),
  200. new SqlParameter("@em_familycircs",SqlDbType.VarChar),
  201. new SqlParameter("@em_recordlocus",SqlDbType.VarChar),
  202. new SqlParameter("@em_jobname",SqlDbType.VarChar),
  203. new SqlParameter("@em_whenjoinwork",SqlDbType.VarChar),
  204. new SqlParameter("@em_whenthiswork",SqlDbType.VarChar),
  205. new SqlParameter("@em_addlength",SqlDbType.VarChar),
  206. new SqlParameter("@em_thisunitlength",SqlDbType.VarChar),
  207. new SqlParameter("@em_dept_id",SqlDbType.Int),
  208. new SqlParameter("@em_duty",SqlDbType.VarChar),
  209. new SqlParameter("@em_remark",SqlDbType.VarChar),
  210. new SqlParameter("@em_bookerid",SqlDbType.Int),
  211. new SqlParameter("@em_registertime",SqlDbType.DateTime),
  212. new SqlParameter("@em_photo",SqlDbType.VarChar)
  213. };
  214.             param[0].Direction = ParameterDirection.Output;
  215.             param[1].Value = employee.em_number;
  216.             param[2].Value = employee.em_name;
  217.             param[3].Value = employee.em_evername;
  218.             param[4].Value = employee.em_gender;
  219.             param[5].Value = employee.em_birth;
  220.             param[6].Value = employee.em_marriage;
  221.             param[7].Value = employee.em_n_id;
  222.             param[8].Value = employee.em_na_id;
  223.             param[9].Value = employee.em_p_id;
  224.             param[10].Value = employee.em_stature;
  225.             param[11].Value = employee.em_avoirdupois;
  226.             param[12].Value = employee.em_v_id;
  227.             param[13].Value = employee.em_statuscard;
  228.             param[14].Value = employee.em_health;
  229.             param[15].Value = employee.em_bloodtype;
  230.             param[16].Value = employee.em_phone;
  231.             param[17].Value = employee.em_mobile;
  232.             param[18].Value = employee.em_email;
  233.             param[19].Value = employee.em_finishschool;
  234.             param[20].Value = employee.em_speciality;
  235.             param[21].Value = employee.em_l_id;
  236.             param[22].Value = employee.em_graduatetime;
  237.             param[23].Value = employee.em_degree;
  238.             param[24].Value = employee.em_language;
  239.             param[25].Value = employee.em_languagelevel;
  240.             param[26].Value = employee.em_languageletter;
  241.             param[27].Value = employee.em_computerlevel;
  242.             param[28].Value = employee.em_computerletter;
  243.             param[29].Value = employee.em_computergood;
  244.             param[30].Value = employee.em_mandarinlevel;
  245.             param[31].Value = employee.em_familyaddress;
  246.             param[32].Value = employee.em_postalcode;
  247.             param[33].Value = employee.em_address;
  248.             param[34].Value = employee.em_familyphone;
  249.             param[35].Value = employee.em_addresspostalcode;
  250.             param[36].Value = employee.em_familycircs;
  251.             param[37].Value = employee.em_recordlocus;
  252.             param[38].Value = employee.em_jobname;
  253.             param[39].Value = employee.em_whenjoinwork;
  254.             param[40].Value = employee.em_whenthiswork;
  255.             param[41].Value = employee.em_addlength;
  256.             param[42].Value = employee.em_thisunitlength;
  257.             param[43].Value = employee.em_dept_id;
  258.             param[44].Value = employee.em_duty;
  259.             param[45].Value = employee.em_remark;
  260.             param[46].Value = employee.em_bookerid;
  261.             param[47].Value = employee.em_registertime;
  262.             param[48].Value = employee.em_photo;
  263.             res = SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param);
  264.             employee.em_id = ((param[0].Value) == DBNull.Value) ? 0 : Convert.ToInt32(param[0].Value);
  265.             return res;
  266.         }
  267.         #endregion
  269.         #region 更新
  270.         /// <summary>
  271.         /// 向数据表employee更新一条记录
  272.         /// </summary>
  273.         /// <param name="employee">employee实体对象</param>
  274.         /// <returns></returns>
  275.         public int Update(employee employee)
  276.         {
  277.             string sqlCommand = "employeeUpdate";
  278.             SqlParameter[] param ={
  279. new SqlParameter("@em_id",SqlDbType.Int),
  280. new SqlParameter("@em_number",SqlDbType.VarChar),
  281. new SqlParameter("@em_name",SqlDbType.VarChar),
  282. new SqlParameter("@em_evername",SqlDbType.VarChar),
  283. new SqlParameter("@em_gender",SqlDbType.Int),
  284. new SqlParameter("@em_birth",SqlDbType.DateTime),
  285. new SqlParameter("@em_marriage",SqlDbType.VarChar),
  286. new SqlParameter("@em_n_id",SqlDbType.Int),
  287. new SqlParameter("@em_na_id",SqlDbType.Int),
  288. new SqlParameter("@em_p_id",SqlDbType.Int),
  289. new SqlParameter("@em_stature",SqlDbType.VarChar),
  290. new SqlParameter("@em_avoirdupois",SqlDbType.VarChar),
  291. new SqlParameter("@em_v_id",SqlDbType.Int),
  292. new SqlParameter("@em_statuscard",SqlDbType.VarChar),
  293. new SqlParameter("@em_health",SqlDbType.VarChar),
  294. new SqlParameter("@em_bloodtype",SqlDbType.VarChar),
  295. new SqlParameter("@em_phone",SqlDbType.VarChar),
  296. new SqlParameter("@em_mobile",SqlDbType.VarChar),
  297. new SqlParameter("@em_email",SqlDbType.VarChar),
  298. new SqlParameter("@em_finishschool",SqlDbType.VarChar),
  299. new SqlParameter("@em_speciality",SqlDbType.VarChar),
  300. new SqlParameter("@em_l_id",SqlDbType.Int),
  301. new SqlParameter("@em_graduatetime",SqlDbType.DateTime),
  302. new SqlParameter("@em_degree",SqlDbType.VarChar),
  303. new SqlParameter("@em_language",SqlDbType.VarChar),
  304. new SqlParameter("@em_languagelevel",SqlDbType.VarChar),
  305. new SqlParameter("@em_languageletter",SqlDbType.VarChar),
  306. new SqlParameter("@em_computerlevel",SqlDbType.VarChar),
  307. new SqlParameter("@em_computerletter",SqlDbType.VarChar),
  308. new SqlParameter("@em_computergood",SqlDbType.VarChar),
  309. new SqlParameter("@em_mandarinlevel",SqlDbType.VarChar),
  310. new SqlParameter("@em_familyaddress",SqlDbType.VarChar),
  311. new SqlParameter("@em_postalcode",SqlDbType.VarChar),
  312. new SqlParameter("@em_address",SqlDbType.VarChar),
  313. new SqlParameter("@em_familyphone",SqlDbType.VarChar),
  314. new SqlParameter("@em_addresspostalcode",SqlDbType.VarChar),
  315. new SqlParameter("@em_familycircs",SqlDbType.VarChar),
  316. new SqlParameter("@em_recordlocus",SqlDbType.VarChar),
  317. new SqlParameter("@em_jobname",SqlDbType.VarChar),
  318. new SqlParameter("@em_whenjoinwork",SqlDbType.VarChar),
  319. new SqlParameter("@em_whenthiswork",SqlDbType.VarChar),
  320. new SqlParameter("@em_addlength",SqlDbType.VarChar),
  321. new SqlParameter("@em_thisunitlength",SqlDbType.VarChar),
  322. new SqlParameter("@em_dept_id",SqlDbType.Int),
  323. new SqlParameter("@em_duty",SqlDbType.VarChar),
  324. new SqlParameter("@em_remark",SqlDbType.VarChar),
  325. new SqlParameter("@em_bookerid",SqlDbType.Int),
  326. new SqlParameter("@em_registertime",SqlDbType.DateTime),
  327. new SqlParameter("@em_photo",SqlDbType.VarChar)
  328. };
  329.             param[0].Value = employee.em_id;
  330.             param[1].Value = employee.em_number;
  331.             param[2].Value = employee.em_name;
  332.             param[3].Value = employee.em_evername;
  333.             param[4].Value = employee.em_gender;
  334.             param[5].Value = employee.em_birth;
  335.             param[6].Value = employee.em_marriage;
  336.             param[7].Value = employee.em_n_id;
  337.             param[8].Value = employee.em_na_id;
  338.             param[9].Value = employee.em_p_id;
  339.             param[10].Value = employee.em_stature;
  340.             param[11].Value = employee.em_avoirdupois;
  341.             param[12].Value = employee.em_v_id;
  342.             param[13].Value = employee.em_statuscard;
  343.             param[14].Value = employee.em_health;
  344.             param[15].Value = employee.em_bloodtype;
  345.             param[16].Value = employee.em_phone;
  346.             param[17].Value = employee.em_mobile;
  347.             param[18].Value = employee.em_email;
  348.             param[19].Value = employee.em_finishschool;
  349.             param[20].Value = employee.em_speciality;
  350.             param[21].Value = employee.em_l_id;
  351.             param[22].Value = employee.em_graduatetime;
  352.             param[23].Value = employee.em_degree;
  353.             param[24].Value = employee.em_language;
  354.             param[25].Value = employee.em_languagelevel;
  355.             param[26].Value = employee.em_languageletter;
  356.             param[27].Value = employee.em_computerlevel;
  357.             param[28].Value = employee.em_computerletter;
  358.             param[29].Value = employee.em_computergood;
  359.             param[30].Value = employee.em_mandarinlevel;
  360.             param[31].Value = employee.em_familyaddress;
  361.             param[32].Value = employee.em_postalcode;
  362.             param[33].Value = employee.em_address;
  363.             param[34].Value = employee.em_familyphone;
  364.             param[35].Value = employee.em_addresspostalcode;
  365.             param[36].Value = employee.em_familycircs;
  366.             param[37].Value = employee.em_recordlocus;
  367.             param[38].Value = employee.em_jobname;
  368.             param[39].Value = employee.em_whenjoinwork;
  369.             param[40].Value = employee.em_whenthiswork;
  370.             param[41].Value = employee.em_addlength;
  371.             param[42].Value = employee.em_thisunitlength;
  372.             param[43].Value = employee.em_dept_id;
  373.             param[44].Value = employee.em_duty;
  374.             param[45].Value = employee.em_remark;
  375.             param[46].Value = employee.em_bookerid;
  376.             param[47].Value = employee.em_registertime;
  377.             param[48].Value = employee.em_photo;
  378.             return SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
  379.         }
  380.         /// <summary>
  381.         /// 向数据表employee更新一条记录。带事务
  382.         /// </summary>
  383.         /// <param name="sp">事务对象</param>
  384.         /// <param name="employee">employee实体对象</param>
  385.         /// <returns></returns>
  386.         public int Update(SqlTransaction sp, employee employee)
  387.         {
  388.             string sqlCommand = "employeeUpdate";
  389.             SqlParameter[] param ={
  390. new SqlParameter("@em_id",SqlDbType.Int),
  391. new SqlParameter("@em_number",SqlDbType.VarChar),
  392. new SqlParameter("@em_name",SqlDbType.VarChar),
  393. new SqlParameter("@em_evername",SqlDbType.VarChar),
  394. new SqlParameter("@em_gender",SqlDbType.Int),
  395. new SqlParameter("@em_birth",SqlDbType.DateTime),
  396. new SqlParameter("@em_marriage",SqlDbType.VarChar),
  397. new SqlParameter("@em_n_id",SqlDbType.Int),
  398. new SqlParameter("@em_na_id",SqlDbType.Int),
  399. new SqlParameter("@em_p_id",SqlDbType.Int),
  400. new SqlParameter("@em_stature",SqlDbType.VarChar),
  401. new SqlParameter("@em_avoirdupois",SqlDbType.VarChar),
  402. new SqlParameter("@em_v_id",SqlDbType.Int),
  403. new SqlParameter("@em_statuscard",SqlDbType.VarChar),
  404. new SqlParameter("@em_health",SqlDbType.VarChar),
  405. new SqlParameter("@em_bloodtype",SqlDbType.VarChar),
  406. new SqlParameter("@em_phone",SqlDbType.VarChar),
  407. new SqlParameter("@em_mobile",SqlDbType.VarChar),
  408. new SqlParameter("@em_email",SqlDbType.VarChar),
  409. new SqlParameter("@em_finishschool",SqlDbType.VarChar),
  410. new SqlParameter("@em_speciality",SqlDbType.VarChar),
  411. new SqlParameter("@em_l_id",SqlDbType.Int),
  412. new SqlParameter("@em_graduatetime",SqlDbType.DateTime),
  413. new SqlParameter("@em_degree",SqlDbType.VarChar),
  414. new SqlParameter("@em_language",SqlDbType.VarChar),
  415. new SqlParameter("@em_languagelevel",SqlDbType.VarChar),
  416. new SqlParameter("@em_languageletter",SqlDbType.VarChar),
  417. new SqlParameter("@em_computerlevel",SqlDbType.VarChar),
  418. new SqlParameter("@em_computerletter",SqlDbType.VarChar),
  419. new SqlParameter("@em_computergood",SqlDbType.VarChar),
  420. new SqlParameter("@em_mandarinlevel",SqlDbType.VarChar),
  421. new SqlParameter("@em_familyaddress",SqlDbType.VarChar),
  422. new SqlParameter("@em_postalcode",SqlDbType.VarChar),
  423. new SqlParameter("@em_address",SqlDbType.VarChar),
  424. new SqlParameter("@em_familyphone",SqlDbType.VarChar),
  425. new SqlParameter("@em_addresspostalcode",SqlDbType.VarChar),
  426. new SqlParameter("@em_familycircs",SqlDbType.VarChar),
  427. new SqlParameter("@em_recordlocus",SqlDbType.VarChar),
  428. new SqlParameter("@em_jobname",SqlDbType.VarChar),
  429. new SqlParameter("@em_whenjoinwork",SqlDbType.VarChar),
  430. new SqlParameter("@em_whenthiswork",SqlDbType.VarChar),
  431. new SqlParameter("@em_addlength",SqlDbType.VarChar),
  432. new SqlParameter("@em_thisunitlength",SqlDbType.VarChar),
  433. new SqlParameter("@em_dept_id",SqlDbType.Int),
  434. new SqlParameter("@em_duty",SqlDbType.VarChar),
  435. new SqlParameter("@em_remark",SqlDbType.VarChar),
  436. new SqlParameter("@em_bookerid",SqlDbType.Int),
  437. new SqlParameter("@em_registertime",SqlDbType.DateTime),
  438. new SqlParameter("@em_photo",SqlDbType.VarChar)
  439. };
  440.             param[0].Value = employee.em_id;
  441.             param[1].Value = employee.em_number;
  442.             param[2].Value = employee.em_name;
  443.             param[3].Value = employee.em_evername;
  444.             param[4].Value = employee.em_gender;
  445.             param[5].Value = employee.em_birth;
  446.             param[6].Value = employee.em_marriage;
  447.             param[7].Value = employee.em_n_id;
  448.             param[8].Value = employee.em_na_id;
  449.             param[9].Value = employee.em_p_id;
  450.             param[10].Value = employee.em_stature;
  451.             param[11].Value = employee.em_avoirdupois;
  452.             param[12].Value = employee.em_v_id;
  453.             param[13].Value = employee.em_statuscard;
  454.             param[14].Value = employee.em_health;
  455.             param[15].Value = employee.em_bloodtype;
  456.             param[16].Value = employee.em_phone;
  457.             param[17].Value = employee.em_mobile;
  458.             param[18].Value = employee.em_email;
  459.             param[19].Value = employee.em_finishschool;
  460.             param[20].Value = employee.em_speciality;
  461.             param[21].Value = employee.em_l_id;
  462.             param[22].Value = employee.em_graduatetime;
  463.             param[23].Value = employee.em_degree;
  464.             param[24].Value = employee.em_language;
  465.             param[25].Value = employee.em_languagelevel;
  466.             param[26].Value = employee.em_languageletter;
  467.             param[27].Value = employee.em_computerlevel;
  468.             param[28].Value = employee.em_computerletter;
  469.             param[29].Value = employee.em_computergood;
  470.             param[30].Value = employee.em_mandarinlevel;
  471.             param[31].Value = employee.em_familyaddress;
  472.             param[32].Value = employee.em_postalcode;
  473.             param[33].Value = employee.em_address;
  474.             param[34].Value = employee.em_familyphone;
  475.             param[35].Value = employee.em_addresspostalcode;
  476.             param[36].Value = employee.em_familycircs;
  477.             param[37].Value = employee.em_recordlocus;
  478.             param[38].Value = employee.em_jobname;
  479.             param[39].Value = employee.em_whenjoinwork;
  480.             param[40].Value = employee.em_whenthiswork;
  481.             param[41].Value = employee.em_addlength;
  482.             param[42].Value = employee.em_thisunitlength;
  483.             param[43].Value = employee.em_dept_id;
  484.             param[44].Value = employee.em_duty;
  485.             param[45].Value = employee.em_remark;
  486.             param[46].Value = employee.em_bookerid;
  487.             param[47].Value = employee.em_registertime;
  488.             param[48].Value = employee.em_photo;
  489.             return SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param);
  490.         }
  491.         #endregion
  493.         #region 删除
  494.         /// <summary>
  495.         /// 删除数据表employee中的一条记录
  496.         /// </summary>
  497.         /// <param name="em_id">em_id</param>
  498.         /// <returns></returns>
  499.         public int Delete(int em_id)
  500.         {
  501.             string sqlCommand = "employeeDelete";
  502.             SqlParameter[] param ={
  503. new SqlParameter("@em_id",SqlDbType.Int)
  504. };
  505.             param[0].Value = em_id;
  506.             return SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
  507.         }
  508.         /// <summary>
  509.         /// 删除数据表employee中的一条记录
  510.         /// </summary>
  511.         /// <param name="employee">employee实体对象</param>
  512.         /// <returns></returns>
  513.         public int Delete(employee employee)
  514.         {
  515.             string sqlCommand = "employeeDelete";
  516.             SqlParameter[] param ={
  517. new SqlParameter("@em_id",SqlDbType.Int)
  518. };
  519.             param[0].Value = employee.em_id;
  520.             return SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
  521.         }
  522.         /// <summary>
  523.         /// 删除数据表employee中的一条记录,带事务
  524.         /// </summary>
  525.         /// <param name="sp">事务对象</param>
  526.         /// <param name="em_id">em_id</param>
  527.         /// <returns></returns>
  528.         public int Delete(SqlTransaction sp, int em_id)
  529.         {
  530.             string sqlCommand = "employeeDelete";
  531.             SqlParameter[] param ={
  532. new SqlParameter("@em_id",SqlDbType.Int)
  533. };
  534.             param[0].Value = em_id;
  535.             return SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param);
  536.         }
  538.         /// <summary>
  539.         /// 删除数据表employee中的一条记录,带事务
  540.         /// </summary>
  541.         /// <param name="sp">事务对象</param>
  542.         /// <param name="employee">employee实体对象</param>
  543.         /// <returns></returns>
  544.         public int Delete(SqlTransaction sp, employee employee)
  545.         {
  546.             string sqlCommand = "employeeDelete";
  547.             SqlParameter[] param ={
  548. new SqlParameter("@em_id",SqlDbType.Int)
  549. };
  550.             param[0].Value = employee.em_id;
  551.             return SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param);
  552.         }
  553.         #endregion
  555.         #region 实体对象
  556.         /// <summary>
  557.         /// 得到employee实体对象
  558.         /// </summary>
  559.         /// <param name="row">row</param>
  560.         /// <returns>employee实体对象</returns>
  561.         public employee Select(DataRow row)
  562.         {
  563.             employee obj = new employee();
  564.             if (row != null)
  565.             {
  566.                 obj.em_id = ((row["em_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["em_id"]);
  567.                 obj.em_number = row["em_number"].ToString();
  568.                 obj.em_name = row["em_name"].ToString();
  569.                 obj.em_evername = row["em_evername"].ToString();
  570.                 obj.em_gender = ((row["em_gender"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["em_gender"]);
  571.                 obj.em_birth = ((row["em_birth"]) == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(row["em_birth"]);
  572.                 obj.em_marriage = row["em_marriage"].ToString();
  573.                 obj.em_n_id = ((row["em_n_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["em_n_id"]);
  574.                 obj.em_na_id = ((row["em_na_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["em_na_id"]);
  575.                 obj.em_p_id = ((row["em_p_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["em_p_id"]);
  576.                 obj.em_stature = row["em_stature"].ToString();
  577.                 obj.em_avoirdupois = row["em_avoirdupois"].ToString();
  578.                 obj.em_v_id = ((row["em_v_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["em_v_id"]);
  579.                 obj.em_statuscard = row["em_statuscard"].ToString();
  580.                 obj.em_health = row["em_health"].ToString();
  581.                 obj.em_bloodtype = row["em_bloodtype"].ToString();
  582.                 obj.em_phone = row["em_phone"].ToString();
  583.                 obj.em_mobile = row["em_mobile"].ToString();
  584.                 obj.em_email = row["em_email"].ToString();
  585.                 obj.em_finishschool = row["em_finishschool"].ToString();
  586.                 obj.em_speciality = row["em_speciality"].ToString();
  587.                 obj.em_l_id = ((row["em_l_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["em_l_id"]);
  588.                 obj.em_graduatetime = ((row["em_graduatetime"]) == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(row["em_graduatetime"]);
  589.                 obj.em_degree = row["em_degree"].ToString();
  590.                 obj.em_language = row["em_language"].ToString();
  591.                 obj.em_languagelevel = row["em_languagelevel"].ToString();
  592.                 obj.em_languageletter = row["em_languageletter"].ToString();
  593.                 obj.em_computerlevel = row["em_computerlevel"].ToString();
  594.                 obj.em_computerletter = row["em_computerletter"].ToString();
  595.                 obj.em_computergood = row["em_computergood"].ToString();
  596.                 obj.em_mandarinlevel = row["em_mandarinlevel"].ToString();
  597.                 obj.em_familyaddress = row["em_familyaddress"].ToString();
  598.                 obj.em_postalcode = row["em_postalcode"].ToString();
  599.                 obj.em_address = row["em_address"].ToString();
  600.                 obj.em_familyphone = row["em_familyphone"].ToString();
  601.                 obj.em_addresspostalcode = row["em_addresspostalcode"].ToString();
  602.                 obj.em_familycircs = row["em_familycircs"].ToString();
  603.                 obj.em_recordlocus = row["em_recordlocus"].ToString();
  604.                 obj.em_jobname = row["em_jobname"].ToString();
  605.                 obj.em_whenjoinwork = row["em_whenjoinwork"].ToString();
  606.                 obj.em_whenthiswork = row["em_whenthiswork"].ToString();
  607.                 obj.em_addlength = row["em_addlength"].ToString();
  608.                 obj.em_thisunitlength = row["em_thisunitlength"].ToString();
  609.                 obj.em_dept_id = ((row["em_dept_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["em_dept_id"]);
  610.                 obj.em_duty = row["em_duty"].ToString();
  611.                 obj.em_remark = row["em_remark"].ToString();
  612.                 obj.em_bookerid = ((row["em_bookerid"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["em_bookerid"]);
  613.                 obj.em_registertime = ((row["em_registertime"]) == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(row["em_registertime"]);
  614.                 obj.em_photo = row["em_photo"].ToString();
  615.             }
  616.             else
  617.             {
  618.                 return null;
  619.             }
  620.             return obj;
  621.         }
  623.         /// <summary>
  624.         /// 得到employee实体对象
  625.         /// </summary>
  626.         /// <param name="dr">dr</param>
  627.         /// <returns>employee实体对象</returns>
  628.         public employee Select(IDataReader dr)
  629.         {
  630.             employee obj = new employee();
  631.             obj.em_id = ((dr["em_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["em_id"]);
  632.             obj.em_number = dr["em_number"].ToString();
  633.             obj.em_name = dr["em_name"].ToString();
  634.             obj.em_evername = dr["em_evername"].ToString();
  635.             obj.em_gender = ((dr["em_gender"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["em_gender"]);
  636.             obj.em_birth = ((dr["em_birth"]) == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dr["em_birth"]);
  637.             obj.em_marriage = dr["em_marriage"].ToString();
  638.             obj.em_n_id = ((dr["em_n_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["em_n_id"]);
  639.             obj.em_na_id = ((dr["em_na_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["em_na_id"]);
  640.             obj.em_p_id = ((dr["em_p_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["em_p_id"]);
  641.             obj.em_stature = dr["em_stature"].ToString();
  642.             obj.em_avoirdupois = dr["em_avoirdupois"].ToString();
  643.             obj.em_v_id = ((dr["em_v_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["em_v_id"]);
  644.             obj.em_statuscard = dr["em_statuscard"].ToString();
  645.             obj.em_health = dr["em_health"].ToString();
  646.             obj.em_bloodtype = dr["em_bloodtype"].ToString();
  647.             obj.em_phone = dr["em_phone"].ToString();
  648.             obj.em_mobile = dr["em_mobile"].ToString();
  649.             obj.em_email = dr["em_email"].ToString();
  650.             obj.em_finishschool = dr["em_finishschool"].ToString();
  651.             obj.em_speciality = dr["em_speciality"].ToString();
  652.             obj.em_l_id = ((dr["em_l_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["em_l_id"]);
  653.             obj.em_graduatetime = ((dr["em_graduatetime"]) == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dr["em_graduatetime"]);
  654.             obj.em_degree = dr["em_degree"].ToString();
  655.             obj.em_language = dr["em_language"].ToString();
  656.             obj.em_languagelevel = dr["em_languagelevel"].ToString();
  657.             obj.em_languageletter = dr["em_languageletter"].ToString();
  658.             obj.em_computerlevel = dr["em_computerlevel"].ToString();
  659.             obj.em_computerletter = dr["em_computerletter"].ToString();
  660.             obj.em_computergood = dr["em_computergood"].ToString();
  661.             obj.em_mandarinlevel = dr["em_mandarinlevel"].ToString();
  662.             obj.em_familyaddress = dr["em_familyaddress"].ToString();
  663.             obj.em_postalcode = dr["em_postalcode"].ToString();
  664.             obj.em_address = dr["em_address"].ToString();
  665.             obj.em_familyphone = dr["em_familyphone"].ToString();
  666.             obj.em_addresspostalcode = dr["em_addresspostalcode"].ToString();
  667.             obj.em_familycircs = dr["em_familycircs"].ToString();
  668.             obj.em_recordlocus = dr["em_recordlocus"].ToString();
  669.             obj.em_jobname = dr["em_jobname"].ToString();
  670.             obj.em_whenjoinwork = dr["em_whenjoinwork"].ToString();
  671.             obj.em_whenthiswork = dr["em_whenthiswork"].ToString();
  672.             obj.em_addlength = dr["em_addlength"].ToString();
  673.             obj.em_thisunitlength = dr["em_thisunitlength"].ToString();
  674.             obj.em_dept_id = ((dr["em_dept_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["em_dept_id"]);
  675.             obj.em_duty = dr["em_duty"].ToString();
  676.             obj.em_remark = dr["em_remark"].ToString();
  677.             obj.em_bookerid = ((dr["em_bookerid"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["em_bookerid"]);
  678.             obj.em_registertime = ((dr["em_registertime"]) == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dr["em_registertime"]);
  679.             obj.em_photo = dr["em_photo"].ToString();
  680.             return obj;
  681.         }
  683.         /// <summary>
  684.         /// 根据ID,返回一个employee实体对象
  685.         /// </summary>
  686.         /// <param name="em_id">em_id</param>
  687.         /// <returns>employee实体对象</returns>
  688.         public employee Select(int em_id)
  689.         {
  690.             return this.Select(em_id, false, false);
  691.         }
  692.         /// <summary>
  693.         /// 根据ID,返回一个employee实体对象
  694.         /// </summary>
  695.         /// <param name="em_id">em_id</param>
  696.         /// <param name="bParentTable">将employee对象设置与父表关联</param>
  697.         /// <param name="bChildrenTable">将employee对象设置与子表关联</param>
  698.         /// <returns>employee实体对象</returns>
  699.         public employee Select(int em_id, bool bParentTable, bool bChildrenTable)
  700.         {
  701.             employee obj = null;
  702.             SqlParameter[] param ={
  703. new SqlParameter("@em_id",SqlDbType.Int)
  704. };
  705.             param[0].Value = em_id;
  706.             string sqlCommand = "employeeSelect";
  707.             using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param))
  708.             {
  709.                 while (dr.Read())
  710.                 {
  711.                     obj = this.Select(dr);
  712.                 }
  713.             }
  714.             this.Select(obj, bParentTable, bChildrenTable);
  715.             return obj;
  716.         }
  717.         /// <summary>
  718.         /// 将employee实体对象设置与父表和子表关联
  719.         /// </summary>
  720.         /// <param name="obj">employee实体对象</param>
  721.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  722.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  723.         public void Select(employee obj, bool bParentTable, bool bChildrenTable)
  724.         {
  725.             //关联的主表
  726.             if (bParentTable)
  727.             {
  728.                 obj.nation = nationBLL.Select(obj.em_na_id);
  729.                 obj.visage = visageBLL.Select(obj.em_v_id);
  730.                 obj.province = provinceBLL.Select(obj.em_p_id);
  731.                 obj.native = nativeBLL.Select(obj.em_n_id);
  732.                 obj.learn = learnBLL.Select(obj.em_l_id);
  733.                 obj.department = departmentBLL.Select(obj.em_dept_id);
  734.             }
  735.             //关联的子表集合
  736.             if (bChildrenTable)
  737.             {
  738.                 obj.users = usersBLL.Select("u_em_id=" + obj.em_id.ToString());
  739.                 foreach (users item in obj.users)
  740.                 {
  741.                     item.employee = obj;
  742.                 }
  743.             }
  744.         }
  745.         #endregion
  747.         #region 父表
  748.         /// <summary>
  749.         /// 设置实体对象(employee)的父表对象
  750.         /// </summary>
  751.         /// <param name="employee">实体对象</param>
  752.         public void nation(employee employee)
  753.         {
  754.             employee.nation = nationBLL.Select(employee.em_na_id);
  755.         }
  756.         /// <summary>
  757.         /// 设置实体对象(employee)的父表对象
  758.         /// </summary>
  759.         /// <param name="employee">实体对象</param>
  760.         public void visage(employee employee)
  761.         {
  762.             employee.visage = visageBLL.Select(employee.em_v_id);
  763.         }
  764.         /// <summary>
  765.         /// 设置实体对象(employee)的父表对象
  766.         /// </summary>
  767.         /// <param name="employee">实体对象</param>
  768.         public void province(employee employee)
  769.         {
  770.             employee.province = provinceBLL.Select(employee.em_p_id);
  771.         }
  772.         /// <summary>
  773.         /// 设置实体对象(employee)的父表对象
  774.         /// </summary>
  775.         /// <param name="employee">实体对象</param>
  776.         public void native(employee employee)
  777.         {
  778.             employee.native = nativeBLL.Select(employee.em_n_id);
  779.         }
  780.         /// <summary>
  781.         /// 设置实体对象(employee)的父表对象
  782.         /// </summary>
  783.         /// <param name="employee">实体对象</param>
  784.         public void learn(employee employee)
  785.         {
  786.             employee.learn = learnBLL.Select(employee.em_l_id);
  787.         }
  788.         /// <summary>
  789.         /// 设置实体对象(employee)的父表对象
  790.         /// </summary>
  791.         /// <param name="employee">实体对象</param>
  792.         public void department(employee employee)
  793.         {
  794.             employee.department = departmentBLL.Select(employee.em_dept_id);
  795.         }
  796.         #endregion
  798.         #region 子表
  799.         /// <summary>
  800.         /// 设置实体对象(employee)的子表对象
  801.         /// </summary>
  802.         /// <param name="employee">实体对象</param>
  803.         public void users(employee employee)
  804.         {
  805.             employee.users = usersBLL.Select("u_em_id=" + employee.em_id.ToString());
  806.         }
  807.         #endregion
  809.         #region 查询
  810.         /// <summary>
  811.         /// 得到数据表employee所有记录
  812.         /// </summary>
  813.         /// <returns>结果集</returns>
  814.         public IList<employee> Select()
  815.         {
  816.             return this.Select(false, false);
  817.         }
  818.         /// <summary>
  819.         /// 得到数据表employee所有记录
  820.         /// </summary>
  821.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  822.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  823.         /// <returns>结果集</returns>
  824.         public IList<employee> Select(bool bParentTable, bool bChildrenTable)
  825.         {
  826.             IList<employee> list = new List<employee>();
  827.             string sqlCommand = "employeeSelectAll";
  828.             using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand))
  829.             {
  830.                 while (dr.Read())
  831.                 {
  832.                     list.Add(this.Select(dr));
  833.                 }
  834.             }
  835.             foreach (employee obj in list)
  836.             {
  837.                 this.Select(obj, bParentTable, bChildrenTable);
  838.             }
  839.             return list;
  840.         }
  841.         /// <summary>
  842.         /// 得到数据表employee满足查询条件的记录
  843.         /// </summary>
  844.         /// <param name="where">查询条件</param>
  845.         /// <returns>结果集</returns>
  846.         public IList<employee> Select(string where)
  847.         {
  848.             return this.Select(where, false, false);
  849.         }
  850.         /// <summary>
  851.         /// 得到数据表employee满足查询条件的记录
  852.         /// </summary>
  853.         /// <param name="where">查询条件</param>
  854.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  855.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  856.         /// <returns>结果集</returns>
  857.         public IList<employee> Select(string where, bool bParentTable, bool bChildrenTable)
  858.         {
  859.             IList<employee> list = new List<employee>();
  860.             SqlParameter[] param ={
  861. new SqlParameter("@where",SqlDbType.VarChar,8000)
  862. };
  863.             param[0].Value = where;
  864.             string sqlCommand = "employeeSelectByParams";
  865.             using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param))
  866.             {
  867.                 while (dr.Read())
  868.                 {
  869.                     list.Add(this.Select(dr));
  870.                 }
  871.             }
  872.             foreach (employee obj in list)
  873.             {
  874.                 this.Select(obj, bParentTable, bChildrenTable);
  875.             }
  876.             return list;
  877.         }
  878.         /// <summary>
  879.         /// 得到数据表ArticalInfo满足外键字段查询条件的记录
  880.         /// </summary>
  881.         /// <param name="foreignFieldName">外键字段名称</param>
  882.         /// <param name="foreignFieldValue">外键字段值</param>
  883.         /// <returns>结果集</returns>
  884.         public IList<employee> Select(string foreignFieldName, int foreignFieldValue)
  885.         {
  886.             return this.Select(foreignFieldName, foreignFieldValue, false, false);
  887.         }
  888.         /// <summary>
  889.         /// 得到数据表ArticalInfo满足外键字段查询条件的记录
  890.         /// </summary>
  891.         /// <param name="foreignFieldName">外键字段名称</param>
  892.         /// <param name="foreignFieldValue">外键字段值</param>
  893.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  894.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  895.         /// <returns>结果集</returns>
  896.         public IList<employee> Select(string foreignFieldName, int foreignFieldValue, bool bParentTable, bool bChildrenTable)
  897.         {
  898.             return this.Select(string.Format("{0}='{1}'", foreignFieldName, foreignFieldValue), bParentTable, bChildrenTable);
  899.         }
  900.         /// <summary>
  901.         /// 得到数据表employee满足查询条件的记录数
  902.         /// </summary>
  903.         /// <param name="where">查询条件</param>
  904.         /// <param name="recordCount">记录数</param>
  905.         public void Select(string where, out int recordCount)
  906.         {
  907.             string sqlCommand = "employeeCountByWhere";
  908.             SqlParameter[] param ={
  909. new SqlParameter("@where",SqlDbType.VarChar,8000),
  910. new SqlParameter("@recordCount",SqlDbType.Int)
  911. };
  912.             param[0].Value = where;
  913.             param[1].Direction = ParameterDirection.Output;
  914.             SqlHelper.ExecuteNonQuery(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param);
  915.             recordCount = Convert.ToInt32(param[1].Value);
  916.         }
  917.         /// <summary>
  918.         /// 得到数据表employee满足查询条件的分页记录
  919.         /// </summary>
  920.         /// <param name="pageSize">每页显示记录数</param>
  921.         /// <param name="pageIndex">当前显示第几页</param>
  922.         /// <param name="where">查询条件</param>
  923.         /// <returns>结果集</returns>
  924.         public IList<employee> Select(int pageSize, int pageIndex, string where)
  925.         {
  926.             return this.Select(pageSize, pageIndex, where, false, false);
  927.         }
  928.         /// <summary>
  929.         /// 得到数据表employee满足查询条件的分页记录
  930.         /// </summary>
  931.         /// <param name="pageSize">每页显示记录数</param>
  932.         /// <param name="pageIndex">当前显示第几页</param>
  933.         /// <param name="where">查询条件</param>
  934.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  935.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  936.         /// <returns>结果集</returns>
  937.         public IList<employee> Select(int pageSize, int pageIndex, string where, bool bParentTable, bool bChildrenTable)
  938.         {
  939.             IList<employee> list = new List<employee>();
  940.             string sqlCommand = "employeeSelectByPagerParams";
  941.             SqlParameter[] param ={
  942. new SqlParameter("@pageSize",SqlDbType.Int),
  943. new SqlParameter("@pageIndex",SqlDbType.Int),
  944. new SqlParameter("@where",SqlDbType.VarChar,8000)
  945. };
  946.             param[0].Value = pageSize;
  947.             param[1].Value = pageIndex;
  948.             param[2].Value = where;
  949.             using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param))
  950.             {
  951.                 while (dr.Read())
  952.                 {
  953.                     list.Add(this.Select(dr));
  954.                 }
  955.             }
  956.             foreach (employee obj in list)
  957.             {
  958.                 this.Select(obj, bParentTable, bChildrenTable);
  959.             }
  960.             return list;
  961.         }
  962.         /// <summary>
  963.         /// 得到数据表employee满足查询条件记录
  964.         /// </summary>
  965.         /// <param name="commandType">命令类型</param>
  966.         /// <param name="sqlCommand">SQL命令</param>
  967.         /// <param name="SqlParameter[]">命令参数数组</param>
  968.         /// <returns>结果集</returns>
  969.         public IList<employee> Select(CommandType commandType, string sqlCommand, params SqlParameter[] param)
  970.         {
  971.             return this.Select(false, false, commandType, sqlCommand, param);
  972.         }
  973.         /// <summary>
  974.         /// 得到数据表employee满足查询条件记录
  975.         /// </summary>
  976.         /// <param name="bParentTable">是/否设置与父表对象关联</param>
  977.         /// <param name="bChildrenTable">是/否设置与子表对象关联</param>
  978.         /// <param name="commandType">命令类型</param>
  979.         /// <param name="sqlCommand">SQL命令</param>
  980.         /// <param name="SqlParameter[]">命令参数数组</param>
  981.         /// <returns>结果集</returns>
  982.         public IList<employee> Select(bool bParentTable, bool bChildrenTable, CommandType commandType, string sqlCommand, params SqlParameter[] param)
  983.         {
  984.             IList<employee> list = new List<employee>();
  985.             using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, commandType, sqlCommand, param))
  986.             {
  987.                 while (dr.Read())
  988.                 {
  989.                     list.Add(this.Select(dr));
  990.                 }
  991.             }
  992.             foreach (employee obj in list)
  993.             {
  994.                 this.Select(obj, bParentTable, bChildrenTable);
  995.             }
  996.             return list;
  997.         }
  998.         /// <summary>
  999.         /// 根据主键检测是否存在该条记录
  1000.         /// </summary>
  1001.         /// <param name="em_id">em_id</param>
  1002.         /// <returns>存在/不存在</returns>
  1003.         public bool Exists(int em_id)
  1004.         {
  1005.             SqlParameter[] param ={
  1006.                                  new SqlParameter("@em_id",SqlDbType.Int)
  1007.                                  };
  1008.             param[0].Value = em_id;
  1009.             string sqlCommand = "employeeIsExist";
  1010.             int a = Convert.ToInt32(SqlHelper.ExecuteScalar(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param));
  1011.             if (a > 0)
  1012.             {
  1013.                 return true;
  1014.             }
  1015.             else
  1016.             {
  1017.                 return false;
  1018.             }
  1019.         }
  1020.         #endregion
  1022.         #endregion
  1023.     }
  1024. }