SpsDbRoutines.cs 2.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Text;
  4. namespace Dfs.WayneChina.SpsDbManager
  5. {
  6. /// <summary>
  7. /// Routines in sps_db
  8. /// </summary>
  9. public class SpsDbRoutines
  10. {
  11. public static string VersionInfo = "VersionInfo";
  12. public static string RegisterTerminal = "RegisterReq";
  13. public static string GetCardAccountInfo = "AccountconfigInfoSelectByCardNo";
  14. public static string GetAllAuthInfo = "GetAllAuthInfo";
  15. public static string InitialData = "IniData";
  16. public static string Login = "Login";
  17. public static string StationConfigInfoSelect = "StationConfigInfoSelect";
  18. public static string GetPriceChangeConfig = "GetPriceChgCfg";
  19. public static string PumpInfo = "Pumpinfo";
  20. public static string GetAllTicketDisplayInfo = "GetallTicketDispinfo";
  21. public static string EquipId = "EquipId";
  22. public static string GetTankInfos = "GetTankInfos";
  23. public static string GetAllUsers = "Getalluser";
  24. public static string InsertTransaction = "TradeInfoinsert";
  25. public static string CheckIfCardIsBlacklisted = "ExistsCardNoInBlackCardInfo";
  26. public static string CheckCard = "CardReq";
  27. public static string InsertAuthInfo = "AuthInfoInsert";
  28. public static string CalculateDiscountedAmount = "DiscountData";
  29. public static string DeleteAuthInfo = "AuthInfoDelete";
  30. public static string CheckIfCardTrxExists = "GetFlag";
  31. public static string GetIcCardCredits = "IntegralDataIC";
  32. public static string UpdateCardInfo = "TradeInfoInsertCard";
  33. public static string FuelPriceConfig = "FuelListConfigInfoSelect";
  34. public static string UpdateVersionInfo = "CommonVersionInfoUpdate";
  35. public static string GetFuelPriceChange = "GetPriceChgCfg";
  36. public static string GetListedCards = "GetTheBlackCardNo";
  37. public static string GetAllPumpNozzleInfo = "PumpAllInfoSelect";
  38. public static string GetAllTankInfo = "GetTankInfos";
  39. public static string GetAllPosConfigInfo = "PosConfigAllInfoSelect";
  40. public static string GetAllNozzleInfo = "NozzleAllInfoSelect";
  41. public static string InsertPumpInfo = "PumpInfoInsert";
  42. public static string UpdatePumpInfo = "PumpInfoUpdate";
  43. public static string InsertNozzleInfo = "NozzleInfoInsert";
  44. public static string UpdateNozzleInfo = "NozzleInfoUpdate";
  45. public static string AddGrayInfo = "GrayInfoInsert";
  46. public static string ReleaseGrayCard = "FreeGrayCardBool";
  47. public static string SelectGrayInfo = "GrayCardSelect";
  48. }
  49. }