using System; using System.Collections.Generic; using System.Text; using System.Data; namespace DAL { public class ClsKF_PonderationBillMain_Temp_View : DBUtility.ClsGy_Base_View { // public Model.ClsKF_PonderationBillMain_Temp omodel = new Model.ClsKF_PonderationBillMain_Temp(); SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); public ClsKF_PonderationBillMain_Temp_View() { base.MvarReportTitle = "出入库条码临时表"; base.MvarItemKey = "KF_PonderationBillMain_Temp"; base.SQLName = "Select HItemID from KF_PonderationBillMain_Temp Order by HItemID "; } // public void Dispose() { GC.SuppressFinalize(this); } // #region 单据列表数据处理 //显示物料明细列表、模治具列表、先进先出列表信息 public DataSet GetBillEntry_TmpList(long HInterID, string HBillNo, string HBillType, ref string sMouldManagerCtl, ref string sFIFOCtl, ref string sErrMsg) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); string sSimpleMode = "N"; //是否启用扫码简易模式，只显示已扫码源单记录(Y,N) //获取系统参数 Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); if (oSystemParameter.ShowBill(ref sErrMsg) == false) { sErrMsg = "单据号：" + HBillNo + "，单据ID：" + HInterID + "；返回物料明细列表时获取系统参数失败！ " + sErrMsg; return null; } //判断是否启用器具管理(Y,N) if (oSystemParameter.omodel.WMS_MouldManagerCtl == "Y") //启用模治具管理 { sMouldManagerCtl = "Y"; } //判断是否启用先进先出管理(Y,N)，是否启用扫码简易模式，只显示已扫码源单记录(Y,N) if (HBillType == "1204") //生产领料单 { if (oSystemParameter.omodel.Kf_MateOutBill_FIFOCtl == "Y") //生产领料单-先进先出控制 { sFIFOCtl = "Y"; } if (oSystemParameter.omodel.Kf_MateOutBill_SimpleMode == "Y") //生产领料单-扫码简易模式 { sSimpleMode = "Y"; } } if (HBillType == "1205" && oSystemParameter.omodel.Kf_SellOutBill_FIFOCtl == "Y") //销售出库单-先进先出控制 { sFIFOCtl = "Y"; } if (HBillType == "1211" && oSystemParameter.omodel.Kf_EntrustOutBill_FIFOCtl == "Y") //委外出库单-先进先出控制 { sFIFOCtl = "Y"; } DataSet DS = oCn.RunProcReturn("exec h_p_WMS_BillEntryTmpList " + HInterID.ToString() + ",'" + HBillType + "','" + sMouldManagerCtl + "','" + sFIFOCtl + "','" + sSimpleMode + "'", "h_p_WMS_BillEntryTmpList"); return DS; } #endregion //缓存列表界面，返回缓存列表信息 public DataSet GetKf_PonderationBillMain_TempList_New(string sHBillType, string sHMaker, Int64 sHOWNERID) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet Ds = oCn.RunProcReturn("exec h_p_KF_GetPonderationBillMain_TempList_New '" + sHBillType + "','" + sHMaker + "'," + sHOWNERID.ToString(), "h_p_KF_GetPonderationBillMain_TempList_New"); if (Ds == null || Ds.Tables[0].Rows.Count == 0) { return null; } else { return Ds; } } //缓存列表已上传列表 public DataSet GetKf_ICStockBillList(string sHBillType, string sHMaker, Int64 sHOWNERID) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet Ds = oCn.RunProcReturn("exec h_p_Kf_ICStockBillList '" + sHBillType + "','" + sHMaker + "'," + sHOWNERID.ToString(), "h_p_Kf_ICStockBillList"); if (Ds == null || Ds.Tables[0].Rows.Count == 0) { return null; } else { return Ds; } } //缓存列表已上传查询 public DataSet GetKf_ICStockBillQueryList(string BillType,string HBillNo, string HSourceBillNo) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet Ds = oCn.RunProcReturn("exec h_p_Kf_ICStockBillQueryList '" + BillType + "','" + HBillNo + "','" + HSourceBillNo+"'", "h_p_Kf_ICStockBillQueryList"); if (Ds == null || Ds.Tables[0].Rows.Count == 0) { return null; } else { return Ds; } } //扫描条码返回出入库条码临时表信息 public DataSet GetInfoByID_View(long HInterID, string sBillType, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("Select * from h_v_KF_PonderationBillMain_Temp Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_KF_PonderationBillMain_Temp", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } //扫描条码返回出入库条码临时表信息 一条条码显示一行 public DataSet GetInfoByIDDetails_View(long HInterID, string sBillType, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("Select top 20 * from h_v_KF_PonderationBillMainDetails_Temp Where HQty<>0 And HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere + " order by HMakeDate desc ", "h_v_KF_PonderationBillMain_Temp", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } //根据条码 数量 判断条码库存 是否充足 并且带出 仓库仓位 public bool CheckQtyByBarCode(long InterID, string sBillType, string sBarCode, ref long HWHID, ref long HSPID, double sQty, ref double sRelQty) { DataSet DS; DataSet DSErp; try { //单条码，一张单据一条条码(凯波) //DS = oCn.RunProcReturn("exec h_p_KF_ICInventory_WMS_GetWHAndSP_Single " + InterID.ToString() + ",'" + sBillType + "','" + sBarCode + "'," + HWHID.ToString() + "," + HSPID.ToString(), "h_p_KF_ICInventory_WMS_GetWHAndSP_Single", ref DBUtility.ClsPub.sExeReturnInfo); //判断条码库存 DS = oCn.RunProcReturn("exec h_p_KF_ICInventory_WMS_GetWHAndSP " + InterID.ToString() + ",'" + sBillType + "','" + sBarCode + "'," + HWHID.ToString() + "," + HSPID.ToString(), "h_p_KF_ICInventory_WMS_GetWHAndSP", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) { sRelQty = 0; return false; } else { double sKFQty = 0; double sKFQtyErp = 0; sKFQty = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HKFQty"]); HWHID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HWhID"]); HSPID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HSPID"]); //强制返回99999，已没有作用 DSErp = oCn.RunProcReturn("exec h_p_IF_ICInventory_WMS_GetWHAndSP " + InterID.ToString() + ",'" + sBillType + "','" + sBarCode + "'," + HWHID.ToString() + "," + HSPID.ToString(), "h_p_IF_ICInventory_WMS_GetWHAndSP", ref DBUtility.ClsPub.sExeReturnInfo); if (DSErp.Tables[0].Rows.Count == 0) { sRelQty = 0; return false; } sKFQtyErp = DBUtility.ClsPub.isDoule(DSErp.Tables[0].Rows[0]["HKFQty"]); if (sQty > sKFQty && sQty > sKFQtyErp) { sRelQty = sKFQtyErp; return false; } else if (sQty > sKFQty && sQty < sKFQtyErp) { sRelQty = sKFQty; return false; } else if (sQty < sKFQty && sQty > sKFQtyErp) { sRelQty = sKFQtyErp; return false; } else { sRelQty = sQty; return true; } } } catch (Exception e) { sRelQty = 0; throw (e); } } //编辑时，返回条码临时表信息 public DataSet GetBarCodeByID_View(long HInterID, string sBillType, long HMaterID, Int64 HAuxPropID, string HMTONo, Int64 HWhID, Int64 HSPID, Int64 HSCWhID, Int64 HSCSPID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("Select HMTONo,HBatchNo,HBarCode,HWHID,HStockPlaceID,HSCWHID,HOutStockPlaceID,sum(HQty) HQty from KF_PonderationBillMain_Temp Where HQty<>0 and HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "'" + " and HMaterID=" + HMaterID + " and HAuxPropID=" + HAuxPropID + " and HMTONo='" + HMTONo + "'" + //" and HWHID=" + HWhID + //" and HStockPlaceID=" + HSPID + //" and HSCWHID=" + HSCWhID + //" and HOutStockPlaceID=" + HSCSPID + " and (HBatchNo='" + HBatchNo + "' or '" + HBatchNo + "' ='')" + " and HSourceInterID=" + HSourceInterID + " and HSourceEntryID=" + HSourceEntryID + sWhere + " Group by HBatchNo,HMTONo,HBarCode,HWHID,HStockPlaceID,HSCWHID,HOutStockPlaceID", "KF_PonderationBillMain_Temp", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } //编辑条码数量时 判断条码档案数量 public bool CheckQtyByBarCodeBill(long InterID, string sBillType, string sBatchNo, string sBarCode, ref double sRelQty) { DataSet DS; try { DS = oCn.RunProcReturn("exec h_p_Kf_CheckBarCodeQty " + InterID.ToString() + ",'" + sBillType + "','" + sBatchNo + "','" + sBarCode + "'," + sRelQty.ToString(), "h_p_Kf_CheckBarCodeQty", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) { sRelQty = sRelQty; return true; } else { double sQtyMust = 0; sQtyMust = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HQtyMust"]); sRelQty = sQtyMust; return false; } } catch (Exception e) { sRelQty = 0; throw (e); } } //编辑条码数量时 判断条码库存 是否充足 （仓库仓位） public bool CheckQtyByBarCode(string sBarCode, long HWHID, long HSPID, long HAuxPropID, string sBatchNo, string HMTONo, double sQty, ref double sRelQty) { DataSet DS; DataSet DSErp; try { DS = oCn.RunProcReturn("exec h_p_KF_ICInventory_WMS '" + sBarCode + "'," + HWHID.ToString() + "," + HSPID.ToString() + "," + HAuxPropID.ToString() + ",'" + sBatchNo + "','" + HMTONo + "'", "h_p_KF_ICInventory_WMS", ref DBUtility.ClsPub.sExeReturnInfo); DSErp = oCn.RunProcReturn("exec h_p_IF_ICInventory '" + sBarCode + "'," + HWHID.ToString() + "," + HSPID.ToString(), "h_p_IF_ICInventory", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0 || DSErp.Tables[0].Rows.Count == 0) { sRelQty = 0; return false; } else { double sKCQty = 0; double sKCQtyErp = 0; sKCQty = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HQty"]); sKCQtyErp = DBUtility.ClsPub.isDoule(DSErp.Tables[0].Rows[0]["HQty"]); if (sQty > sKCQty && sQty > sKCQtyErp) { sRelQty = sKCQtyErp; return false; } else if (sQty > sKCQty && sQty < sKCQtyErp) { sRelQty = sKCQty; return false; } else if (sQty < sKCQty && sQty > sKCQtyErp) { sRelQty = sKCQtyErp; return false; } else { sRelQty = sQty; return true; } } } catch (Exception e) { sRelQty = 0; throw (e); } } public bool CheakBarCodeAndCP(long HCusID, string sCPStr, string sBarCode, ref string sReturn) { DataSet DS; try { DS = oCn.RunProcReturn("exec h_p_CheakBarCodeAndCP " + HCusID.ToString() + ",'" + sCPStr + "','" + sBarCode + "'", "h_p_CheakBarCodeAndCP", ref DBUtility.ClsPub.sExeReturnInfo); //if (DS.Tables[0].Rows.Count == 0) if (DS == null || DS.Tables[0].Rows.Count == 0) { sReturn = "验证失败！"; return false; } else { double sBack = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HBack"]); string sBackRemark = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HBackRemark"]); if (sBack == 0) { sReturn = "验证通过！"; return true; } else { sReturn = sBackRemark; return false; } } } catch (Exception e) { sReturn = e.Message; throw (e); } } ////判断明细表中条码库存、K3库存 是否充足 （仓库仓位批次） //public bool CheckQtyByBarCode_Sub(long HInterID, string sBillType, long HMaterID, Int64 HWhID, Int64 HSPID, Int64 HSCWhID, Int64 HSCSPID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, string sWhere, ref string sReturn) //{ // DataSet DSBarCode; // DataSet DS; // DataSet DSk3; // string sBarCode; // string sBatchNo; // Int64 sHWHID; // Int64 sHSPID; // double sQty; // try // { // DSBarCode=GetBarCodeByID_View(HInterID, sBillType, HMaterID, HWhID, HSPID, HSCWhID, HSCSPID, HBatchNo, HSourceInterID, HSourceEntryID, sWhere); // if (DSBarCode == null || DSBarCode.Tables[0].Rows.Count == 0) // { // sReturn = "正常！"; // return true; // } // for (int i = 0; i <= DSBarCode.Tables[0].Rows.Count - 1; i++) // { // sBarCode = DBUtility.ClsPub.isStrNull(DSBarCode.Tables[0].Rows[i]["HBarCode"].ToString()); // sBatchNo = DBUtility.ClsPub.isStrNull(DSBarCode.Tables[0].Rows[i]["HBatchNo"].ToString()); // sHWHID = DBUtility.ClsPub.isInt(DSBarCode.Tables[0].Rows[i]["HWHID"].ToString()); // sHSPID = DBUtility.ClsPub.isInt(DSBarCode.Tables[0].Rows[i]["HStockPlaceID"].ToString()); // sQty = DBUtility.ClsPub.isDoule(DSBarCode.Tables[0].Rows[i]["HQty"].ToString()); // DS = oCn.RunProcReturn("exec h_p_KF_ICInventory_WMS '" + sBarCode + "'," + sHWHID.ToString() + "," + sHSPID.ToString() + ",'" + sBatchNo + "'", "h_p_KF_ICInventory_WMS", ref DBUtility.ClsPub.sExeReturnInfo); // DSk3 = oCn.RunProcReturn("exec h_p_k3_icinventory '" + sBarCode + "'," + sHWHID.ToString() + "," + sHSPID.ToString(), "h_p_k3_icinventory", ref DBUtility.ClsPub.sExeReturnInfo); // if (DS.Tables[0].Rows.Count == 0) // { // sReturn = "条码" + sBarCode + "无条码库存！"; // return false; // } // else if (DSk3.Tables[0].Rows.Count == 0) // { // sReturn = "条码" + sBarCode + "无K3库存！"; // return false; // } // else // { // double sKCQty = 0; // double sKCQtyk3 = 0; // sKCQty = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HQty"]); // sKCQtyk3 = DBUtility.ClsPub.isDoule(DSk3.Tables[0].Rows[0]["HQty"]); // if (sQty > sKCQty && sQty > sKCQtyk3) // { // sReturn = "条码" + sBarCode + "的扫描数量" + sQty + "大于条码库存数量" + sKCQty + "，大于K3库存数量" + sKCQtyk3 + "！"; // return false; // } // else if (sQty > sKCQty && sQty < sKCQtyk3) // { // sReturn = "条码" + sBarCode + "的扫描数量" + sQty + "大于条码库存数量" + sKCQty + "！"; // return false; // } // else if (sQty < sKCQty && sQty > sKCQtyk3) // { // sReturn = "条码" + sBarCode + "的扫描数量" + sQty + "，大于K3库存数量" + sKCQtyk3 + "！"; // return false; // } // else // { // } // } // } // } // catch (Exception e) // { // sReturn = e.Message; // throw (e); // } // return false; //} //根据条码 判断条码库存中物料仓库仓位是否与所选源单一致 public bool CheckQtyByBarCode_WHAndSP(long HInterID, string sBarCode) { DataSet DS; try { DS = oCn.RunProcReturn("exec h_p_KF_ICInventory_WMS_GetWHAndSPAndBC " + HInterID.ToString() + ",'" + sBarCode + "'" , "h_p_KF_ICInventory_WMS_GetWHAndSPAndBC", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) { return false; } else { return true; } } catch (Exception e) { throw (e); } } //返回项目信息 public override bool GetInfoByID(Int64 sItemID) { DataSet DS ; try { DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HItemID='" + sItemID + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return false; else { return GetInfo(DS); } } catch (Exception e) { throw (e); } } //根据代码返回项目信息 public DataSet GetInfoByID_View_Check(long HInterID, string sBillType, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("Select * from h_v_KF_PonderationBillMain_Temp_Wh_SP Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_KF_PonderationBillMain_Temp_Wh_SP", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } //根据代码返回项目信息(盘点) public DataSet GetInfoByID_View_CheckStcok(long HInterID, string sBillType, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("exec h_p_KF_PonderationBillMain_Temp_CheckStock " + HInterID.ToString() + ",'" + sBillType + "'", "h_p_KF_PonderationBillMain_Temp_CheckStock", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } //根据代码返回项目信息 public DataSet GetInfoByID_View_FIFO(long HInterID, string sBillType, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("select * from h_v_Kf_ICInventory_FIFO_Tmp Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_Kf_ICInventory_FIFO_Tmp", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } //根据代码返回项目信息 public DataSet GetInfoByID_View_FIFO(long HInterID, string sBillType, long HMaterID, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("select * from h_v_Kf_ICInventory_FIFO_Tmp_New Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' and HMaterID=" + HMaterID.ToString() + sWhere, "h_v_Kf_ICInventory_FIFO_Tmp_New", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } ////根据代码返回项目信息 //public DataSet GetCusAndBarCodeByID_View(long HInterID, string sWhere) //{ // DataSet DS; // try // { // DS = oCn.RunProcReturn("Select * from h_v_K3_GetCusAndBarCodeList Where HInterID=" + HInterID.ToString() + sWhere, "h_v_K3_GetCusAndBarCodeList", ref DBUtility.ClsPub.sExeReturnInfo); // if (DS.Tables[0].Rows.Count == 0) // return null; // else // { // return DS; // } // } // catch (Exception e) // { // throw (e); // } //} //根据代码返回项目信息 public DataSet GetBarCodeByID_View(long HInterID, string sBillType, long HMaterID, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("Select * from KF_PonderationBillMain_Temp Where HQty<>0 and HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' and HMaterID=" + HMaterID + sWhere, "KF_PonderationBillMain_Temp", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } ////根据代码返回项目信息 //public DataSet GetBarCodeByID_View(long HInterID, string sBillType, long HMaterID, Int64 HWhID, Int64 HSPID, Int64 HSCWhID, Int64 HSCSPID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, string sWhere) //{ // DataSet DS; // try // { // DS = oCn.RunProcReturn("Select HBarCode,sum(HQty) HQty from KF_PonderationBillMain_Temp Where HQty<>0 and HInterID=" + HInterID.ToString() + // " and HBillType='" + sBillType + "'" + // " and HMaterID=" + HMaterID + // " and HWHID=" + HWhID + // " and HStockPlaceID=" + HSPID + // " and HSCWHID=" + HSCWhID + // " and HOutStockPlaceID=" + HSCSPID + // " and HBatchNo='" + HBatchNo + "'" + // " and HSourceInterID=" + HSourceInterID + // " and HSourceEntryID=" + HSourceEntryID + // sWhere + // " Group by HBarCode", "KF_PonderationBillMain_Temp", ref DBUtility.ClsPub.sExeReturnInfo); // if (DS.Tables[0].Rows.Count == 0) // return null; // else // { // return DS; // } // } // catch (Exception e) // { // throw (e); // } //} //根据代码返回项目信息 public override bool GetInfoByNumber(string sNumber) { DataSet DS; try { DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HBarCode='" + sNumber + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return false; else { return GetInfo(DS); } } catch (Exception e) { throw (e); } } //返回项目信息 public override bool GetInfo(DataSet Ds) { try { omodel = new Model.ClsKF_PonderationBillMain_Temp(); omodel.HItemID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HItemID"]); omodel.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"]); omodel.HBarCode = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBarCode"]); omodel.HMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMaterID"]); omodel.HProcID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HProcID"]); omodel.HWhID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HWhID"]); omodel.HSCWHID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSCWHID"]); omodel.HStockPlaceID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HStockPlaceID"]); omodel.HOutStockPlaceID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HOutStockPlaceID"]); omodel.HGroupID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HGroupID"]); omodel.HQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HQty"]); omodel.HPieceQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HPieceQty"]); omodel.HAddr = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HAddr"]); // omodel.HSourceBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSourceBillType"]); omodel.HSourceInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSourceInterID"]); omodel.HSourceEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSourceEntryID"]); return true; } catch (Exception e) { throw (e); } } //根据代码返回项目信息 public DataSet GetCusAndBarCodeByID_View(long HInterID, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("Select * from h_v_K3_GetCusAndBarCodeList Where HInterID=" + HInterID.ToString() + sWhere, "h_v_K3_GetCusAndBarCodeList", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } public DataSet GetInfoByID_View_Sub(long HInterID, string sBillType, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("exec h_p_KF_PonderationBillMain_Temp_Sub " + HInterID.ToString() + " ,'" + sBillType + "' ", "h_p_KF_PonderationBillMain_Temp_Sub", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } public DataSet GetInfoByID_View_Sub_FIFO(long HInterID, string sBillType, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("exec h_p_KF_PonderationBillMain_Temp_FIFO " + HInterID.ToString() + " ,'" + sBillType + "' ", "h_p_KF_PonderationBillMain_Temp_FIFO", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } public DataSet GetInfoByID_View_Sub_FIFO_Bill(string sBillNo, string sBillType, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("exec h_p_KF_PonderationBillMain_Temp_FIFO_Bill '" + sBillNo + "' ,'" + sBillType + "' ", "h_p_KF_PonderationBillMain_Temp_FIFO_Bill", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } //根据代码返回项目信息 public DataSet GetInfoByID_View_Sum(long HInterID, string sBillType, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("Select * from h_v_KF_PonderationBillMain_Temp_Sum Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_KF_PonderationBillMain_Temp_Sum", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } //根据代码返回项目信息（未上传） public DataSet GetInfoByID_View(string sBillType, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("Select * from h_v_KF_PonderationBillMain_Temp_OffLine Where HBillType='" + sBillType + "' " + sWhere, "h_v_KF_PonderationBillMain_Temp_OffLine", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } //返回缓存列表信息 public DataSet GetKf_PonderationBillMain_TempList(string sBillType, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("exec h_p_KF_GetPonderationBillMain_TempList '" + sBillType + "','" +sWhere + "'", "h_p_KF_GetPonderationBillMain_TempList", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } //返回缓存列表信息（倒箱单） public DataSet GetKf_PonderationBillMain_TempList_ChangeBox(string sBillType, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("exec h_p_KF_GetPonderationBillMain_TempList_ChangeBox '" + sBillType + "','" + sWhere + "'", "h_p_KF_GetPonderationBillMain_TempList_ChangeBox", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } ////根据代码返回项目信息 //public DataSet GetInfoByID_View(long HInterID, string sBillType, string sWhere) //{ // DataSet DS; // try // { // DS = oCn.RunProcReturn("Select * from h_v_KF_PonderationBillMain_Temp Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_KF_PonderationBillMain_Temp", ref DBUtility.ClsPub.sExeReturnInfo); // if (DS.Tables[0].Rows.Count == 0) // return null; // else // { // return DS; // } // } // catch (Exception e) // { // throw (e); // } //} public DataSet GetMaterByBarCode_View(string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn(" exec h_p_KF_ICInventory_BarCodeMater_Main '" + sWhere + "'","h_p_KF_ICInventory_BarCodeMater_Main", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } public DataSet GetICInventoryByBarCode_View(string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn(" exec h_p_KF_ICInventory_BarCodeMater_Sub '" + sWhere + "'","h_p_KF_ICInventory_BarCodeMater_Sub", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } public DataSet GetMaterByBarCodeSP_View(string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn(" exec h_p_KF_ICInventory_BarCodeSP_Sub '" + sWhere + "'","h_p_KF_ICInventory_BarCodeSP_Sub", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } public DataSet GetICInventoryByBarCodeSP_View(string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn(" exec h_p_KF_ICInventory_BarCodeSP_Main '" + sWhere + "'","h_p_KF_ICInventory_BarCodeSP_Main", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } //返回即时库存 public DataSet Get_ICInventoryByBarCodeList(string sBarCode, long sHWHID, long sHSPID, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("exec h_p_KF_ICInventoryByBarCodeList '" + sBarCode + "'," + sHWHID.ToString() + "," + sHSPID.ToString(), "h_p_KF_ICInventoryByBarCodeList", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } //根据物料返回即时库存 public DataSet Get_ICInventoryByMaterID(long sHMaterID, long sHWhID, string sWhere) { DataSet DS; try { DS = oCn.RunProcReturn("exec h_p_KF_ICInventoryByMaterID " + sHMaterID.ToString() + "," + sHWhID.ToString(), "h_p_KF_ICInventoryByMaterID", ref DBUtility.ClsPub.sExeReturnInfo); if (DS == null || DS.Tables[0].Rows.Count == 0) return null; else { return DS; } } catch (Exception e) { throw (e); } } //判断扫描记录，是否按照先进先出规则 public bool CheckICInventory_FIFO_Tmp(long InterID, string sBillType, ref string sReturn) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet DS; try { DS = oCn.RunProcReturn("exec h_p_Kf_ICInventory_FIFO_Tmp_Check " + InterID.ToString() + "," + sBillType.ToString(), "h_p_Kf_ICInventory_FIFO_Tmp_Check", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0 || DS == null) { oCn.CnClose(); oCn.CnDispose(); sReturn = "null未知错误"; return false; //不存在 入库数量超过条码本身额定数量 条码 } else { if (DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0][0]) == 1) { oCn.CnClose(); oCn.CnDispose(); sReturn = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][1]); return false; } else { oCn.CnClose(); oCn.CnDispose(); sReturn = "正常！"; return true; } } } catch (Exception e) { sReturn = e.Message; throw (e); } } //根据VDA箱号 数量 判断扫描数量 是否匹配 public bool CheckQtyByVDAPack(long InterID, string sBillType, string sVDAPack, ref string sReturn) { DataSet DS; try { DS = oCn.RunProcReturn("select sum(HQty) HQty,HVDAQty from KF_PonderationBillMain_Temp where HInterID=" + InterID.ToString() + " and HBillType='" + sBillType + "' and HVDAPack='" + sVDAPack + "' group by HVDAQty", "KF_PonderationBillMain_Temp", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) { return false; } else { double sQty = 0; double sVDAQty = 0; sQty = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HQty"]); sVDAQty = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HVDAQty"]); if (sQty != sVDAQty) { sReturn = "本托数量与 VDA数量不一致！"; return false; } else { sReturn = "正常"; return true; } } } catch (Exception e) { throw (e); } } } }