LgStlHmpOptinfoService.cs 1.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  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.LgResService
  11. {
  12. public class LgStlHmpOptinfoService : Core.LgMes.Client.lgServiceMgt.BaseService.LgBaseService
  13. {
  14. /// <summary>
  15. /// 获取脱硫站记录集合
  16. /// </summary>
  17. /// <param name="param">ClientParamWithSqlConditionAndOpenBase</param>
  18. /// <returns></returns>
  19. public DataSet returnDsOfHmpInfo(ClientParamWithSqlConditionAndOpenBase param)
  20. {
  21. DataSet ds = new DataSet();
  22. string sqlStr = "";
  23. try
  24. {
  25. sqlStr = LgSqlCollection.LgRes.LgHmpSql.LgHmpSql001.returnSqlOfStl_Hmp_Optinfo(param.sqlCondition);
  26. ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr,param.ob));
  27. }
  28. catch
  29. {
  30. }
  31. return ds;
  32. }
  33. /// <summary>
  34. /// 返回当前工作表中的脱硫数据,即从stl_hmp_optinfo 获取数据
  35. /// </summary>
  36. /// <param name="param"></param>
  37. /// <returns></returns>
  38. public DataSet returnDsOfHmpWorkingInfo(ClientParamWithSqlConditionAndOpenBase param)
  39. {
  40. DataSet ds = new DataSet();
  41. string sqlStr = "";
  42. try
  43. {
  44. sqlStr = LgSqlCollection.LgRes.LgHmpSql.LgHmpSql001.returnSqlOfStl_Hmp_Optinfo_Working(param.sqlCondition);
  45. ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
  46. }
  47. catch
  48. {
  49. }
  50. return ds;
  51. }
  52. }
  53. }