SqlIDDef.cs 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. namespace Core.StlMes.Client.PlnSaleOrd.PlanStove
  6. {
  7. /// <summary>
  8. /// sqlid全名命名
  9. /// </summary>
  10. public class SqlIDDef
  11. {
  12. public struct MaterialChoose
  13. {
  14. public const string queryMaterial = "MaterialChoose.queryMaterial";
  15. public const string queryMaxProdIndex = "MaterialChoose.queryMaxProdIndex";
  16. public const string updateMaterial = "MaterialChoose.updateMaterial";
  17. public const string queryGP = "MaterialChoose.queryGP";
  18. public const string updateGP = "MaterialChoose.updateGP";
  19. public const string updateMaterialBack = "MaterialChoose.updateMaterialBack";
  20. public const string updateGPBack = "MaterialChoose.updateGPBack";
  21. public const string queryLOCKLIKU = "MaterialChoose.queryLOCKLIKU";
  22. public const string queryMaterialByStoveBatch = "MaterialChoose.queryMaterialByStoveBatch";
  23. public const string queryBindedMaterial = "MaterialChoose.queryBindedMaterial";
  24. public const string queryGPLOCKLIKU = "MaterialChoose.queryGPLOCKLIKU";
  25. public const string queryGPByStove = "MaterialChoose.queryGPByStove";
  26. public const string queryBindedGP="MaterialChoose.queryBindedGP";
  27. public const string updateMaterialBackWhenFinish="MaterialChoose.updateMaterialBackWhenFinish";
  28. }
  29. public struct PlanLuDBK
  30. {
  31. public const string queryZYDBK = "PlanLuDBK.queryZYDBK";
  32. public const string queryOrderDBK = "PlanLuDBK.queryOrderDBK";
  33. public const string insertZYDBK = "PlanLuDBK.insertZYDBK";
  34. public const string UpdateOrderDBK_WT_NUM = "PlanLuDBK.UpdateOrderDBK_WT_NUM";
  35. public const string queryMaxHeat_Plan_No = "PlanLuDBK.queryMaxHeat_Plan_No";
  36. public const string UpdateOrderDBK_WT_NUM_ENTITY = "PlanLuDBK.UpdateOrderDBK_WT_NUM_ENTITY";
  37. public const string deleteZyDbkM="PlanLuDBK.deleteZyDbkM";
  38. public const string UpdateOrderDBK_MATCH_WT_NUM = "PlanLuDBK.UpdateOrderDBK_MATCH_WT_NUM";
  39. public const string UpdateZYDBK_WT_NUM="PlanLuDBK.UpdateZYDBK_WT_NUM";
  40. }
  41. public struct PlanLuRCL
  42. {
  43. public const string queryOrderRCL = "PlanLuRCL.queryOrderRCL";
  44. public const string queryZyRCL = "PlanLuRCL.queryZyRCL";
  45. public const string AddNewRows = "PlanLuRCL.AddNewRows";
  46. public const string UpdateRCLORDER_WT_NUM = "PlanLuRCL.UpdateRCLORDER_WT_NUM";
  47. public const string queryMaxHeat_Plan_No = "PlanLuRCL.queryMaxHeat_Plan_No";
  48. public const string deleteZyRclM="PlanLuRCL.deleteZyRclM";
  49. public const string UpdateOrderRCL_MATCH_WT_NUM = "PlanLuRCL.UpdateOrderRCL_MATCH_WT_NUM";
  50. public const string UpdateZYRCL_WT_NUM = "PlanLuRCL.UpdateZYRCL_WT_NUM";
  51. }
  52. public struct PlanLuJGX
  53. {
  54. public const string queryZYJGXM= "PlanLuJGX.queryZYJGXM";
  55. public const string queryZYJGXC= "PlanLuJGX.queryZYJGXC";
  56. public const string queryOrderJGX= "PlanLuJGX.queryOrderJGX";
  57. public const string insertZYJGXM = "PlanLuJGX.insertZYJGXM";
  58. public const string insertZYJGXC = "PlanLuJGX.insertZYJGXC";
  59. public const string UpdateOrderJGX_WT_NUM = "PlanLuJGX.UpdateOrderJGX_WT_NUM";
  60. public const string queryMaxHeat_Plan_No = "PlanLuJGX.queryMaxHeat_Plan_No";
  61. public const string deleteZyJgxM = "PlanLuJGX.deleteZyJgxM";
  62. public const string deleteZyJgxC = "PlanLuJGX.deleteZyJgxC";
  63. public const string UpdateOrderJGX_MATCH_WT_NUM="PlanLuJGX.UpdateOrderJGX_MATCH_WT_NUM";
  64. public const string UpdateZYJGX_WT_NUM = "PlanLuJGX.UpdateZYJGX_WT_NUM";
  65. public const string UpdateZYJGXC_WT_NUM = "PlanLuZG.UpdateZYJGXC_WT_NUM";
  66. }
  67. public struct PlanLuZG
  68. {
  69. public const string queryZYZGM = "PlanLuZG.queryZYZGM";
  70. public const string queryZYZGC = "PlanLuZG.queryZYZGC";
  71. public const string queryOrderZG = "PlanLuZG.queryOrderZG";
  72. public const string insertZYZGM = "PlanLuZG.insertZYZGM";
  73. public const string insertZYZGC = "PlanLuZG.insertZYZGC";
  74. public const string UpdateOrderZG_WT_NUM = "PlanLuZG.UpdateOrderZG_WT_NUM";
  75. public const string queryMaxHeat_Plan_No = "PlanLuZG.queryMaxHeat_Plan_No";
  76. public const string deleteZyZgM = "PlanLuZG.deleteZyZgM";
  77. public const string deleteZyZgC = "PlanLuZG.deleteZyZgC";
  78. public const string UpdateOrderZG_MATCH_WT_NUM = "PlanLuZG.UpdateOrderZG_MATCH_WT_NUM";
  79. public const string UpdateZYZG_WT_NUM ="PlanLuZG.UpdateZYZG_WT_NUM";
  80. public const string queryInNumInOrder = "PlanLuZG.queryInNumInOrder";
  81. public const string UpdateZYZGC_GPWT_GPNUM="PlanLuZG.UpdateZYZGC_GPWT_GPNUM";
  82. public const string deleteZyZgCByCutNo = "PlanLuZG.deleteZyZgCByCutNo";
  83. }
  84. public struct StoveBase
  85. {
  86. public const string insertZYDBK = "StoveBase.insertZYDBK";
  87. public const string UpdateOrderRows = "StoveBase.UpdateOrderRows";
  88. public const string queryMaxHeat_Plan_No = "StoveBase.queryMaxHeat_Plan_No";
  89. public const string UpdateOrder_WT_NUM = "StoveBase.UpdateOrder_WT_NUM";
  90. public const string UpdatePlnStatus = "StoveBase.UpdatePlnStatus";
  91. public const string queryMaxProdIndex="StoveBase.queryMaxProdIndex";
  92. public const string queryCHECKJVAL="StoveBase.queryCHECKJVAL";
  93. public const string UpdateOrder_MatchIn_WT_NUM = "StoveBase.UpdateOrder_MatchIn_WT_NUM";
  94. public const string queryBatchMatch = "StoveBase.queryBatchMatch";
  95. public const string queryOrderStatus = "StoveBase.queryOrderStatus";
  96. public const string queryPlanStatus = "StoveBase.queryPlanStatus";
  97. }
  98. }
  99. }