| | |
| | | } |
| | | } |
| | | |
| | | //删除单据信息 |
| | | 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) |
| | | { |
| | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 编辑页面返回产品入库条码临时表信息 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Web/GetHBarCodeShowBillSub")] |
| | | [HttpGet] |
| | | public object GetHBarCodeShowBillSub(long HInterID, long HMaterID, Int64 HAuxPropID, string HMTONo, Int64 HWhID, Int64 HSPID, Int64 HSCWhID, Int64 HSCSPID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, string sBillType, string sWhere) |
| | | { |
| | | try |
| | | { |
| | | ds = webserver.GetBarCode_Temp(HInterID, HMaterID, HAuxPropID, HMTONo, HWhID, HSPID, HSCWhID, HSCSPID, HBatchNo, HSourceInterID, HSourceEntryID, sBillType, sWhere); |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没有返回任何记录!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning); |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "获取信息成功!"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没有返回任何记录!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | //点击编辑 公用窗体删除方法 |
| | | [Route("Kf_BarCodeEditDlg/DeltetBill")] |
| | | [HttpGet] |
| | | public object DeltetBill(long HInterID,string HBarCode,string HBillType) |
| | | { |
| | | string sErrMsg = string.Empty; |
| | | try |
| | | { |
| | | if (webserver.set_DelPonderationBillMain_Temp_BarCode(HInterID,HBarCode, HBillType, ref sErrMsg)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "删除成功!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "删除失败!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception) |
| | | { |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "删除失败!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 返回产品入库扫码明细 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | |
| | | |
| | | [Route("ProductIn/Delete_Json")] |
| | | [HttpGet] |
| | | public object Delete_Json(long HInterID, long HMaterID, long HAuxPropID, string HMTONo, long HSourceInterID, long HSourceEntryID, string sHBillType) |
| | | public object Delete_Json(long HInterID,string HBillNo,string HBillType,string HBarCode) |
| | | { |
| | | string sErrMsg = string.Empty; |
| | | try |
| | | { |
| | | if (webserver.set_DelPonderationBillMain_Temp_InterIDAndSource(HInterID, HMaterID, HAuxPropID, HMTONo, HSourceInterID, HSourceEntryID, sHBillType, ref sErrMsg)) |
| | | if (webserver.DeleteBill(HInterID, HBillNo, HBillType, HBarCode, ref sErrMsg)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "删除失败!"; |
| | | objJsonResult.Message = "删除失败!" ; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception) |
| | | catch (Exception e) |
| | | { |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "删除失败!"; |
| | | objJsonResult.Message = "删除失败!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | return false; |
| | | } |
| | | } |
| | | //删除单据临时表信息 |
| | | public bool DeleteBill(Int64 sHInterID,string HBillNo,string HBillType,string HBarCode, ref string sErrMsg) |
| | | { |
| | | DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl(); |
| | | if (dal.DeleteBill(sHInterID, HBillNo, HBillType, HBarCode)) |
| | | { |
| | | sErrMsg = "删除成功!"; |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "删除失败!"; |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | //public Model.ClsGy_BarCodeBill_WMS_Model_View get_InfoByBarCode_Source(string sBarCode, Int64 sInterID, ref bool sBool, ref string sErrMsg) |
| | | //{ |
| | | // SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | |
| | | // return null; |
| | | // } |
| | | //} |
| | | |
| | | |
| | | #endregion |
| | | |
| | | #region 外购入库 |
| | |
| | | } |
| | | #endregion |
| | | |
| | | //返回条码临时表 |
| | | /// <summary> |
| | | /// 返回条码临时表 |
| | | /// </summary> |
| | | public DataSet GetBarCode_Temp(long HInterID, long HMaterID, Int64 HAuxPropID, string HMTONo, Int64 HWhID, Int64 HSPID, Int64 HSCWhID, Int64 HSCSPID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, string sBillType, string sWhere) |
| | | { |
| | | DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); |
| | | return dal.GetBarCodeByID_View(HInterID, sBillType, HMaterID, HAuxPropID, HMTONo, HWhID, HSPID, HSCWhID, HSCSPID, HBatchNo, HSourceInterID, HSourceEntryID, sWhere); |
| | | } |
| | | |
| | | //删除出入库条码临时表(根据条码) |
| | | public bool set_DelPonderationBillMain_Temp_BarCode(long HInterID, string sBarCode, string sHBillType, ref string sErrMsg) |
| | | { |
| | | DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl(); |
| | | if (dal.DeleteByBarCode(HInterID, sBarCode, sHBillType)) |
| | | { |
| | | sErrMsg = "删除成功!"; |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "删除失败!"; |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 返回扫码明细信息 |
| | | /// </summary> |