/Las/Las.Dal/DaUsers.auto.cs

http://sgsoft-las.googlecode.com/ · C# · 760 lines · 679 code · 60 blank · 21 comment · 46 complexity · 57106dac99b1a442a9644d2cd4e6f6c5 MD5 · raw file

  1. #region DaUsers
  2. /*----------------------------------------------------------------
  3. // ????DaUsers.cs
  4. // ??????Users??????
  5. //
  6. //
  7. // ?????2009-07-19 DtataAccess template . Ver 5.0.20090413
  8. //
  9. // ?????
  10. // ?????
  11. //----------------------------------------------------------------*/
  12. using System;
  13. using System.Collections;
  14. using System.Collections.Generic;
  15. using System.Collections.ObjectModel;
  16. using System.Data;
  17. using System.Globalization;
  18. using System.Text;
  19. using System.Data.Common;
  20. using Microsoft.Practices.EnterpriseLibrary.Data;
  21. using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
  22. using Las.Model;
  23. namespace Las.Dal
  24. {
  25. ///?????????,IUsers ,???????DaBase?
  26. ///DaBase????DbException????????
  27. public partial class DaUsers:DaBase<MoUsers>
  28. {
  29. #region SQL const
  30. internal const string TABLE_COLUMNS=" USEQ ,LOGIN_NAME ,USER_CODE ,ARM_TYPE ,SPECIALTY_PHASE ,BRANCH_ID ,PERSON_ID ,PERSON_NAME ,SEX_ID ,FORK_ID ,BIRTHDAY ,ENROLL_DATE ,BIRTHPLACE ,FAM_ORI_ID ,PERSON_ING_ID ,POLITY_MEMBER_ID ,CURRENTPOST_ID ,CURRENTPOSTTIME ,FIRSTDEGREE_ID ,SCHOOLSPECIAL ,CURRENTDEGREE_ID ,STRONG_SUIT ,DEGREE_ID ,TYPICAL_LEVEL ,IDENTITY_TYPE_ID ,READINESS_ID ,GRADUATEFROM ,TRAIN_INFO ,TRAIN_SCORE ,TRAIN_EVA ,ABILITY_EVA ,GOODTEACHER ,PAPER ,PARTYATTENDED ,PERSONLIB ,AWARDORPUNISH ,RESUME ,PHOTO ,USER_ID ,USER_PWD ,FULL_NAME ,POSTTYPE ,ZCBM ,ZGSF ,ENABLED ,STATE ";
  31. internal const string SQL_INSERT="INSERT INTO MT_USERS ("+TABLE_COLUMNS+") VALUES (@Useq,@LoginName,@UserCode,@ArmType,@SpecialtyPhase,@BranchId,@PersonId,@PersonName,@SexId,@ForkId,@Birthday,@EnrollDate,@Birthplace,@FamOriId,@PersonIngId,@PolityMemberId,@CurrentpostId,@Currentposttime,@FirstdegreeId,@Schoolspecial,@CurrentdegreeId,@StrongSuit,@DegreeId,@TypicalLevel,@IdentityTypeId,@ReadinessId,@Graduatefrom,@TrainInfo,@TrainScore,@TrainEva,@AbilityEva,@Goodteacher,@Paper,@Partyattended,@Personlib,@Awardorpunish,@Resume,@Photo,@UserId,@UserPwd,@FullName,@Posttype,@Zcbm,@Zgsf,@Enabled,@State)";
  32. internal const string SQL_SELECT="SELECT "+TABLE_COLUMNS+" FROM MT_USERS ";
  33. internal const string SQL_SELECT_ONE=SQL_SELECT+" WHERE USER_ID=@UserId";
  34. internal const string SQL_EXIST="SELECT COUNT(*) FROM MT_USERS WHERE USER_ID=@UserId ";
  35. internal const string SQL_UPDATE="UPDATE MT_USERS SET USEQ=@Useq, LOGIN_NAME=@LoginName, USER_CODE=@UserCode, ARM_TYPE=@ArmType, SPECIALTY_PHASE=@SpecialtyPhase, BRANCH_ID=@BranchId, PERSON_ID=@PersonId, PERSON_NAME=@PersonName, SEX_ID=@SexId, FORK_ID=@ForkId, BIRTHDAY=@Birthday, ENROLL_DATE=@EnrollDate, BIRTHPLACE=@Birthplace, FAM_ORI_ID=@FamOriId, PERSON_ING_ID=@PersonIngId, POLITY_MEMBER_ID=@PolityMemberId, CURRENTPOST_ID=@CurrentpostId, CURRENTPOSTTIME=@Currentposttime, FIRSTDEGREE_ID=@FirstdegreeId, SCHOOLSPECIAL=@Schoolspecial, CURRENTDEGREE_ID=@CurrentdegreeId, STRONG_SUIT=@StrongSuit, DEGREE_ID=@DegreeId, TYPICAL_LEVEL=@TypicalLevel, IDENTITY_TYPE_ID=@IdentityTypeId, READINESS_ID=@ReadinessId, GRADUATEFROM=@Graduatefrom, TRAIN_INFO=@TrainInfo, TRAIN_SCORE=@TrainScore, TRAIN_EVA=@TrainEva, ABILITY_EVA=@AbilityEva, GOODTEACHER=@Goodteacher, PAPER=@Paper, PARTYATTENDED=@Partyattended, PERSONLIB=@Personlib, AWARDORPUNISH=@Awardorpunish, RESUME=@Resume, PHOTO=@Photo, USER_PWD=@UserPwd, FULL_NAME=@FullName, POSTTYPE=@Posttype, ZCBM=@Zcbm, ZGSF=@Zgsf, ENABLED=@Enabled, STATE=@State WHERE USER_ID=@UserId";
  36. internal const string SQL_DELETE_DEFAULT = "DELETE FROM MT_USERS ";
  37. internal const string SQL_DELETE="DELETE FROM MT_USERS WHERE USER_ID=@UserId";
  38. internal const string SQL_COUNT="SELECT COUNT(*) FROM mt_users ";
  39. #endregion
  40. #region Constructor
  41. /// <summary>
  42. /// ???????????????????????
  43. /// </summary>
  44. public DaUsers ()
  45. {
  46. this.db=DatabaseFactory.CreateDatabase();
  47. }
  48. /// <summary>
  49. /// ?????databaseName??????
  50. /// </summary>
  51. /// <param name="databaseName">??????????????</param>
  52. public DaUsers (string databaseName)
  53. {
  54. this.db = DatabaseFactory.CreateDatabase(databaseName);
  55. }
  56. public DaUsers (Database db)
  57. {
  58. this.db = db;
  59. }
  60. #endregion
  61. //???CRUD??????????????????
  62. #region ?????
  63. protected override MoUsers ConstructT()
  64. {
  65. return new MoUsers();
  66. }
  67. #endregion
  68. #region Add?? Helper
  69. ///build the command object.It never throw exception.
  70. protected override DbCommand ConstructAddCommand(Database db)
  71. {
  72. DbCommand dbCommand = db.GetSqlStringCommand(SQL_INSERT);
  73. db.AddInParameter(dbCommand,"Useq",DbType.Int32);
  74. db.AddInParameter(dbCommand,"LoginName",DbType.AnsiString);
  75. db.AddInParameter(dbCommand,"UserCode",DbType.AnsiString);
  76. db.AddInParameter(dbCommand,"ArmType",DbType.AnsiString);
  77. db.AddInParameter(dbCommand,"SpecialtyPhase",DbType.AnsiString);
  78. db.AddInParameter(dbCommand,"BranchId",DbType.AnsiString);
  79. db.AddInParameter(dbCommand,"PersonId",DbType.AnsiString);
  80. db.AddInParameter(dbCommand,"PersonName",DbType.AnsiString);
  81. db.AddInParameter(dbCommand,"SexId",DbType.AnsiString);
  82. db.AddInParameter(dbCommand,"ForkId",DbType.AnsiString);
  83. db.AddInParameter(dbCommand,"Birthday",DbType.DateTime);
  84. db.AddInParameter(dbCommand,"EnrollDate",DbType.DateTime);
  85. db.AddInParameter(dbCommand,"Birthplace",DbType.AnsiString);
  86. db.AddInParameter(dbCommand,"FamOriId",DbType.AnsiString);
  87. db.AddInParameter(dbCommand,"PersonIngId",DbType.AnsiString);
  88. db.AddInParameter(dbCommand,"PolityMemberId",DbType.AnsiString);
  89. db.AddInParameter(dbCommand,"CurrentpostId",DbType.AnsiString);
  90. db.AddInParameter(dbCommand,"Currentposttime",DbType.AnsiString);
  91. db.AddInParameter(dbCommand,"FirstdegreeId",DbType.AnsiString);
  92. db.AddInParameter(dbCommand,"Schoolspecial",DbType.AnsiString);
  93. db.AddInParameter(dbCommand,"CurrentdegreeId",DbType.AnsiString);
  94. db.AddInParameter(dbCommand,"StrongSuit",DbType.AnsiString);
  95. db.AddInParameter(dbCommand,"DegreeId",DbType.AnsiString);
  96. db.AddInParameter(dbCommand,"TypicalLevel",DbType.AnsiString);
  97. db.AddInParameter(dbCommand,"IdentityTypeId",DbType.AnsiString);
  98. db.AddInParameter(dbCommand,"ReadinessId",DbType.AnsiString);
  99. db.AddInParameter(dbCommand,"Graduatefrom",DbType.AnsiString);
  100. db.AddInParameter(dbCommand,"TrainInfo",DbType.AnsiString);
  101. db.AddInParameter(dbCommand,"TrainScore",DbType.AnsiString);
  102. db.AddInParameter(dbCommand,"TrainEva",DbType.AnsiString);
  103. db.AddInParameter(dbCommand,"AbilityEva",DbType.AnsiString);
  104. db.AddInParameter(dbCommand,"Goodteacher",DbType.AnsiString);
  105. db.AddInParameter(dbCommand,"Paper",DbType.AnsiString);
  106. db.AddInParameter(dbCommand,"Partyattended",DbType.AnsiString);
  107. db.AddInParameter(dbCommand,"Personlib",DbType.AnsiString);
  108. db.AddInParameter(dbCommand,"Awardorpunish",DbType.AnsiString);
  109. db.AddInParameter(dbCommand,"Resume",DbType.AnsiString);
  110. db.AddInParameter(dbCommand,"Photo",DbType.AnsiString);
  111. db.AddInParameter(dbCommand,"UserId",DbType.AnsiString);
  112. db.AddInParameter(dbCommand,"UserPwd",DbType.AnsiString);
  113. db.AddInParameter(dbCommand,"FullName",DbType.AnsiString);
  114. db.AddInParameter(dbCommand,"Posttype",DbType.AnsiString);
  115. db.AddInParameter(dbCommand,"Zcbm",DbType.AnsiString);
  116. db.AddInParameter(dbCommand,"Zgsf",DbType.AnsiString);
  117. db.AddInParameter(dbCommand,"Enabled",DbType.AnsiString);
  118. db.AddInParameter(dbCommand,"State",DbType.Int32);
  119. return dbCommand;
  120. }
  121. protected override DbCommand ConstructAddCommand(Database db,MoUsers entity)
  122. {
  123. DbCommand dbCommand=db.GetSqlStringCommand(SQL_INSERT);
  124. db.AddInParameter(dbCommand,"Useq",DbType.Int32,entity.Useq);
  125. db.AddInParameter(dbCommand,"LoginName",DbType.AnsiString,entity.LoginName);
  126. db.AddInParameter(dbCommand,"UserCode",DbType.AnsiString,entity.UserCode);
  127. db.AddInParameter(dbCommand,"ArmType",DbType.AnsiString,entity.ArmType);
  128. db.AddInParameter(dbCommand,"SpecialtyPhase",DbType.AnsiString,entity.SpecialtyPhase);
  129. db.AddInParameter(dbCommand,"BranchId",DbType.AnsiString,entity.BranchId);
  130. db.AddInParameter(dbCommand,"PersonId",DbType.AnsiString,entity.PersonId);
  131. db.AddInParameter(dbCommand,"PersonName",DbType.AnsiString,entity.PersonName);
  132. db.AddInParameter(dbCommand,"SexId",DbType.AnsiString,entity.SexId);
  133. db.AddInParameter(dbCommand,"ForkId",DbType.AnsiString,entity.ForkId);
  134. db.AddInParameter(dbCommand,"Birthday",DbType.DateTime,entity.Birthday);
  135. db.AddInParameter(dbCommand,"EnrollDate",DbType.DateTime,entity.EnrollDate);
  136. db.AddInParameter(dbCommand,"Birthplace",DbType.AnsiString,entity.Birthplace);
  137. db.AddInParameter(dbCommand,"FamOriId",DbType.AnsiString,entity.FamOriId);
  138. db.AddInParameter(dbCommand,"PersonIngId",DbType.AnsiString,entity.PersonIngId);
  139. db.AddInParameter(dbCommand,"PolityMemberId",DbType.AnsiString,entity.PolityMemberId);
  140. db.AddInParameter(dbCommand,"CurrentpostId",DbType.AnsiString,entity.CurrentpostId);
  141. db.AddInParameter(dbCommand,"Currentposttime",DbType.AnsiString,entity.Currentposttime);
  142. db.AddInParameter(dbCommand,"FirstdegreeId",DbType.AnsiString,entity.FirstdegreeId);
  143. db.AddInParameter(dbCommand,"Schoolspecial",DbType.AnsiString,entity.Schoolspecial);
  144. db.AddInParameter(dbCommand,"CurrentdegreeId",DbType.AnsiString,entity.CurrentdegreeId);
  145. db.AddInParameter(dbCommand,"StrongSuit",DbType.AnsiString,entity.StrongSuit);
  146. db.AddInParameter(dbCommand,"DegreeId",DbType.AnsiString,entity.DegreeId);
  147. db.AddInParameter(dbCommand,"TypicalLevel",DbType.AnsiString,entity.TypicalLevel);
  148. db.AddInParameter(dbCommand,"IdentityTypeId",DbType.AnsiString,entity.IdentityTypeId);
  149. db.AddInParameter(dbCommand,"ReadinessId",DbType.AnsiString,entity.ReadinessId);
  150. db.AddInParameter(dbCommand,"Graduatefrom",DbType.AnsiString,entity.Graduatefrom);
  151. db.AddInParameter(dbCommand,"TrainInfo",DbType.AnsiString,entity.TrainInfo);
  152. db.AddInParameter(dbCommand,"TrainScore",DbType.AnsiString,entity.TrainScore);
  153. db.AddInParameter(dbCommand,"TrainEva",DbType.AnsiString,entity.TrainEva);
  154. db.AddInParameter(dbCommand,"AbilityEva",DbType.AnsiString,entity.AbilityEva);
  155. db.AddInParameter(dbCommand,"Goodteacher",DbType.AnsiString,entity.Goodteacher);
  156. db.AddInParameter(dbCommand,"Paper",DbType.AnsiString,entity.Paper);
  157. db.AddInParameter(dbCommand,"Partyattended",DbType.AnsiString,entity.Partyattended);
  158. db.AddInParameter(dbCommand,"Personlib",DbType.AnsiString,entity.Personlib);
  159. db.AddInParameter(dbCommand,"Awardorpunish",DbType.AnsiString,entity.Awardorpunish);
  160. db.AddInParameter(dbCommand,"Resume",DbType.AnsiString,entity.Resume);
  161. db.AddInParameter(dbCommand,"Photo",DbType.AnsiString,entity.Photo);
  162. db.AddInParameter(dbCommand,"UserId",DbType.AnsiString,entity.UserId);
  163. db.AddInParameter(dbCommand,"UserPwd",DbType.AnsiString,entity.UserPwd);
  164. db.AddInParameter(dbCommand,"FullName",DbType.AnsiString,entity.FullName);
  165. db.AddInParameter(dbCommand,"Posttype",DbType.AnsiString,entity.Posttype);
  166. db.AddInParameter(dbCommand,"Zcbm",DbType.AnsiString,entity.Zcbm);
  167. db.AddInParameter(dbCommand,"Zgsf",DbType.AnsiString,entity.Zgsf);
  168. db.AddInParameter(dbCommand,"Enabled",DbType.AnsiString,entity.Enabled);
  169. db.AddInParameter(dbCommand,"State",DbType.Int32,entity.State);
  170. return dbCommand;
  171. }
  172. protected override DbCommand PopulateAddCommandParameters(Database db,DbCommand addCmd,MoUsers entity)
  173. {
  174. db.SetParameterValue(addCmd,"Useq",entity.Useq);
  175. db.SetParameterValue(addCmd,"LoginName",entity.LoginName);
  176. db.SetParameterValue(addCmd,"UserCode",entity.UserCode);
  177. db.SetParameterValue(addCmd,"ArmType",entity.ArmType);
  178. db.SetParameterValue(addCmd,"SpecialtyPhase",entity.SpecialtyPhase);
  179. db.SetParameterValue(addCmd,"BranchId",entity.BranchId);
  180. db.SetParameterValue(addCmd,"PersonId",entity.PersonId);
  181. db.SetParameterValue(addCmd,"PersonName",entity.PersonName);
  182. db.SetParameterValue(addCmd,"SexId",entity.SexId);
  183. db.SetParameterValue(addCmd,"ForkId",entity.ForkId);
  184. db.SetParameterValue(addCmd,"Birthday",entity.Birthday);
  185. db.SetParameterValue(addCmd,"EnrollDate",entity.EnrollDate);
  186. db.SetParameterValue(addCmd,"Birthplace",entity.Birthplace);
  187. db.SetParameterValue(addCmd,"FamOriId",entity.FamOriId);
  188. db.SetParameterValue(addCmd,"PersonIngId",entity.PersonIngId);
  189. db.SetParameterValue(addCmd,"PolityMemberId",entity.PolityMemberId);
  190. db.SetParameterValue(addCmd,"CurrentpostId",entity.CurrentpostId);
  191. db.SetParameterValue(addCmd,"Currentposttime",entity.Currentposttime);
  192. db.SetParameterValue(addCmd,"FirstdegreeId",entity.FirstdegreeId);
  193. db.SetParameterValue(addCmd,"Schoolspecial",entity.Schoolspecial);
  194. db.SetParameterValue(addCmd,"CurrentdegreeId",entity.CurrentdegreeId);
  195. db.SetParameterValue(addCmd,"StrongSuit",entity.StrongSuit);
  196. db.SetParameterValue(addCmd,"DegreeId",entity.DegreeId);
  197. db.SetParameterValue(addCmd,"TypicalLevel",entity.TypicalLevel);
  198. db.SetParameterValue(addCmd,"IdentityTypeId",entity.IdentityTypeId);
  199. db.SetParameterValue(addCmd,"ReadinessId",entity.ReadinessId);
  200. db.SetParameterValue(addCmd,"Graduatefrom",entity.Graduatefrom);
  201. db.SetParameterValue(addCmd,"TrainInfo",entity.TrainInfo);
  202. db.SetParameterValue(addCmd,"TrainScore",entity.TrainScore);
  203. db.SetParameterValue(addCmd,"TrainEva",entity.TrainEva);
  204. db.SetParameterValue(addCmd,"AbilityEva",entity.AbilityEva);
  205. db.SetParameterValue(addCmd,"Goodteacher",entity.Goodteacher);
  206. db.SetParameterValue(addCmd,"Paper",entity.Paper);
  207. db.SetParameterValue(addCmd,"Partyattended",entity.Partyattended);
  208. db.SetParameterValue(addCmd,"Personlib",entity.Personlib);
  209. db.SetParameterValue(addCmd,"Awardorpunish",entity.Awardorpunish);
  210. db.SetParameterValue(addCmd,"Resume",entity.Resume);
  211. db.SetParameterValue(addCmd,"Photo",entity.Photo);
  212. db.SetParameterValue(addCmd,"UserId",entity.UserId);
  213. db.SetParameterValue(addCmd,"UserPwd",entity.UserPwd);
  214. db.SetParameterValue(addCmd,"FullName",entity.FullName);
  215. db.SetParameterValue(addCmd,"Posttype",entity.Posttype);
  216. db.SetParameterValue(addCmd,"Zcbm",entity.Zcbm);
  217. db.SetParameterValue(addCmd,"Zgsf",entity.Zgsf);
  218. db.SetParameterValue(addCmd,"Enabled",entity.Enabled);
  219. db.SetParameterValue(addCmd,"State",entity.State);
  220. return addCmd;
  221. }
  222. protected override DbCommand PopulateAddCommandParameters(Database db,DbCommand addCmd,DataRow row)
  223. {
  224. db.SetParameterValue(addCmd,"Useq",row["Useq"]);
  225. db.SetParameterValue(addCmd,"LoginName",row["LoginName"]);
  226. db.SetParameterValue(addCmd,"UserCode",row["UserCode"]);
  227. db.SetParameterValue(addCmd,"ArmType",row["ArmType"]);
  228. db.SetParameterValue(addCmd,"SpecialtyPhase",row["SpecialtyPhase"]);
  229. db.SetParameterValue(addCmd,"BranchId",row["BranchId"]);
  230. db.SetParameterValue(addCmd,"PersonId",row["PersonId"]);
  231. db.SetParameterValue(addCmd,"PersonName",row["PersonName"]);
  232. db.SetParameterValue(addCmd,"SexId",row["SexId"]);
  233. db.SetParameterValue(addCmd,"ForkId",row["ForkId"]);
  234. db.SetParameterValue(addCmd,"Birthday",row["Birthday"]);
  235. db.SetParameterValue(addCmd,"EnrollDate",row["EnrollDate"]);
  236. db.SetParameterValue(addCmd,"Birthplace",row["Birthplace"]);
  237. db.SetParameterValue(addCmd,"FamOriId",row["FamOriId"]);
  238. db.SetParameterValue(addCmd,"PersonIngId",row["PersonIngId"]);
  239. db.SetParameterValue(addCmd,"PolityMemberId",row["PolityMemberId"]);
  240. db.SetParameterValue(addCmd,"CurrentpostId",row["CurrentpostId"]);
  241. db.SetParameterValue(addCmd,"Currentposttime",row["Currentposttime"]);
  242. db.SetParameterValue(addCmd,"FirstdegreeId",row["FirstdegreeId"]);
  243. db.SetParameterValue(addCmd,"Schoolspecial",row["Schoolspecial"]);
  244. db.SetParameterValue(addCmd,"CurrentdegreeId",row["CurrentdegreeId"]);
  245. db.SetParameterValue(addCmd,"StrongSuit",row["StrongSuit"]);
  246. db.SetParameterValue(addCmd,"DegreeId",row["DegreeId"]);
  247. db.SetParameterValue(addCmd,"TypicalLevel",row["TypicalLevel"]);
  248. db.SetParameterValue(addCmd,"IdentityTypeId",row["IdentityTypeId"]);
  249. db.SetParameterValue(addCmd,"ReadinessId",row["ReadinessId"]);
  250. db.SetParameterValue(addCmd,"Graduatefrom",row["Graduatefrom"]);
  251. db.SetParameterValue(addCmd,"TrainInfo",row["TrainInfo"]);
  252. db.SetParameterValue(addCmd,"TrainScore",row["TrainScore"]);
  253. db.SetParameterValue(addCmd,"TrainEva",row["TrainEva"]);
  254. db.SetParameterValue(addCmd,"AbilityEva",row["AbilityEva"]);
  255. db.SetParameterValue(addCmd,"Goodteacher",row["Goodteacher"]);
  256. db.SetParameterValue(addCmd,"Paper",row["Paper"]);
  257. db.SetParameterValue(addCmd,"Partyattended",row["Partyattended"]);
  258. db.SetParameterValue(addCmd,"Personlib",row["Personlib"]);
  259. db.SetParameterValue(addCmd,"Awardorpunish",row["Awardorpunish"]);
  260. db.SetParameterValue(addCmd,"Resume",row["Resume"]);
  261. db.SetParameterValue(addCmd,"Photo",row["Photo"]);
  262. db.SetParameterValue(addCmd,"UserId",row["UserId"]);
  263. db.SetParameterValue(addCmd,"UserPwd",row["UserPwd"]);
  264. db.SetParameterValue(addCmd,"FullName",row["FullName"]);
  265. db.SetParameterValue(addCmd,"Posttype",row["Posttype"]);
  266. db.SetParameterValue(addCmd,"Zcbm",row["Zcbm"]);
  267. db.SetParameterValue(addCmd,"Zgsf",row["Zgsf"]);
  268. db.SetParameterValue(addCmd,"Enabled",row["Enabled"]);
  269. db.SetParameterValue(addCmd,"State",row["State"]);
  270. return addCmd;
  271. }
  272. #endregion
  273. #region Update?? Helper
  274. protected override DbCommand ConstructUpdateCommand(Database db)
  275. {
  276. DbCommand dbCommand=db.GetSqlStringCommand(SQL_UPDATE);
  277. db.AddInParameter(dbCommand,"Useq",DbType.Int32);
  278. db.AddInParameter(dbCommand,"LoginName",DbType.AnsiString);
  279. db.AddInParameter(dbCommand,"UserCode",DbType.AnsiString);
  280. db.AddInParameter(dbCommand,"ArmType",DbType.AnsiString);
  281. db.AddInParameter(dbCommand,"SpecialtyPhase",DbType.AnsiString);
  282. db.AddInParameter(dbCommand,"BranchId",DbType.AnsiString);
  283. db.AddInParameter(dbCommand,"PersonId",DbType.AnsiString);
  284. db.AddInParameter(dbCommand,"PersonName",DbType.AnsiString);
  285. db.AddInParameter(dbCommand,"SexId",DbType.AnsiString);
  286. db.AddInParameter(dbCommand,"ForkId",DbType.AnsiString);
  287. db.AddInParameter(dbCommand,"Birthday",DbType.DateTime);
  288. db.AddInParameter(dbCommand,"EnrollDate",DbType.DateTime);
  289. db.AddInParameter(dbCommand,"Birthplace",DbType.AnsiString);
  290. db.AddInParameter(dbCommand,"FamOriId",DbType.AnsiString);
  291. db.AddInParameter(dbCommand,"PersonIngId",DbType.AnsiString);
  292. db.AddInParameter(dbCommand,"PolityMemberId",DbType.AnsiString);
  293. db.AddInParameter(dbCommand,"CurrentpostId",DbType.AnsiString);
  294. db.AddInParameter(dbCommand,"Currentposttime",DbType.AnsiString);
  295. db.AddInParameter(dbCommand,"FirstdegreeId",DbType.AnsiString);
  296. db.AddInParameter(dbCommand,"Schoolspecial",DbType.AnsiString);
  297. db.AddInParameter(dbCommand,"CurrentdegreeId",DbType.AnsiString);
  298. db.AddInParameter(dbCommand,"StrongSuit",DbType.AnsiString);
  299. db.AddInParameter(dbCommand,"DegreeId",DbType.AnsiString);
  300. db.AddInParameter(dbCommand,"TypicalLevel",DbType.AnsiString);
  301. db.AddInParameter(dbCommand,"IdentityTypeId",DbType.AnsiString);
  302. db.AddInParameter(dbCommand,"ReadinessId",DbType.AnsiString);
  303. db.AddInParameter(dbCommand,"Graduatefrom",DbType.AnsiString);
  304. db.AddInParameter(dbCommand,"TrainInfo",DbType.AnsiString);
  305. db.AddInParameter(dbCommand,"TrainScore",DbType.AnsiString);
  306. db.AddInParameter(dbCommand,"TrainEva",DbType.AnsiString);
  307. db.AddInParameter(dbCommand,"AbilityEva",DbType.AnsiString);
  308. db.AddInParameter(dbCommand,"Goodteacher",DbType.AnsiString);
  309. db.AddInParameter(dbCommand,"Paper",DbType.AnsiString);
  310. db.AddInParameter(dbCommand,"Partyattended",DbType.AnsiString);
  311. db.AddInParameter(dbCommand,"Personlib",DbType.AnsiString);
  312. db.AddInParameter(dbCommand,"Awardorpunish",DbType.AnsiString);
  313. db.AddInParameter(dbCommand,"Resume",DbType.AnsiString);
  314. db.AddInParameter(dbCommand,"Photo",DbType.AnsiString);
  315. db.AddInParameter(dbCommand,"UserPwd",DbType.AnsiString);
  316. db.AddInParameter(dbCommand,"FullName",DbType.AnsiString);
  317. db.AddInParameter(dbCommand,"Posttype",DbType.AnsiString);
  318. db.AddInParameter(dbCommand,"Zcbm",DbType.AnsiString);
  319. db.AddInParameter(dbCommand,"Zgsf",DbType.AnsiString);
  320. db.AddInParameter(dbCommand,"Enabled",DbType.AnsiString);
  321. db.AddInParameter(dbCommand,"State",DbType.Int32);
  322. db.AddInParameter(dbCommand,"UserId",DbType.AnsiString);
  323. return dbCommand;
  324. }
  325. protected override DbCommand ConstructUpdateCommand(Database db,MoUsers entity)
  326. {
  327. DbCommand dbCommand=db.GetSqlStringCommand(SQL_UPDATE);
  328. db.AddInParameter(dbCommand,"Useq",DbType.Int32,entity.Useq);
  329. db.AddInParameter(dbCommand,"LoginName",DbType.AnsiString,entity.LoginName);
  330. db.AddInParameter(dbCommand,"UserCode",DbType.AnsiString,entity.UserCode);
  331. db.AddInParameter(dbCommand,"ArmType",DbType.AnsiString,entity.ArmType);
  332. db.AddInParameter(dbCommand,"SpecialtyPhase",DbType.AnsiString,entity.SpecialtyPhase);
  333. db.AddInParameter(dbCommand,"BranchId",DbType.AnsiString,entity.BranchId);
  334. db.AddInParameter(dbCommand,"PersonId",DbType.AnsiString,entity.PersonId);
  335. db.AddInParameter(dbCommand,"PersonName",DbType.AnsiString,entity.PersonName);
  336. db.AddInParameter(dbCommand,"SexId",DbType.AnsiString,entity.SexId);
  337. db.AddInParameter(dbCommand,"ForkId",DbType.AnsiString,entity.ForkId);
  338. db.AddInParameter(dbCommand,"Birthday",DbType.DateTime,entity.Birthday);
  339. db.AddInParameter(dbCommand,"EnrollDate",DbType.DateTime,entity.EnrollDate);
  340. db.AddInParameter(dbCommand,"Birthplace",DbType.AnsiString,entity.Birthplace);
  341. db.AddInParameter(dbCommand,"FamOriId",DbType.AnsiString,entity.FamOriId);
  342. db.AddInParameter(dbCommand,"PersonIngId",DbType.AnsiString,entity.PersonIngId);
  343. db.AddInParameter(dbCommand,"PolityMemberId",DbType.AnsiString,entity.PolityMemberId);
  344. db.AddInParameter(dbCommand,"CurrentpostId",DbType.AnsiString,entity.CurrentpostId);
  345. db.AddInParameter(dbCommand,"Currentposttime",DbType.AnsiString,entity.Currentposttime);
  346. db.AddInParameter(dbCommand,"FirstdegreeId",DbType.AnsiString,entity.FirstdegreeId);
  347. db.AddInParameter(dbCommand,"Schoolspecial",DbType.AnsiString,entity.Schoolspecial);
  348. db.AddInParameter(dbCommand,"CurrentdegreeId",DbType.AnsiString,entity.CurrentdegreeId);
  349. db.AddInParameter(dbCommand,"StrongSuit",DbType.AnsiString,entity.StrongSuit);
  350. db.AddInParameter(dbCommand,"DegreeId",DbType.AnsiString,entity.DegreeId);
  351. db.AddInParameter(dbCommand,"TypicalLevel",DbType.AnsiString,entity.TypicalLevel);
  352. db.AddInParameter(dbCommand,"IdentityTypeId",DbType.AnsiString,entity.IdentityTypeId);
  353. db.AddInParameter(dbCommand,"ReadinessId",DbType.AnsiString,entity.ReadinessId);
  354. db.AddInParameter(dbCommand,"Graduatefrom",DbType.AnsiString,entity.Graduatefrom);
  355. db.AddInParameter(dbCommand,"TrainInfo",DbType.AnsiString,entity.TrainInfo);
  356. db.AddInParameter(dbCommand,"TrainScore",DbType.AnsiString,entity.TrainScore);
  357. db.AddInParameter(dbCommand,"TrainEva",DbType.AnsiString,entity.TrainEva);
  358. db.AddInParameter(dbCommand,"AbilityEva",DbType.AnsiString,entity.AbilityEva);
  359. db.AddInParameter(dbCommand,"Goodteacher",DbType.AnsiString,entity.Goodteacher);
  360. db.AddInParameter(dbCommand,"Paper",DbType.AnsiString,entity.Paper);
  361. db.AddInParameter(dbCommand,"Partyattended",DbType.AnsiString,entity.Partyattended);
  362. db.AddInParameter(dbCommand,"Personlib",DbType.AnsiString,entity.Personlib);
  363. db.AddInParameter(dbCommand,"Awardorpunish",DbType.AnsiString,entity.Awardorpunish);
  364. db.AddInParameter(dbCommand,"Resume",DbType.AnsiString,entity.Resume);
  365. db.AddInParameter(dbCommand,"Photo",DbType.AnsiString,entity.Photo);
  366. db.AddInParameter(dbCommand,"UserPwd",DbType.AnsiString,entity.UserPwd);
  367. db.AddInParameter(dbCommand,"FullName",DbType.AnsiString,entity.FullName);
  368. db.AddInParameter(dbCommand,"Posttype",DbType.AnsiString,entity.Posttype);
  369. db.AddInParameter(dbCommand,"Zcbm",DbType.AnsiString,entity.Zcbm);
  370. db.AddInParameter(dbCommand,"Zgsf",DbType.AnsiString,entity.Zgsf);
  371. db.AddInParameter(dbCommand,"Enabled",DbType.AnsiString,entity.Enabled);
  372. db.AddInParameter(dbCommand,"State",DbType.Int32,entity.State);
  373. db.AddInParameter(dbCommand,"UserId",DbType.AnsiString,entity.UserId);
  374. return dbCommand;
  375. }
  376. protected override DbCommand PopulateUpdateCommandParameters(Database db,DbCommand updateCmd,MoUsers entity)
  377. {
  378. db.SetParameterValue(updateCmd,"Useq",entity.Useq);
  379. db.SetParameterValue(updateCmd,"LoginName",entity.LoginName);
  380. db.SetParameterValue(updateCmd,"UserCode",entity.UserCode);
  381. db.SetParameterValue(updateCmd,"ArmType",entity.ArmType);
  382. db.SetParameterValue(updateCmd,"SpecialtyPhase",entity.SpecialtyPhase);
  383. db.SetParameterValue(updateCmd,"BranchId",entity.BranchId);
  384. db.SetParameterValue(updateCmd,"PersonId",entity.PersonId);
  385. db.SetParameterValue(updateCmd,"PersonName",entity.PersonName);
  386. db.SetParameterValue(updateCmd,"SexId",entity.SexId);
  387. db.SetParameterValue(updateCmd,"ForkId",entity.ForkId);
  388. db.SetParameterValue(updateCmd,"Birthday",entity.Birthday);
  389. db.SetParameterValue(updateCmd,"EnrollDate",entity.EnrollDate);
  390. db.SetParameterValue(updateCmd,"Birthplace",entity.Birthplace);
  391. db.SetParameterValue(updateCmd,"FamOriId",entity.FamOriId);
  392. db.SetParameterValue(updateCmd,"PersonIngId",entity.PersonIngId);
  393. db.SetParameterValue(updateCmd,"PolityMemberId",entity.PolityMemberId);
  394. db.SetParameterValue(updateCmd,"CurrentpostId",entity.CurrentpostId);
  395. db.SetParameterValue(updateCmd,"Currentposttime",entity.Currentposttime);
  396. db.SetParameterValue(updateCmd,"FirstdegreeId",entity.FirstdegreeId);
  397. db.SetParameterValue(updateCmd,"Schoolspecial",entity.Schoolspecial);
  398. db.SetParameterValue(updateCmd,"CurrentdegreeId",entity.CurrentdegreeId);
  399. db.SetParameterValue(updateCmd,"StrongSuit",entity.StrongSuit);
  400. db.SetParameterValue(updateCmd,"DegreeId",entity.DegreeId);
  401. db.SetParameterValue(updateCmd,"TypicalLevel",entity.TypicalLevel);
  402. db.SetParameterValue(updateCmd,"IdentityTypeId",entity.IdentityTypeId);
  403. db.SetParameterValue(updateCmd,"ReadinessId",entity.ReadinessId);
  404. db.SetParameterValue(updateCmd,"Graduatefrom",entity.Graduatefrom);
  405. db.SetParameterValue(updateCmd,"TrainInfo",entity.TrainInfo);
  406. db.SetParameterValue(updateCmd,"TrainScore",entity.TrainScore);
  407. db.SetParameterValue(updateCmd,"TrainEva",entity.TrainEva);
  408. db.SetParameterValue(updateCmd,"AbilityEva",entity.AbilityEva);
  409. db.SetParameterValue(updateCmd,"Goodteacher",entity.Goodteacher);
  410. db.SetParameterValue(updateCmd,"Paper",entity.Paper);
  411. db.SetParameterValue(updateCmd,"Partyattended",entity.Partyattended);
  412. db.SetParameterValue(updateCmd,"Personlib",entity.Personlib);
  413. db.SetParameterValue(updateCmd,"Awardorpunish",entity.Awardorpunish);
  414. db.SetParameterValue(updateCmd,"Resume",entity.Resume);
  415. db.SetParameterValue(updateCmd,"Photo",entity.Photo);
  416. db.SetParameterValue(updateCmd,"UserPwd",entity.UserPwd);
  417. db.SetParameterValue(updateCmd,"FullName",entity.FullName);
  418. db.SetParameterValue(updateCmd,"Posttype",entity.Posttype);
  419. db.SetParameterValue(updateCmd,"Zcbm",entity.Zcbm);
  420. db.SetParameterValue(updateCmd,"Zgsf",entity.Zgsf);
  421. db.SetParameterValue(updateCmd,"Enabled",entity.Enabled);
  422. db.SetParameterValue(updateCmd,"State",entity.State);
  423. db.SetParameterValue(updateCmd,"UserId",entity.UserId);
  424. return updateCmd;
  425. }
  426. protected override DbCommand PopulateUpdateCommandParameters(Database db,DbCommand updateCmd,DataRow row)
  427. {
  428. db.SetParameterValue(updateCmd,"Useq",row["Useq"]);
  429. db.SetParameterValue(updateCmd,"LoginName",row["LoginName"]);
  430. db.SetParameterValue(updateCmd,"UserCode",row["UserCode"]);
  431. db.SetParameterValue(updateCmd,"ArmType",row["ArmType"]);
  432. db.SetParameterValue(updateCmd,"SpecialtyPhase",row["SpecialtyPhase"]);
  433. db.SetParameterValue(updateCmd,"BranchId",row["BranchId"]);
  434. db.SetParameterValue(updateCmd,"PersonId",row["PersonId"]);
  435. db.SetParameterValue(updateCmd,"PersonName",row["PersonName"]);
  436. db.SetParameterValue(updateCmd,"SexId",row["SexId"]);
  437. db.SetParameterValue(updateCmd,"ForkId",row["ForkId"]);
  438. db.SetParameterValue(updateCmd,"Birthday",row["Birthday"]);
  439. db.SetParameterValue(updateCmd,"EnrollDate",row["EnrollDate"]);
  440. db.SetParameterValue(updateCmd,"Birthplace",row["Birthplace"]);
  441. db.SetParameterValue(updateCmd,"FamOriId",row["FamOriId"]);
  442. db.SetParameterValue(updateCmd,"PersonIngId",row["PersonIngId"]);
  443. db.SetParameterValue(updateCmd,"PolityMemberId",row["PolityMemberId"]);
  444. db.SetParameterValue(updateCmd,"CurrentpostId",row["CurrentpostId"]);
  445. db.SetParameterValue(updateCmd,"Currentposttime",row["Currentposttime"]);
  446. db.SetParameterValue(updateCmd,"FirstdegreeId",row["FirstdegreeId"]);
  447. db.SetParameterValue(updateCmd,"Schoolspecial",row["Schoolspecial"]);
  448. db.SetParameterValue(updateCmd,"CurrentdegreeId",row["CurrentdegreeId"]);
  449. db.SetParameterValue(updateCmd,"StrongSuit",row["StrongSuit"]);
  450. db.SetParameterValue(updateCmd,"DegreeId",row["DegreeId"]);
  451. db.SetParameterValue(updateCmd,"TypicalLevel",row["TypicalLevel"]);
  452. db.SetParameterValue(updateCmd,"IdentityTypeId",row["IdentityTypeId"]);
  453. db.SetParameterValue(updateCmd,"ReadinessId",row["ReadinessId"]);
  454. db.SetParameterValue(updateCmd,"Graduatefrom",row["Graduatefrom"]);
  455. db.SetParameterValue(updateCmd,"TrainInfo",row["TrainInfo"]);
  456. db.SetParameterValue(updateCmd,"TrainScore",row["TrainScore"]);
  457. db.SetParameterValue(updateCmd,"TrainEva",row["TrainEva"]);
  458. db.SetParameterValue(updateCmd,"AbilityEva",row["AbilityEva"]);
  459. db.SetParameterValue(updateCmd,"Goodteacher",row["Goodteacher"]);
  460. db.SetParameterValue(updateCmd,"Paper",row["Paper"]);
  461. db.SetParameterValue(updateCmd,"Partyattended",row["Partyattended"]);
  462. db.SetParameterValue(updateCmd,"Personlib",row["Personlib"]);
  463. db.SetParameterValue(updateCmd,"Awardorpunish",row["Awardorpunish"]);
  464. db.SetParameterValue(updateCmd,"Resume",row["Resume"]);
  465. db.SetParameterValue(updateCmd,"Photo",row["Photo"]);
  466. db.SetParameterValue(updateCmd,"UserPwd",row["UserPwd"]);
  467. db.SetParameterValue(updateCmd,"FullName",row["FullName"]);
  468. db.SetParameterValue(updateCmd,"Posttype",row["Posttype"]);
  469. db.SetParameterValue(updateCmd,"Zcbm",row["Zcbm"]);
  470. db.SetParameterValue(updateCmd,"Zgsf",row["Zgsf"]);
  471. db.SetParameterValue(updateCmd,"Enabled",row["Enabled"]);
  472. db.SetParameterValue(updateCmd,"State",row["State"]);
  473. db.SetParameterValue(updateCmd,"UserId",row["UserId"]);
  474. return updateCmd;
  475. }
  476. protected override void PrepareDataAdapterCommand(Database db,out DbCommand dbInsertCommand,
  477. out DbCommand dbUpdateCommand,out DbCommand dbDeleteCommand)
  478. {
  479. dbInsertCommand = db.GetSqlStringCommand(SQL_INSERT);
  480. #region set insert cmd parameters
  481. db.AddInParameter(dbInsertCommand, "Useq",DbType.Int32, "USEQ", DataRowVersion.Current);
  482. db.AddInParameter(dbInsertCommand, "LoginName",DbType.AnsiString, "LOGIN_NAME", DataRowVersion.Current);
  483. db.AddInParameter(dbInsertCommand, "UserCode",DbType.AnsiString, "USER_CODE", DataRowVersion.Current);
  484. db.AddInParameter(dbInsertCommand, "ArmType",DbType.AnsiString, "ARM_TYPE", DataRowVersion.Current);
  485. db.AddInParameter(dbInsertCommand, "SpecialtyPhase",DbType.AnsiString, "SPECIALTY_PHASE", DataRowVersion.Current);
  486. db.AddInParameter(dbInsertCommand, "BranchId",DbType.AnsiString, "BRANCH_ID", DataRowVersion.Current);
  487. db.AddInParameter(dbInsertCommand, "PersonId",DbType.AnsiString, "PERSON_ID", DataRowVersion.Current);
  488. db.AddInParameter(dbInsertCommand, "PersonName",DbType.AnsiString, "PERSON_NAME", DataRowVersion.Current);
  489. db.AddInParameter(dbInsertCommand, "SexId",DbType.AnsiString, "SEX_ID", DataRowVersion.Current);
  490. db.AddInParameter(dbInsertCommand, "ForkId",DbType.AnsiString, "FORK_ID", DataRowVersion.Current);
  491. db.AddInParameter(dbInsertCommand, "Birthday",DbType.DateTime, "BIRTHDAY", DataRowVersion.Current);
  492. db.AddInParameter(dbInsertCommand, "EnrollDate",DbType.DateTime, "ENROLL_DATE", DataRowVersion.Current);
  493. db.AddInParameter(dbInsertCommand, "Birthplace",DbType.AnsiString, "BIRTHPLACE", DataRowVersion.Current);
  494. db.AddInParameter(dbInsertCommand, "FamOriId",DbType.AnsiString, "FAM_ORI_ID", DataRowVersion.Current);
  495. db.AddInParameter(dbInsertCommand, "PersonIngId",DbType.AnsiString, "PERSON_ING_ID", DataRowVersion.Current);
  496. db.AddInParameter(dbInsertCommand, "PolityMemberId",DbType.AnsiString, "POLITY_MEMBER_ID", DataRowVersion.Current);
  497. db.AddInParameter(dbInsertCommand, "CurrentpostId",DbType.AnsiString, "CURRENTPOST_ID", DataRowVersion.Current);
  498. db.AddInParameter(dbInsertCommand, "Currentposttime",DbType.AnsiString, "CURRENTPOSTTIME", DataRowVersion.Current);
  499. db.AddInParameter(dbInsertCommand, "FirstdegreeId",DbType.AnsiString, "FIRSTDEGREE_ID", DataRowVersion.Current);
  500. db.AddInParameter(dbInsertCommand, "Schoolspecial",DbType.AnsiString, "SCHOOLSPECIAL", DataRowVersion.Current);
  501. db.AddInParameter(dbInsertCommand, "CurrentdegreeId",DbType.AnsiString, "CURRENTDEGREE_ID", DataRowVersion.Current);
  502. db.AddInParameter(dbInsertCommand, "StrongSuit",DbType.AnsiString, "STRONG_SUIT", DataRowVersion.Current);
  503. db.AddInParameter(dbInsertCommand, "DegreeId",DbType.AnsiString, "DEGREE_ID", DataRowVersion.Current);
  504. db.AddInParameter(dbInsertCommand, "TypicalLevel",DbType.AnsiString, "TYPICAL_LEVEL", DataRowVersion.Current);
  505. db.AddInParameter(dbInsertCommand, "IdentityTypeId",DbType.AnsiString, "IDENTITY_TYPE_ID", DataRowVersion.Current);
  506. db.AddInParameter(dbInsertCommand, "ReadinessId",DbType.AnsiString, "READINESS_ID", DataRowVersion.Current);
  507. db.AddInParameter(dbInsertCommand, "Graduatefrom",DbType.AnsiString, "GRADUATEFROM", DataRowVersion.Current);
  508. db.AddInParameter(dbInsertCommand, "TrainInfo",DbType.AnsiString, "TRAIN_INFO", DataRowVersion.Current);
  509. db.AddInParameter(dbInsertCommand, "TrainScore",DbType.AnsiString, "TRAIN_SCORE", DataRowVersion.Current);
  510. db.AddInParameter(dbInsertCommand, "TrainEva",DbType.AnsiString, "TRAIN_EVA", DataRowVersion.Current);
  511. db.AddInParameter(dbInsertCommand, "AbilityEva",DbType.AnsiString, "ABILITY_EVA", DataRowVersion.Current);
  512. db.AddInParameter(dbInsertCommand, "Goodteacher",DbType.AnsiString, "GOODTEACHER", DataRowVersion.Current);
  513. db.AddInParameter(dbInsertCommand, "Paper",DbType.AnsiString, "PAPER", DataRowVersion.Current);
  514. db.AddInParameter(dbInsertCommand, "Partyattended",DbType.AnsiString, "PARTYATTENDED", DataRowVersion.Current);
  515. db.AddInParameter(dbInsertCommand, "Personlib",DbType.AnsiString, "PERSONLIB", DataRowVersion.Current);
  516. db.AddInParameter(dbInsertCommand, "Awardorpunish",DbType.AnsiString, "AWARDORPUNISH", DataRowVersion.Current);
  517. db.AddInParameter(dbInsertCommand, "Resume",DbType.AnsiString, "RESUME", DataRowVersion.Current);
  518. db.AddInParameter(dbInsertCommand, "Photo",DbType.AnsiString, "PHOTO", DataRowVersion.Current);
  519. db.AddInParameter(dbInsertCommand, "UserId",DbType.AnsiString, "USER_ID", DataRowVersion.Current);
  520. db.AddInParameter(dbInsertCommand, "UserPwd",DbType.AnsiString, "USER_PWD", DataRowVersion.Current);
  521. db.AddInParameter(dbInsertCommand, "FullName",DbType.AnsiString, "FULL_NAME", DataRowVersion.Current);
  522. db.AddInParameter(dbInsertCommand, "Posttype",DbType.AnsiString, "POSTTYPE", DataRowVersion.Current);
  523. db.AddInParameter(dbInsertCommand, "Zcbm",DbType.AnsiString, "ZCBM", DataRowVersion.Current);
  524. db.AddInParameter(dbInsertCommand, "Zgsf",DbType.AnsiString, "ZGSF", DataRowVersion.Current);
  525. db.AddInParameter(dbInsertCommand, "Enabled",DbType.AnsiString, "ENABLED", DataRowVersion.Current);
  526. db.AddInParameter(dbInsertCommand, "State",DbType.Int32, "STATE", DataRowVersion.Current);
  527. #endregion
  528. dbUpdateCommand = db.GetSqlStringCommand(SQL_UPDATE);
  529. #region Set update cmd value parameters
  530. db.AddInParameter(dbUpdateCommand, "Useq", DbType.Int32, "USEQ", DataRowVersion.Current);
  531. db.AddInParameter(dbUpdateCommand, "LoginName", DbType.AnsiString, "LOGIN_NAME", DataRowVersion.Current);
  532. db.AddInParameter(dbUpdateCommand, "UserCode", DbType.AnsiString, "USER_CODE", DataRowVersion.Current);
  533. db.AddInParameter(dbUpdateCommand, "ArmType", DbType.AnsiString, "ARM_TYPE", DataRowVersion.Current);
  534. db.AddInParameter(dbUpdateCommand, "SpecialtyPhase", DbType.AnsiString, "SPECIALTY_PHASE", DataRowVersion.Current);
  535. db.AddInParameter(dbUpdateCommand, "BranchId", DbType.AnsiString, "BRANCH_ID", DataRowVersion.Current);
  536. db.AddInParameter(dbUpdateCommand, "PersonId", DbType.AnsiString, "PERSON_ID", DataRowVersion.Current);
  537. db.AddInParameter(dbUpdateCommand, "PersonName", DbType.AnsiString, "PERSON_NAME", DataRowVersion.Current);
  538. db.AddInParameter(dbUpdateCommand, "SexId", DbType.AnsiString, "SEX_ID", DataRowVersion.Current);
  539. db.AddInParameter(dbUpdateCommand, "ForkId", DbType.AnsiString, "FORK_ID", DataRowVersion.Current);
  540. db.AddInParameter(dbUpdateCommand, "Birthday", DbType.DateTime, "BIRTHDAY", DataRowVersion.Current);
  541. db.AddInParameter(dbUpdateCommand, "EnrollDate", DbType.DateTime, "ENROLL_DATE", DataRowVersion.Current);
  542. db.AddInParameter(dbUpdateCommand, "Birthplace", DbType.AnsiString, "BIRTHPLACE", DataRowVersion.Current);
  543. db.AddInParameter(dbUpdateCommand, "FamOriId", DbType.AnsiString, "FAM_ORI_ID", DataRowVersion.Current);
  544. db.AddInParameter(dbUpdateCommand, "PersonIngId", DbType.AnsiString, "PERSON_ING_ID", DataRowVersion.Current);
  545. db.AddInParameter(dbUpdateCommand, "PolityMemberId", DbType.AnsiString, "POLITY_MEMBER_ID", DataRowVersion.Current);
  546. db.AddInParameter(dbUpdateCommand, "CurrentpostId", DbType.AnsiString, "CURRENTPOST_ID", DataRowVersion.Current);
  547. db.AddInParameter(dbUpdateCommand, "Currentposttime", DbType.AnsiString, "CURRENTPOSTTIME", DataRowVersion.Current);
  548. db.AddInParameter(dbUpdateCommand, "FirstdegreeId", DbType.AnsiString, "FIRSTDEGREE_ID", DataRowVersion.Current);
  549. db.AddInParameter(dbUpdateCommand, "Schoolspecial", DbType.AnsiString, "SCHOOLSPECIAL", DataRowVersion.Current);
  550. db.AddInParameter(dbUpdateCommand, "CurrentdegreeId", DbType.AnsiString, "CURRENTDEGREE_ID", DataRowVersion.Current);
  551. db.AddInParameter(dbUpdateCommand, "StrongSuit", DbType.AnsiString, "STRONG_SUIT", DataRowVersion.Current);
  552. db.AddInParameter(dbUpdateCommand, "DegreeId", DbType.AnsiString, "DEGREE_ID", DataRowVersion.Current);
  553. db.AddInParameter(dbUpdateCommand, "TypicalLevel", DbType.AnsiString, "TYPICAL_LEVEL", DataRowVersion.Current);
  554. db.AddInParameter(dbUpdateCommand, "IdentityTypeId", DbType.AnsiString, "IDENTITY_TYPE_ID", DataRowVersion.Current);
  555. db.AddInParameter(dbUpdateCommand, "ReadinessId", DbType.AnsiString, "READINESS_ID", DataRowVersion.Current);
  556. db.AddInParameter(dbUpdateCommand, "Graduatefrom", DbType.AnsiString, "GRADUATEFROM", DataRowVersion.Current);
  557. db.AddInParameter(dbUpdateCommand, "TrainInfo", DbType.AnsiString, "TRAIN_INFO", DataRowVersion.Current);
  558. db.AddInParameter(dbUpdateCommand, "TrainScore", DbType.AnsiString, "TRAIN_SCORE", DataRowVersion.Current);
  559. db.AddInParameter(dbUpdateCommand, "TrainEva", DbType.AnsiString, "TRAIN_EVA", DataRowVersion.Current);
  560. db.AddInParameter(dbUpdateCommand, "AbilityEva", DbType.AnsiString, "ABILITY_EVA", DataRowVersion.Current);
  561. db.AddInParameter(dbUpdateCommand, "Goodteacher", DbType.AnsiString, "GOODTEACHER", DataRowVersion.Current);
  562. db.AddInParameter(dbUpdateCommand, "Paper", DbType.AnsiString, "PAPER", DataRowVersion.Current);
  563. db.AddInParameter(dbUpdateCommand, "Partyattended", DbType.AnsiString, "PARTYATTENDED", DataRowVersion.Current);
  564. db.AddInParameter(dbUpdateCommand, "Personlib", DbType.AnsiString, "PERSONLIB", DataRowVersion.Current);
  565. db.AddInParameter(dbUpdateCommand, "Awardorpunish", DbType.AnsiString, "AWARDORPUNISH", DataRowVersion.Current);
  566. db.AddInParameter(dbUpdateCommand, "Resume", DbType.AnsiString, "RESUME", DataRowVersion.Current);
  567. db.AddInParameter(dbUpdateCommand, "Photo", DbType.AnsiString, "PHOTO", DataRowVersion.Current);
  568. db.AddInParameter(dbUpdateCommand, "UserPwd", DbType.AnsiString, "USER_PWD", DataRowVersion.Current);
  569. db.AddInParameter(dbUpdateCommand, "FullName", DbType.AnsiString, "FULL_NAME", DataRowVersion.Current);
  570. db.AddInParameter(dbUpdateCommand, "Posttype", DbType.AnsiString, "POSTTYPE", DataRowVersion.Current);
  571. db.AddInParameter(dbUpdateCommand, "Zcbm", DbType.AnsiString, "ZCBM", DataRowVersion.Current);
  572. db.AddInParameter(dbUpdateCommand, "Zgsf", DbType.AnsiString, "ZGSF", DataRowVersion.Current);
  573. db.AddInParameter(dbUpdateCommand, "Enabled", DbType.AnsiString, "ENABLED", DataRowVersion.Current);
  574. db.AddInParameter(dbUpdateCommand, "State", DbType.Int32, "STATE", DataRowVersion.Current);
  575. #endregion
  576. #region set update cmd pk where parameters
  577. db.AddInParameter(dbUpdateCommand, "UserId", DbType.AnsiString, "USER_ID", DataRowVersion.Current);
  578. #endregion
  579. dbDeleteCommand = db.GetSqlStringCommand(SQL_DELETE);
  580. #region set delete cmd pk where parameters
  581. db.AddInParameter(dbDeleteCommand, "UserId", DbType.AnsiString, "USER_ID", DataRowVersion.Current);
  582. #endregion
  583. }
  584. #endregion
  585. #region Delete?? Helper
  586. protected override DbCommand ConstructDeleteCommand(Database db)
  587. {
  588. DbCommand dbCommand=db.GetSqlStringCommand(SQL_DELETE);
  589. db.AddInParameter(dbCommand,"UserId",DbType.AnsiString);
  590. return dbCommand;
  591. }
  592. protected override DbCommand ConstructDeleteCommand(Database db,MoUsers entity)
  593. {
  594. DbCommand dbCommand=db.GetSqlStringCommand(SQL_DELETE);
  595. db.AddInParameter(dbCommand,"UserId",DbType.AnsiString,entity.UserId);
  596. return dbCommand;
  597. }
  598. protected override DbCommand ConstructDeleteCommandForWhere(Database db, string where)
  599. {
  600. return db.GetSqlStringCommand(SQL_DELETE_DEFAULT + where);
  601. }
  602. protected override DbCommand PopulateDeleteCommandParameters(Database db, DbCommand deleteCmd, MoUsers entity)
  603. {
  604. db.SetParameterValue(deleteCmd,"UserId",entity.UserId);
  605. return deleteCmd;
  606. }
  607. protected override DbCommand PopulateDeleteCommandParameters(Database db, DbCommand deleteCmd, DataRow row)
  608. {
  609. db.SetParameterValue(deleteCmd,"UserId",row["UserId"]);
  610. return deleteCmd;
  611. }
  612. #endregion helper
  613. #region Query?? Helper
  614. protected override DbCommand ConstructQueryCommand(string condition)
  615. {
  616. return db.GetSqlStringCommand(SQL_SELECT + condition);
  617. }
  618. #endregion
  619. #region GetEntity(s)?? Helper
  620. protected override DbCommand ConstructSelectOneCommand(Database db,MoUsers entity)
  621. {
  622. DbCommand dbCommand=db.GetSqlStringCommand(SQL_SELECT_ONE);
  623. db.AddInParameter(dbCommand,"UserId",DbType.AnsiString,entity.UserId);
  624. return dbCommand;
  625. }
  626. protected override void PopulateEntityByDataReader(IDataReader reader,ref MoUsers entity)
  627. {
  628. if (!reader.IsDBNull(0)) entity.Useq = reader.GetInt32(0);
  629. if (!reader.IsDBNull(1)) entity.LoginName = reader.GetString(1);
  630. if (!reader.IsDBNull(2)) entity.UserCode = reader.GetString(2);
  631. if (!reader.IsDBNull(3)) entity.ArmType = reader.GetString(3);
  632. if (!reader.IsDBNull(4)) entity.SpecialtyPhase = reader.GetString(4);
  633. if (!reader.IsDBNull(5)) entity.BranchId = reader.GetString(5);
  634. if (!reader.IsDBNull(6)) entity.PersonId = reader.GetString(6);
  635. if (!reader.IsDBNull(7)) entity.PersonName = reader.GetString(7);
  636. if (!reader.IsDBNull(8)) entity.SexId = reader.GetString(8);
  637. if (!reader.IsDBNull(9)) entity.ForkId = reader.GetString(9);
  638. if (!reader.IsDBNull(10)) entity.Birthday = reader.GetDateTime(10);
  639. if (!reader.IsDBNull(11)) entity.EnrollDate = reader.GetDateTime(11);
  640. if (!reader.IsDBNull(12)) entity.Birthplace = reader.GetString(12);
  641. if (!reader.IsDBNull(13)) entity.FamOriId = reader.GetString(13);
  642. if (!reader.IsDBNull(14)) entity.PersonIngId = reader.GetString(14);
  643. if (!reader.IsDBNull(15)) entity.PolityMemberId = reader.GetString(15);
  644. if (!reader.IsDBNull(16)) entity.CurrentpostId = reader.GetString(16);
  645. if (!reader.IsDBNull(17)) entity.Currentposttime = reader.GetString(17);
  646. if (!reader.IsDBNull(18)) entity.FirstdegreeId = reader.GetString(18);
  647. if (!reader.IsDBNull(19)) entity.Schoolspecial = reader.GetString(19);
  648. if (!reader.IsDBNull(20)) entity.CurrentdegreeId = reader.GetString(20);
  649. if (!reader.IsDBNull(21)) entity.StrongSuit = reader.GetString(21);
  650. if (!reader.IsDBNull(22)) entity.DegreeId = reader.GetString(22);
  651. if (!reader.IsDBNull(23)) entity.TypicalLevel = reader.GetString(23);
  652. if (!reader.IsDBNull(24)) entity.IdentityTypeId = reader.GetString(24);
  653. if (!reader.IsDBNull(25)) entity.ReadinessId = reader.GetString(25);
  654. if (!reader.IsDBNull(26)) entity.Graduatefrom = reader.GetString(26);
  655. if (!reader.IsDBNull(27)) entity.TrainInfo = reader.GetString(27);
  656. if (!reader.IsDBNull(28)) entity.TrainScore = reader.GetString(28);
  657. if (!reader.IsDBNull(29)) entity.TrainEva = reader.GetString(29);
  658. if (!reader.IsDBNull(30)) entity.AbilityEva = reader.GetString(30);
  659. if (!reader.IsDBNull(31)) entity.Goodteacher = reader.GetString(31);
  660. if (!reader.IsDBNull(32)) entity.Paper = reader.GetString(32);
  661. if (!reader.IsDBNull(33)) entity.Partyattended = reader.GetString(33);
  662. if (!reader.IsDBNull(34)) entity.Personlib = reader.GetString(34);
  663. if (!reader.IsDBNull(35)) entity.Awardorpunish = reader.GetString(35);
  664. if (!reader.IsDBNull(36)) entity.Resume = reader.GetString(36);
  665. if (!reader.IsDBNull(37)) entity.Photo = reader.GetString(37);
  666. if (!reader.IsDBNull(38)) entity.UserId = reader.GetString(38);
  667. if (!reader.IsDBNull(39)) entity.UserPwd = reader.GetString(39);
  668. if (!reader.IsDBNull(40)) entity.FullName = reader.GetString(40);
  669. if (!reader.IsDBNull(41)) entity.Posttype = reader.GetString(41);
  670. if (!reader.IsDBNull(42)) entity.Zcbm = reader.GetString(42);
  671. if (!reader.IsDBNull(43)) entity.Zgsf = reader.GetString(43);
  672. if (!reader.IsDBNull(44)) entity.Enabled = reader.GetString(44);
  673. if (!reader.IsDBNull(45)) entity.State = reader.GetInt32(45);
  674. }
  675. protected override DbCommand ConstructSelectConditionCommand(Database db, string condition)
  676. {
  677. return db.GetSqlStringCommand(SQL_SELECT + condition);
  678. }
  679. #endregion
  680. #region Count?? Helper
  681. protected override DbCommand ConstructCountCommand(Database db)
  682. {
  683. return db.GetSqlStringCommand(SQL_COUNT);
  684. }
  685. protected override DbCommand ConstructCountConditionCommand(Database db, string condition)
  686. {
  687. return db.GetSqlStringCommand(SQL_COUNT + condition);
  688. }
  689. #endregion
  690. #region IsExist?? Helper
  691. protected override DbCommand ConstructIsExistCommand(Database db, MoUsers entity)
  692. {
  693. DbCommand dbCommand = db.GetSqlStringCommand(SQL_EXIST);
  694. db.AddInParameter(dbCommand,"UserId",DbType.AnsiString,entity.UserId);
  695. return dbCommand;
  696. }
  697. #endregion
  698. }
  699. }
  700. #endregion