10ddac9f29d149ea8154a0d370d716df307c8675.svn-base 2.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687
  1. package xin.glue.ui.G.G01;
  2. import com.posdata.glue.biz.constants.PosBizControlConstants;
  3. import com.posdata.glue.context.PosContext;
  4. import com.posdata.glue.dao.PosGenericDao;
  5. import com.posdata.glue.dao.vo.PosParameter;
  6. import com.posdata.glue.dao.vo.PosRow;
  7. import com.posdata.glue.dao.vo.PosRowSet;
  8. public class XTBGCreateMaterial {
  9. private PosGenericDao dao;
  10. private PosParameter param;
  11. private PosRowSet rowset;
  12. private PosRow row;
  13. public XTBGCreateMaterial(PosGenericDao dao){
  14. this.dao = dao;
  15. }
  16. public void CreateCharge(String chargeNo){
  17. param = new PosParameter();
  18. param.setValueParamter(0, chargeNo);
  19. dao.insert("XTBGCOMM_CREATE_CHARGE_INSERT_01", param);
  20. param = new PosParameter();
  21. param.setValueParamter(0, chargeNo);
  22. dao.insert("XTBGCOMM_CREATE_CHARGE_D_INSERT_01", param);
  23. }
  24. public void CreateSlab(String planSlabNo){
  25. param = new PosParameter();
  26. param.setValueParamter(0, planSlabNo);
  27. dao.insert("XTBGCOMM_CREATE_SLAB_INSERT_01", param);
  28. param = new PosParameter();
  29. param.setValueParamter(0, planSlabNo);
  30. dao.insert("XTBGCOMM_CREATE_SLAB_D_INSERT_01", param);
  31. /*
  32. param = new PosParameter();
  33. param.setWhereClauseParameter(0, planSlabNo);
  34. int udtcnt = dao.update("XTBGCOMM_CREATE_SLAB_UPDATE_01", param);
  35. if(udtcnt == 0){
  36. param = new PosParameter();
  37. param.setValueParamter(0, planSlabNo);
  38. dao.insert("XTBGCOMM_CREATE_SLAB_INSERT_01", param);
  39. }
  40. param = new PosParameter();
  41. param.setWhereClauseParameter(0, planSlabNo);
  42. udtcnt = dao.update("XTBGCOMM_CREATE_SLAB_D_UPDATE_01", param);
  43. if(udtcnt == 0){
  44. param = new PosParameter();
  45. param.setValueParamter(0, planSlabNo);
  46. dao.insert("XTBGCOMM_CREATE_SLAB_D_INSERT_01", param);
  47. }
  48. */
  49. }
  50. public void CreateSlab(String planSlabNo,String tag){
  51. param = new PosParameter();
  52. param.setValueParamter(0, planSlabNo);
  53. param.setValueParamter(1, planSlabNo);
  54. dao.insert("XTBGCOMM_CREATE_SLAB_INSERT_02", param);
  55. param = new PosParameter();
  56. param.setValueParamter(0, planSlabNo);
  57. param.setValueParamter(1, planSlabNo);
  58. dao.insert("XTBGCOMM_CREATE_SLAB_D_INSERT_02", param);
  59. }
  60. public String getSubSlabNo(PosContext context,String slabNo,String strandNo){
  61. String subSlabNo = null;
  62. if(strandNo == null || strandNo.equals("")){
  63. return "";
  64. }
  65. param = new PosParameter();
  66. param.setWhereClauseParameter(0, slabNo);
  67. param.setWhereClauseParameter(1, strandNo);
  68. rowset = dao.find("", param);
  69. if(rowset.hasNext()){
  70. PosRow row = rowset.next();
  71. }
  72. return subSlabNo;
  73. }
  74. }