| | |
| | | { |
| | | try |
| | | { |
| | | ds = oCn.RunProcReturn("select * from h_v_IF_MateOutBillList order by æ¥æ desc", "h_v_IF_MateOutBillList"); |
| | | ds = oCn.RunProcReturn("select * from h_v_IF_MateOutBillList " + sWhere + " order by æ¥æ desc", "h_v_IF_MateOutBillList"); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è¿åè®°å½æåï¼"; |
| | |
| | | /// <returns></returns> |
| | | [Route("Kf_MateOutBill/set_DeleteBill")] |
| | | [HttpGet] |
| | | public object set_DeleteBill(string HInterID,string user) |
| | | public object set_DeleteBill(string HInterID, string user) |
| | | { |
| | | //ç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log_second("Kf_MateOutBill_Delete", 1, true, user)) |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | if (oBill.omodel.HChecker != ""&& oBill.omodel.HChecker !=null) |
| | | if (oBill.omodel.HChecker != "" && oBill.omodel.HChecker != null) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | { |
| | | ds = oCN.RunProcReturn(string.Format(@"select HMaterID ,ç©æä»£ç HMaterCode ,ç©æåç§° HMaterName,è§æ ¼åå· HMaterSpec,HUnitID,计éåä½ä»£ç HUnitCode,计éåä½ HUnitName,åºæ¶æ°é HQtyMust,宿¶æ°é HQty,åä»· HPrice,éé¢ HMoney,HWHID,颿ä»åºä»£ç HWHCode,颿ä»åº HWHName,表ä½å¤æ³¨ HRemark |
| | | from h_v_IF_MateOutBillList"), "H_V_IF_MATEOUTBILLLIST"); |
| | | |
| | | |
| | | } |
| | | else |
| | | { |