| | |
| | | } |
| | | } |
| | | |
| | | ////删除单据信息 |
| | | //public bool DeleteBill(Int64 HInterID,long HMaterID,long HAuxPropID,string HMTONo,long HSourceInterID,long HSourceEntryID,string sHBillType) |
| | | //{ |
| | | // try |
| | | // { |
| | | // oCn.RunProc("Delete from " + MvarItemKey + " where HInterID=" + HInterID.ToString() + " and HMaterID= " + HMaterID.ToString() + " and HAuxPropID= " + HAuxPropID.ToString() + " and HMTONo='" + HMTONo + "' and HBillType='" + sHBillType + "' and HSourceInterID=" + HSourceInterID.ToString() + " and HSourceEntryID=" + HSourceEntryID.ToString() + " and HQty<>0 ", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | // return true; |
| | | // } |
| | | // catch (Exception e) |
| | | // { |
| | | // throw (e); |
| | | // } |
| | | //} |
| | | |
| | | //删除单据信息 |
| | | public bool DeleteBill(Int64 sHInterID, string HBillNo, string HBillType, string HBarCode) |
| | | { |
| | | try |
| | | { |
| | | oCn.RunProc("Delete from " + MvarItemKey + " where HInterID=" + sHInterID.ToString() + " and HBillNo='" + HBillNo.ToString() + "'and HBillType='" + HBillType + "'and HBarCode='" + HBarCode + "'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | throw (e); |
| | | } |
| | | } |
| | | |
| | | //新增 |
| | | public bool AddNew_sQty_FIFO(string sQty, ref string sReturn) |
| | | { |