Brak opisu

T_Wiki_LawGuide.cs 22KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481
  1. using System;
  2. using System.Data;
  3. using System.Text;
  4. using System.Data.SqlClient;
  5. using CallCenterApi.DB;
  6. namespace CallCenterApi.DAL
  7. {
  8. /// <summary>
  9. /// 数据访问类:T_Wiki_LawGuide
  10. /// </summary>
  11. public partial class T_Wiki_LawGuide
  12. {
  13. public T_Wiki_LawGuide()
  14. { }
  15. #region BasicMethod
  16. /// <summary>
  17. /// 是否存在该记录
  18. /// </summary>
  19. public bool Exists(int F_Id)
  20. {
  21. StringBuilder strSql = new StringBuilder();
  22. strSql.Append("select count(1) from T_Wiki_LawGuide with(nolock)");
  23. strSql.Append(" where F_Id=@F_Id");
  24. SqlParameter[] parameters = {
  25. new SqlParameter("@F_Id", SqlDbType.Int,4)
  26. };
  27. parameters[0].Value = F_Id;
  28. return DbHelperSQL.Exists(strSql.ToString(), parameters);
  29. }
  30. /// <summary>
  31. /// 增加一条数据
  32. /// </summary>
  33. public int Add(CallCenterApi.Model.T_Wiki_LawGuide model)
  34. {
  35. StringBuilder strSql = new StringBuilder();
  36. strSql.Append("insert into T_Wiki_LawGuide(");
  37. strSql.Append("F_FaBuDanWei,F_FaBuRen,F_HangYe,F_DiQu,F_ShengXiaoShiJian,F_ShiXiaoShiJian,F_FaBuShiJian,F_Key,F_YeWuMingCheng,F_BiaoShiBianMa,F_ShenQingTiaoJian,F_ZhengCeYiJu,F_WangShangBanLiLianJie,F_File,F_BanLiCaiLiao,F_BanLiShiXian,F_BanLiDiDian,F_BanLiShiJian,F_BanLiDianHua,F_QiTaShuoMing,F_BanLiLiuCheng,F_BeiZhu,F_DianJiLiang,F_CreateUser,F_CreateTime,F_IsDelete,F_DeleteUser,F_DeleteTime)");
  38. strSql.Append(" values (");
  39. strSql.Append("@F_FaBuDanWei,@F_FaBuRen,@F_HangYe,@F_DiQu,@F_ShengXiaoShiJian,@F_ShiXiaoShiJian,@F_FaBuShiJian,@F_Key,@F_YeWuMingCheng,@F_BiaoShiBianMa,@F_ShenQingTiaoJian,@F_ZhengCeYiJu,@F_WangShangBanLiLianJie,@F_File,@F_BanLiCaiLiao,@F_BanLiShiXian,@F_BanLiDiDian,@F_BanLiShiJian,@F_BanLiDianHua,@F_QiTaShuoMing,@F_BanLiLiuCheng,@F_BeiZhu,@F_DianJiLiang,@F_CreateUser,@F_CreateTime,@F_IsDelete,@F_DeleteUser,@F_DeleteTime)");
  40. strSql.Append(";select @@IDENTITY");
  41. SqlParameter[] parameters = {
  42. new SqlParameter("@F_FaBuDanWei", SqlDbType.NVarChar,255),
  43. new SqlParameter("@F_FaBuRen", SqlDbType.NVarChar,50),
  44. new SqlParameter("@F_HangYe", SqlDbType.NVarChar,50),
  45. new SqlParameter("@F_DiQu", SqlDbType.NVarChar,50),
  46. new SqlParameter("@F_ShengXiaoShiJian", SqlDbType.DateTime),
  47. new SqlParameter("@F_ShiXiaoShiJian", SqlDbType.DateTime),
  48. new SqlParameter("@F_FaBuShiJian", SqlDbType.DateTime),
  49. new SqlParameter("@F_Key", SqlDbType.Int,4),
  50. new SqlParameter("@F_YeWuMingCheng", SqlDbType.NVarChar,50),
  51. new SqlParameter("@F_BiaoShiBianMa", SqlDbType.VarChar,50),
  52. new SqlParameter("@F_ShenQingTiaoJian", SqlDbType.NVarChar,255),
  53. new SqlParameter("@F_ZhengCeYiJu", SqlDbType.NVarChar,255),
  54. new SqlParameter("@F_WangShangBanLiLianJie", SqlDbType.VarChar,255),
  55. new SqlParameter("@F_File", SqlDbType.VarChar,500),
  56. new SqlParameter("@F_BanLiCaiLiao", SqlDbType.NVarChar,255),
  57. new SqlParameter("@F_BanLiShiXian", SqlDbType.NVarChar,50),
  58. new SqlParameter("@F_BanLiDiDian", SqlDbType.NVarChar,255),
  59. new SqlParameter("@F_BanLiShiJian", SqlDbType.DateTime),
  60. new SqlParameter("@F_BanLiDianHua", SqlDbType.VarChar,50),
  61. new SqlParameter("@F_QiTaShuoMing", SqlDbType.NVarChar,500),
  62. new SqlParameter("@F_BanLiLiuCheng", SqlDbType.NVarChar,500),
  63. new SqlParameter("@F_BeiZhu", SqlDbType.NVarChar,-1),
  64. new SqlParameter("@F_DianJiLiang", SqlDbType.BigInt,8),
  65. new SqlParameter("@F_CreateUser", SqlDbType.VarChar,50),
  66. new SqlParameter("@F_CreateTime", SqlDbType.DateTime),
  67. new SqlParameter("@F_IsDelete", SqlDbType.Int,4),
  68. new SqlParameter("@F_DeleteUser", SqlDbType.VarChar,50),
  69. new SqlParameter("@F_DeleteTime", SqlDbType.DateTime)};
  70. parameters[0].Value = model.F_FaBuDanWei;
  71. parameters[1].Value = model.F_FaBuRen;
  72. parameters[2].Value = model.F_HangYe;
  73. parameters[3].Value = model.F_DiQu;
  74. parameters[4].Value = model.F_ShengXiaoShiJian;
  75. parameters[5].Value = model.F_ShiXiaoShiJian;
  76. parameters[6].Value = model.F_FaBuShiJian;
  77. parameters[7].Value = model.F_Key;
  78. parameters[8].Value = model.F_YeWuMingCheng;
  79. parameters[9].Value = model.F_BiaoShiBianMa;
  80. parameters[10].Value = model.F_ShenQingTiaoJian;
  81. parameters[11].Value = model.F_ZhengCeYiJu;
  82. parameters[12].Value = model.F_WangShangBanLiLianJie;
  83. parameters[13].Value = model.F_File;
  84. parameters[14].Value = model.F_BanLiCaiLiao;
  85. parameters[15].Value = model.F_BanLiShiXian;
  86. parameters[16].Value = model.F_BanLiDiDian;
  87. parameters[17].Value = model.F_BanLiShiJian;
  88. parameters[18].Value = model.F_BanLiDianHua;
  89. parameters[19].Value = model.F_QiTaShuoMing;
  90. parameters[20].Value = model.F_BanLiLiuCheng;
  91. parameters[21].Value = model.F_BeiZhu;
  92. parameters[22].Value = model.F_DianJiLiang;
  93. parameters[23].Value = model.F_CreateUser;
  94. parameters[24].Value = model.F_CreateTime;
  95. parameters[25].Value = model.F_IsDelete;
  96. parameters[26].Value = model.F_DeleteUser;
  97. parameters[27].Value = model.F_DeleteTime;
  98. object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
  99. if (obj == null)
  100. {
  101. return 0;
  102. }
  103. else
  104. {
  105. return Convert.ToInt32(obj);
  106. }
  107. }
  108. /// <summary>
  109. /// 更新一条数据
  110. /// </summary>
  111. public bool Update(CallCenterApi.Model.T_Wiki_LawGuide model)
  112. {
  113. StringBuilder strSql = new StringBuilder();
  114. strSql.Append("update T_Wiki_LawGuide set ");
  115. strSql.Append("F_FaBuDanWei=@F_FaBuDanWei,");
  116. strSql.Append("F_FaBuRen=@F_FaBuRen,");
  117. strSql.Append("F_HangYe=@F_HangYe,");
  118. strSql.Append("F_DiQu=@F_DiQu,");
  119. strSql.Append("F_ShengXiaoShiJian=@F_ShengXiaoShiJian,");
  120. strSql.Append("F_ShiXiaoShiJian=@F_ShiXiaoShiJian,");
  121. strSql.Append("F_FaBuShiJian=@F_FaBuShiJian,");
  122. strSql.Append("F_Key=@F_Key,");
  123. strSql.Append("F_YeWuMingCheng=@F_YeWuMingCheng,");
  124. strSql.Append("F_BiaoShiBianMa=@F_BiaoShiBianMa,");
  125. strSql.Append("F_ShenQingTiaoJian=@F_ShenQingTiaoJian,");
  126. strSql.Append("F_ZhengCeYiJu=@F_ZhengCeYiJu,");
  127. strSql.Append("F_WangShangBanLiLianJie=@F_WangShangBanLiLianJie,");
  128. strSql.Append("F_File=@F_File,");
  129. strSql.Append("F_BanLiCaiLiao=@F_BanLiCaiLiao,");
  130. strSql.Append("F_BanLiShiXian=@F_BanLiShiXian,");
  131. strSql.Append("F_BanLiDiDian=@F_BanLiDiDian,");
  132. strSql.Append("F_BanLiShiJian=@F_BanLiShiJian,");
  133. strSql.Append("F_BanLiDianHua=@F_BanLiDianHua,");
  134. strSql.Append("F_QiTaShuoMing=@F_QiTaShuoMing,");
  135. strSql.Append("F_BanLiLiuCheng=@F_BanLiLiuCheng,");
  136. strSql.Append("F_BeiZhu=@F_BeiZhu,");
  137. strSql.Append("F_DianJiLiang=@F_DianJiLiang,");
  138. strSql.Append("F_CreateUser=@F_CreateUser,");
  139. strSql.Append("F_CreateTime=@F_CreateTime,");
  140. strSql.Append("F_IsDelete=@F_IsDelete,");
  141. strSql.Append("F_DeleteUser=@F_DeleteUser,");
  142. strSql.Append("F_DeleteTime=@F_DeleteTime");
  143. strSql.Append(" where F_Id=@F_Id");
  144. SqlParameter[] parameters = {
  145. new SqlParameter("@F_FaBuDanWei", SqlDbType.NVarChar,255),
  146. new SqlParameter("@F_FaBuRen", SqlDbType.NVarChar,50),
  147. new SqlParameter("@F_HangYe", SqlDbType.NVarChar,50),
  148. new SqlParameter("@F_DiQu", SqlDbType.NVarChar,50),
  149. new SqlParameter("@F_ShengXiaoShiJian", SqlDbType.DateTime),
  150. new SqlParameter("@F_ShiXiaoShiJian", SqlDbType.DateTime),
  151. new SqlParameter("@F_FaBuShiJian", SqlDbType.DateTime),
  152. new SqlParameter("@F_Key", SqlDbType.Int,4),
  153. new SqlParameter("@F_YeWuMingCheng", SqlDbType.NVarChar,50),
  154. new SqlParameter("@F_BiaoShiBianMa", SqlDbType.VarChar,50),
  155. new SqlParameter("@F_ShenQingTiaoJian", SqlDbType.NVarChar,255),
  156. new SqlParameter("@F_ZhengCeYiJu", SqlDbType.NVarChar,255),
  157. new SqlParameter("@F_WangShangBanLiLianJie", SqlDbType.VarChar,255),
  158. new SqlParameter("@F_File", SqlDbType.VarChar,500),
  159. new SqlParameter("@F_BanLiCaiLiao", SqlDbType.NVarChar,255),
  160. new SqlParameter("@F_BanLiShiXian", SqlDbType.NVarChar,50),
  161. new SqlParameter("@F_BanLiDiDian", SqlDbType.NVarChar,255),
  162. new SqlParameter("@F_BanLiShiJian", SqlDbType.DateTime),
  163. new SqlParameter("@F_BanLiDianHua", SqlDbType.VarChar,50),
  164. new SqlParameter("@F_QiTaShuoMing", SqlDbType.NVarChar,500),
  165. new SqlParameter("@F_BanLiLiuCheng", SqlDbType.NVarChar,500),
  166. new SqlParameter("@F_BeiZhu", SqlDbType.NVarChar,-1),
  167. new SqlParameter("@F_DianJiLiang", SqlDbType.BigInt,8),
  168. new SqlParameter("@F_CreateUser", SqlDbType.VarChar,50),
  169. new SqlParameter("@F_CreateTime", SqlDbType.DateTime),
  170. new SqlParameter("@F_IsDelete", SqlDbType.Int,4),
  171. new SqlParameter("@F_DeleteUser", SqlDbType.VarChar,50),
  172. new SqlParameter("@F_DeleteTime", SqlDbType.DateTime),
  173. new SqlParameter("@F_Id", SqlDbType.Int,4)};
  174. parameters[0].Value = model.F_FaBuDanWei;
  175. parameters[1].Value = model.F_FaBuRen;
  176. parameters[2].Value = model.F_HangYe;
  177. parameters[3].Value = model.F_DiQu;
  178. parameters[4].Value = model.F_ShengXiaoShiJian;
  179. parameters[5].Value = model.F_ShiXiaoShiJian;
  180. parameters[6].Value = model.F_FaBuShiJian;
  181. parameters[7].Value = model.F_Key;
  182. parameters[8].Value = model.F_YeWuMingCheng;
  183. parameters[9].Value = model.F_BiaoShiBianMa;
  184. parameters[10].Value = model.F_ShenQingTiaoJian;
  185. parameters[11].Value = model.F_ZhengCeYiJu;
  186. parameters[12].Value = model.F_WangShangBanLiLianJie;
  187. parameters[13].Value = model.F_File;
  188. parameters[14].Value = model.F_BanLiCaiLiao;
  189. parameters[15].Value = model.F_BanLiShiXian;
  190. parameters[16].Value = model.F_BanLiDiDian;
  191. parameters[17].Value = model.F_BanLiShiJian;
  192. parameters[18].Value = model.F_BanLiDianHua;
  193. parameters[19].Value = model.F_QiTaShuoMing;
  194. parameters[20].Value = model.F_BanLiLiuCheng;
  195. parameters[21].Value = model.F_BeiZhu;
  196. parameters[22].Value = model.F_DianJiLiang;
  197. parameters[23].Value = model.F_CreateUser;
  198. parameters[24].Value = model.F_CreateTime;
  199. parameters[25].Value = model.F_IsDelete;
  200. parameters[26].Value = model.F_DeleteUser;
  201. parameters[27].Value = model.F_DeleteTime;
  202. parameters[28].Value = model.F_Id;
  203. int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
  204. if (rows > 0)
  205. {
  206. return true;
  207. }
  208. else
  209. {
  210. return false;
  211. }
  212. }
  213. /// <summary>
  214. /// 删除一条数据
  215. /// </summary>
  216. public bool Delete(int F_Id)
  217. {
  218. StringBuilder strSql = new StringBuilder();
  219. strSql.Append("delete from T_Wiki_LawGuide ");
  220. strSql.Append(" where F_Id=@F_Id");
  221. SqlParameter[] parameters = {
  222. new SqlParameter("@F_Id", SqlDbType.Int,4)
  223. };
  224. parameters[0].Value = F_Id;
  225. int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
  226. if (rows > 0)
  227. {
  228. return true;
  229. }
  230. else
  231. {
  232. return false;
  233. }
  234. }
  235. /// <summary>
  236. /// 批量删除数据
  237. /// </summary>
  238. public bool DeleteList(string F_Idlist)
  239. {
  240. StringBuilder strSql = new StringBuilder();
  241. strSql.Append("delete from T_Wiki_LawGuide ");
  242. strSql.Append(" where F_Id in (" + F_Idlist + ") ");
  243. int rows = DbHelperSQL.ExecuteSql(strSql.ToString());
  244. if (rows > 0)
  245. {
  246. return true;
  247. }
  248. else
  249. {
  250. return false;
  251. }
  252. }
  253. /// <summary>
  254. /// 得到一个对象实体
  255. /// </summary>
  256. public CallCenterApi.Model.T_Wiki_LawGuide GetModel(int F_Id)
  257. {
  258. StringBuilder strSql = new StringBuilder();
  259. strSql.Append("select top 1 F_Id,F_FaBuDanWei,F_FaBuRen,F_HangYe,F_DiQu,F_ShengXiaoShiJian,F_ShiXiaoShiJian,F_FaBuShiJian,F_Key,F_YeWuMingCheng,F_BiaoShiBianMa,F_ShenQingTiaoJian,F_ZhengCeYiJu,F_WangShangBanLiLianJie,F_File,F_BanLiCaiLiao,F_BanLiShiXian,F_BanLiDiDian,F_BanLiShiJian,F_BanLiDianHua,F_QiTaShuoMing,F_BanLiLiuCheng,F_BeiZhu,F_DianJiLiang,F_CreateUser,F_CreateTime,F_IsDelete,F_DeleteUser,F_DeleteTime from T_Wiki_LawGuide with(nolock)");
  260. strSql.Append(" where F_Id=@F_Id");
  261. SqlParameter[] parameters = {
  262. new SqlParameter("@F_Id", SqlDbType.Int,4)
  263. };
  264. parameters[0].Value = F_Id;
  265. CallCenterApi.Model.T_Wiki_LawGuide model = new CallCenterApi.Model.T_Wiki_LawGuide();
  266. DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
  267. if (ds.Tables[0].Rows.Count > 0)
  268. {
  269. return DataRowToModel(ds.Tables[0].Rows[0]);
  270. }
  271. else
  272. {
  273. return null;
  274. }
  275. }
  276. /// <summary>
  277. /// 得到一个对象实体
  278. /// </summary>
  279. public CallCenterApi.Model.T_Wiki_LawGuide DataRowToModel(DataRow row)
  280. {
  281. CallCenterApi.Model.T_Wiki_LawGuide model = new CallCenterApi.Model.T_Wiki_LawGuide();
  282. if (row != null)
  283. {
  284. if (row["F_Id"] != null && row["F_Id"].ToString() != "")
  285. {
  286. model.F_Id = int.Parse(row["F_Id"].ToString());
  287. }
  288. if (row["F_FaBuDanWei"] != null)
  289. {
  290. model.F_FaBuDanWei = row["F_FaBuDanWei"].ToString();
  291. }
  292. if (row["F_FaBuRen"] != null)
  293. {
  294. model.F_FaBuRen = row["F_FaBuRen"].ToString();
  295. }
  296. if (row["F_HangYe"] != null)
  297. {
  298. model.F_HangYe = row["F_HangYe"].ToString();
  299. }
  300. if (row["F_DiQu"] != null)
  301. {
  302. model.F_DiQu = row["F_DiQu"].ToString();
  303. }
  304. if (row["F_ShengXiaoShiJian"] != null && row["F_ShengXiaoShiJian"].ToString() != "")
  305. {
  306. model.F_ShengXiaoShiJian = DateTime.Parse(row["F_ShengXiaoShiJian"].ToString());
  307. }
  308. if (row["F_ShiXiaoShiJian"] != null && row["F_ShiXiaoShiJian"].ToString() != "")
  309. {
  310. model.F_ShiXiaoShiJian = DateTime.Parse(row["F_ShiXiaoShiJian"].ToString());
  311. }
  312. if (row["F_FaBuShiJian"] != null && row["F_FaBuShiJian"].ToString() != "")
  313. {
  314. model.F_FaBuShiJian = DateTime.Parse(row["F_FaBuShiJian"].ToString());
  315. }
  316. if (row["F_Key"] != null && row["F_Key"].ToString() != "")
  317. {
  318. model.F_Key = int.Parse(row["F_Key"].ToString());
  319. }
  320. if (row["F_YeWuMingCheng"] != null)
  321. {
  322. model.F_YeWuMingCheng = row["F_YeWuMingCheng"].ToString();
  323. }
  324. if (row["F_BiaoShiBianMa"] != null)
  325. {
  326. model.F_BiaoShiBianMa = row["F_BiaoShiBianMa"].ToString();
  327. }
  328. if (row["F_ShenQingTiaoJian"] != null)
  329. {
  330. model.F_ShenQingTiaoJian = row["F_ShenQingTiaoJian"].ToString();
  331. }
  332. if (row["F_ZhengCeYiJu"] != null)
  333. {
  334. model.F_ZhengCeYiJu = row["F_ZhengCeYiJu"].ToString();
  335. }
  336. if (row["F_WangShangBanLiLianJie"] != null)
  337. {
  338. model.F_WangShangBanLiLianJie = row["F_WangShangBanLiLianJie"].ToString();
  339. }
  340. if (row["F_File"] != null)
  341. {
  342. model.F_File = row["F_File"].ToString();
  343. }
  344. if (row["F_BanLiCaiLiao"] != null)
  345. {
  346. model.F_BanLiCaiLiao = row["F_BanLiCaiLiao"].ToString();
  347. }
  348. if (row["F_BanLiShiXian"] != null)
  349. {
  350. model.F_BanLiShiXian = row["F_BanLiShiXian"].ToString();
  351. }
  352. if (row["F_BanLiDiDian"] != null)
  353. {
  354. model.F_BanLiDiDian = row["F_BanLiDiDian"].ToString();
  355. }
  356. if (row["F_BanLiShiJian"] != null && row["F_BanLiShiJian"].ToString() != "")
  357. {
  358. model.F_BanLiShiJian = DateTime.Parse(row["F_BanLiShiJian"].ToString());
  359. }
  360. if (row["F_BanLiDianHua"] != null)
  361. {
  362. model.F_BanLiDianHua = row["F_BanLiDianHua"].ToString();
  363. }
  364. if (row["F_QiTaShuoMing"] != null)
  365. {
  366. model.F_QiTaShuoMing = row["F_QiTaShuoMing"].ToString();
  367. }
  368. if (row["F_BanLiLiuCheng"] != null)
  369. {
  370. model.F_BanLiLiuCheng = row["F_BanLiLiuCheng"].ToString();
  371. }
  372. if (row["F_BeiZhu"] != null)
  373. {
  374. model.F_BeiZhu = row["F_BeiZhu"].ToString();
  375. }
  376. if (row["F_DianJiLiang"] != null && row["F_DianJiLiang"].ToString() != "")
  377. {
  378. model.F_DianJiLiang = long.Parse(row["F_DianJiLiang"].ToString());
  379. }
  380. if (row["F_CreateUser"] != null)
  381. {
  382. model.F_CreateUser = row["F_CreateUser"].ToString();
  383. }
  384. if (row["F_CreateTime"] != null && row["F_CreateTime"].ToString() != "")
  385. {
  386. model.F_CreateTime = DateTime.Parse(row["F_CreateTime"].ToString());
  387. }
  388. if (row["F_IsDelete"] != null && row["F_IsDelete"].ToString() != "")
  389. {
  390. model.F_IsDelete = int.Parse(row["F_IsDelete"].ToString());
  391. }
  392. if (row["F_DeleteUser"] != null)
  393. {
  394. model.F_DeleteUser = row["F_DeleteUser"].ToString();
  395. }
  396. if (row["F_DeleteTime"] != null && row["F_DeleteTime"].ToString() != "")
  397. {
  398. model.F_DeleteTime = DateTime.Parse(row["F_DeleteTime"].ToString());
  399. }
  400. }
  401. return model;
  402. }
  403. /// <summary>
  404. /// 获得数据列表
  405. /// </summary>
  406. public DataSet GetList(string strWhere)
  407. {
  408. StringBuilder strSql = new StringBuilder();
  409. strSql.Append("select F_Id,F_FaBuDanWei,F_FaBuRen,F_HangYe,F_DiQu,F_ShengXiaoShiJian,F_ShiXiaoShiJian,F_FaBuShiJian,F_Key,F_YeWuMingCheng,F_BiaoShiBianMa,F_ShenQingTiaoJian,F_ZhengCeYiJu,F_WangShangBanLiLianJie,F_File,F_BanLiCaiLiao,F_BanLiShiXian,F_BanLiDiDian,F_BanLiShiJian,F_BanLiDianHua,F_QiTaShuoMing,F_BanLiLiuCheng,F_BeiZhu,F_DianJiLiang,F_CreateUser,F_CreateTime,F_IsDelete,F_DeleteUser,F_DeleteTime ");
  410. strSql.Append(" FROM T_Wiki_LawGuide with(nolock)");
  411. if (strWhere.Trim() != "")
  412. {
  413. strSql.Append(" where " + strWhere);
  414. }
  415. return DbHelperSQL.Query(strSql.ToString());
  416. }
  417. /// <summary>
  418. /// 获得前几行数据
  419. /// </summary>
  420. public DataSet GetList(int Top, string strWhere, string filedOrder)
  421. {
  422. StringBuilder strSql = new StringBuilder();
  423. strSql.Append("select ");
  424. if (Top > 0)
  425. {
  426. strSql.Append(" top " + Top.ToString());
  427. }
  428. strSql.Append(" F_Id,F_FaBuDanWei,F_FaBuRen,F_HangYe,F_DiQu,F_ShengXiaoShiJian,F_ShiXiaoShiJian,F_FaBuShiJian,F_Key,F_YeWuMingCheng,F_BiaoShiBianMa,F_ShenQingTiaoJian,F_ZhengCeYiJu,F_WangShangBanLiLianJie,F_File,F_BanLiCaiLiao,F_BanLiShiXian,F_BanLiDiDian,F_BanLiShiJian,F_BanLiDianHua,F_QiTaShuoMing,F_BanLiLiuCheng,F_BeiZhu,F_DianJiLiang,F_CreateUser,F_CreateTime,F_IsDelete,F_DeleteUser,F_DeleteTime ");
  429. strSql.Append(" FROM T_Wiki_LawGuide with(nolock)");
  430. if (strWhere.Trim() != "")
  431. {
  432. strSql.Append(" where " + strWhere);
  433. }
  434. strSql.Append(" order by " + filedOrder);
  435. return DbHelperSQL.Query(strSql.ToString());
  436. }
  437. /// <summary>
  438. /// 获取记录总数
  439. /// </summary>
  440. public int GetRecordCount(string strWhere)
  441. {
  442. StringBuilder strSql = new StringBuilder();
  443. strSql.Append("select count(1) FROM T_Wiki_LawGuide with(nolock)");
  444. if (strWhere.Trim() != "")
  445. {
  446. strSql.Append(" where " + strWhere);
  447. }
  448. object obj = DbHelperSQL.GetSingle(strSql.ToString());
  449. if (obj == null)
  450. {
  451. return 0;
  452. }
  453. else
  454. {
  455. return Convert.ToInt32(obj);
  456. }
  457. }
  458. #endregion BasicMethod
  459. }
  460. }