CcmAllDAL.cs 2.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using CoreFS.CA06;
  6. using System.Data;
  7. using System.Collections;
  8. using Core.Mes.Client.Common;
  9. using Core.LgMes.Client.lgDbMgt;
  10. namespace Core.LgMes.Client.lgServiceMgt.RtdDal.CcmDAL
  11. {
  12. public class CcmAllDAL : Core.LgMes.Client.lgServiceMgt.BaseService.LgBaseService
  13. {
  14. private const string SQL_STR_RTD_POINTCCM3NO1 = " select * from rtd_pointccm3no1 ";
  15. private const string SQL_STR_RTD_POINTCCM2NO1 = " select * from rtd_pointccm2no1 ";
  16. private const string SQL_STR_RTD_POINTCCM1NO1 = " select * from rtd_pointccm1no1 ";
  17. /// <summary>
  18. /// 返回rtd_pointccm3no1 数据集
  19. /// </summary>
  20. /// <param name="param"></param>
  21. /// <returns></returns>
  22. public DataSet GetRtdPointCcm3No1(ClientParamWithSqlConditionAndOpenBase param)
  23. {
  24. string sqlStr = SQL_STR_RTD_POINTCCM3NO1;
  25. DataSet ds = new DataSet();
  26. try
  27. {
  28. ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
  29. }
  30. catch
  31. {
  32. }
  33. return ds;
  34. }
  35. /// <summary>
  36. /// 返回rtd_pointccm2no1 数据集
  37. /// </summary>
  38. /// <param name="param"></param>
  39. /// <returns></returns>
  40. public DataSet GetRtdPointCcm2No1(ClientParamWithSqlConditionAndOpenBase param)
  41. {
  42. string sqlStr = SQL_STR_RTD_POINTCCM2NO1;
  43. DataSet ds = new DataSet();
  44. try
  45. {
  46. ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
  47. }
  48. catch
  49. {
  50. }
  51. return ds;
  52. }
  53. /// <summary>
  54. /// 返回rtd_pointccm1no1 数据集
  55. /// </summary>
  56. /// <param name="param"></param>
  57. /// <returns></returns>
  58. public DataSet GetRtdPointCcm1No1(ClientParamWithSqlConditionAndOpenBase param)
  59. {
  60. string sqlStr = SQL_STR_RTD_POINTCCM1NO1;
  61. DataSet ds = new DataSet();
  62. try
  63. {
  64. ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
  65. }
  66. catch
  67. {
  68. }
  69. return ds;
  70. }
  71. }
  72. }