| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ProcPriceList where 1 = 1 " + sWhere, "h_v_Gy_ProcPriceList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ProcPriceList where 1 = 1 " + sWhere + " order by å¶åæ¥æ desc", "h_v_Gy_ProcPriceList"); |
| | | |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | |
| | | oSub.HMaker = DBUtility.ClsPub.isStrNull(mainList[0].HMaker); |
| | | oSub.HMakeDate = DateTime.Today.ToString(); |
| | | oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[i].HRemarkCol); |
| | | oSub.HWorkCenterID = DBUtility.ClsPub.isLong(subList[i].HWorkCenterID); |
| | | oSub.HWorkQty = DBUtility.ClsPub.isSingle(subList[i].HWorkQty); //å°æ¶äº§è½ |
| | | oSub.HStdEmp = DBUtility.ClsPub.isSingle(subList[i].HStdEmp); //æ å人å |
| | | oSub.HChangeTimes = DBUtility.ClsPub.isSingle(subList[i].HChangeTimes); //æ¢çº¿æ¶é´ |
| | | oSub.HChangeMoney = DBUtility.ClsPub.isSingle(subList[i].HChangeMoney); //æ¢çº¿è¡¥è´´ |
| | | oSub.HProcNo = DBUtility.ClsPub.isLong(subList[i].HProcNo); //å·¥èºè·¯çº¿æµæ°´å· |
| | | oSub.HPieceTimes = DBUtility.ClsPub.isSingle(subList[i].HPieceTimes); //åä»¶å å·¥æ¶é´ï¼å段å¯è½å·²ç»åå¨äºï¼ |
| | | oSub.HMouldQty = DBUtility.ClsPub.isSingle(subList[i].HMouldQty); //模å
·æ°é |
| | | oSub.HChangeMouldMoney = DBUtility.ClsPub.isSingle(subList[i].HChangeMouldMoney); //æ¢æ¨¡è¡¥è´´ |
| | | oSub.HRushQty = DBUtility.ClsPub.isSingle(subList[i].HRushQty); //å件岿¬¡æ¬¡æ° |
| | | |
| | | BillNew.DetailColl.Add(oSub); |
| | | } |
| | | else |