/Las/Las.Dal/DaLevelDeclare.auto.cs

http://sgsoft-las.googlecode.com/ · C# · 738 lines · 657 code · 60 blank · 21 comment · 44 complexity · 1f66b8f0b954eb12eb90133c972052ca MD5 · raw file

  1. #region DaLevelDeclare
  2. /*----------------------------------------------------------------
  3. // ????DaLevelDeclare.cs
  4. // ??????LevelDeclare??????
  5. //
  6. //
  7. // ?????2009-07-10 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. ///?????????,ILevelDeclare ,???????DaBase?
  26. ///DaBase????DbException????????
  27. public partial class DaLevelDeclare:DaBase<MoLevelDeclare>
  28. {
  29. #region SQL const
  30. internal const string TABLE_COLUMNS=" LEV_DCL_ID ,YEAR_NUM ,ITEM_TYPE ,ITEM_ID ,ITEM_NAME ,CLASS1 ,CLASS2 ,CLASS3 ,CLASS4 ,CLASS5 ,CLASS6 ,CLASS7 ,CLASS8 ,CLASS9 ,CLASS10 ,CLASS11 ,CLASS12 ,FROM_YEAR ,FROM_LEVEL ,TO_LEVEL ,APPROVE_LEV ,SBDW_ID ,SBDW_NAME ,SLDW_ID ,SBR_ID ,SBR_NAME ,SLDW_NAME ,SBSJ ,LEV_DCL_STATUS ,SCR_ID ,SCR_NAME ,SCSJ ,ASS_GRP_ID ,ASS_GRP_NAME ,ASS_GRP_SCORE ,KCR_ID ,KCR_NAME ,KCSJ ,PDR_ID ,PDR_NAME ,PDSJ ,ZGSCQK ,ZGSBQK ,DJKCQK ";
  31. internal const string SQL_INSERT="INSERT INTO LA_LEVEL_DECLARE ("+TABLE_COLUMNS+") VALUES (@LevDclId,@YearNum,@ItemType,@ItemId,@ItemName,@Class1,@Class2,@Class3,@Class4,@Class5,@Class6,@Class7,@Class8,@Class9,@Class10,@Class11,@Class12,@FromYear,@FromLevel,@ToLevel,@ApproveLev,@SbdwId,@SbdwName,@SldwId,@SbrId,@SbrName,@SldwName,@Sbsj,@LevDclStatus,@ScrId,@ScrName,@Scsj,@AssGrpId,@AssGrpName,@AssGrpScore,@KcrId,@KcrName,@Kcsj,@PdrId,@PdrName,@Pdsj,@Zgscqk,@Zgsbqk,@Djkcqk)";
  32. internal const string SQL_SELECT="SELECT "+TABLE_COLUMNS+" FROM LA_LEVEL_DECLARE ";
  33. internal const string SQL_SELECT_ONE=SQL_SELECT+" WHERE LEV_DCL_ID=@LevDclId";
  34. internal const string SQL_EXIST="SELECT COUNT(*) FROM LA_LEVEL_DECLARE WHERE LEV_DCL_ID=@LevDclId ";
  35. internal const string SQL_UPDATE="UPDATE LA_LEVEL_DECLARE SET YEAR_NUM=@YearNum, ITEM_TYPE=@ItemType, ITEM_ID=@ItemId, ITEM_NAME=@ItemName, CLASS1=@Class1, CLASS2=@Class2, CLASS3=@Class3, CLASS4=@Class4, CLASS5=@Class5, CLASS6=@Class6, CLASS7=@Class7, CLASS8=@Class8, CLASS9=@Class9, CLASS10=@Class10, CLASS11=@Class11, CLASS12=@Class12, FROM_YEAR=@FromYear, FROM_LEVEL=@FromLevel, TO_LEVEL=@ToLevel, APPROVE_LEV=@ApproveLev, SBDW_ID=@SbdwId, SBDW_NAME=@SbdwName, SLDW_ID=@SldwId, SBR_ID=@SbrId, SBR_NAME=@SbrName, SLDW_NAME=@SldwName, SBSJ=@Sbsj, LEV_DCL_STATUS=@LevDclStatus, SCR_ID=@ScrId, SCR_NAME=@ScrName, SCSJ=@Scsj, ASS_GRP_ID=@AssGrpId, ASS_GRP_NAME=@AssGrpName, ASS_GRP_SCORE=@AssGrpScore, KCR_ID=@KcrId, KCR_NAME=@KcrName, KCSJ=@Kcsj, PDR_ID=@PdrId, PDR_NAME=@PdrName, PDSJ=@Pdsj, ZGSCQK=@Zgscqk, ZGSBQK=@Zgsbqk, DJKCQK=@Djkcqk WHERE LEV_DCL_ID=@LevDclId";
  36. internal const string SQL_DELETE_DEFAULT = "DELETE FROM LA_LEVEL_DECLARE ";
  37. internal const string SQL_DELETE="DELETE FROM LA_LEVEL_DECLARE WHERE LEV_DCL_ID=@LevDclId";
  38. internal const string SQL_COUNT="SELECT COUNT(*) FROM LA_LEVEL_DECLARE";
  39. #endregion
  40. #region Constructor
  41. /// <summary>
  42. /// ???????????????????????
  43. /// </summary>
  44. public DaLevelDeclare ()
  45. {
  46. this.db=DatabaseFactory.CreateDatabase();
  47. }
  48. /// <summary>
  49. /// ?????databaseName??????
  50. /// </summary>
  51. /// <param name="databaseName">??????????????</param>
  52. public DaLevelDeclare (string databaseName)
  53. {
  54. this.db = DatabaseFactory.CreateDatabase(databaseName);
  55. }
  56. public DaLevelDeclare (Database db)
  57. {
  58. this.db = db;
  59. }
  60. #endregion
  61. //???CRUD??????????????????
  62. #region ?????
  63. protected override MoLevelDeclare ConstructT()
  64. {
  65. return new MoLevelDeclare();
  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,"LevDclId",DbType.AnsiString);
  74. db.AddInParameter(dbCommand,"YearNum",DbType.Int32);
  75. db.AddInParameter(dbCommand,"ItemType",DbType.Int32);
  76. db.AddInParameter(dbCommand,"ItemId",DbType.AnsiString);
  77. db.AddInParameter(dbCommand,"ItemName",DbType.String);
  78. db.AddInParameter(dbCommand,"Class1",DbType.AnsiString);
  79. db.AddInParameter(dbCommand,"Class2",DbType.AnsiString);
  80. db.AddInParameter(dbCommand,"Class3",DbType.AnsiString);
  81. db.AddInParameter(dbCommand,"Class4",DbType.AnsiString);
  82. db.AddInParameter(dbCommand,"Class5",DbType.AnsiString);
  83. db.AddInParameter(dbCommand,"Class6",DbType.AnsiString);
  84. db.AddInParameter(dbCommand,"Class7",DbType.AnsiString);
  85. db.AddInParameter(dbCommand,"Class8",DbType.AnsiString);
  86. db.AddInParameter(dbCommand,"Class9",DbType.AnsiString);
  87. db.AddInParameter(dbCommand,"Class10",DbType.AnsiString);
  88. db.AddInParameter(dbCommand,"Class11",DbType.AnsiString);
  89. db.AddInParameter(dbCommand,"Class12",DbType.AnsiString);
  90. db.AddInParameter(dbCommand,"FromYear",DbType.Int32);
  91. db.AddInParameter(dbCommand,"FromLevel",DbType.Int32);
  92. db.AddInParameter(dbCommand,"ToLevel",DbType.Int32);
  93. db.AddInParameter(dbCommand,"ApproveLev",DbType.Int32);
  94. db.AddInParameter(dbCommand,"SbdwId",DbType.AnsiString);
  95. db.AddInParameter(dbCommand,"SbdwName",DbType.String);
  96. db.AddInParameter(dbCommand,"SldwId",DbType.AnsiString);
  97. db.AddInParameter(dbCommand,"SbrId",DbType.AnsiString);
  98. db.AddInParameter(dbCommand,"SbrName",DbType.String);
  99. db.AddInParameter(dbCommand,"SldwName",DbType.String);
  100. db.AddInParameter(dbCommand,"Sbsj",DbType.DateTime);
  101. db.AddInParameter(dbCommand,"LevDclStatus",DbType.Int32);
  102. db.AddInParameter(dbCommand,"ScrId",DbType.AnsiString);
  103. db.AddInParameter(dbCommand,"ScrName",DbType.String);
  104. db.AddInParameter(dbCommand,"Scsj",DbType.DateTime);
  105. db.AddInParameter(dbCommand,"AssGrpId",DbType.AnsiString);
  106. db.AddInParameter(dbCommand,"AssGrpName",DbType.String);
  107. db.AddInParameter(dbCommand,"AssGrpScore",DbType.Int32);
  108. db.AddInParameter(dbCommand,"KcrId",DbType.AnsiString);
  109. db.AddInParameter(dbCommand,"KcrName",DbType.String);
  110. db.AddInParameter(dbCommand,"Kcsj",DbType.DateTime);
  111. db.AddInParameter(dbCommand,"PdrId",DbType.AnsiString);
  112. db.AddInParameter(dbCommand,"PdrName",DbType.String);
  113. db.AddInParameter(dbCommand,"Pdsj",DbType.DateTime);
  114. db.AddInParameter(dbCommand,"Zgscqk",DbType.String);
  115. db.AddInParameter(dbCommand,"Zgsbqk",DbType.String);
  116. db.AddInParameter(dbCommand,"Djkcqk",DbType.String);
  117. return dbCommand;
  118. }
  119. protected override DbCommand ConstructAddCommand(Database db,MoLevelDeclare entity)
  120. {
  121. DbCommand dbCommand=db.GetSqlStringCommand(SQL_INSERT);
  122. db.AddInParameter(dbCommand,"LevDclId",DbType.AnsiString,entity.LevDclId);
  123. db.AddInParameter(dbCommand,"YearNum",DbType.Int32,entity.YearNum);
  124. db.AddInParameter(dbCommand,"ItemType",DbType.Int32,entity.ItemType);
  125. db.AddInParameter(dbCommand,"ItemId",DbType.AnsiString,entity.ItemId);
  126. db.AddInParameter(dbCommand,"ItemName",DbType.String,entity.ItemName);
  127. db.AddInParameter(dbCommand,"Class1",DbType.AnsiString,entity.Class1);
  128. db.AddInParameter(dbCommand,"Class2",DbType.AnsiString,entity.Class2);
  129. db.AddInParameter(dbCommand,"Class3",DbType.AnsiString,entity.Class3);
  130. db.AddInParameter(dbCommand,"Class4",DbType.AnsiString,entity.Class4);
  131. db.AddInParameter(dbCommand,"Class5",DbType.AnsiString,entity.Class5);
  132. db.AddInParameter(dbCommand,"Class6",DbType.AnsiString,entity.Class6);
  133. db.AddInParameter(dbCommand,"Class7",DbType.AnsiString,entity.Class7);
  134. db.AddInParameter(dbCommand,"Class8",DbType.AnsiString,entity.Class8);
  135. db.AddInParameter(dbCommand,"Class9",DbType.AnsiString,entity.Class9);
  136. db.AddInParameter(dbCommand,"Class10",DbType.AnsiString,entity.Class10);
  137. db.AddInParameter(dbCommand,"Class11",DbType.AnsiString,entity.Class11);
  138. db.AddInParameter(dbCommand,"Class12",DbType.AnsiString,entity.Class12);
  139. db.AddInParameter(dbCommand,"FromYear",DbType.Int32,entity.FromYear);
  140. db.AddInParameter(dbCommand,"FromLevel",DbType.Int32,entity.FromLevel);
  141. db.AddInParameter(dbCommand,"ToLevel",DbType.Int32,entity.ToLevel);
  142. db.AddInParameter(dbCommand,"ApproveLev",DbType.Int32,entity.ApproveLev);
  143. db.AddInParameter(dbCommand,"SbdwId",DbType.AnsiString,entity.SbdwId);
  144. db.AddInParameter(dbCommand,"SbdwName",DbType.String,entity.SbdwName);
  145. db.AddInParameter(dbCommand,"SldwId",DbType.AnsiString,entity.SldwId);
  146. db.AddInParameter(dbCommand,"SbrId",DbType.AnsiString,entity.SbrId);
  147. db.AddInParameter(dbCommand,"SbrName",DbType.String,entity.SbrName);
  148. db.AddInParameter(dbCommand,"SldwName",DbType.String,entity.SldwName);
  149. db.AddInParameter(dbCommand,"Sbsj",DbType.DateTime,entity.Sbsj);
  150. db.AddInParameter(dbCommand,"LevDclStatus",DbType.Int32,entity.LevDclStatus);
  151. db.AddInParameter(dbCommand,"ScrId",DbType.AnsiString,entity.ScrId);
  152. db.AddInParameter(dbCommand,"ScrName",DbType.String,entity.ScrName);
  153. db.AddInParameter(dbCommand,"Scsj",DbType.DateTime,entity.Scsj);
  154. db.AddInParameter(dbCommand,"AssGrpId",DbType.AnsiString,entity.AssGrpId);
  155. db.AddInParameter(dbCommand,"AssGrpName",DbType.String,entity.AssGrpName);
  156. db.AddInParameter(dbCommand,"AssGrpScore",DbType.Int32,entity.AssGrpScore);
  157. db.AddInParameter(dbCommand,"KcrId",DbType.AnsiString,entity.KcrId);
  158. db.AddInParameter(dbCommand,"KcrName",DbType.String,entity.KcrName);
  159. db.AddInParameter(dbCommand,"Kcsj",DbType.DateTime,entity.Kcsj);
  160. db.AddInParameter(dbCommand,"PdrId",DbType.AnsiString,entity.PdrId);
  161. db.AddInParameter(dbCommand,"PdrName",DbType.String,entity.PdrName);
  162. db.AddInParameter(dbCommand,"Pdsj",DbType.DateTime,entity.Pdsj);
  163. db.AddInParameter(dbCommand,"Zgscqk",DbType.String,entity.Zgscqk);
  164. db.AddInParameter(dbCommand,"Zgsbqk",DbType.String,entity.Zgsbqk);
  165. db.AddInParameter(dbCommand,"Djkcqk",DbType.String,entity.Djkcqk);
  166. return dbCommand;
  167. }
  168. protected override DbCommand PopulateAddCommandParameters(Database db,DbCommand addCmd,MoLevelDeclare entity)
  169. {
  170. db.SetParameterValue(addCmd,"LevDclId",entity.LevDclId);
  171. db.SetParameterValue(addCmd,"YearNum",entity.YearNum);
  172. db.SetParameterValue(addCmd,"ItemType",entity.ItemType);
  173. db.SetParameterValue(addCmd,"ItemId",entity.ItemId);
  174. db.SetParameterValue(addCmd,"ItemName",entity.ItemName);
  175. db.SetParameterValue(addCmd,"Class1",entity.Class1);
  176. db.SetParameterValue(addCmd,"Class2",entity.Class2);
  177. db.SetParameterValue(addCmd,"Class3",entity.Class3);
  178. db.SetParameterValue(addCmd,"Class4",entity.Class4);
  179. db.SetParameterValue(addCmd,"Class5",entity.Class5);
  180. db.SetParameterValue(addCmd,"Class6",entity.Class6);
  181. db.SetParameterValue(addCmd,"Class7",entity.Class7);
  182. db.SetParameterValue(addCmd,"Class8",entity.Class8);
  183. db.SetParameterValue(addCmd,"Class9",entity.Class9);
  184. db.SetParameterValue(addCmd,"Class10",entity.Class10);
  185. db.SetParameterValue(addCmd,"Class11",entity.Class11);
  186. db.SetParameterValue(addCmd,"Class12",entity.Class12);
  187. db.SetParameterValue(addCmd,"FromYear",entity.FromYear);
  188. db.SetParameterValue(addCmd,"FromLevel",entity.FromLevel);
  189. db.SetParameterValue(addCmd,"ToLevel",entity.ToLevel);
  190. db.SetParameterValue(addCmd,"ApproveLev",entity.ApproveLev);
  191. db.SetParameterValue(addCmd,"SbdwId",entity.SbdwId);
  192. db.SetParameterValue(addCmd,"SbdwName",entity.SbdwName);
  193. db.SetParameterValue(addCmd,"SldwId",entity.SldwId);
  194. db.SetParameterValue(addCmd,"SbrId",entity.SbrId);
  195. db.SetParameterValue(addCmd,"SbrName",entity.SbrName);
  196. db.SetParameterValue(addCmd,"SldwName",entity.SldwName);
  197. db.SetParameterValue(addCmd,"Sbsj",entity.Sbsj);
  198. db.SetParameterValue(addCmd,"LevDclStatus",entity.LevDclStatus);
  199. db.SetParameterValue(addCmd,"ScrId",entity.ScrId);
  200. db.SetParameterValue(addCmd,"ScrName",entity.ScrName);
  201. db.SetParameterValue(addCmd,"Scsj",entity.Scsj);
  202. db.SetParameterValue(addCmd,"AssGrpId",entity.AssGrpId);
  203. db.SetParameterValue(addCmd,"AssGrpName",entity.AssGrpName);
  204. db.SetParameterValue(addCmd,"AssGrpScore",entity.AssGrpScore);
  205. db.SetParameterValue(addCmd,"KcrId",entity.KcrId);
  206. db.SetParameterValue(addCmd,"KcrName",entity.KcrName);
  207. db.SetParameterValue(addCmd,"Kcsj",entity.Kcsj);
  208. db.SetParameterValue(addCmd,"PdrId",entity.PdrId);
  209. db.SetParameterValue(addCmd,"PdrName",entity.PdrName);
  210. db.SetParameterValue(addCmd,"Pdsj",entity.Pdsj);
  211. db.SetParameterValue(addCmd,"Zgscqk",entity.Zgscqk);
  212. db.SetParameterValue(addCmd,"Zgsbqk",entity.Zgsbqk);
  213. db.SetParameterValue(addCmd,"Djkcqk",entity.Djkcqk);
  214. return addCmd;
  215. }
  216. protected override DbCommand PopulateAddCommandParameters(Database db,DbCommand addCmd,DataRow row)
  217. {
  218. db.SetParameterValue(addCmd,"LevDclId",row["LevDclId"]);
  219. db.SetParameterValue(addCmd,"YearNum",row["YearNum"]);
  220. db.SetParameterValue(addCmd,"ItemType",row["ItemType"]);
  221. db.SetParameterValue(addCmd,"ItemId",row["ItemId"]);
  222. db.SetParameterValue(addCmd,"ItemName",row["ItemName"]);
  223. db.SetParameterValue(addCmd,"Class1",row["Class1"]);
  224. db.SetParameterValue(addCmd,"Class2",row["Class2"]);
  225. db.SetParameterValue(addCmd,"Class3",row["Class3"]);
  226. db.SetParameterValue(addCmd,"Class4",row["Class4"]);
  227. db.SetParameterValue(addCmd,"Class5",row["Class5"]);
  228. db.SetParameterValue(addCmd,"Class6",row["Class6"]);
  229. db.SetParameterValue(addCmd,"Class7",row["Class7"]);
  230. db.SetParameterValue(addCmd,"Class8",row["Class8"]);
  231. db.SetParameterValue(addCmd,"Class9",row["Class9"]);
  232. db.SetParameterValue(addCmd,"Class10",row["Class10"]);
  233. db.SetParameterValue(addCmd,"Class11",row["Class11"]);
  234. db.SetParameterValue(addCmd,"Class12",row["Class12"]);
  235. db.SetParameterValue(addCmd,"FromYear",row["FromYear"]);
  236. db.SetParameterValue(addCmd,"FromLevel",row["FromLevel"]);
  237. db.SetParameterValue(addCmd,"ToLevel",row["ToLevel"]);
  238. db.SetParameterValue(addCmd,"ApproveLev",row["ApproveLev"]);
  239. db.SetParameterValue(addCmd,"SbdwId",row["SbdwId"]);
  240. db.SetParameterValue(addCmd,"SbdwName",row["SbdwName"]);
  241. db.SetParameterValue(addCmd,"SldwId",row["SldwId"]);
  242. db.SetParameterValue(addCmd,"SbrId",row["SbrId"]);
  243. db.SetParameterValue(addCmd,"SbrName",row["SbrName"]);
  244. db.SetParameterValue(addCmd,"SldwName",row["SldwName"]);
  245. db.SetParameterValue(addCmd,"Sbsj",row["Sbsj"]);
  246. db.SetParameterValue(addCmd,"LevDclStatus",row["LevDclStatus"]);
  247. db.SetParameterValue(addCmd,"ScrId",row["ScrId"]);
  248. db.SetParameterValue(addCmd,"ScrName",row["ScrName"]);
  249. db.SetParameterValue(addCmd,"Scsj",row["Scsj"]);
  250. db.SetParameterValue(addCmd,"AssGrpId",row["AssGrpId"]);
  251. db.SetParameterValue(addCmd,"AssGrpName",row["AssGrpName"]);
  252. db.SetParameterValue(addCmd,"AssGrpScore",row["AssGrpScore"]);
  253. db.SetParameterValue(addCmd,"KcrId",row["KcrId"]);
  254. db.SetParameterValue(addCmd,"KcrName",row["KcrName"]);
  255. db.SetParameterValue(addCmd,"Kcsj",row["Kcsj"]);
  256. db.SetParameterValue(addCmd,"PdrId",row["PdrId"]);
  257. db.SetParameterValue(addCmd,"PdrName",row["PdrName"]);
  258. db.SetParameterValue(addCmd,"Pdsj",row["Pdsj"]);
  259. db.SetParameterValue(addCmd,"Zgscqk",row["Zgscqk"]);
  260. db.SetParameterValue(addCmd,"Zgsbqk",row["Zgsbqk"]);
  261. db.SetParameterValue(addCmd,"Djkcqk",row["Djkcqk"]);
  262. return addCmd;
  263. }
  264. #endregion
  265. #region Update?? Helper
  266. protected override DbCommand ConstructUpdateCommand(Database db)
  267. {
  268. DbCommand dbCommand=db.GetSqlStringCommand(SQL_UPDATE);
  269. db.AddInParameter(dbCommand,"YearNum",DbType.Int32);
  270. db.AddInParameter(dbCommand,"ItemType",DbType.Int32);
  271. db.AddInParameter(dbCommand,"ItemId",DbType.AnsiString);
  272. db.AddInParameter(dbCommand,"ItemName",DbType.String);
  273. db.AddInParameter(dbCommand,"Class1",DbType.AnsiString);
  274. db.AddInParameter(dbCommand,"Class2",DbType.AnsiString);
  275. db.AddInParameter(dbCommand,"Class3",DbType.AnsiString);
  276. db.AddInParameter(dbCommand,"Class4",DbType.AnsiString);
  277. db.AddInParameter(dbCommand,"Class5",DbType.AnsiString);
  278. db.AddInParameter(dbCommand,"Class6",DbType.AnsiString);
  279. db.AddInParameter(dbCommand,"Class7",DbType.AnsiString);
  280. db.AddInParameter(dbCommand,"Class8",DbType.AnsiString);
  281. db.AddInParameter(dbCommand,"Class9",DbType.AnsiString);
  282. db.AddInParameter(dbCommand,"Class10",DbType.AnsiString);
  283. db.AddInParameter(dbCommand,"Class11",DbType.AnsiString);
  284. db.AddInParameter(dbCommand,"Class12",DbType.AnsiString);
  285. db.AddInParameter(dbCommand,"FromYear",DbType.Int32);
  286. db.AddInParameter(dbCommand,"FromLevel",DbType.Int32);
  287. db.AddInParameter(dbCommand,"ToLevel",DbType.Int32);
  288. db.AddInParameter(dbCommand,"ApproveLev",DbType.Int32);
  289. db.AddInParameter(dbCommand,"SbdwId",DbType.AnsiString);
  290. db.AddInParameter(dbCommand,"SbdwName",DbType.String);
  291. db.AddInParameter(dbCommand,"SldwId",DbType.AnsiString);
  292. db.AddInParameter(dbCommand,"SbrId",DbType.AnsiString);
  293. db.AddInParameter(dbCommand,"SbrName",DbType.String);
  294. db.AddInParameter(dbCommand,"SldwName",DbType.String);
  295. db.AddInParameter(dbCommand,"Sbsj",DbType.DateTime);
  296. db.AddInParameter(dbCommand,"LevDclStatus",DbType.Int32);
  297. db.AddInParameter(dbCommand,"ScrId",DbType.AnsiString);
  298. db.AddInParameter(dbCommand,"ScrName",DbType.String);
  299. db.AddInParameter(dbCommand,"Scsj",DbType.DateTime);
  300. db.AddInParameter(dbCommand,"AssGrpId",DbType.AnsiString);
  301. db.AddInParameter(dbCommand,"AssGrpName",DbType.String);
  302. db.AddInParameter(dbCommand,"AssGrpScore",DbType.Int32);
  303. db.AddInParameter(dbCommand,"KcrId",DbType.AnsiString);
  304. db.AddInParameter(dbCommand,"KcrName",DbType.String);
  305. db.AddInParameter(dbCommand,"Kcsj",DbType.DateTime);
  306. db.AddInParameter(dbCommand,"PdrId",DbType.AnsiString);
  307. db.AddInParameter(dbCommand,"PdrName",DbType.String);
  308. db.AddInParameter(dbCommand,"Pdsj",DbType.DateTime);
  309. db.AddInParameter(dbCommand,"Zgscqk",DbType.String);
  310. db.AddInParameter(dbCommand,"Zgsbqk",DbType.String);
  311. db.AddInParameter(dbCommand,"Djkcqk",DbType.String);
  312. db.AddInParameter(dbCommand,"LevDclId",DbType.AnsiString);
  313. return dbCommand;
  314. }
  315. protected override DbCommand ConstructUpdateCommand(Database db,MoLevelDeclare entity)
  316. {
  317. DbCommand dbCommand=db.GetSqlStringCommand(SQL_UPDATE);
  318. db.AddInParameter(dbCommand,"YearNum",DbType.Int32,entity.YearNum);
  319. db.AddInParameter(dbCommand,"ItemType",DbType.Int32,entity.ItemType);
  320. db.AddInParameter(dbCommand,"ItemId",DbType.AnsiString,entity.ItemId);
  321. db.AddInParameter(dbCommand,"ItemName",DbType.String,entity.ItemName);
  322. db.AddInParameter(dbCommand,"Class1",DbType.AnsiString,entity.Class1);
  323. db.AddInParameter(dbCommand,"Class2",DbType.AnsiString,entity.Class2);
  324. db.AddInParameter(dbCommand,"Class3",DbType.AnsiString,entity.Class3);
  325. db.AddInParameter(dbCommand,"Class4",DbType.AnsiString,entity.Class4);
  326. db.AddInParameter(dbCommand,"Class5",DbType.AnsiString,entity.Class5);
  327. db.AddInParameter(dbCommand,"Class6",DbType.AnsiString,entity.Class6);
  328. db.AddInParameter(dbCommand,"Class7",DbType.AnsiString,entity.Class7);
  329. db.AddInParameter(dbCommand,"Class8",DbType.AnsiString,entity.Class8);
  330. db.AddInParameter(dbCommand,"Class9",DbType.AnsiString,entity.Class9);
  331. db.AddInParameter(dbCommand,"Class10",DbType.AnsiString,entity.Class10);
  332. db.AddInParameter(dbCommand,"Class11",DbType.AnsiString,entity.Class11);
  333. db.AddInParameter(dbCommand,"Class12",DbType.AnsiString,entity.Class12);
  334. db.AddInParameter(dbCommand,"FromYear",DbType.Int32,entity.FromYear);
  335. db.AddInParameter(dbCommand,"FromLevel",DbType.Int32,entity.FromLevel);
  336. db.AddInParameter(dbCommand,"ToLevel",DbType.Int32,entity.ToLevel);
  337. db.AddInParameter(dbCommand,"ApproveLev",DbType.Int32,entity.ApproveLev);
  338. db.AddInParameter(dbCommand,"SbdwId",DbType.AnsiString,entity.SbdwId);
  339. db.AddInParameter(dbCommand,"SbdwName",DbType.String,entity.SbdwName);
  340. db.AddInParameter(dbCommand,"SldwId",DbType.AnsiString,entity.SldwId);
  341. db.AddInParameter(dbCommand,"SbrId",DbType.AnsiString,entity.SbrId);
  342. db.AddInParameter(dbCommand,"SbrName",DbType.String,entity.SbrName);
  343. db.AddInParameter(dbCommand,"SldwName",DbType.String,entity.SldwName);
  344. db.AddInParameter(dbCommand,"Sbsj",DbType.DateTime,entity.Sbsj);
  345. db.AddInParameter(dbCommand,"LevDclStatus",DbType.Int32,entity.LevDclStatus);
  346. db.AddInParameter(dbCommand,"ScrId",DbType.AnsiString,entity.ScrId);
  347. db.AddInParameter(dbCommand,"ScrName",DbType.String,entity.ScrName);
  348. db.AddInParameter(dbCommand,"Scsj",DbType.DateTime,entity.Scsj);
  349. db.AddInParameter(dbCommand,"AssGrpId",DbType.AnsiString,entity.AssGrpId);
  350. db.AddInParameter(dbCommand,"AssGrpName",DbType.String,entity.AssGrpName);
  351. db.AddInParameter(dbCommand,"AssGrpScore",DbType.Int32,entity.AssGrpScore);
  352. db.AddInParameter(dbCommand,"KcrId",DbType.AnsiString,entity.KcrId);
  353. db.AddInParameter(dbCommand,"KcrName",DbType.String,entity.KcrName);
  354. db.AddInParameter(dbCommand,"Kcsj",DbType.DateTime,entity.Kcsj);
  355. db.AddInParameter(dbCommand,"PdrId",DbType.AnsiString,entity.PdrId);
  356. db.AddInParameter(dbCommand,"PdrName",DbType.String,entity.PdrName);
  357. db.AddInParameter(dbCommand,"Pdsj",DbType.DateTime,entity.Pdsj);
  358. db.AddInParameter(dbCommand,"Zgscqk",DbType.String,entity.Zgscqk);
  359. db.AddInParameter(dbCommand,"Zgsbqk",DbType.String,entity.Zgsbqk);
  360. db.AddInParameter(dbCommand,"Djkcqk",DbType.String,entity.Djkcqk);
  361. db.AddInParameter(dbCommand,"LevDclId",DbType.AnsiString,entity.LevDclId);
  362. return dbCommand;
  363. }
  364. protected override DbCommand PopulateUpdateCommandParameters(Database db,DbCommand updateCmd,MoLevelDeclare entity)
  365. {
  366. db.SetParameterValue(updateCmd,"YearNum",entity.YearNum);
  367. db.SetParameterValue(updateCmd,"ItemType",entity.ItemType);
  368. db.SetParameterValue(updateCmd,"ItemId",entity.ItemId);
  369. db.SetParameterValue(updateCmd,"ItemName",entity.ItemName);
  370. db.SetParameterValue(updateCmd,"Class1",entity.Class1);
  371. db.SetParameterValue(updateCmd,"Class2",entity.Class2);
  372. db.SetParameterValue(updateCmd,"Class3",entity.Class3);
  373. db.SetParameterValue(updateCmd,"Class4",entity.Class4);
  374. db.SetParameterValue(updateCmd,"Class5",entity.Class5);
  375. db.SetParameterValue(updateCmd,"Class6",entity.Class6);
  376. db.SetParameterValue(updateCmd,"Class7",entity.Class7);
  377. db.SetParameterValue(updateCmd,"Class8",entity.Class8);
  378. db.SetParameterValue(updateCmd,"Class9",entity.Class9);
  379. db.SetParameterValue(updateCmd,"Class10",entity.Class10);
  380. db.SetParameterValue(updateCmd,"Class11",entity.Class11);
  381. db.SetParameterValue(updateCmd,"Class12",entity.Class12);
  382. db.SetParameterValue(updateCmd,"FromYear",entity.FromYear);
  383. db.SetParameterValue(updateCmd,"FromLevel",entity.FromLevel);
  384. db.SetParameterValue(updateCmd,"ToLevel",entity.ToLevel);
  385. db.SetParameterValue(updateCmd,"ApproveLev",entity.ApproveLev);
  386. db.SetParameterValue(updateCmd,"SbdwId",entity.SbdwId);
  387. db.SetParameterValue(updateCmd,"SbdwName",entity.SbdwName);
  388. db.SetParameterValue(updateCmd,"SldwId",entity.SldwId);
  389. db.SetParameterValue(updateCmd,"SbrId",entity.SbrId);
  390. db.SetParameterValue(updateCmd,"SbrName",entity.SbrName);
  391. db.SetParameterValue(updateCmd,"SldwName",entity.SldwName);
  392. db.SetParameterValue(updateCmd,"Sbsj",entity.Sbsj);
  393. db.SetParameterValue(updateCmd,"LevDclStatus",entity.LevDclStatus);
  394. db.SetParameterValue(updateCmd,"ScrId",entity.ScrId);
  395. db.SetParameterValue(updateCmd,"ScrName",entity.ScrName);
  396. db.SetParameterValue(updateCmd,"Scsj",entity.Scsj);
  397. db.SetParameterValue(updateCmd,"AssGrpId",entity.AssGrpId);
  398. db.SetParameterValue(updateCmd,"AssGrpName",entity.AssGrpName);
  399. db.SetParameterValue(updateCmd,"AssGrpScore",entity.AssGrpScore);
  400. db.SetParameterValue(updateCmd,"KcrId",entity.KcrId);
  401. db.SetParameterValue(updateCmd,"KcrName",entity.KcrName);
  402. db.SetParameterValue(updateCmd,"Kcsj",entity.Kcsj);
  403. db.SetParameterValue(updateCmd,"PdrId",entity.PdrId);
  404. db.SetParameterValue(updateCmd,"PdrName",entity.PdrName);
  405. db.SetParameterValue(updateCmd,"Pdsj",entity.Pdsj);
  406. db.SetParameterValue(updateCmd,"Zgscqk",entity.Zgscqk);
  407. db.SetParameterValue(updateCmd,"Zgsbqk",entity.Zgsbqk);
  408. db.SetParameterValue(updateCmd,"Djkcqk",entity.Djkcqk);
  409. db.SetParameterValue(updateCmd,"LevDclId",entity.LevDclId);
  410. return updateCmd;
  411. }
  412. protected override DbCommand PopulateUpdateCommandParameters(Database db,DbCommand updateCmd,DataRow row)
  413. {
  414. db.SetParameterValue(updateCmd,"YearNum",row["YearNum"]);
  415. db.SetParameterValue(updateCmd,"ItemType",row["ItemType"]);
  416. db.SetParameterValue(updateCmd,"ItemId",row["ItemId"]);
  417. db.SetParameterValue(updateCmd,"ItemName",row["ItemName"]);
  418. db.SetParameterValue(updateCmd,"Class1",row["Class1"]);
  419. db.SetParameterValue(updateCmd,"Class2",row["Class2"]);
  420. db.SetParameterValue(updateCmd,"Class3",row["Class3"]);
  421. db.SetParameterValue(updateCmd,"Class4",row["Class4"]);
  422. db.SetParameterValue(updateCmd,"Class5",row["Class5"]);
  423. db.SetParameterValue(updateCmd,"Class6",row["Class6"]);
  424. db.SetParameterValue(updateCmd,"Class7",row["Class7"]);
  425. db.SetParameterValue(updateCmd,"Class8",row["Class8"]);
  426. db.SetParameterValue(updateCmd,"Class9",row["Class9"]);
  427. db.SetParameterValue(updateCmd,"Class10",row["Class10"]);
  428. db.SetParameterValue(updateCmd,"Class11",row["Class11"]);
  429. db.SetParameterValue(updateCmd,"Class12",row["Class12"]);
  430. db.SetParameterValue(updateCmd,"FromYear",row["FromYear"]);
  431. db.SetParameterValue(updateCmd,"FromLevel",row["FromLevel"]);
  432. db.SetParameterValue(updateCmd,"ToLevel",row["ToLevel"]);
  433. db.SetParameterValue(updateCmd,"ApproveLev",row["ApproveLev"]);
  434. db.SetParameterValue(updateCmd,"SbdwId",row["SbdwId"]);
  435. db.SetParameterValue(updateCmd,"SbdwName",row["SbdwName"]);
  436. db.SetParameterValue(updateCmd,"SldwId",row["SldwId"]);
  437. db.SetParameterValue(updateCmd,"SbrId",row["SbrId"]);
  438. db.SetParameterValue(updateCmd,"SbrName",row["SbrName"]);
  439. db.SetParameterValue(updateCmd,"SldwName",row["SldwName"]);
  440. db.SetParameterValue(updateCmd,"Sbsj",row["Sbsj"]);
  441. db.SetParameterValue(updateCmd,"LevDclStatus",row["LevDclStatus"]);
  442. db.SetParameterValue(updateCmd,"ScrId",row["ScrId"]);
  443. db.SetParameterValue(updateCmd,"ScrName",row["ScrName"]);
  444. db.SetParameterValue(updateCmd,"Scsj",row["Scsj"]);
  445. db.SetParameterValue(updateCmd,"AssGrpId",row["AssGrpId"]);
  446. db.SetParameterValue(updateCmd,"AssGrpName",row["AssGrpName"]);
  447. db.SetParameterValue(updateCmd,"AssGrpScore",row["AssGrpScore"]);
  448. db.SetParameterValue(updateCmd,"KcrId",row["KcrId"]);
  449. db.SetParameterValue(updateCmd,"KcrName",row["KcrName"]);
  450. db.SetParameterValue(updateCmd,"Kcsj",row["Kcsj"]);
  451. db.SetParameterValue(updateCmd,"PdrId",row["PdrId"]);
  452. db.SetParameterValue(updateCmd,"PdrName",row["PdrName"]);
  453. db.SetParameterValue(updateCmd,"Pdsj",row["Pdsj"]);
  454. db.SetParameterValue(updateCmd,"Zgscqk",row["Zgscqk"]);
  455. db.SetParameterValue(updateCmd,"Zgsbqk",row["Zgsbqk"]);
  456. db.SetParameterValue(updateCmd,"Djkcqk",row["Djkcqk"]);
  457. db.SetParameterValue(updateCmd,"LevDclId",row["LevDclId"]);
  458. return updateCmd;
  459. }
  460. protected override void PrepareDataAdapterCommand(Database db,out DbCommand dbInsertCommand,
  461. out DbCommand dbUpdateCommand,out DbCommand dbDeleteCommand)
  462. {
  463. dbInsertCommand = db.GetSqlStringCommand(SQL_INSERT);
  464. #region set insert cmd parameters
  465. db.AddInParameter(dbInsertCommand, "LevDclId",DbType.AnsiString, "LEV_DCL_ID", DataRowVersion.Current);
  466. db.AddInParameter(dbInsertCommand, "YearNum",DbType.Int32, "YEAR_NUM", DataRowVersion.Current);
  467. db.AddInParameter(dbInsertCommand, "ItemType",DbType.Int32, "ITEM_TYPE", DataRowVersion.Current);
  468. db.AddInParameter(dbInsertCommand, "ItemId",DbType.AnsiString, "ITEM_ID", DataRowVersion.Current);
  469. db.AddInParameter(dbInsertCommand, "ItemName",DbType.String, "ITEM_NAME", DataRowVersion.Current);
  470. db.AddInParameter(dbInsertCommand, "Class1",DbType.AnsiString, "CLASS1", DataRowVersion.Current);
  471. db.AddInParameter(dbInsertCommand, "Class2",DbType.AnsiString, "CLASS2", DataRowVersion.Current);
  472. db.AddInParameter(dbInsertCommand, "Class3",DbType.AnsiString, "CLASS3", DataRowVersion.Current);
  473. db.AddInParameter(dbInsertCommand, "Class4",DbType.AnsiString, "CLASS4", DataRowVersion.Current);
  474. db.AddInParameter(dbInsertCommand, "Class5",DbType.AnsiString, "CLASS5", DataRowVersion.Current);
  475. db.AddInParameter(dbInsertCommand, "Class6",DbType.AnsiString, "CLASS6", DataRowVersion.Current);
  476. db.AddInParameter(dbInsertCommand, "Class7",DbType.AnsiString, "CLASS7", DataRowVersion.Current);
  477. db.AddInParameter(dbInsertCommand, "Class8",DbType.AnsiString, "CLASS8", DataRowVersion.Current);
  478. db.AddInParameter(dbInsertCommand, "Class9",DbType.AnsiString, "CLASS9", DataRowVersion.Current);
  479. db.AddInParameter(dbInsertCommand, "Class10",DbType.AnsiString, "CLASS10", DataRowVersion.Current);
  480. db.AddInParameter(dbInsertCommand, "Class11",DbType.AnsiString, "CLASS11", DataRowVersion.Current);
  481. db.AddInParameter(dbInsertCommand, "Class12",DbType.AnsiString, "CLASS12", DataRowVersion.Current);
  482. db.AddInParameter(dbInsertCommand, "FromYear",DbType.Int32, "FROM_YEAR", DataRowVersion.Current);
  483. db.AddInParameter(dbInsertCommand, "FromLevel",DbType.Int32, "FROM_LEVEL", DataRowVersion.Current);
  484. db.AddInParameter(dbInsertCommand, "ToLevel",DbType.Int32, "TO_LEVEL", DataRowVersion.Current);
  485. db.AddInParameter(dbInsertCommand, "ApproveLev",DbType.Int32, "APPROVE_LEV", DataRowVersion.Current);
  486. db.AddInParameter(dbInsertCommand, "SbdwId",DbType.AnsiString, "SBDW_ID", DataRowVersion.Current);
  487. db.AddInParameter(dbInsertCommand, "SbdwName",DbType.String, "SBDW_NAME", DataRowVersion.Current);
  488. db.AddInParameter(dbInsertCommand, "SldwId",DbType.AnsiString, "SLDW_ID", DataRowVersion.Current);
  489. db.AddInParameter(dbInsertCommand, "SbrId",DbType.AnsiString, "SBR_ID", DataRowVersion.Current);
  490. db.AddInParameter(dbInsertCommand, "SbrName",DbType.String, "SBR_NAME", DataRowVersion.Current);
  491. db.AddInParameter(dbInsertCommand, "SldwName",DbType.String, "SLDW_NAME", DataRowVersion.Current);
  492. db.AddInParameter(dbInsertCommand, "Sbsj",DbType.DateTime, "SBSJ", DataRowVersion.Current);
  493. db.AddInParameter(dbInsertCommand, "LevDclStatus",DbType.Int32, "LEV_DCL_STATUS", DataRowVersion.Current);
  494. db.AddInParameter(dbInsertCommand, "ScrId",DbType.AnsiString, "SCR_ID", DataRowVersion.Current);
  495. db.AddInParameter(dbInsertCommand, "ScrName",DbType.String, "SCR_NAME", DataRowVersion.Current);
  496. db.AddInParameter(dbInsertCommand, "Scsj",DbType.DateTime, "SCSJ", DataRowVersion.Current);
  497. db.AddInParameter(dbInsertCommand, "AssGrpId",DbType.AnsiString, "ASS_GRP_ID", DataRowVersion.Current);
  498. db.AddInParameter(dbInsertCommand, "AssGrpName",DbType.String, "ASS_GRP_NAME", DataRowVersion.Current);
  499. db.AddInParameter(dbInsertCommand, "AssGrpScore",DbType.Int32, "ASS_GRP_SCORE", DataRowVersion.Current);
  500. db.AddInParameter(dbInsertCommand, "KcrId",DbType.AnsiString, "KCR_ID", DataRowVersion.Current);
  501. db.AddInParameter(dbInsertCommand, "KcrName",DbType.String, "KCR_NAME", DataRowVersion.Current);
  502. db.AddInParameter(dbInsertCommand, "Kcsj",DbType.DateTime, "KCSJ", DataRowVersion.Current);
  503. db.AddInParameter(dbInsertCommand, "PdrId",DbType.AnsiString, "PDR_ID", DataRowVersion.Current);
  504. db.AddInParameter(dbInsertCommand, "PdrName",DbType.String, "PDR_NAME", DataRowVersion.Current);
  505. db.AddInParameter(dbInsertCommand, "Pdsj",DbType.DateTime, "PDSJ", DataRowVersion.Current);
  506. db.AddInParameter(dbInsertCommand, "Zgscqk",DbType.String, "ZGSCQK", DataRowVersion.Current);
  507. db.AddInParameter(dbInsertCommand, "Zgsbqk",DbType.String, "ZGSBQK", DataRowVersion.Current);
  508. db.AddInParameter(dbInsertCommand, "Djkcqk",DbType.String, "DJKCQK", DataRowVersion.Current);
  509. #endregion
  510. dbUpdateCommand = db.GetSqlStringCommand(SQL_UPDATE);
  511. #region Set update cmd value parameters
  512. db.AddInParameter(dbUpdateCommand, "YearNum", DbType.Int32, "YEAR_NUM", DataRowVersion.Current);
  513. db.AddInParameter(dbUpdateCommand, "ItemType", DbType.Int32, "ITEM_TYPE", DataRowVersion.Current);
  514. db.AddInParameter(dbUpdateCommand, "ItemId", DbType.AnsiString, "ITEM_ID", DataRowVersion.Current);
  515. db.AddInParameter(dbUpdateCommand, "ItemName", DbType.String, "ITEM_NAME", DataRowVersion.Current);
  516. db.AddInParameter(dbUpdateCommand, "Class1", DbType.AnsiString, "CLASS1", DataRowVersion.Current);
  517. db.AddInParameter(dbUpdateCommand, "Class2", DbType.AnsiString, "CLASS2", DataRowVersion.Current);
  518. db.AddInParameter(dbUpdateCommand, "Class3", DbType.AnsiString, "CLASS3", DataRowVersion.Current);
  519. db.AddInParameter(dbUpdateCommand, "Class4", DbType.AnsiString, "CLASS4", DataRowVersion.Current);
  520. db.AddInParameter(dbUpdateCommand, "Class5", DbType.AnsiString, "CLASS5", DataRowVersion.Current);
  521. db.AddInParameter(dbUpdateCommand, "Class6", DbType.AnsiString, "CLASS6", DataRowVersion.Current);
  522. db.AddInParameter(dbUpdateCommand, "Class7", DbType.AnsiString, "CLASS7", DataRowVersion.Current);
  523. db.AddInParameter(dbUpdateCommand, "Class8", DbType.AnsiString, "CLASS8", DataRowVersion.Current);
  524. db.AddInParameter(dbUpdateCommand, "Class9", DbType.AnsiString, "CLASS9", DataRowVersion.Current);
  525. db.AddInParameter(dbUpdateCommand, "Class10", DbType.AnsiString, "CLASS10", DataRowVersion.Current);
  526. db.AddInParameter(dbUpdateCommand, "Class11", DbType.AnsiString, "CLASS11", DataRowVersion.Current);
  527. db.AddInParameter(dbUpdateCommand, "Class12", DbType.AnsiString, "CLASS12", DataRowVersion.Current);
  528. db.AddInParameter(dbUpdateCommand, "FromYear", DbType.Int32, "FROM_YEAR", DataRowVersion.Current);
  529. db.AddInParameter(dbUpdateCommand, "FromLevel", DbType.Int32, "FROM_LEVEL", DataRowVersion.Current);
  530. db.AddInParameter(dbUpdateCommand, "ToLevel", DbType.Int32, "TO_LEVEL", DataRowVersion.Current);
  531. db.AddInParameter(dbUpdateCommand, "ApproveLev", DbType.Int32, "APPROVE_LEV", DataRowVersion.Current);
  532. db.AddInParameter(dbUpdateCommand, "SbdwId", DbType.AnsiString, "SBDW_ID", DataRowVersion.Current);
  533. db.AddInParameter(dbUpdateCommand, "SbdwName", DbType.String, "SBDW_NAME", DataRowVersion.Current);
  534. db.AddInParameter(dbUpdateCommand, "SldwId", DbType.AnsiString, "SLDW_ID", DataRowVersion.Current);
  535. db.AddInParameter(dbUpdateCommand, "SbrId", DbType.AnsiString, "SBR_ID", DataRowVersion.Current);
  536. db.AddInParameter(dbUpdateCommand, "SbrName", DbType.String, "SBR_NAME", DataRowVersion.Current);
  537. db.AddInParameter(dbUpdateCommand, "SldwName", DbType.String, "SLDW_NAME", DataRowVersion.Current);
  538. db.AddInParameter(dbUpdateCommand, "Sbsj", DbType.DateTime, "SBSJ", DataRowVersion.Current);
  539. db.AddInParameter(dbUpdateCommand, "LevDclStatus", DbType.Int32, "LEV_DCL_STATUS", DataRowVersion.Current);
  540. db.AddInParameter(dbUpdateCommand, "ScrId", DbType.AnsiString, "SCR_ID", DataRowVersion.Current);
  541. db.AddInParameter(dbUpdateCommand, "ScrName", DbType.String, "SCR_NAME", DataRowVersion.Current);
  542. db.AddInParameter(dbUpdateCommand, "Scsj", DbType.DateTime, "SCSJ", DataRowVersion.Current);
  543. db.AddInParameter(dbUpdateCommand, "AssGrpId", DbType.AnsiString, "ASS_GRP_ID", DataRowVersion.Current);
  544. db.AddInParameter(dbUpdateCommand, "AssGrpName", DbType.String, "ASS_GRP_NAME", DataRowVersion.Current);
  545. db.AddInParameter(dbUpdateCommand, "AssGrpScore", DbType.Int32, "ASS_GRP_SCORE", DataRowVersion.Current);
  546. db.AddInParameter(dbUpdateCommand, "KcrId", DbType.AnsiString, "KCR_ID", DataRowVersion.Current);
  547. db.AddInParameter(dbUpdateCommand, "KcrName", DbType.String, "KCR_NAME", DataRowVersion.Current);
  548. db.AddInParameter(dbUpdateCommand, "Kcsj", DbType.DateTime, "KCSJ", DataRowVersion.Current);
  549. db.AddInParameter(dbUpdateCommand, "PdrId", DbType.AnsiString, "PDR_ID", DataRowVersion.Current);
  550. db.AddInParameter(dbUpdateCommand, "PdrName", DbType.String, "PDR_NAME", DataRowVersion.Current);
  551. db.AddInParameter(dbUpdateCommand, "Pdsj", DbType.DateTime, "PDSJ", DataRowVersion.Current);
  552. db.AddInParameter(dbUpdateCommand, "Zgscqk", DbType.String, "ZGSCQK", DataRowVersion.Current);
  553. db.AddInParameter(dbUpdateCommand, "Zgsbqk", DbType.String, "ZGSBQK", DataRowVersion.Current);
  554. db.AddInParameter(dbUpdateCommand, "Djkcqk", DbType.String, "DJKCQK", DataRowVersion.Current);
  555. #endregion
  556. #region set update cmd pk where parameters
  557. db.AddInParameter(dbUpdateCommand, "LevDclId", DbType.AnsiString, "LEV_DCL_ID", DataRowVersion.Current);
  558. #endregion
  559. dbDeleteCommand = db.GetSqlStringCommand(SQL_DELETE);
  560. #region set delete cmd pk where parameters
  561. db.AddInParameter(dbDeleteCommand, "LevDclId", DbType.AnsiString, "LEV_DCL_ID", DataRowVersion.Current);
  562. #endregion
  563. }
  564. #endregion
  565. #region Delete?? Helper
  566. protected override DbCommand ConstructDeleteCommand(Database db)
  567. {
  568. DbCommand dbCommand=db.GetSqlStringCommand(SQL_DELETE);
  569. db.AddInParameter(dbCommand,"LevDclId",DbType.AnsiString);
  570. return dbCommand;
  571. }
  572. protected override DbCommand ConstructDeleteCommand(Database db,MoLevelDeclare entity)
  573. {
  574. DbCommand dbCommand=db.GetSqlStringCommand(SQL_DELETE);
  575. db.AddInParameter(dbCommand,"LevDclId",DbType.AnsiString,entity.LevDclId);
  576. return dbCommand;
  577. }
  578. protected override DbCommand ConstructDeleteCommandForWhere(Database db, string where)
  579. {
  580. return db.GetSqlStringCommand(SQL_DELETE_DEFAULT + where);
  581. }
  582. protected override DbCommand PopulateDeleteCommandParameters(Database db, DbCommand deleteCmd, MoLevelDeclare entity)
  583. {
  584. db.SetParameterValue(deleteCmd,"LevDclId",entity.LevDclId);
  585. return deleteCmd;
  586. }
  587. protected override DbCommand PopulateDeleteCommandParameters(Database db, DbCommand deleteCmd, DataRow row)
  588. {
  589. db.SetParameterValue(deleteCmd,"LevDclId",row["LevDclId"]);
  590. return deleteCmd;
  591. }
  592. #endregion helper
  593. #region Query?? Helper
  594. protected override DbCommand ConstructQueryCommand(string condition)
  595. {
  596. return db.GetSqlStringCommand(SQL_SELECT + condition);
  597. }
  598. #endregion
  599. #region GetEntity(s)?? Helper
  600. protected override DbCommand ConstructSelectOneCommand(Database db,MoLevelDeclare entity)
  601. {
  602. DbCommand dbCommand=db.GetSqlStringCommand(SQL_SELECT_ONE);
  603. db.AddInParameter(dbCommand,"LevDclId",DbType.AnsiString,entity.LevDclId);
  604. return dbCommand;
  605. }
  606. protected override void PopulateEntityByDataReader(IDataReader reader,ref MoLevelDeclare entity)
  607. {
  608. if (!reader.IsDBNull(0)) entity.LevDclId = reader.GetString(0);
  609. if (!reader.IsDBNull(1)) entity.YearNum = reader.GetInt32(1);
  610. if (!reader.IsDBNull(2)) entity.ItemType = reader.GetInt32(2);
  611. if (!reader.IsDBNull(3)) entity.ItemId = reader.GetString(3);
  612. if (!reader.IsDBNull(4)) entity.ItemName = reader.GetString(4);
  613. if (!reader.IsDBNull(5)) entity.Class1 = reader.GetString(5);
  614. if (!reader.IsDBNull(6)) entity.Class2 = reader.GetString(6);
  615. if (!reader.IsDBNull(7)) entity.Class3 = reader.GetString(7);
  616. if (!reader.IsDBNull(8)) entity.Class4 = reader.GetString(8);
  617. if (!reader.IsDBNull(9)) entity.Class5 = reader.GetString(9);
  618. if (!reader.IsDBNull(10)) entity.Class6 = reader.GetString(10);
  619. if (!reader.IsDBNull(11)) entity.Class7 = reader.GetString(11);
  620. if (!reader.IsDBNull(12)) entity.Class8 = reader.GetString(12);
  621. if (!reader.IsDBNull(13)) entity.Class9 = reader.GetString(13);
  622. if (!reader.IsDBNull(14)) entity.Class10 = reader.GetString(14);
  623. if (!reader.IsDBNull(15)) entity.Class11 = reader.GetString(15);
  624. if (!reader.IsDBNull(16)) entity.Class12 = reader.GetString(16);
  625. if (!reader.IsDBNull(17)) entity.FromYear = reader.GetInt32(17);
  626. if (!reader.IsDBNull(18)) entity.FromLevel = reader.GetInt32(18);
  627. if (!reader.IsDBNull(19)) entity.ToLevel = reader.GetInt32(19);
  628. if (!reader.IsDBNull(20)) entity.ApproveLev = reader.GetInt32(20);
  629. if (!reader.IsDBNull(21)) entity.SbdwId = reader.GetString(21);
  630. if (!reader.IsDBNull(22)) entity.SbdwName = reader.GetString(22);
  631. if (!reader.IsDBNull(23)) entity.SldwId = reader.GetString(23);
  632. if (!reader.IsDBNull(24)) entity.SbrId = reader.GetString(24);
  633. if (!reader.IsDBNull(25)) entity.SbrName = reader.GetString(25);
  634. if (!reader.IsDBNull(26)) entity.SldwName = reader.GetString(26);
  635. if (!reader.IsDBNull(27)) entity.Sbsj = reader.GetDateTime(27);
  636. if (!reader.IsDBNull(28)) entity.LevDclStatus = reader.GetInt32(28);
  637. if (!reader.IsDBNull(29)) entity.ScrId = reader.GetString(29);
  638. if (!reader.IsDBNull(30)) entity.ScrName = reader.GetString(30);
  639. if (!reader.IsDBNull(31)) entity.Scsj = reader.GetDateTime(31);
  640. if (!reader.IsDBNull(32)) entity.AssGrpId = reader.GetString(32);
  641. if (!reader.IsDBNull(33)) entity.AssGrpName = reader.GetString(33);
  642. if (!reader.IsDBNull(34)) entity.AssGrpScore = reader.GetInt32(34);
  643. if (!reader.IsDBNull(35)) entity.KcrId = reader.GetString(35);
  644. if (!reader.IsDBNull(36)) entity.KcrName = reader.GetString(36);
  645. if (!reader.IsDBNull(37)) entity.Kcsj = reader.GetDateTime(37);
  646. if (!reader.IsDBNull(38)) entity.PdrId = reader.GetString(38);
  647. if (!reader.IsDBNull(39)) entity.PdrName = reader.GetString(39);
  648. if (!reader.IsDBNull(40)) entity.Pdsj = reader.GetDateTime(40);
  649. if (!reader.IsDBNull(41)) entity.Zgscqk = reader.GetString(41);
  650. if (!reader.IsDBNull(42)) entity.Zgsbqk = reader.GetString(42);
  651. if (!reader.IsDBNull(43)) entity.Djkcqk = reader.GetString(43);
  652. }
  653. protected override DbCommand ConstructSelectConditionCommand(Database db, string condition)
  654. {
  655. return db.GetSqlStringCommand(SQL_SELECT + condition);
  656. }
  657. #endregion
  658. #region Count?? Helper
  659. protected override DbCommand ConstructCountCommand(Database db)
  660. {
  661. return db.GetSqlStringCommand(SQL_COUNT);
  662. }
  663. protected override DbCommand ConstructCountConditionCommand(Database db, string condition)
  664. {
  665. return db.GetSqlStringCommand(SQL_COUNT + condition);
  666. }
  667. #endregion
  668. #region IsExist?? Helper
  669. protected override DbCommand ConstructIsExistCommand(Database db, MoLevelDeclare entity)
  670. {
  671. DbCommand dbCommand = db.GetSqlStringCommand(SQL_EXIST);
  672. db.AddInParameter(dbCommand,"LevDclId",DbType.AnsiString,entity.LevDclId);
  673. return dbCommand;
  674. }
  675. #endregion
  676. }
  677. }
  678. #endregion