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

源码开发语言/平台
当前位置：首页 > 源码/资料 > Windows编程 > .net编程 > 查看源码
MrBaseInf.cs
资源名称：ASP[1].NET.rar　[点击查看]
上传用户：autodoor
上传日期：2022-08-04
资源大小：9973k
文件大小：42k
源码类别：

.net编程

开发平台：

Others

MrBaseInf.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Data.SqlClient;
  6. using qminoa.Common.Data;
  8. namespace qminoa.DA
  9. {
  10. public class MrBaseInf :IDisposable
  11. {
  12. private string conStr ;
  13. private SqlConnection con ;
  14. private SqlDataAdapter commandAdp ;
  16. private string paramChg(string str)
  17. {
  18. str = "@"+str;
  19. return str;
  20. }
  22. public DataSet GetEmpConData_By_ConID(int conID)
  23. {
  24. SqlCommand command = new SqlCommand();
  25. command.CommandText = "GetEmpConInfByConID";
  26. command.CommandType = CommandType.StoredProcedure;
  27. command.Connection = con;
  29. SqlParameter param = new SqlParameter(paramChg(EmpConData.CONID_FIELD),SqlDbType.Int);
  30. param.Value = conID;
  31. command.Parameters.Add(param);
  33. commandAdp.SelectCommand = command;
  34. DataSet data = new DataSet();
  35. try
  36. {
  37. commandAdp.Fill(data);
  38. }
  39. catch(Exception ex)
  40. {
  41. throw new ApplicationException(ex.ToString());
  42. }
  43. return data;
  44. }
  46. public bool UpdateMrContact(EmpConData empData)
  47. {
  48. SqlCommand command = new SqlCommand();
  49. command.CommandText = "UpdateMrContact";
  50. command.CommandType = CommandType.StoredProcedure;
  51. command.Connection = con;
  53. command.Parameters.Add(paramChg(EmpConData.CONID_FIELD),SqlDbType.Int);
  54. command.Parameters.Add(paramChg(EmpConData.CATETORY_FIELD),SqlDbType.VarChar);
  55. command.Parameters.Add(paramChg(EmpConData.FDATE_FIELD),SqlDbType.DateTime);
  56. command.Parameters.Add(paramChg(EmpConData.TDATE_FIELD),SqlDbType.DateTime);
  57. command.Parameters.Add(paramChg(EmpConData.POSILEVL_FIELD),SqlDbType.VarChar);
  58. command.Parameters.Add(paramChg(EmpConData.SALALEVL_FIELD),SqlDbType.VarChar);
  59. command.Parameters.Add(paramChg(EmpConData.ANNSALA_FIELD),SqlDbType.VarChar);
  60. command.Parameters.Add(paramChg(EmpConData.STATUS_FIELD),SqlDbType.VarChar);
  61. command.Parameters.Add(paramChg(EmpConData.CONNOTE_FIELD),SqlDbType.Text);
  62. command.Parameters[paramChg(EmpConData.CONID_FIELD)].SourceColumn = EmpConData.CONID_FIELD;
  63. command.Parameters[paramChg(EmpConData.CATETORY_FIELD)].SourceColumn = EmpConData.CATETORY_FIELD;
  64. command.Parameters[paramChg(EmpConData.FDATE_FIELD)].SourceColumn = EmpConData.FDATE_FIELD;
  65. command.Parameters[paramChg(EmpConData.TDATE_FIELD)].SourceColumn = EmpConData.TDATE_FIELD;
  66. command.Parameters[paramChg(EmpConData.POSILEVL_FIELD)].SourceColumn = EmpConData.POSILEVL_FIELD;
  67. command.Parameters[paramChg(EmpConData.SALALEVL_FIELD)].SourceColumn = EmpConData.SALALEVL_FIELD;
  68. command.Parameters[paramChg(EmpConData.ANNSALA_FIELD)].SourceColumn = EmpConData.ANNSALA_FIELD;
  69. command.Parameters[paramChg(EmpConData.STATUS_FIELD)].SourceColumn = EmpConData.STATUS_FIELD;
  70. command.Parameters[paramChg(EmpConData.CONNOTE_FIELD)].SourceColumn = EmpConData.CONNOTE_FIELD;
  72. commandAdp.UpdateCommand = command;
  73. commandAdp.Update(empData,EmpConData.EMPCONTACT_TABLE_NAME);
  75. if(empData.HasErrors)
  76. {
  77. empData.Tables[EmpBaseData.EMP_TABLE_NAME].GetErrors()[0].ClearErrors();
  78. return false;
  79. }
  80. else
  81. {
  82. empData.AcceptChanges();
  83. return true;
  84. }
  85. }
  87. public bool InsertMrContact(EmpConData empData)
  88. {
  89. SqlCommand command = new SqlCommand();
  90. command.CommandText = "InsertMrContact";
  91. command.CommandType = CommandType.StoredProcedure;
  92. command.Connection = con;
  94. command.Parameters.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
  95. command.Parameters.Add(paramChg(EmpConData.CATETORY_FIELD),SqlDbType.VarChar);
  96. command.Parameters.Add(paramChg(EmpConData.FDATE_FIELD),SqlDbType.DateTime);
  97. command.Parameters.Add(paramChg(EmpConData.TDATE_FIELD),SqlDbType.DateTime);
  98. command.Parameters.Add(paramChg(EmpConData.POSILEVL_FIELD),SqlDbType.VarChar);
  99. command.Parameters.Add(paramChg(EmpConData.SALALEVL_FIELD),SqlDbType.VarChar);
  100. command.Parameters.Add(paramChg(EmpConData.ANNSALA_FIELD),SqlDbType.VarChar);
  101. command.Parameters.Add(paramChg(EmpConData.STATUS_FIELD),SqlDbType.VarChar);
  102. command.Parameters.Add(paramChg(EmpConData.CONNOTE_FIELD),SqlDbType.Text);
  103. command.Parameters[paramChg(EmpBaseData.EMPID_FIELD)].SourceColumn = EmpBaseData.EMPID_FIELD;
  104. command.Parameters[paramChg(EmpConData.CATETORY_FIELD)].SourceColumn = EmpConData.CATETORY_FIELD;
  105. command.Parameters[paramChg(EmpConData.FDATE_FIELD)].SourceColumn = EmpConData.FDATE_FIELD;
  106. command.Parameters[paramChg(EmpConData.TDATE_FIELD)].SourceColumn = EmpConData.TDATE_FIELD;
  107. command.Parameters[paramChg(EmpConData.POSILEVL_FIELD)].SourceColumn = EmpConData.POSILEVL_FIELD;
  108. command.Parameters[paramChg(EmpConData.SALALEVL_FIELD)].SourceColumn = EmpConData.SALALEVL_FIELD;
  109. command.Parameters[paramChg(EmpConData.ANNSALA_FIELD)].SourceColumn = EmpConData.ANNSALA_FIELD;
  110. command.Parameters[paramChg(EmpConData.STATUS_FIELD)].SourceColumn = EmpConData.STATUS_FIELD;
  111. command.Parameters[paramChg(EmpConData.CONNOTE_FIELD)].SourceColumn = EmpConData.CONNOTE_FIELD;
  113. commandAdp.InsertCommand = command;
  115. commandAdp.Update(empData,EmpConData.EMPCONTACT_TABLE_NAME);
  117. if(empData.HasErrors)
  118. {
  119. empData.Tables[EmpBaseData.EMP_TABLE_NAME].GetErrors()[0].ClearErrors();
  120. return false;
  121. }
  122. else
  123. {
  124. empData.AcceptChanges();
  125. return true;
  126. }
  127. }
  129. public bool DeleteMrContact(int conID)
  130. {
  131. SqlCommand command = new SqlCommand();
  132. command.CommandText = "DeleteMrContact";
  133. command.CommandType = CommandType.StoredProcedure;
  134. command.Connection = con;
  136. SqlParameter param = new SqlParameter(paramChg(EmpConData.CONID_FIELD),SqlDbType.Int);
  137. param.Value = conID;
  138. command.Parameters.Add(param);
  140. con.Open();
  141. int result = command.ExecuteNonQuery();
  142. con.Close();
  143. if(result>0)
  144. {
  145. return true;
  146. }
  147. else
  148. {
  149. return false;
  150. }
  152. }
  154. public DataSet GetEmpConData(int empID)
  155. {
  156. SqlCommand command = new SqlCommand();
  157. command.CommandText = "GetEmpConInf";
  158. command.CommandType = CommandType.StoredProcedure;
  159. command.Connection = con;
  161. SqlParameter param = new SqlParameter(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
  162. param.Value = empID;
  163. command.Parameters.Add(param);
  165. commandAdp.SelectCommand = command;
  166. DataSet data = new DataSet();
  167. try
  168. {
  169. commandAdp.Fill(data);
  170. }
  171. catch(Exception ex)
  172. {
  173. throw new ApplicationException(ex.ToString());
  174. }
  175. return data;
  177. }
  179. public bool InsertMrArchive(EmpArcData empData)
  180. {
  181. SqlCommand command = new SqlCommand();
  182. command.CommandText = "InsertMrArchive";
  183. command.CommandType = CommandType.StoredProcedure;
  184. command.Connection = con;
  186. command.Parameters.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
  187. command.Parameters.Add(paramChg(EmpArcData.CATETORY_FIELD),SqlDbType.VarChar);
  188. command.Parameters.Add(paramChg(EmpArcData.FDATE_FIELD),SqlDbType.DateTime);
  189. command.Parameters.Add(paramChg(EmpArcData.TDATE_FIELD),SqlDbType.DateTime);
  190. command.Parameters.Add(paramChg(EmpArcData.BRANAME_FIELD),SqlDbType.VarChar);
  191. command.Parameters.Add(paramChg(EmpArcData.DEPNAME_FIELD),SqlDbType.VarChar);
  192. command.Parameters.Add(paramChg(EmpArcData.POSITION_FIELD),SqlDbType.VarChar);
  193. command.Parameters.Add(paramChg(EmpArcData.REASON_FIELD),SqlDbType.Text);
  194. command.Parameters.Add(paramChg(EmpArcData.ARCNOTE_FIELD),SqlDbType.Text);
  196. command.Parameters[paramChg(EmpBaseData.EMPID_FIELD)].SourceColumn = EmpBaseData.EMPID_FIELD;
  197. command.Parameters[paramChg(EmpArcData.CATETORY_FIELD)].SourceColumn = EmpArcData.CATETORY_FIELD;
  198. command.Parameters[paramChg(EmpArcData.FDATE_FIELD)].SourceColumn = EmpArcData.FDATE_FIELD;
  199. command.Parameters[paramChg(EmpArcData.TDATE_FIELD)].SourceColumn = EmpArcData.TDATE_FIELD;
  200. command.Parameters[paramChg(EmpArcData.BRANAME_FIELD)].SourceColumn = EmpArcData.BRANAME_FIELD;
  201. command.Parameters[paramChg(EmpArcData.DEPNAME_FIELD)].SourceColumn = EmpArcData.DEPNAME_FIELD;
  202. command.Parameters[paramChg(EmpArcData.POSITION_FIELD)].SourceColumn = EmpArcData.POSITION_FIELD;
  203. command.Parameters[paramChg(EmpArcData.REASON_FIELD)].SourceColumn = EmpArcData.REASON_FIELD;
  204. command.Parameters[paramChg(EmpArcData.ARCNOTE_FIELD)].SourceColumn = EmpArcData.ARCNOTE_FIELD;
  206. commandAdp.InsertCommand = command;
  208. commandAdp.Update(empData,EmpArcData.EMPARCHIVE_TABLE_NAME);
  210. if(empData.HasErrors)
  211. {
  212. empData.Tables[EmpBaseData.EMP_TABLE_NAME].GetErrors()[0].ClearErrors();
  213. return false;
  214. }
  215. else
  216. {
  217. empData.AcceptChanges();
  218. return true;
  219. }
  220. }
  222. public bool UpdateMrArchive(EmpArcData empData)
  223. {
  224. SqlCommand command = new SqlCommand();
  225. command.CommandText = "UpdateMrArchive";
  226. command.CommandType = CommandType.StoredProcedure;
  227. command.Connection = con;
  229. command.Parameters.Add(paramChg(EmpArcData.ARCID_FIELD),SqlDbType.Int);
  230. command.Parameters.Add(paramChg(EmpArcData.CATETORY_FIELD),SqlDbType.VarChar)  ;
  231. command.Parameters.Add(paramChg(EmpArcData.FDATE_FIELD),SqlDbType.DateTime);
  232. command.Parameters.Add(paramChg(EmpArcData.TDATE_FIELD),SqlDbType.DateTime);
  233. command.Parameters.Add(paramChg(EmpArcData.BRANAME_FIELD),SqlDbType.VarChar);
  234. command.Parameters.Add(paramChg(EmpArcData.DEPNAME_FIELD),SqlDbType.VarChar);
  235. command.Parameters.Add(paramChg(EmpArcData.POSITION_FIELD),SqlDbType.VarChar);
  236. command.Parameters.Add(paramChg(EmpArcData.REASON_FIELD),SqlDbType.Text);
  237. command.Parameters.Add(paramChg(EmpArcData.ARCNOTE_FIELD),SqlDbType.Text);
  238. //
  239. //
  240. //
  241. command.Parameters[paramChg(EmpArcData.ARCID_FIELD)].SourceColumn = EmpArcData.ARCID_FIELD;
  242. command.Parameters[paramChg(EmpArcData.CATETORY_FIELD)].SourceColumn = EmpArcData.CATETORY_FIELD;
  243. command.Parameters[paramChg(EmpArcData.FDATE_FIELD)].SourceColumn = EmpArcData.FDATE_FIELD;
  244. command.Parameters[paramChg(EmpArcData.TDATE_FIELD)].SourceColumn = EmpArcData.TDATE_FIELD;
  245. command.Parameters[paramChg(EmpArcData.BRANAME_FIELD)].SourceColumn = EmpArcData.BRANAME_FIELD;
  246. command.Parameters[paramChg(EmpArcData.DEPNAME_FIELD)].SourceColumn = EmpArcData.DEPNAME_FIELD;
  247. command.Parameters[paramChg(EmpArcData.POSITION_FIELD)].SourceColumn = EmpArcData.POSITION_FIELD;
  248. command.Parameters[paramChg(EmpArcData.REASON_FIELD)].SourceColumn = EmpArcData.REASON_FIELD;
  249. command.Parameters[paramChg(EmpArcData.ARCNOTE_FIELD)].SourceColumn = EmpArcData.ARCNOTE_FIELD;
  251. commandAdp.UpdateCommand = command;
  253. commandAdp.Update(empData,EmpArcData.EMPARCHIVE_TABLE_NAME);
  255. if(empData.HasErrors)
  256. {
  257. empData.Tables[EmpBaseData.EMP_TABLE_NAME].GetErrors()[0].ClearErrors();
  258. return false;
  259. }
  260. else
  261. {
  262. empData.AcceptChanges();
  263. return true;
  264. }
  265. }
  267. public DataSet GetEmpArcData_By_ArcID(int arcID)
  268. {
  269. SqlCommand command = new SqlCommand();
  270. command.CommandText = "GetEmpArcInfByArcID";
  271. command.CommandType = CommandType.StoredProcedure;
  272. command.Connection = con;
  274. SqlParameter param = new SqlParameter(paramChg(EmpArcData.ARCID_FIELD),SqlDbType.Int);
  275. param.Value = arcID;
  276. command.Parameters.Add(param);
  278. commandAdp.SelectCommand = command;
  279. DataSet data = new DataSet();
  280. try
  281. {
  282. commandAdp.Fill(data);
  283. }
  284. catch(Exception ex)
  285. {
  286. throw new ApplicationException(ex.ToString());
  287. }
  288. return data;
  289. }
  291. public bool DeleteMrArchive(int arcID)
  292. {
  293. SqlCommand command = new SqlCommand();
  294. command.CommandText = "DeleteMrArchive";
  295. command.CommandType = CommandType.StoredProcedure;
  296. command.Connection = con;
  298. SqlParameter param = new SqlParameter(paramChg(EmpArcData.ARCID_FIELD),SqlDbType.Int);
  299. param.Value = arcID;
  300. command.Parameters.Add(param);
  302. con.Open();
  303. int result = command.ExecuteNonQuery();
  304. con.Close();
  305. if(result>0)
  306. {
  307. return true;
  308. }
  309. else
  310. {
  311. return false;
  312. }
  313. }
  315. public bool UpdateMrVita(EmpVisaData empData)
  316. {
  317. SqlCommand command = new SqlCommand();
  318. command.CommandText = "UpdateMrVita";
  319. command.CommandType = CommandType.StoredProcedure;
  320. command.Connection = con;
  322. command.Parameters.Add(paramChg(EmpVisaData.VISAID_FIELD),SqlDbType.Int);
  323. command.Parameters.Add(paramChg(EmpVisaData.FDATE_FIELD),SqlDbType.DateTime);
  324. command.Parameters.Add(paramChg(EmpVisaData.TDATE_FIELD),SqlDbType.DateTime);
  325. command.Parameters.Add(paramChg(EmpVisaData.COMMPANY_FIELD),SqlDbType.VarChar);
  326. command.Parameters.Add(paramChg(EmpVisaData.DEPNAME_FIELD),SqlDbType.VarChar);
  327. command.Parameters.Add(paramChg(EmpVisaData.POSITION_FIELD),SqlDbType.VarChar);
  328. command.Parameters.Add(paramChg(EmpVisaData.VISANOTE_FIELD),SqlDbType.Text);
  329. //
  330. //
  331. //
  332. command.Parameters[paramChg(EmpVisaData.VISAID_FIELD)].SourceColumn = EmpVisaData.VISAID_FIELD;
  333. command.Parameters[paramChg(EmpVisaData.FDATE_FIELD)].SourceColumn = EmpVisaData.FDATE_FIELD;
  334. command.Parameters[paramChg(EmpVisaData.TDATE_FIELD)].SourceColumn = EmpVisaData.TDATE_FIELD;
  335. command.Parameters[paramChg(EmpVisaData.COMMPANY_FIELD)].SourceColumn = EmpVisaData.COMMPANY_FIELD;
  336. command.Parameters[paramChg(EmpVisaData.DEPNAME_FIELD)].SourceColumn = EmpVisaData.DEPNAME_FIELD;
  337. command.Parameters[paramChg(EmpVisaData.POSITION_FIELD)].SourceColumn = EmpVisaData.POSITION_FIELD;
  338. command.Parameters[paramChg(EmpVisaData.VISANOTE_FIELD)].SourceColumn = EmpVisaData.VISANOTE_FIELD;
  340. commandAdp.UpdateCommand = command;
  342. commandAdp.Update(empData,EmpVisaData.EMPVISA_TABLE_NAME);
  344. if(empData.HasErrors)
  345. {
  346. empData.Tables[EmpBaseData.EMP_TABLE_NAME].GetErrors()[0].ClearErrors();
  347. return false;
  348. }
  349. else
  350. {
  351. empData.AcceptChanges();
  352. return true;
  353. }
  356. }
  358. public bool InsertMrVita(EmpVisaData empData)
  359. {
  360. SqlCommand command = new SqlCommand();
  361. command.CommandText = "InsertMrVita";
  362. command.CommandType = CommandType.StoredProcedure;
  363. command.Connection = con;
  365. command.Parameters.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
  366. command.Parameters.Add(paramChg(EmpVisaData.FDATE_FIELD),SqlDbType.DateTime);
  367. command.Parameters.Add(paramChg(EmpVisaData.TDATE_FIELD),SqlDbType.DateTime);
  368. command.Parameters.Add(paramChg(EmpVisaData.COMMPANY_FIELD),SqlDbType.VarChar);
  369. command.Parameters.Add(paramChg(EmpVisaData.DEPNAME_FIELD),SqlDbType.VarChar);
  370. command.Parameters.Add(paramChg(EmpVisaData.POSITION_FIELD),SqlDbType.VarChar);
  371. command.Parameters.Add(paramChg(EmpVisaData.VISANOTE_FIELD),SqlDbType.Text);
  373. command.Parameters[paramChg(EmpBaseData.EMPID_FIELD)].SourceColumn = EmpBaseData.EMPID_FIELD;
  374. command.Parameters[paramChg(EmpVisaData.FDATE_FIELD)].SourceColumn = EmpVisaData.FDATE_FIELD;
  375. command.Parameters[paramChg(EmpVisaData.TDATE_FIELD)].SourceColumn = EmpVisaData.TDATE_FIELD;
  376. command.Parameters[paramChg(EmpVisaData.COMMPANY_FIELD)].SourceColumn = EmpVisaData.COMMPANY_FIELD;
  377. command.Parameters[paramChg(EmpVisaData.DEPNAME_FIELD)].SourceColumn = EmpVisaData.DEPNAME_FIELD;
  378. command.Parameters[paramChg(EmpVisaData.POSITION_FIELD)].SourceColumn = EmpVisaData.POSITION_FIELD;
  379. command.Parameters[paramChg(EmpVisaData.VISANOTE_FIELD)].SourceColumn = EmpVisaData.VISANOTE_FIELD;
  381. commandAdp.InsertCommand = command;
  383. commandAdp.Update(empData,EmpVisaData.EMPVISA_TABLE_NAME);
  385. if(empData.HasErrors)
  386. {
  387. empData.Tables[EmpBaseData.EMP_TABLE_NAME].GetErrors()[0].ClearErrors();
  388. return false;
  389. }
  390. else
  391. {
  392. empData.AcceptChanges();
  393. return true;
  394. }
  395. }
  397. public bool DeleteMrVita(int visaID)
  398. {
  399. SqlCommand command = new SqlCommand();
  401. command.CommandText = "DeleteMrVita";
  402. command.CommandType = CommandType.StoredProcedure;
  403. command.Connection = con;
  405. SqlParameter param = new SqlParameter(paramChg(EmpVisaData.VISAID_FIELD),SqlDbType.Int);
  406. param.Value = visaID;
  407. command.Parameters.Add(param);
  408. int result =0;
  409. try
  410. {
  411. con.Open();
  412. result = command.ExecuteNonQuery();
  413. con.Close();
  414. }
  415. catch(Exception ex)
  416. {
  417. throw new ApplicationException(ex.ToString());
  418. }
  419. return (result>0)?true:false;
  420. }
  422. public DataSet GetEmpArcData(int empID)
  423. {
  424. SqlCommand command = new SqlCommand();
  425. command.CommandText = "GetEmpArcInf";
  426. command.CommandType = CommandType.StoredProcedure;
  427. command.Connection = con;
  429. SqlParameter param = new SqlParameter(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
  430. param.Value = empID;
  431. command.Parameters.Add(param);
  433. commandAdp.SelectCommand = command;
  434. DataSet data = new DataSet();
  435. try
  436. {
  437. commandAdp.Fill(data);
  438. }
  439. catch(Exception ex)
  440. {
  441. throw new ApplicationException(ex.ToString());
  442. }
  443. return data;
  444. }
  446. public bool UpdateEmpEduInf(EmpBaseData empData)
  447. {
  448. SqlCommand command = new SqlCommand();
  450. command.CommandText = "UpdateEmpEduInf";
  451. command.CommandType =  CommandType.StoredProcedure;
  452. command.Connection = con;
  454. command.Parameters.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
  456. command.Parameters.Add(paramChg(EmpBaseData.SCHOOL1_FIELD),SqlDbType.VarChar);
  457. command.Parameters.Add(paramChg(EmpBaseData.SPECIAL1_FIELD),SqlDbType.VarChar);
  458. command.Parameters.Add(paramChg(EmpBaseData.GERTIME1_FIELD),SqlDbType.DateTime);
  459. command.Parameters.Add(paramChg(EmpBaseData.EDUCAT1_FIELD),SqlDbType.VarChar);
  462. command.Parameters.Add(paramChg(EmpBaseData.SCHOOL2_FIELD),SqlDbType.VarChar);
  463. command.Parameters.Add(paramChg(EmpBaseData.SPECIAL2_FIELD),SqlDbType.VarChar);
  464. command.Parameters.Add(paramChg(EmpBaseData.GERTIME2_FIELD),SqlDbType.DateTime);
  465. command.Parameters.Add(paramChg(EmpBaseData.EDUCAT2_FIELD),SqlDbType.VarChar);
  467. command.Parameters.Add(paramChg(EmpBaseData.QULI1_FIELD),SqlDbType.VarChar);
  468. command.Parameters.Add(paramChg(EmpBaseData.QULI2_FIELD),SqlDbType.VarChar);
  469. command.Parameters.Add(paramChg(EmpBaseData.QULI3_FIELD),SqlDbType.VarChar);
  470. command.Parameters.Add(paramChg(EmpBaseData.QULI4_FIELD),SqlDbType.VarChar);
  472. command.Parameters.Add(paramChg(EmpBaseData.EDUNOTE_FIELD),SqlDbType.Text);
  474. command.Parameters[paramChg(EmpBaseData.EMPID_FIELD)].SourceColumn = EmpBaseData.EMPID_FIELD;
  476. command.Parameters[paramChg(EmpBaseData.SCHOOL1_FIELD)].SourceColumn = EmpBaseData.SCHOOL1_FIELD;
  477. command.Parameters[paramChg(EmpBaseData.SPECIAL1_FIELD)].SourceColumn = EmpBaseData.SPECIAL1_FIELD;
  478. command.Parameters[paramChg(EmpBaseData.GERTIME1_FIELD)].SourceColumn = EmpBaseData.GERTIME1_FIELD;
  479. command.Parameters[paramChg(EmpBaseData.EDUCAT1_FIELD)].SourceColumn = EmpBaseData.EDUCAT1_FIELD;
  481. command.Parameters[paramChg(EmpBaseData.SCHOOL2_FIELD)].SourceColumn = EmpBaseData.SCHOOL2_FIELD;
  482. command.Parameters[paramChg(EmpBaseData.SPECIAL2_FIELD)].SourceColumn = EmpBaseData.SPECIAL2_FIELD;
  483. command.Parameters[paramChg(EmpBaseData.GERTIME2_FIELD)].SourceColumn = EmpBaseData.GERTIME2_FIELD;
  484. command.Parameters[paramChg(EmpBaseData.EDUCAT2_FIELD)].SourceColumn = EmpBaseData.EDUCAT2_FIELD;
  486. command.Parameters[paramChg(EmpBaseData.QULI1_FIELD)].SourceColumn = EmpBaseData.QULI1_FIELD;
  487. command.Parameters[paramChg(EmpBaseData.QULI2_FIELD)].SourceColumn = EmpBaseData.QULI2_FIELD;
  488. command.Parameters[paramChg(EmpBaseData.QULI3_FIELD)].SourceColumn = EmpBaseData.QULI3_FIELD;
  489. command.Parameters[paramChg(EmpBaseData.QULI4_FIELD)].SourceColumn = EmpBaseData.QULI4_FIELD;
  491. command.Parameters[paramChg(EmpBaseData.EDUNOTE_FIELD)].SourceColumn = EmpBaseData.EDUNOTE_FIELD;
  493. commandAdp.UpdateCommand = command;
  495. commandAdp.Update(empData,EmpBaseData.EMP_TABLE_NAME);
  497. if(empData.HasErrors)
  498. {
  499. empData.Tables[EmpBaseData.EMP_TABLE_NAME].GetErrors()[0].ClearErrors();
  500. return false;
  501. }
  502. else
  503. {
  504. empData.AcceptChanges();
  505. return true;
  506. }
  508. }
  510. public DataSet GetEmpVisaData_By_VisaID(int visaID)
  511. {
  512. SqlCommand command = new SqlCommand();
  513. command.CommandText = "GetEmpVisaInfByVisaID";
  514. command.CommandType = CommandType.StoredProcedure;
  515. command.Connection = con;
  517. SqlParameter param = new SqlParameter(paramChg(EmpVisaData.VISAID_FIELD),SqlDbType.Int);
  518. param.Value = visaID;
  519. command.Parameters.Add(param);
  521. commandAdp.SelectCommand = command;
  522. DataSet data = new DataSet();
  523. try
  524. {
  525. commandAdp.Fill(data);
  526. }
  527. catch(Exception ex)
  528. {
  529. throw new ApplicationException(ex.ToString());
  530. }
  531. return data;
  532. }
  534. public DataSet GetEmpVisaData(int empID)
  535. {
  536. SqlCommand command = new SqlCommand();
  538. command.CommandText = "GetEmpVisaInf";
  539. command.CommandType =  CommandType.StoredProcedure;
  540. command.Connection = con;
  542. SqlParameter param = new SqlParameter(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
  543. param.Value = empID;
  544. command.Parameters.Add(param);
  546. commandAdp.SelectCommand = command;
  547. DataSet data = new DataSet();
  548. try
  549. {
  550. commandAdp.Fill(data);
  551. }
  552. catch(Exception ex)
  553. {
  554. throw new ApplicationException(ex.ToString());
  555. }
  556. return data;
  557. }
  559. public bool StopEmpLogin(int empID,int allowLogin)
  560. {
  561. SqlCommand command = new SqlCommand();
  563. command.Connection = con;
  564. command.CommandText = "StopEmpLogin";
  565. command.CommandType = CommandType.StoredProcedure;
  567. SqlParameter param = new SqlParameter(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
  568. param.Value = empID;
  569. command.Parameters.Add(paramChg(EmpBaseData.ALLOWLOGIN_FIELD),SqlDbType.Bit);
  570. command.Parameters[paramChg(EmpBaseData.ALLOWLOGIN_FIELD)].Value = allowLogin;
  572. command.Parameters.Add(param);
  573. try
  574. {
  575. con.Open();
  576. command.ExecuteNonQuery();
  577. con.Close();
  578. }
  579. catch
  580. {
  581. return false;
  582. }
  583. return true;
  584. }
  586. public DataSet GetEmpDataStoped()
  587. {
  588. SqlCommand command = new SqlCommand();
  590. command.Connection = con;
  591. command.CommandText = "GetEmpInfStoped";
  592. command.CommandType = CommandType.StoredProcedure;
  594. commandAdp.SelectCommand = command ;
  596. DataSet data = new DataSet();
  597. try
  598. {
  599. commandAdp.Fill(data);
  600. }
  601. catch(Exception ex)
  602. {
  603. throw new ApplicationException(ex.ToString());
  604. }
  605. return data;
  606. }
  608. public DataSet GetEmpPicData(int empID)
  609. {
  610. SqlCommand command = new SqlCommand();
  612. command.CommandText = "GetEmpPic";
  613. command.CommandType = CommandType.StoredProcedure;
  614. command.Connection = con;
  616. command.Parameters.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
  617. command.Parameters[paramChg(EmpBaseData.EMPID_FIELD)].Value = empID;
  620. commandAdp.SelectCommand = command;
  622. DataSet data = new DataSet();
  623. try
  624. {
  625. commandAdp.Fill(data);
  626. }
  627. catch(Exception ex)
  628. {
  629. throw new ApplicationException(ex.ToString());
  630. }
  631. return data;
  632. }
  634. public void UpdateEmpPic(int empID,byte[] byteArray)
  635. {
  636. SqlCommand command = new SqlCommand();
  637. command.CommandText = "UpdateMrPhoto";
  638. command.CommandType = CommandType.StoredProcedure;
  639. command.Connection = con;
  641. SqlParameterCollection param = command.Parameters;
  643. param.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
  644. param.Add(paramChg(EmpBaseData.PHOTO_SIZE_FIELD),SqlDbType.Int);
  645. param.Add(paramChg(EmpBaseData.PHOTO_CONTENT_FIELD),SqlDbType.Image);
  647. param[paramChg(EmpBaseData.EMPID_FIELD)].Value = empID;
  648. if(byteArray != null)
  649. {
  650. param[paramChg(EmpBaseData.PHOTO_SIZE_FIELD)].Value = byteArray.Length;
  651. param[paramChg(EmpBaseData.PHOTO_CONTENT_FIELD)].Value = byteArray;
  652. }
  653. else
  654. {
  655. param[paramChg(EmpBaseData.PHOTO_SIZE_FIELD)].Value = DBNull.Value;
  656. param[paramChg(EmpBaseData.PHOTO_CONTENT_FIELD)].Value = DBNull.Value;
  657. }
  658. con.Open();
  659. command.ExecuteNonQuery();
  660. con.Close();
  662. }
  664. public DataSet GetEmpData_By_QueryStr(string branchID,string depID,string empName)
  665. {
  666. string queryStr = "select i.EmpID,i.LoginID,i.EmpName,i.Email,i.OfficeTel,i.OfficeFax,i.Mobile,i.PhotoSize,j.DepName,k.SimpleCode from mrBaseInf i,mrDepartment j,mrBranch k where i.AllowLogin = 1 and i.DepID = j.DepID and  k.BranchID = "+branchID ;
  668. if(empName!=string.Empty)
  669. {
  670. queryStr = queryStr + " and " ;
  671. queryStr = queryStr + " i.EmpName = '"+empName+"'";
  672. }
  673. if(depID!=string.Empty)
  674. {
  675. queryStr = queryStr + " and ";
  676. queryStr = queryStr + " i.DepID = "+depID;
  677. }
  678. else
  679. {
  680. queryStr = queryStr + " and ";
  681. queryStr = queryStr + " i.DepID in(select DepID from mrDepartment where BranchID = "+branchID+" )";
  682. }
  684. SqlCommand command = new SqlCommand();
  686. command.CommandText = queryStr;
  687. command.Connection = con;
  689. commandAdp.SelectCommand = command;
  691. DataSet data = new DataSet();
  692. try
  693. {
  694. commandAdp.Fill(data);
  695. }
  696. catch(Exception ex)
  697. {
  698. throw new ApplicationException(ex.ToString());
  699. }
  700. return data;
  701. }
  703. public DataSet GetEmpBaseData_By_EmpID(int empID)
  704. {
  705. SqlCommand command = new SqlCommand();
  707. command.CommandText = "GetEmpBaseInfByEmpID";
  708. command.CommandType = CommandType.StoredProcedure;
  709. command.Connection = con;
  711. SqlParameter param = new SqlParameter(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
  712. param.Value = empID;
  713. command.Parameters.Add(param);
  715. commandAdp.SelectCommand = command;
  717. DataSet data = new DataSet();
  718. try
  719. {
  720. commandAdp.Fill(data);
  721. }
  722. catch(Exception ex)
  723. {
  724. throw new ApplicationException(ex.ToString());
  725. }
  726. return data;
  727. }
  730. public int InsertMrBaseInf(EmpBaseData empBaseData)
  731. {
  732. SqlCommand command = new SqlCommand();
  734. command.CommandType = CommandType.StoredProcedure;
  735. command.Connection = con;
  736. command.CommandText = "InsertMrBaseInf";
  738. SqlParameterCollection param = command.Parameters;
  740. SqlParameter paramTmp = new SqlParameter("@Identify",SqlDbType.Int);
  741. paramTmp.Direction = ParameterDirection.ReturnValue;
  742. param.Add(paramTmp);
  744. param.Add(paramChg(DepData.DEPID_FIELD),SqlDbType.Int);
  745. param.Add(paramChg(EmpBaseData.EMPNAME_FIELD),SqlDbType.VarChar);
  746. param.Add(paramChg(EmpBaseData.LOGINID_FIELD),SqlDbType.VarChar);
  747. param.Add(paramChg(EmpBaseData.PASSWORD_FIELD),SqlDbType.VarChar);
  748. param.Add(paramChg(EmpBaseData.SEX_FIELD),SqlDbType.Bit);
  749. param.Add(paramChg(EmpBaseData.EMPCODE_FIELD),SqlDbType.VarChar);
  750. param.Add(paramChg(EmpBaseData.EMAIL_FIELD),SqlDbType.VarChar);
  751. param.Add(paramChg(EmpBaseData.OFFICETEL_FIELD),SqlDbType.VarChar);
  752. param.Add(paramChg(EmpBaseData.OFFICEFAX_FIELD),SqlDbType.VarChar);
  753. param.Add(paramChg(EmpBaseData.MOBILE_FIELD),SqlDbType.VarChar);
  754. param.Add(paramChg(EmpBaseData.POSITION_FIELD),SqlDbType.VarChar);
  756. param[paramChg(DepData.DEPID_FIELD)].SourceColumn = DepData.DEPID_FIELD;
  757. param[paramChg(EmpBaseData.EMPNAME_FIELD)].SourceColumn = EmpBaseData.EMPNAME_FIELD;
  758. param[paramChg(EmpBaseData.LOGINID_FIELD)].SourceColumn = EmpBaseData.LOGINID_FIELD;
  759. param[paramChg(EmpBaseData.PASSWORD_FIELD)].SourceColumn = EmpBaseData.PASSWORD_FIELD;
  760. param[paramChg(EmpBaseData.SEX_FIELD)].SourceColumn = EmpBaseData.SEX_FIELD;
  761. param[paramChg(EmpBaseData.EMPCODE_FIELD)].SourceColumn = EmpBaseData.EMPCODE_FIELD;
  762. param[paramChg(EmpBaseData.EMAIL_FIELD)].SourceColumn = EmpBaseData.EMAIL_FIELD;
  763. param[paramChg(EmpBaseData.OFFICETEL_FIELD)].SourceColumn = EmpBaseData.OFFICETEL_FIELD;
  764. param[paramChg(EmpBaseData.OFFICEFAX_FIELD)].SourceColumn = EmpBaseData.OFFICEFAX_FIELD;
  765. param[paramChg(EmpBaseData.MOBILE_FIELD)].SourceColumn = EmpBaseData.MOBILE_FIELD;
  766. param[paramChg(EmpBaseData.POSITION_FIELD)].SourceColumn = EmpBaseData.POSITION_FIELD;
  768. commandAdp.InsertCommand = command;
  769. int result = commandAdp.Update(empBaseData,EmpBaseData.EMP_TABLE_NAME);
  770. if(result>0)
  771. return (int)commandAdp.InsertCommand.Parameters["@Identify"].Value;
  772. else
  773. return 0;
  774. }
  776. public bool UpdateMrBaseInf(EmpBaseData empBaseData)
  777. {
  778. SqlCommand command = new SqlCommand();
  780. command.CommandType = CommandType.StoredProcedure;
  781. command.Connection = con;
  782. command.CommandText = "UpdateMrBaseInf";
  784. SqlParameterCollection param = command.Parameters;
  786. param.Add(paramChg(DepData.DEPID_FIELD),SqlDbType.Int);
  787. param.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
  788. param.Add(paramChg(EmpBaseData.EMPNAME_FIELD),SqlDbType.VarChar);
  789. param.Add(paramChg(EmpBaseData.LOGINID_FIELD),SqlDbType.VarChar);
  790. param.Add(paramChg(EmpBaseData.SEX_FIELD),SqlDbType.Bit);
  791. param.Add(paramChg(EmpBaseData.EMPCODE_FIELD),SqlDbType.VarChar);
  792. param.Add(paramChg(EmpBaseData.EMAIL_FIELD),SqlDbType.VarChar);
  793. param.Add(paramChg(EmpBaseData.OFFICETEL_FIELD),SqlDbType.VarChar);
  794. param.Add(paramChg(EmpBaseData.OFFICEFAX_FIELD),SqlDbType.VarChar);
  795. param.Add(paramChg(EmpBaseData.MOBILE_FIELD),SqlDbType.VarChar);
  796. param.Add(paramChg(EmpBaseData.POSITION_FIELD),SqlDbType.VarChar);
  798. param[paramChg(DepData.DEPID_FIELD)].SourceColumn = DepData.DEPID_FIELD;
  799. param[paramChg(EmpBaseData.EMPID_FIELD)].SourceColumn = EmpBaseData.EMPID_FIELD;
  800. param[paramChg(EmpBaseData.EMPNAME_FIELD)].SourceColumn = EmpBaseData.EMPNAME_FIELD;
  801. param[paramChg(EmpBaseData.LOGINID_FIELD)].SourceColumn = EmpBaseData.LOGINID_FIELD;
  802. param[paramChg(EmpBaseData.SEX_FIELD)].SourceColumn = EmpBaseData.SEX_FIELD;
  803. param[paramChg(EmpBaseData.EMPCODE_FIELD)].SourceColumn = EmpBaseData.EMPCODE_FIELD;
  804. param[paramChg(EmpBaseData.EMAIL_FIELD)].SourceColumn = EmpBaseData.EMAIL_FIELD;
  805. param[paramChg(EmpBaseData.OFFICETEL_FIELD)].SourceColumn = EmpBaseData.OFFICETEL_FIELD;
  806. param[paramChg(EmpBaseData.OFFICEFAX_FIELD)].SourceColumn = EmpBaseData.OFFICEFAX_FIELD;
  807. param[paramChg(EmpBaseData.MOBILE_FIELD)].SourceColumn = EmpBaseData.MOBILE_FIELD;
  808. param[paramChg(EmpBaseData.POSITION_FIELD)].SourceColumn = EmpBaseData.POSITION_FIELD;
  810. commandAdp.UpdateCommand = command;
  811. commandAdp.Update(empBaseData,EmpBaseData.EMP_TABLE_NAME);
  812. if(empBaseData.HasErrors)
  813. {
  814. empBaseData.Tables[EmpBaseData.EMP_TABLE_NAME].GetErrors()[0].ClearErrors();
  815. return false;
  816. }
  817. else
  818. {
  819. empBaseData.AcceptChanges();
  820. return true;
  821. }
  822. }
  824. public bool UpdateEmpWelInf(EmpBaseData empData)
  825. {
  826. SqlCommand command = new SqlCommand();
  828. command.CommandText = "UpdateEmpWelInf";
  829. command.CommandType = CommandType.StoredProcedure;
  830. command.Connection = con;
  832. SqlParameterCollection param = command.Parameters;
  834. param.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
  835. param.Add(paramChg(EmpBaseData.ENTERDATE_FIELD),SqlDbType.DateTime);
  836. param.Add(paramChg(EmpBaseData.ENTERMODE_FIELD),SqlDbType.VarChar);
  837. param.Add(paramChg(EmpBaseData.POSILEVL_FIELD),SqlDbType.VarChar);
  838. param.Add(paramChg(EmpBaseData.SALALEVL_FIELD),SqlDbType.VarChar);
  840. param.Add(paramChg(EmpBaseData.ENDOFLAG_FIELD),SqlDbType.Bit);
  841. param.Add(paramChg(EmpBaseData.HOSPFLAG_FIELD),SqlDbType.Bit);
  842. param.Add(paramChg(EmpBaseData.HOUSFLAG_FIELD),SqlDbType.Bit);
  843. param.Add(paramChg(EmpBaseData.GRAVFLAG_FIELD),SqlDbType.Bit);
  844. param.Add(paramChg(EmpBaseData.UNEMFLAG_FIELD),SqlDbType.Bit);
  845. param.Add(paramChg(EmpBaseData.WELNOTE_FIELD),SqlDbType.Text);
  849. param[paramChg(EmpBaseData.EMPID_FIELD)].SourceColumn = EmpBaseData.EMPID_FIELD;
  850. param[paramChg(EmpBaseData.ENTERDATE_FIELD)].SourceColumn = EmpBaseData.ENTERDATE_FIELD;
  851. param[paramChg(EmpBaseData.ENTERMODE_FIELD)].SourceColumn = EmpBaseData.ENTERMODE_FIELD;
  852. param[paramChg(EmpBaseData.POSILEVL_FIELD)].SourceColumn = EmpBaseData.POSILEVL_FIELD;
  853. param[paramChg(EmpBaseData.SALALEVL_FIELD)].SourceColumn = EmpBaseData.SALALEVL_FIELD;
  855. param[paramChg(EmpBaseData.ENDOFLAG_FIELD)].SourceColumn = EmpBaseData.ENDOFLAG_FIELD;
  856. param[paramChg(EmpBaseData.HOSPFLAG_FIELD)].SourceColumn = EmpBaseData.HOSPFLAG_FIELD;
  857. param[paramChg(EmpBaseData.HOUSFLAG_FIELD)].SourceColumn = EmpBaseData.HOUSFLAG_FIELD;
  858. param[paramChg(EmpBaseData.GRAVFLAG_FIELD)].SourceColumn = EmpBaseData.GRAVFLAG_FIELD;
  859. param[paramChg(EmpBaseData.UNEMFLAG_FIELD)].SourceColumn = EmpBaseData.UNEMFLAG_FIELD;
  860. param[paramChg(EmpBaseData.WELNOTE_FIELD)].SourceColumn = EmpBaseData.WELNOTE_FIELD;
  862. commandAdp.UpdateCommand = command;
  864. commandAdp.Update(empData,EmpBaseData.EMP_TABLE_NAME);
  866. if(empData.HasErrors)
  867. {
  868. empData.Tables[EmpBaseData.EMP_TABLE_NAME].GetErrors()[0].ClearErrors();
  869. return false;
  870. }
  871. else
  872. {
  873. empData.AcceptChanges();
  874. return true;
  875. }
  877. }
  879. public bool UpdateEmpPersInf(EmpBaseData empData)
  880. {
  881. SqlCommand command = new SqlCommand();
  883. command.CommandText = "UpdateEmpPersInf";
  884. command.CommandType = CommandType.StoredProcedure;
  885. command.Connection = con;
  887. SqlParameterCollection param = command.Parameters;
  889. param.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
  890. param.Add(paramChg(EmpBaseData.PROVINCE_FIELD),SqlDbType.VarChar);
  891. param.Add(paramChg(EmpBaseData.CITY_FIELD),SqlDbType.VarChar);
  892. param.Add(paramChg(EmpBaseData.DISTRICT_FIELD),SqlDbType.VarChar);
  893. param.Add(paramChg(EmpBaseData.STREET_FIELD),SqlDbType.VarChar);
  894. param.Add(paramChg(EmpBaseData.POSTCODE_FIELD),SqlDbType.VarChar);
  895. param.Add(paramChg(EmpBaseData.TEL1_FIELD),SqlDbType.VarChar);
  896. param.Add(paramChg(EmpBaseData.TEL2_FIELD),SqlDbType.VarChar);
  897. param.Add(paramChg(EmpBaseData.BIRTHDAY_FIELD),SqlDbType.DateTime);
  898. param.Add(paramChg(EmpBaseData.IDCARDNO_FIELD),SqlDbType.VarChar);
  899. param.Add(paramChg(EmpBaseData.NAPLACE_FIELD),SqlDbType.VarChar);
  900. param.Add(paramChg(EmpBaseData.PARTY_FIELD),SqlDbType.VarChar);
  901. param.Add(paramChg(EmpBaseData.PERSNOTE_FIELD),SqlDbType.Text);
  903. param[paramChg(EmpBaseData.EMPID_FIELD)].SourceColumn = EmpBaseData.EMPID_FIELD;
  904. param[paramChg(EmpBaseData.PROVINCE_FIELD)].SourceColumn = EmpBaseData.PROVINCE_FIELD;
  905. param[paramChg(EmpBaseData.CITY_FIELD)].SourceColumn = EmpBaseData.CITY_FIELD;
  906. param[paramChg(EmpBaseData.DISTRICT_FIELD)].SourceColumn = EmpBaseData.DISTRICT_FIELD;
  907. param[paramChg(EmpBaseData.STREET_FIELD)].SourceColumn = EmpBaseData.STREET_FIELD;
  908. param[paramChg(EmpBaseData.POSTCODE_FIELD)].SourceColumn = EmpBaseData.POSTCODE_FIELD;
  909. param[paramChg(EmpBaseData.TEL1_FIELD)].SourceColumn = EmpBaseData.TEL1_FIELD;
  910. param[paramChg(EmpBaseData.TEL2_FIELD)].SourceColumn = EmpBaseData.TEL2_FIELD;
  911. param[paramChg(EmpBaseData.BIRTHDAY_FIELD)].SourceColumn = EmpBaseData.BIRTHDAY_FIELD;
  912. param[paramChg(EmpBaseData.IDCARDNO_FIELD)].SourceColumn = EmpBaseData.IDCARDNO_FIELD;
  913. param[paramChg(EmpBaseData.NAPLACE_FIELD)].SourceColumn = EmpBaseData.NAPLACE_FIELD;
  914. param[paramChg(EmpBaseData.PARTY_FIELD)].SourceColumn = EmpBaseData.PARTY_FIELD;
  915. param[paramChg(EmpBaseData.PERSNOTE_FIELD)].SourceColumn = EmpBaseData.PERSNOTE_FIELD;
  919. commandAdp.UpdateCommand = command;
  921. commandAdp.Update(empData,EmpBaseData.EMP_TABLE_NAME);
  923. if(empData.HasErrors)
  924. {
  925. empData.Tables[EmpBaseData.EMP_TABLE_NAME].GetErrors()[0].ClearErrors();
  926. return false;
  927. }
  928. else
  929. {
  930. empData.AcceptChanges();
  931. return true;
  932. }
  934. }
  936. private SqlCommand GetCommand()
  937. {
  938. SqlCommand command = new SqlCommand();
  940. command.CommandType = CommandType.StoredProcedure;
  941. command.Connection = con;
  943. SqlParameterCollection param = command.Parameters;
  946. SqlParameter paramTmp = new SqlParameter("@Identify",SqlDbType.Int);
  947. paramTmp.Direction = ParameterDirection.ReturnValue;
  948. param.Add(paramTmp);
  950. param.Add(paramChg(DepData.DEPID_FIELD),SqlDbType.Int);
  951. param.Add(paramChg(DepData.BRANCHID_FIELD),SqlDbType.Int);
  954. param.Add(paramChg(EmpBaseData.EMPNAME_FIELD),SqlDbType.VarChar);
  955. param.Add(paramChg(EmpBaseData.LOGINID_FIELD),SqlDbType.VarChar);
  956. param.Add(paramChg(EmpBaseData.SEX_FIELD),SqlDbType.Bit);
  957. param.Add(paramChg(EmpBaseData.EMPCODE_FIELD),SqlDbType.VarChar);
  958. param.Add(paramChg(EmpBaseData.EMAIL_FIELD),SqlDbType.VarChar);
  959. param.Add(paramChg(EmpBaseData.OFFICETEL_FIELD),SqlDbType.VarChar);
  960. param.Add(paramChg(EmpBaseData.OFFICEFAX_FIELD),SqlDbType.VarChar);
  961. param.Add(paramChg(EmpBaseData.MOBILE_FIELD),SqlDbType.VarChar);
  963. param.Add(paramChg(EmpBaseData.PROVINCE_FIELD),SqlDbType.VarChar);
  964. param.Add(paramChg(EmpBaseData.CITY_FIELD),SqlDbType.VarChar);
  965. param.Add(paramChg(EmpBaseData.DISTRICT_FIELD),SqlDbType.VarChar);
  966. param.Add(paramChg(EmpBaseData.STREET_FIELD),SqlDbType.VarChar);
  967. param.Add(paramChg(EmpBaseData.POSTCODE_FIELD),SqlDbType.VarChar);
  968. param.Add(paramChg(EmpBaseData.TEL1_FIELD),SqlDbType.VarChar);
  969. param.Add(paramChg(EmpBaseData.TEL2_FIELD),SqlDbType.VarChar);
  970. param.Add(paramChg(EmpBaseData.BIRTHDAY_FIELD),SqlDbType.DateTime);
  971. param.Add(paramChg(EmpBaseData.IDCARDNO_FIELD),SqlDbType.VarChar);
  972. param.Add(paramChg(EmpBaseData.NAPLACE_FIELD),SqlDbType.VarChar);
  973. param.Add(paramChg(EmpBaseData.PARTY_FIELD),SqlDbType.VarChar);
  975. param.Add(paramChg(EmpBaseData.EDUCAT1_FIELD),SqlDbType.VarChar);
  976. param.Add(paramChg(EmpBaseData.SCHOOL1_FIELD),SqlDbType.VarChar);
  977. param.Add(paramChg(EmpBaseData.SPECIAL1_FIELD),SqlDbType.VarChar);
  978. param.Add(paramChg(EmpBaseData.GERTIME1_FIELD),SqlDbType.DateTime);
  979. param.Add(paramChg(EmpBaseData.EDUCAT2_FIELD),SqlDbType.VarChar);
  980. param.Add(paramChg(EmpBaseData.SCHOOL2_FIELD),SqlDbType.VarChar);
  981. param.Add(paramChg(EmpBaseData.SPECIAL2_FIELD),SqlDbType.VarChar);
  982. param.Add(paramChg(EmpBaseData.GERTIME2_FIELD),SqlDbType.DateTime);
  983. param.Add(paramChg(EmpBaseData.QULI1_FIELD),SqlDbType.VarChar);
  984. param.Add(paramChg(EmpBaseData.QULI2_FIELD),SqlDbType.VarChar);
  985. param.Add(paramChg(EmpBaseData.QULI3_FIELD),SqlDbType.VarChar);
  986. param.Add(paramChg(EmpBaseData.QULI4_FIELD),SqlDbType.VarChar);
  988. param.Add(paramChg(EmpBaseData.ENTERDATE_FIELD),SqlDbType.DateTime);
  989. param.Add(paramChg(EmpBaseData.ENTERMODE_FIELD),SqlDbType.VarChar);
  990. param.Add(paramChg(EmpBaseData.POSILEVL_FIELD),SqlDbType.VarChar);
  991. param.Add(paramChg(EmpBaseData.SALALEVL_FIELD),SqlDbType.VarChar);
  993. param.Add(paramChg(EmpBaseData.ENDOFLAG_FIELD),SqlDbType.Bit);
  994. param.Add(paramChg(EmpBaseData.HOSPFLAG_FIELD),SqlDbType.Bit);
  995. param.Add(paramChg(EmpBaseData.HOUSFLAG_FIELD),SqlDbType.Bit);
  996. param.Add(paramChg(EmpBaseData.GRAVFLAG_FIELD),SqlDbType.Bit);
  997. param.Add(paramChg(EmpBaseData.UNEMFLAG_FIELD),SqlDbType.Bit);
  999. param.Add(paramChg(EmpBaseData.WELNOTE_FIELD),SqlDbType.Text);
  1000. param.Add(paramChg(EmpBaseData.PERSNOTE_FIELD),SqlDbType.Text);
  1001. param[paramChg(DepData.DEPID_FIELD)].SourceColumn = DepData.DEPID_FIELD;
  1002. param[paramChg(DepData.BRANCHID_FIELD)].SourceColumn = DepData.BRANCHID_FIELD;
  1006. param[paramChg(EmpBaseData.EMPNAME_FIELD)].SourceColumn = EmpBaseData.EMPNAME_FIELD;
  1007. param[paramChg(EmpBaseData.LOGINID_FIELD)].SourceColumn = EmpBaseData.LOGINID_FIELD;
  1008. param[paramChg(EmpBaseData.SEX_FIELD)].SourceColumn = EmpBaseData.SEX_FIELD;
  1009. param[paramChg(EmpBaseData.EMPCODE_FIELD)].SourceColumn = EmpBaseData.EMPCODE_FIELD;
  1010. param[paramChg(EmpBaseData.EMAIL_FIELD)].SourceColumn = EmpBaseData.EMAIL_FIELD;
  1011. param[paramChg(EmpBaseData.OFFICETEL_FIELD)].SourceColumn = EmpBaseData.OFFICETEL_FIELD;
  1012. param[paramChg(EmpBaseData.OFFICEFAX_FIELD)].SourceColumn = EmpBaseData.OFFICEFAX_FIELD;
  1013. param[paramChg(EmpBaseData.MOBILE_FIELD)].SourceColumn = EmpBaseData.MOBILE_FIELD;
  1015. param[paramChg(EmpBaseData.PROVINCE_FIELD)].SourceColumn = EmpBaseData.PROVINCE_FIELD;
  1016. param[paramChg(EmpBaseData.CITY_FIELD)].SourceColumn = EmpBaseData.CITY_FIELD;
  1017. param[paramChg(EmpBaseData.DISTRICT_FIELD)].SourceColumn = EmpBaseData.DISTRICT_FIELD;
  1018. param[paramChg(EmpBaseData.STREET_FIELD)].SourceColumn = EmpBaseData.STREET_FIELD;
  1019. param[paramChg(EmpBaseData.POSTCODE_FIELD)].SourceColumn = EmpBaseData.POSTCODE_FIELD;
  1020. param[paramChg(EmpBaseData.TEL1_FIELD)].SourceColumn = EmpBaseData.TEL1_FIELD;
  1021. param[paramChg(EmpBaseData.TEL2_FIELD)].SourceColumn = EmpBaseData.TEL2_FIELD;
  1022. param[paramChg(EmpBaseData.BIRTHDAY_FIELD)].SourceColumn = EmpBaseData.BIRTHDAY_FIELD;
  1023. param[paramChg(EmpBaseData.IDCARDNO_FIELD)].SourceColumn = EmpBaseData.IDCARDNO_FIELD;
  1024. param[paramChg(EmpBaseData.NAPLACE_FIELD)].SourceColumn = EmpBaseData.NAPLACE_FIELD;
  1025. param[paramChg(EmpBaseData.PARTY_FIELD)].SourceColumn = EmpBaseData.PARTY_FIELD;
  1027. param[paramChg(EmpBaseData.EDUCAT1_FIELD)].SourceColumn = EmpBaseData.EDUCAT1_FIELD;
  1028. param[paramChg(EmpBaseData.SCHOOL1_FIELD)].SourceColumn = EmpBaseData.SCHOOL1_FIELD;
  1029. param[paramChg(EmpBaseData.SPECIAL1_FIELD)].SourceColumn = EmpBaseData.SPECIAL1_FIELD;
  1030. param[paramChg(EmpBaseData.GERTIME1_FIELD)].SourceColumn = EmpBaseData.GERTIME1_FIELD;
  1031. param[paramChg(EmpBaseData.EDUCAT2_FIELD)].SourceColumn = EmpBaseData.EDUCAT2_FIELD;
  1032. param[paramChg(EmpBaseData.SCHOOL2_FIELD)].SourceColumn = EmpBaseData.SCHOOL2_FIELD;
  1033. param[paramChg(EmpBaseData.SPECIAL2_FIELD)].SourceColumn = EmpBaseData.SPECIAL2_FIELD;
  1034. param[paramChg(EmpBaseData.GERTIME2_FIELD)].SourceColumn = EmpBaseData.GERTIME2_FIELD;
  1035. param[paramChg(EmpBaseData.QULI1_FIELD)].SourceColumn = EmpBaseData.QULI1_FIELD;
  1036. param[paramChg(EmpBaseData.QULI2_FIELD)].SourceColumn = EmpBaseData.QULI2_FIELD;
  1037. param[paramChg(EmpBaseData.QULI3_FIELD)].SourceColumn = EmpBaseData.QULI3_FIELD;
  1038. param[paramChg(EmpBaseData.QULI4_FIELD)].SourceColumn = EmpBaseData.QULI4_FIELD;
  1040. param[paramChg(EmpBaseData.ENTERDATE_FIELD)].SourceColumn = EmpBaseData.ENTERDATE_FIELD;
  1041. param[paramChg(EmpBaseData.ENTERMODE_FIELD)].SourceColumn = EmpBaseData.ENTERMODE_FIELD;
  1042. param[paramChg(EmpBaseData.POSILEVL_FIELD)].SourceColumn = EmpBaseData.POSILEVL_FIELD;
  1043. param[paramChg(EmpBaseData.SALALEVL_FIELD)].SourceColumn = EmpBaseData.SALALEVL_FIELD;
  1045. param[paramChg(EmpBaseData.ENDOFLAG_FIELD)].SourceColumn = EmpBaseData.ENDOFLAG_FIELD;
  1046. param[paramChg(EmpBaseData.HOSPFLAG_FIELD)].SourceColumn = EmpBaseData.HOSPFLAG_FIELD;
  1047. param[paramChg(EmpBaseData.HOUSFLAG_FIELD)].SourceColumn = EmpBaseData.HOUSFLAG_FIELD;
  1048. param[paramChg(EmpBaseData.GRAVFLAG_FIELD)].SourceColumn = EmpBaseData.GRAVFLAG_FIELD;
  1049. param[paramChg(EmpBaseData.UNEMFLAG_FIELD)].SourceColumn = EmpBaseData.UNEMFLAG_FIELD;
  1051. param[paramChg(EmpBaseData.WELNOTE_FIELD)].SourceColumn = EmpBaseData.WELNOTE_FIELD;
  1052. param[paramChg(EmpBaseData.PERSNOTE_FIELD)].SourceColumn = EmpBaseData.PERSNOTE_FIELD;
  1054. return command;
  1056. }
  1058. public void Dispose()
  1059. {
  1060. Dispose(true);
  1061. GC.SuppressFinalize(true);
  1062. }
  1064. protected virtual void Dispose(bool disposing)
  1065. {
  1067. }
  1069. public MrBaseInf()
  1070. {
  1071. conStr = System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString");
  1072. con = new SqlConnection(conStr);
  1073. commandAdp = new SqlDataAdapter();
  1074. }
  1075. }
  1076. }