using System; using System.Collections.Generic; using System.Text; using System.Data; namespace DAL { public class ClsKF_PonderationBillMain_Audit_Temp_Ctl : DBUtility.ClsGy_Base_Ctl { //原代码 用于 替换子项目 public string HOldNumber; public Model.ClsKF_PonderationBillMain_Audit_Temp oModel = new Model.ClsKF_PonderationBillMain_Audit_Temp(); //删除 根据内码全部清除 public bool DeleteByInterID(Int64 sHInterID, string sHBillType) { try { oCn.RunProc("Delete from " + MvarItemKey + " where HInterID=" + sHInterID.ToString() + " and HBillType='" + sHBillType + "'", ref DBUtility.ClsPub.sExeReturnInfo); return true; } catch (Exception e) { throw (e); } } //删除 根据内码+条码清除该条码记录 public bool DeleteByBarCode(Int64 sHInterID, string sBarCode, string sHBillType) { try { oCn.RunProc("Delete from " + MvarItemKey + " where HInterID=" + sHInterID.ToString() + " and HBillType='" + sHBillType + "' and HBarCode='" + sBarCode + "'", ref DBUtility.ClsPub.sExeReturnInfo); return true; } catch (Exception e) { throw (e); } } //删除 根据内码+物料清除该物料记录 public bool DeleteByInterIDAndSource(Int64 sHInterID, Int64 sMaterID, Int64 sHAuxPropID, Int64 sSInterID, Int64 sSEntryID, string sHBillType) { try { oCn.RunProc("Delete from " + MvarItemKey + " where HInterID=" + sHInterID.ToString() + " and HMaterID= " + sMaterID.ToString() + " and HAuxPropID= " + sHAuxPropID.ToString() + " and HBillType='" + sHBillType + "' and HSourceInterID=" + sSInterID.ToString() + " and HSourceEntryID=" + sSEntryID.ToString() + " and HQty<>0 ", ref DBUtility.ClsPub.sExeReturnInfo); return true; } catch (Exception e) { throw (e); } } //删除(源单主ID，源单子ID) public bool DeleteByInterID(Int64 sHInterID, Int64 sHEntryID, string sHBillType) { try { oCn.RunProc("Delete from " + MvarItemKey + " where HSourceInterID=" + sHInterID.ToString() + " and HSourceEntryID=" + sHEntryID.ToString() + " and HBillType='" + sHBillType + "'", ref DBUtility.ClsPub.sExeReturnInfo); return true; } catch (Exception e) { throw (e); } } //删除（先进先出数据）更新 HlineStatus =1 public bool DeleteFIFOByInterID(Int64 sHInterID, string sHBillType) { try { oCn.RunProc("update Kf_ICInventory_FIFO_Tmp set HlineStatus =1 where HInterID=" + sHInterID.ToString() + " and HBillType='" + sHBillType + "'", ref DBUtility.ClsPub.sExeReturnInfo); return true; } catch (Exception e) { throw (e); } } //删除缓存列表单据 public bool DeleteBillList(Int64 sHInterID) { try { oCn.RunProc("Delete from " + MvarItemKey + " where HInterID=" + sHInterID.ToString() , ref DBUtility.ClsPub.sExeReturnInfo); return true; } catch (Exception e) { throw (e); } } //新增 public bool AddNew(ref string sReturn) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // DataSet oDs = new DataSet(); // DataSet oDs1 = new DataSet(); // DataSet oDs2 = new DataSet(); // // // long sSourceInterID = 0; // long sSourceEntryID = 0; // long sTMSourceInterID = oModel.HSourceInterID; // long sTMSourceEntryID = oModel.HSourceEntryID; // bool iBool = false; // oCn.BeginTran(); // //产品入库，外购入库，其他入库，委外入库 有源单单据只能扫描对应源单条码，无源单单据只能扫描无源单条码（不包括红字单据） // if (oModel.HBillType == "2" || oModel.HBillType == "10" || oModel.HBillType == "5" || oModel.HBillType == "1") // { // if (oModel.HRedBlueFlag == false) // { // oDs1 = oCn.RunProcReturn("select distinct HSourceInterID,HSourceEntryID from " + MvarItemKey + " where HInterID=" + oModel.HInterID.ToString() + " and HQty=0 ", "KF_PonderationBillMain_Audit_Temp"); // if (oDs1 != null && oDs1.Tables[0].Rows.Count > 0) // { // for (int i = 0; i <= oDs1.Tables[0].Rows.Count - 1; i++) // { // sSourceInterID = DBUtility.ClsPub.isLong(oDs1.Tables[0].Rows[i]["HSourceInterID"]); // sSourceEntryID = DBUtility.ClsPub.isLong(oDs1.Tables[0].Rows[i]["HSourceEntryID"]); // //有源单 （扫描条码 无源单信息） // if (sSourceInterID + sSourceEntryID != 0 && sTMSourceInterID + sTMSourceEntryID == 0) // { // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "有源单单据，不允许扫描无源单条码！"; // return false; // } // //有源单（但是扫描条码 源单信息， 与所选源单信息 不匹配） // else if (sSourceInterID + sSourceEntryID != 0 && sTMSourceInterID.ToString() + sTMSourceEntryID.ToString() != sSourceInterID.ToString() + sSourceEntryID.ToString()) // { // iBool = false; // continue; // } // //有源单（但是扫描条码 源单信息， 与所选源单信息 匹配） *** // else if (sSourceInterID + sSourceEntryID != 0 && sTMSourceInterID.ToString() + sTMSourceEntryID.ToString() == sSourceInterID.ToString() + sSourceEntryID.ToString()) // { // iBool = true; // break; // } // ////无源单 （扫描条码 有源单信息 ） // //else if (sSourceInterID + sSourceEntryID == 0 && sTMSourceInterID + sTMSourceEntryID != 0) // //{ // // oCn.Commit(); // // oCn.CnClose(); // // oCn.CnDispose(); // // sReturn = "无源单单据，不允许扫描有源单条码！"; // // return false; // //} // ////无源单 （扫描条码 无源单信息 ） // //else if (sSourceInterID + sSourceEntryID == 0 && sTMSourceInterID + sTMSourceEntryID == 0) // //{ // // iBool = true; // // break; // //} // } // if (iBool == false) // { // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "扫描条码源单，与所选源单不匹配！"; // return false; // } // } // //else if (oDs1.Tables[0].Rows.Count == 0) // //{ // // //无源单 （扫描条码 有源单信息 ） // // if (sSourceInterID + sSourceEntryID == 0 && sTMSourceInterID + sTMSourceEntryID != 0) // // { // // oCn.Commit(); // // oCn.CnClose(); // // oCn.CnDispose(); // // sReturn = "无源单单据，不允许扫描有源单条码！"; // // return false; // // } // //} // } // } // // // oDs = oCn.RunProcReturn("select HQtyMust,HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo from " + MvarItemKey + " where HInterID=" + oModel.HInterID.ToString() + " and HBillType='" + oModel.HBillType + "' and HMaterID=" + oModel.HMaterID.ToString() + " and HQty=0 ", "KF_PonderationBillMain_Audit_Temp"); // // // if (oDs != null && oDs.Tables[0].Rows.Count > 0) // { // oDs2 = oCn.RunProcReturn("select HBarCodeType from Gy_BarCodeBill where HBarCode='" + oModel.HBarCode + "'", "Gy_BarCodeBill"); // if(DBUtility.ClsPub.isStrNull(oDs2.Tables[0].Rows[0]["HBarCodeType"])!="唯一条码") // { // oModel.HQty = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HQtyMust"]); // } // oModel.HQtyMust = 0; // oModel.HSourceInterID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceInterID"]); // oModel.HSourceEntryID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceEntryID"]); // oModel.HSourceBillType = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillType"]); // oModel.HSourceBillNo = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillNo"]); // } // else // { // oModel.HQtyMust = 0; // } // oCn.RunProc("Insert into " + MvarItemKey + " " + // " (HInterID,HBillNo,HBillType,HMaterID,HProcID,HWhID,HSCWHID" + // ",HStockPlaceID,HOutStockPlaceID,HGroupID,HQty,HQtyMust,HPieceQty " + // ",HBatchNo,HBarCode,HAddr,HMaker,HMakeDate " + // //",HVDAPack,HVDAMaterNum,HVDAQty " + // ",HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo" + // ",HRelationInterID,HRelationEntryID,HRelationBillNo,HRedBlueFlag) " + // " Values(" + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HProcID.ToString() + "," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() + // "," + oModel.HStockPlaceID.ToString() + "," + oModel.HOutStockPlaceID.ToString() + "," + oModel.HGroupID.ToString() + "," + oModel.HQty.ToString() + "," + oModel.HQtyMust.ToString() + "," + oModel.HPieceQty.ToString() + // ",'" + oModel.HBatchNo + "','" + oModel.HBarCode + "','" + oModel.HAddr + "','" + oModel.HMaker + "',getdate()" + // //",'','',0 "+ // "," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" + oModel.HSourceBillNo + "'" + // "," + oModel.HRelationInterID.ToString() + "," + oModel.HRelationEntryID.ToString() + ",'" + oModel.HRelationBillNo + "'," + Convert.ToString(oModel.HRedBlueFlag ? 1 : 0) + ")", ref DBUtility.ClsPub.sExeReturnInfo); // //修改上级为非末级代码 // //oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "保存成功！"; return true; //} //catch (Exception e) //{ // sReturn = e.Message; // oCn.RollBack(); // throw (e); //} } //新增(出入库单据已经生成，核对生单时) public bool AddNew_CheckAdd(ref string sReturn) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); try { DataSet oDs = new DataSet(); oCn.BeginTran(); oDs = oCn.RunProcReturn("select HQtyMust,HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo from " + MvarItemKey + " where HInterID=" + oModel.HInterID.ToString() + " and HBillType='" + oModel.HBillType + "' and HBarCode='" + oModel.HBarCode.ToString() + "' and HSourceLine=1 ", "KF_PonderationBillMain_Audit_Temp"); // if (oDs != null && oDs.Tables[0].Rows.Count > 0) { oModel.HQtyMust = 0; oModel.HSourceInterID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceInterID"]); oModel.HSourceEntryID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceEntryID"]); oModel.HSourceBillType = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillType"]); oModel.HSourceBillNo = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillNo"]); } else { oModel.HQtyMust = 0; } oCn.RunProc("Insert into " + MvarItemKey + " " + " (HInterID,HBillNo,HBillType,HMaterID,HAuxPropID,HProcID,HWhID,HSCWHID" + ",HStockPlaceID,HOutStockPlaceID,HGroupID,HQty,HQtyMust,HPieceQty " + ",HBatchNo,HBarCode,HAddr,HMaker,HMakeDate " + ",HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo" + ",HRelationInterID,HRelationEntryID,HRelationBillNo,HRedBlueFlag,HSourceLine) " + " Values(" + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HAuxPropID.ToString() + "," + oModel.HProcID.ToString() + "," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() + "," + oModel.HStockPlaceID.ToString() + "," + oModel.HOutStockPlaceID.ToString() + "," + oModel.HGroupID.ToString() + "," + oModel.HQty.ToString() + "," + oModel.HQtyMust.ToString() + "," + oModel.HPieceQty.ToString() + ",'" + oModel.HBatchNo + "','" + oModel.HBarCode + "','" + oModel.HAddr + "','" + oModel.HMaker + "',getdate()" + //",'','',0 "+ "," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" + oModel.HSourceBillNo + "'" + "," + oModel.HRelationInterID.ToString() + "," + oModel.HRelationEntryID.ToString() + ",'" + oModel.HRelationBillNo + "'," + Convert.ToString(oModel.HRedBlueFlag ? 1 : 0) + ",0)", ref DBUtility.ClsPub.sExeReturnInfo); //修改上级为非末级代码 //oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); oCn.Commit(); oCn.CnClose(); oCn.CnDispose(); sReturn = "保存成功！"; return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //新增(出入库单据已经生成，核对生单时) public bool AddNew_CheckAdd(double sQty, ref string sReturn) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // DataSet oDs = new DataSet(); // DataSet oDs2 = new DataSet(); // oCn.BeginTran(); // oDs = oCn.RunProcReturn("select HQtyMust,HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo from " + MvarItemKey + " where HInterID=" + oModel.HInterID.ToString() + " and HBillType='" + oModel.HBillType + "' and HMaterID=" + oModel.HMaterID.ToString() + " and HQty=0 ", "KF_PonderationBillMain_Audit_Temp"); // // // if (oDs != null && oDs.Tables[0].Rows.Count > 0) // { // oModel.HQtyMust = 0; // oModel.HSourceInterID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceInterID"]); // oModel.HSourceEntryID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceEntryID"]); // oModel.HSourceBillType = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillType"]); // oModel.HSourceBillNo = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillNo"]); // long sHSumQty = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HQtyMust"]); // oDs2 = oCn.RunProcReturn("select sum(HQty) HQty from " + MvarItemKey + " where HSourceInterID=" + oModel.HSourceInterID.ToString() + " and HSourceEntryID=" + oModel.HSourceEntryID.ToString() + " and HQty > 0 ", "KF_PonderationBillMain_Audit_Temp"); // if (sQty == 0) // { // oModel.HQty = sHSumQty - DBUtility.ClsPub.isDoule(oDs2.Tables[0].Rows[0]["HQty"]); // if (oModel.HQty <= 0) // { // sReturn = "扫描数量总和不能大于实际数量！"; // return false; // } // } // else // { // oModel.HQty = DBUtility.ClsPub.isDoule(sQty); // if (oModel.HQty < 0) // { // sReturn = "输入的数量不能小于0！"; // return false; // } // if (oModel.HQtyMust <= DBUtility.ClsPub.isDoule(oDs2.Tables[0].Rows[0]["HQty"])) // { // sReturn = "扫描数量总和不能大于实际数量！"; // return false; // } // } // } // else // { // oModel.HQtyMust = 0; // } // oCn.RunProc("Insert into " + MvarItemKey + " " + // " (HInterID,HBillNo,HBillType,HMaterID,HProcID,HWhID,HSCWHID" + // ",HStockPlaceID,HOutStockPlaceID,HGroupID,HQty,HQtyMust,HPieceQty " + // ",HBatchNo,HBarCode,HAddr,HMaker,HMakeDate " + // //",HVDAPack,HVDAMaterNum,HVDAQty " + // ",HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo" + // ",HRelationInterID,HRelationEntryID,HRelationBillNo,HRedBlueFlag) " + // " Values(" + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HProcID.ToString() + "," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() + // "," + oModel.HStockPlaceID.ToString() + "," + oModel.HOutStockPlaceID.ToString() + "," + oModel.HGroupID.ToString() + "," + oModel.HQty.ToString() + "," + oModel.HQtyMust.ToString() + "," + oModel.HPieceQty.ToString() + // ",'" + oModel.HBatchNo + "','" + oModel.HBarCode + "','" + oModel.HAddr + "','" + oModel.HMaker + "',getdate()" + // //",'','',0 "+ // "," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" + oModel.HSourceBillNo + "'" + // "," + oModel.HRelationInterID.ToString() + "," + oModel.HRelationEntryID.ToString() + ",'" + oModel.HRelationBillNo + "'," + Convert.ToString(oModel.HRedBlueFlag ? 1 : 0) + ")", ref DBUtility.ClsPub.sExeReturnInfo); // //修改上级为非末级代码 // //oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "保存成功！"; return true; //} //catch (Exception e) //{ // sReturn = e.Message; // oCn.RollBack(); // throw (e); //} } //新增 public bool AddNew_FIFO(ref string sReturn) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // DataSet oDs = new DataSet(); // // // oCn.BeginTran(); // //领料出库 // if (oModel.HBillType == "24") // { // oDs = oCn.RunProcReturn("select HWHID,HSPID,HQty,HSumQtyMust,HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo from Kf_ICInventory_FIFO_Tmp where HInterID=" + oModel.HInterID.ToString() + " and HBillType='" + oModel.HBillType + "' and HBatchNo='" + oModel.HBatchNo + "' and HBarCode='" + oModel.HBarCode + "'", "Kf_ICInventory_FIFO_Tmp"); // // // if (oDs != null && oDs.Tables[0].Rows.Count > 0) // { // double sKFQty = DBUtility.ClsPub.isDoule(oDs.Tables[0].Rows[0]["HQty"]); // if (oModel.HQty > sKFQty) // { // oModel.HQty = sKFQty; // } // oModel.HWhID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HWHID"]); // oModel.HStockPlaceID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSPID"]); // oModel.HQtyMust = DBUtility.ClsPub.isDoule(oDs.Tables[0].Rows[0]["HSumQtyMust"]); // oModel.HSourceInterID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceInterID"]); // oModel.HSourceEntryID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceEntryID"]); // oModel.HSourceBillType = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillType"]); // oModel.HSourceBillNo = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillNo"]); // } // else // { // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "请根据先进先出清单扫码！"; // return false; // } // } // //调拨 // else if (oModel.HBillType == "41") // { // oDs = oCn.RunProcReturn("select HWHID,HSPID,HQty,HSumQtyMust,HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo from Kf_ICInventory_FIFO_Tmp where HInterID=" + oModel.HInterID.ToString() + " and HBillType='" + oModel.HBillType + "' and HBatchNo='" + oModel.HBatchNo + "' and HBarCode='" + oModel.HBarCode + "'", "Kf_ICInventory_FIFO_Tmp"); // // // if (oDs != null && oDs.Tables[0].Rows.Count > 0) // { // double sKFQty = DBUtility.ClsPub.isDoule(oDs.Tables[0].Rows[0]["HQty"]); // if (oModel.HQty > sKFQty) // { // oModel.HQty = sKFQty; // } // oModel.HSCWHID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HWHID"]); // oModel.HOutStockPlaceID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSPID"]); // oModel.HQtyMust = DBUtility.ClsPub.isDoule(oDs.Tables[0].Rows[0]["HSumQtyMust"]); // oModel.HSourceInterID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceInterID"]); // oModel.HSourceEntryID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceEntryID"]); // oModel.HSourceBillType = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillType"]); // oModel.HSourceBillNo = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillNo"]); // } // else // { // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "请根据先进先出清单扫码！"; // return false; // } // } // oCn.RunProc("Insert into " + MvarItemKey + " " + // " (HInterID,HBillNo,HBillType,HMaterID,HProcID,HWhID,HSCWHID" + // ",HStockPlaceID,HOutStockPlaceID,HGroupID,HQty,HQtyMust,HPieceQty " + // ",HBatchNo,HBarCode,HAddr,HMaker,HMakeDate " + // //",HVDAPack,HVDAMaterNum,HVDAQty " + // ",HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo" + // ",HRelationInterID,HRelationEntryID,HRelationBillNo,HRedBlueFlag) " + // " Values(" + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HProcID.ToString() + "," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() + // "," + oModel.HStockPlaceID.ToString() + "," + oModel.HOutStockPlaceID.ToString() + "," + oModel.HGroupID.ToString() + "," + oModel.HQty.ToString() + "," + oModel.HQtyMust.ToString() + "," + oModel.HPieceQty.ToString() + // ",'" + oModel.HBatchNo + "','" + oModel.HBarCode + "','" + oModel.HAddr + "','" + oModel.HMaker + "',getdate()" + // //",'','',0" + // "," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" + oModel.HSourceBillNo + "'" + // "," + oModel.HRelationInterID.ToString() + "," + oModel.HRelationEntryID.ToString() + ",'" + oModel.HRelationBillNo + "'," + Convert.ToString(oModel.HRedBlueFlag ? 1 : 0) + ")", ref DBUtility.ClsPub.sExeReturnInfo); // //修改上级为非末级代码 // //oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "保存成功！"; return true; //} //catch (Exception e) //{ // sReturn = e.Message; // oCn.RollBack(); // throw (e); //} } //新增 public bool AddNew_More(ref string sReturn) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // oCn.BeginTran(); // //箱号条码,批量新增 // oCn.RunProc("exec h_p_KF_PonderationBillMain_Audit_Temp_Add_Sell " + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "','" + oModel.HBarCode + "'," + oModel.HWhID.ToString() + "," + oModel.HStockPlaceID.ToString() + "," + oModel.HSCWHID.ToString() + "," + oModel.HOutStockPlaceID.ToString() + ",'" + oModel.HMaker + "'," + Convert.ToString(oModel.HRedBlueFlag ? 1 : 0), ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "保存成功！"; return true; //} //catch (Exception e) //{ // sReturn = e.Message; // oCn.RollBack(); // throw (e); //} } //新增(源单) public bool AddNew_Source(ref string sReturn) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); try { DataSet oDs = new DataSet(); oCn.BeginTran(); oCn.RunProc("Insert into " + MvarItemKey + " " + " (HInterID,HBillNo,HBillType,HMaterID,HProcID,HWhID,HSCWHID" + ",HStockPlaceID,HOutStockPlaceID,HGroupID,HQty,HQtyMust,HPieceQty " + ",HBatchNo,HBarCode,HAddr,HMaker,HMakeDate " + ",HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo" + ",HRelationInterID,HRelationEntryID,HRelationBillNo,HRedBlueFlag) " + " Values(" + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HProcID.ToString() + "," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() + "," + oModel.HStockPlaceID.ToString() + "," + oModel.HOutStockPlaceID.ToString() + "," + oModel.HGroupID.ToString() + "," + oModel.HQty.ToString() + "," + oModel.HQtyMust.ToString() + "," + oModel.HPieceQty.ToString() + ",'" + oModel.HBatchNo + "','" + oModel.HBarCode + "','" + oModel.HAddr + "','" + oModel.HMaker + "',getdate()" + "," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" + oModel.HSourceBillNo + "'" + "," + oModel.HRelationInterID.ToString() + "," + oModel.HRelationEntryID.ToString() + ",'" + oModel.HRelationBillNo + "'," + Convert.ToString(oModel.HRedBlueFlag ? 1 : 0) + ")", ref DBUtility.ClsPub.sExeReturnInfo); //修改上级为非末级代码 //oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); oCn.Commit(); oCn.CnClose(); oCn.CnDispose(); sReturn = "保存成功！"; return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //新增(源单) public bool AddNew_Source(double sQty,ref string sReturn) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); try { DataSet oDs = new DataSet(); DataSet oDs2 = new DataSet(); oCn.BeginTran(); oDs2 = oCn.RunProcReturn("select sum(HQty) HQty from " + MvarItemKey + " where HSourceInterID=" + oModel.HSourceInterID.ToString() + " and HSourceEntryID=" + oModel.HSourceEntryID.ToString() + " and HQty > 0 ", "KF_PonderationBillMain_Audit_Temp"); if (sQty == 0) { oModel.HQty = oModel.HQtyMust - DBUtility.ClsPub.isDoule(oDs2.Tables[0].Rows[0]["HQty"]); if (oModel.HQty <= 0) { sReturn = "扫描数量总和不能大于实际数量！"; return false; } } else { oModel.HQty = DBUtility.ClsPub.isDoule(sQty); if (oModel.HQty < 0) { sReturn = "输入的数量不能小于0！"; return false; } if (oModel.HQtyMust <= DBUtility.ClsPub.isDoule(oDs2.Tables[0].Rows[0]["HQty"])) { sReturn = "扫描数量总和不能大于实际数量！"; return false; } } oModel.HQtyMust = 0; oCn.RunProc("Insert into " + MvarItemKey + " " + " (HInterID,HBillNo,HBillType,HMaterID,HProcID,HWhID,HSCWHID" + ",HStockPlaceID,HOutStockPlaceID,HGroupID,HQty,HQtyMust,HPieceQty " + ",HBatchNo,HBarCode,HAddr,HMaker,HMakeDate " + ",HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo" + ",HRelationInterID,HRelationEntryID,HRelationBillNo,HRedBlueFlag) " + " Values(" + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HProcID.ToString() + "," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() + "," + oModel.HStockPlaceID.ToString() + "," + oModel.HOutStockPlaceID.ToString() + "," + oModel.HGroupID.ToString() + "," + oModel.HQty.ToString() + "," + oModel.HQtyMust.ToString() + "," + oModel.HPieceQty.ToString() + ",'" + oModel.HBatchNo + "','" + oModel.HBarCode + "','" + oModel.HAddr + "','" + oModel.HMaker + "',getdate()" + "," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" + oModel.HSourceBillNo + "'" + "," + oModel.HRelationInterID.ToString() + "," + oModel.HRelationEntryID.ToString() + ",'" + oModel.HRelationBillNo + "'," + Convert.ToString(oModel.HRedBlueFlag ? 1 : 0) + ")", ref DBUtility.ClsPub.sExeReturnInfo); //修改上级为非末级代码 //oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); oCn.Commit(); oCn.CnClose(); oCn.CnDispose(); sReturn = "保存成功！"; return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //新增(源单) 根据源单单号 批量新增源单信息 public bool AddNew_Source(long sNewInterID, string sNewBillNo, string sNewBillType, string sSourceBillNo, string sSourceBillType, string sRedBlueflag, ref string sReturn) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); try { DataSet oDs = new DataSet(); oCn.BeginTran(); oDs = oCn.RunProcReturn("exec h_p_K3_SourceBill_Check_Add " + sNewInterID.ToString() + ",'" + sNewBillNo + "','" + sNewBillType + "','" + sSourceBillNo + "','" + sSourceBillType + "','" + sRedBlueflag + "'", "h_p_K3_SourceBill_Check_Add"); if (oDs.Tables[0].Rows.Count == 0 || oDs == null) { oCn.Commit(); oCn.CnClose(); oCn.CnDispose(); sReturn = "null未知错误！"; return false; } if (DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0][0]) == 1) { //输入源单信息不准确，请输入较完整的单据号 oCn.Commit(); oCn.CnClose(); oCn.CnDispose(); sReturn = "输入源单信息不准确，请输入较完整的单据号！"; return false; } else if (DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0][0]) == 9) { //保存成功 oCn.Commit(); oCn.CnClose(); oCn.CnDispose(); sReturn = "保存成功！"; return true; } else { oCn.Commit(); oCn.CnClose(); oCn.CnDispose(); sReturn = "else未知错误！"; return false; } // } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //新增(源单) 根据源单单号 批量新增源单信息 public bool AddNew_Aduit_Source(long sNewInterID, string sNewBillNo, string sNewBillType, string sSourceBillNo, string sSourceBillType, string sRedBlueflag, ref string sReturn) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); try { DataSet oDs = new DataSet(); oCn.BeginTran(); oDs = oCn.RunProcReturn("exec h_p_K3_SourceBill_Audit_Add " + sNewInterID.ToString() + ",'" + sNewBillNo + "','" + sNewBillType + "','" + sSourceBillNo + "','" + sSourceBillType + "','" + sRedBlueflag + "'", "h_p_K3_SourceBill_Audit_Add"); if (oDs.Tables[0].Rows.Count == 0 || oDs == null) { oCn.Commit(); oCn.CnClose(); oCn.CnDispose(); sReturn = "null未知错误！"; return false; } if (DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0][0]) == 1) { //输入源单信息不准确，请输入较完整的单据号 oCn.Commit(); oCn.CnClose(); oCn.CnDispose(); sReturn = "输入源单信息不准确，请输入较完整的单据号！"; return false; } else if (DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0][0]) == 9) { //保存成功 oCn.Commit(); oCn.CnClose(); oCn.CnDispose(); sReturn = "保存成功！"; return true; } else { oCn.Commit(); oCn.CnClose(); oCn.CnDispose(); sReturn = "else未知错误！"; return false; } // } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //新增(源单) 根据源单单号 批量新增源单信息（倒箱单） public bool AddNew_Source_ChangeBox(long sNewInterID, string sNewBillNo, string sNewBillType, string sSourceBillNo, string sSourceBillType, string sRedBlueflag, long sInterID, string sBillNo, string sMaker, ref string sReturn) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // DataSet oDs = new DataSet(); // oCn.BeginTran(); // oDs = oCn.RunProcReturn("exec h_p_K3_SourceBill_Check_ChangeBox_Add " + sNewInterID.ToString() + ",'" + sNewBillNo + "','" + sNewBillType + "','" + sSourceBillNo + "','" + sSourceBillType + "','" + sRedBlueflag + "'," + sInterID.ToString() + ",'" + sBillNo + "','" + sMaker + "'", "h_p_K3_SourceBill_Check_ChangeBox_Add"); // if (oDs.Tables[0].Rows.Count == 0 || oDs == null) // { // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "null未知错误！"; // return false; // } // if (DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0][0]) == 1) // { // //输入源单信息不准确，请输入较完整的单据号 // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "输入源单信息不准确，请输入较完整的单据号！"; // return false; // } // else if (DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0][0]) == 9) // { // //保存成功 // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "保存成功！"; return true; // } // else // { // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "else未知错误！"; // return false; // } // // //} //catch (Exception e) //{ // sReturn = e.Message; // oCn.RollBack(); // throw (e); //} } //新增(源单) 根据源单单号 批量新增源单信息 (先进先出) public bool AddNew_Source_FIFO(long sNewInterID, string sNewBillNo, string sNewBillType, string sSourceBillNo, string sSourceBillType, long sHWHID, string sRedBlueflag, ref string sReturn) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // DataSet oDs = new DataSet(); // oCn.BeginTran(); // oDs = oCn.RunProcReturn("exec h_p_K3_SourceBill_Check_FIFO_Add " + sNewInterID.ToString() + ",'" + sNewBillNo + "','" + sNewBillType + "','" + sSourceBillNo + "','" + sSourceBillType + "'," + sHWHID.ToString(), "h_p_K3_SourceBill_Check_FIFO_Add"); // if (oDs.Tables[0].Rows.Count == 0 || oDs == null) // { // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "null未知错误！"; // return false; // } // if (DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0][0]) == 1) // { // //输入源单信息不准确，请输入较完整的单据号 // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "输入源单信息不准确，请输入较完整的单据号！"; // return false; // } // else if (DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0][0]) == 9) // { // //保存成功 // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "保存成功！"; return true; // } // else // { // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "else未知错误！"; // return false; // } // // //} //catch (Exception e) //{ // sReturn = e.Message; // oCn.RollBack(); // throw (e); //} } //新增(一张单据,存在相同物料) public bool AddNew_Select_Check(ref string sReturn) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // DataSet oDs = new DataSet(); // oCn.BeginTran(); // oDs = oCn.RunProcReturn("select HQtyMust,HWhID,HStockPlaceID,HSCWHID,HOutStockPlaceID from " + MvarItemKey + " where HInterID=" + oModel.HInterID.ToString() + " and HMaterID=" + oModel.HMaterID.ToString() + " and HSourceInterID=" + oModel.HSourceInterID + " and HSourceEntryID=" + oModel.HSourceEntryID, "KF_PonderationBillMain_Audit_Temp"); // if (oDs != null && oDs.Tables[0].Rows.Count > 0) // { // oModel.HQtyMust =0; // oModel.HWhID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HWhID"]); // oModel.HStockPlaceID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HStockPlaceID"]); // oModel.HSCWHID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSCWHID"]); // oModel.HOutStockPlaceID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HOutStockPlaceID"]); // oModel.HBatchNo = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HBatchNo"]); // } // oCn.RunProc("Insert into " + MvarItemKey + " " + // " (HInterID,HBillNo,HBillType,HMaterID,HProcID,HWhID,HSCWHID" + // ",HStockPlaceID,HOutStockPlaceID,HGroupID,HQty,HQtyMust,HPieceQty " + // ",HBatchNo,HBarCode,HAddr,HMaker,HMakeDate " + // //",HVDAPack,HVDAMaterNum,HVDAQty " + // ",HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo" + // ",HRelationInterID,HRelationEntryID,HRelationBillNo,HRedBlueFlag) " + // " Values(" + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HProcID.ToString() + "," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() + // "," + oModel.HStockPlaceID.ToString() + "," + oModel.HOutStockPlaceID.ToString() + "," + oModel.HGroupID.ToString() + "," + oModel.HQty.ToString() + "," + oModel.HQtyMust.ToString() + "," + oModel.HPieceQty.ToString() + // ",'" + oModel.HBatchNo + "','" + oModel.HBarCode + "','" + oModel.HAddr + "','" + oModel.HMaker + "',getdate()" + // //",'','',0 " + // "," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" + oModel.HSourceBillNo + "'" + // "," + oModel.HRelationInterID.ToString() + "," + oModel.HRelationEntryID.ToString() + ",'" + oModel.HRelationBillNo + "'," + Convert.ToString(oModel.HRedBlueFlag ? 1 : 0) + ")", ref DBUtility.ClsPub.sExeReturnInfo); // //修改上级为非末级代码 // //oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "保存成功！"; return true; //} //catch (Exception e) //{ // sReturn = e.Message; // oCn.RollBack(); // throw (e); //} } //新增(一张单据,存在相同物料) public bool AddNew_Select(ref string sReturn) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // DataSet oDs = new DataSet(); // oCn.BeginTran(); // oDs = oCn.RunProcReturn("select HQtyMust from " + MvarItemKey + " where HInterID=" + oModel.HInterID.ToString() + " and HMaterID=" + oModel.HMaterID.ToString() + " and HSourceInterID=" + oModel.HSourceInterID + " and HSourceEntryID=" + oModel.HSourceEntryID, "KF_PonderationBillMain_Audit_Temp"); // if (oDs != null && oDs.Tables[0].Rows.Count > 0) // { // oModel.HQtyMust = DBUtility.ClsPub.isDoule(oDs.Tables[0].Rows[0]["HQtyMust"]); // } // oCn.RunProc("Insert into " + MvarItemKey + " " + // " (HInterID,HBillNo,HBillType,HMaterID,HProcID,HWhID,HSCWHID" + // ",HStockPlaceID,HOutStockPlaceID,HGroupID,HQty,HQtyMust,HPieceQty " + // ",HBatchNo,HBarCode,HAddr,HMaker,HMakeDate " + // //",HVDAPack,HVDAMaterNum,HVDAQty " + // ",HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo" + // ",HRelationInterID,HRelationEntryID,HRelationBillNo,HRedBlueFlag) " + // " Values(" + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HProcID.ToString() + "," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() + // "," + oModel.HStockPlaceID.ToString() + "," + oModel.HOutStockPlaceID.ToString() + "," + oModel.HGroupID.ToString() + "," + oModel.HQty.ToString() + "," + oModel.HQtyMust.ToString() + "," + oModel.HPieceQty.ToString() + // ",'" + oModel.HBatchNo + "','" + oModel.HBarCode + "','" + oModel.HAddr + "','" + oModel.HMaker + "',getdate()" + // //",'','', 0 " + // "," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" + oModel.HSourceBillNo + "'" + // "," + oModel.HRelationInterID.ToString() + "," + oModel.HRelationEntryID.ToString() + ",'" + oModel.HRelationBillNo + "'," + Convert.ToString(oModel.HRedBlueFlag ? 1 : 0) + ")", ref DBUtility.ClsPub.sExeReturnInfo); // //修改上级为非末级代码 // //oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "保存成功！"; return true; //} //catch (Exception e) //{ // sReturn = e.Message; // oCn.RollBack(); // throw (e); //} } //新增(一张单据,存在相同物料) public bool AddNew_More_Select(ref string sReturn) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // oCn.BeginTran(); // //箱号条码,批量新增 // oCn.RunProc("exec h_p_KF_PonderationBillMain_Audit_Temp_Add_Select " + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "','" + oModel.HBarCode + "','" + oModel.HMaker + "'," + oModel.HSourceInterID + "," + oModel.HSourceEntryID, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "保存成功！"; return true; //} //catch (Exception e) //{ // sReturn = e.Message; // oCn.RollBack(); // throw (e); //} } //新增(盘点 扫仓库带出该仓库所有库存信息) public bool AddNew_CheckStock(long HInterID, string HBillNo, string sBillType, long HWHID, long HSPID, ref string sReturn) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // oCn.BeginTran(); // //批量新增 // oCn.RunProc("exec h_p_Kf_CheckStock_Add " + HInterID.ToString() + ",'" + HBillNo + "','" + sBillType + "'," + HWHID.ToString() + "," + HSPID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "保存成功！"; return true; //} //catch (Exception e) //{ // sReturn = e.Message; // oCn.RollBack(); // throw (e); //} } //新增(常规物料条码记录) public bool AddNew_More_ChangGui(long HInterID, long HMaterID, string sBillType, double sQty, ref string sReturn) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // oCn.BeginTran(); // //批量新增 // oCn.RunProc("exec h_p_KF_PonderationBillMain_Audit_Temp_Add_ChangGui " + HInterID + ",'" + sBillType + "'," + HMaterID + "," + sQty, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "保存成功！"; return true; //} //catch (Exception e) //{ // sReturn = e.Message; // oCn.RollBack(); // throw (e); //} } //新增(常规物料条码记录) public bool AddNew_More_ChangGui(long HInterID, long HMaterID, Int64 HWhID, Int64 HSPID, Int64 HSCWhID, Int64 HSCSPID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, string sBarCode, string sBillType, double sQty, ref string sReturn) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // oCn.BeginTran(); // //批量新增 // oCn.RunProc("exec h_p_KF_PonderationBillMain_Audit_Temp_Add_BatchNo " + HInterID + ",'" + sBillType + "'" + // "," + HMaterID + // "," + HWhID + // "," + HSPID + // "," + HSCWhID + // "," + HSCSPID + // ",'" + HBatchNo + "'" + // "," + HSourceInterID + // "," + HSourceEntryID + // ",'" + sBarCode + "'" + // "," + sQty, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "保存成功！"; return true; //} //catch (Exception e) //{ // sReturn = e.Message; // oCn.RollBack(); // throw (e); //} } //减少(常规物料条码记录) public bool AddNew_Clear_ChangGui(long HInterID, long HMaterID, Int64 HWhID, Int64 HSPID, Int64 HSCWhID, Int64 HSCSPID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, string sBarCode, string sBillType, double sQty, ref string sReturn) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // oCn.BeginTran(); // //批量新增 // oCn.RunProc("exec h_p_KF_PonderationBillMain_Audit_Temp_Clear_BatchNo " + HInterID + ",'" + sBillType + "'" + // "," + HMaterID + // "," + HWhID + // "," + HSPID + // "," + HSCWhID + // "," + HSCSPID + // ",'" + HBatchNo + "'" + // "," + HSourceInterID + // "," + HSourceEntryID + // ",'" + sBarCode + "'" + // "," + sQty, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "减少成功！"; return true; //} //catch (Exception e) //{ // sReturn = e.Message; // oCn.RollBack(); // throw (e); //} } //新增 public override bool AddNew() { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); try { oCn.BeginTran(); oCn.RunProc("Insert into " + MvarItemKey + " " + " (HInterID,HBillNo,HBillType,HMaterID,HProcID,HWhID,HSCWHID" + ",HStockPlaceID,HOutStockPlaceID,HGroupID,HQty,HQtyMust,HPieceQty " + ",HBarCode,HAddr,HMaker,HMakeDate " + ",HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo" + ",HRelationInterID,HRelationEntryID,HRelationBillNo) " + " Values(" + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HProcID.ToString() + "," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() + "," + oModel.HStockPlaceID.ToString() + "," + oModel.HOutStockPlaceID.ToString() + "," + oModel.HGroupID.ToString() + "," + oModel.HQty.ToString() + "," + oModel.HQtyMust.ToString() + "," + oModel.HPieceQty.ToString() + ",'" + oModel.HBarCode + "','" + oModel.HAddr + "','" + oModel.HMaker + "',getdate()" + "," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" +oModel.HSourceBillNo+"'"+ "," + oModel.HRelationInterID.ToString() + "," + oModel.HRelationEntryID.ToString() + ",'" + oModel.HRelationBillNo + "')", ref DBUtility.ClsPub.sExeReturnInfo); //修改上级为非末级代码 //oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); oCn.Commit(); oCn.CnClose(); oCn.CnDispose(); return true; } catch (Exception e) { oCn.RollBack(); throw (e); } } //新增 public bool AddNew_More() { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // oCn.BeginTran(); // //箱号条码,批量新增 // oCn.RunProc("exec h_p_KF_PonderationBillMain_Audit_Temp_Add " + oModel.HInterID.ToString() + "," + oModel.HWhID.ToString() + ",'" + oModel.HBillType + "','" + oModel.HBarCode + "'," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" + oModel.HMaker + "'", ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); return true; //} //catch (Exception e) //{ // oCn.RollBack(); // throw (e); //} } public bool AddNew_Sell() { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // DataSet oDs = new DataSet(); // oCn.BeginTran(); // oDs = oCn.RunProcReturn("select * from " + MvarItemKey + " where HInterID=" + oModel.HInterID.ToString() + " and HMaterID=" + oModel.HMaterID.ToString(), "KF_PonderationBillMain_Audit_Temp"); // if (oDs == null || oDs.Tables[0].Rows.Count == 0) // { // return false; // } // else // { // //if (oModel.HBillType == "21") // //{ // // oModel.HWhID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HWhID"]); // //} // //else if (oModel.HBillType == "41") // //{ // // oModel.HSCWHID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSCWhID"]); // //} // oModel.HQtyMust = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HQtyMust"]); // oModel.HSourceInterID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceInterID"]); // oModel.HSourceEntryID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceEntryID"]); // oModel.HSourceBillType = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillType"]); // oModel.HSourceBillNo = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillNo"]); // } // oCn.RunProc("Insert into " + MvarItemKey + " " + // " (HInterID,HBillNo,HBillType,HMaterID,HProcID,HWhID,HSCWHID" + // ",HStockPlaceID,HOutStockPlaceID,HGroupID,HQty,HQtyMust,HPieceQty " + // ",HBarCode,HAddr,HMaker,HMakeDate " + // ",HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo" + // ",HRelationInterID,HRelationEntryID,HRelationBillNo) " + // " Values(" + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HProcID.ToString() + "," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() + // "," + oModel.HStockPlaceID.ToString() + "," + oModel.HOutStockPlaceID.ToString() + "," + oModel.HGroupID.ToString() + "," + oModel.HQty.ToString() + "," + oModel.HQtyMust.ToString() + "," + oModel.HPieceQty.ToString() + // ",'" + oModel.HBarCode + "','" + oModel.HAddr + "','" + oModel.HMaker + "',getdate()" + // "," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" + oModel.HSourceBillNo + "'" + // "," + oModel.HRelationInterID.ToString() + "," + oModel.HRelationEntryID.ToString() + ",'" + oModel.HRelationBillNo + "')", ref DBUtility.ClsPub.sExeReturnInfo); // //修改上级为非末级代码 // //oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); return true; //} //catch (Exception e) //{ // oCn.RollBack(); // throw (e); //} } //新增 public bool AddNew_More_Sell() { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // oCn.BeginTran(); // //箱号条码,批量新增 // oCn.RunProc("exec h_p_KF_PonderationBillMain_Audit_Temp_Add_Sell " + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "','" + oModel.HBarCode + "'," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() + ",'" + oModel.HMaker + "'", ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); return true; //} //catch (Exception e) //{ // oCn.RollBack(); // throw (e); //} } //新增(一张单据,存在相同物料) public bool AddNew_Select() { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // DataSet oDs = new DataSet(); // oCn.BeginTran(); // oDs = oCn.RunProcReturn("select * from " + MvarItemKey + " where HInterID=" + oModel.HInterID.ToString() + " and HMaterID=" + oModel.HMaterID.ToString() + " and HSourceInterID=" + oModel.HSourceInterID + " and HSourceEntryID=" + oModel.HSourceEntryID, "KF_PonderationBillMain_Audit_Temp"); // if (oDs == null || oDs.Tables[0].Rows.Count == 0) // { // return false; // } // else // { // //if (oModel.HBillType == "21") // //{ // // oModel.HWhID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HWhID"]); // //} // //else if (oModel.HBillType == "41") // //{ // // oModel.HSCWHID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSCWhID"]); // //} // oModel.HQtyMust = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HQtyMust"]); // oModel.HSourceInterID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceInterID"]); // oModel.HSourceEntryID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceEntryID"]); // oModel.HSourceBillType = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillType"]); // oModel.HSourceBillNo = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillNo"]); // } // oCn.RunProc("Insert into " + MvarItemKey + " " + // " (HInterID,HBillNo,HBillType,HMaterID,HProcID,HWhID,HSCWHID" + // ",HStockPlaceID,HOutStockPlaceID,HGroupID,HQty,HQtyMust,HPieceQty " + // ",HBarCode,HAddr,HMaker,HMakeDate " + // ",HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo" + // ",HRelationInterID,HRelationEntryID,HRelationBillNo) " + // " Values(" + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HProcID.ToString() + "," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() + // "," + oModel.HStockPlaceID.ToString() + "," + oModel.HOutStockPlaceID.ToString() + "," + oModel.HGroupID.ToString() + "," + oModel.HQty.ToString() + "," + oModel.HQtyMust.ToString() + "," + oModel.HPieceQty.ToString() + // ",'" + oModel.HBarCode + "','" + oModel.HAddr + "','" + oModel.HMaker + "',getdate()" + // "," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" + oModel.HSourceBillNo + "'" + // "," + oModel.HRelationInterID.ToString() + "," + oModel.HRelationEntryID.ToString() + ",'" + oModel.HRelationBillNo + "')", ref DBUtility.ClsPub.sExeReturnInfo); // //修改上级为非末级代码 // //oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); return true; //} //catch (Exception e) //{ // oCn.RollBack(); // throw (e); //} } //新增(一张单据,存在相同物料) public bool AddNew_More_Select() { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // oCn.BeginTran(); // //箱号条码,批量新增 // oCn.RunProc("exec h_p_KF_PonderationBillMain_Audit_Temp_Add_Select " + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "','" + oModel.HBarCode + "','" + oModel.HMaker + "'," + oModel.HSourceInterID + "," + oModel.HSourceEntryID, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); return true; //} //catch (Exception e) //{ // oCn.RollBack(); // throw (e); //} } //新增(出入库单据已经生成，需要关联条码记录时) public bool AddNew_Check(ref string sReturn) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // oCn.BeginTran(); // //箱号条码,批量新增 // oCn.RunProc("exec h_p_KF_PonderationBillMain_Audit_Temp_Add_Check " + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HQty.ToString() + ",'" + oModel.HBarCode + "','" + oModel.HMaker + "'," + Convert.ToString(oModel.HRedBlueFlag ? 1 : 0), ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "保存成功！"; return true; //} //catch (Exception e) //{ // sReturn = e.Message; // oCn.RollBack(); // throw (e); //} } //新增(常规物料条码记录) public bool AddNew_More_ChangGui(long HInterID, long HMaterID, string sBillType, int sQty) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // oCn.BeginTran(); // //批量新增 // oCn.RunProc("exec h_p_KF_PonderationBillMain_Audit_Temp_Add_ChangGui " + HInterID + ",'" + sBillType + "'," + HMaterID + "," + sQty, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); return true; //} //catch (Exception e) //{ // oCn.RollBack(); // throw (e); //} } //新增(常规物料条码记录) public bool AddNew_More_ChangGui(long HInterID, long HMaterID, Int64 HWhID, Int64 HSPID, Int64 HSCWhID, Int64 HSCSPID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, string sBarCode, string sBillType, int sQty) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // oCn.BeginTran(); // //批量新增 // oCn.RunProc("exec h_p_KF_PonderationBillMain_Audit_Temp_Add_BatchNo " + HInterID + ",'" + sBillType + "'" + // "," + HMaterID + // "," + HWhID + // "," + HSPID + // "," + HSCWhID + // "," + HSCSPID + // ",'" + HBatchNo + "'" + // "," + HSourceInterID + // "," + HSourceEntryID + // ",'" + sBarCode + "'" + // "," + sQty, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); return true; //} //catch (Exception e) //{ // oCn.RollBack(); // throw (e); //} } //减少(常规物料条码记录) public bool AddNew_Clear_ChangGui(long HInterID, long HMaterID, Int64 HWhID, Int64 HSPID, Int64 HSCWhID, Int64 HSCSPID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, string sBarCode, string sBillType, int sQty) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //try //{ // oCn.BeginTran(); // //批量新增 // oCn.RunProc("exec h_p_KF_PonderationBillMain_Audit_Temp_Clear_BatchNo " + HInterID + ",'" + sBillType + "'" + // "," + HMaterID + // "," + HWhID + // "," + HSPID + // "," + HSCWhID + // "," + HSCSPID + // ",'" + HBatchNo + "'" + // "," + HSourceInterID + // "," + HSourceEntryID + // ",'" + sBarCode + "'" + // "," + sQty, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.Commit(); // oCn.CnClose(); // oCn.CnDispose(); return true; //} //catch (Exception e) //{ // oCn.RollBack(); // throw (e); //} } //修改 public override bool ModifyByID(Int64 sItemID) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); try { oCn.BeginTran(); //oCn.RunProc("Update " + MvarItemKey + " set " + // " HNumber='" + oModel.HNumber + "'" + // ",HName='" + oModel.HName + "'" + // ",HShortNumber='" + oModel.HShortNumber + "'" + // ",HHelpCode='" + oModel.HHelpCode + "'" + // ",HLevel=" + oModel.HLevel.ToString() + // ",HParentID=" + oModel.HParentID.ToString() + // ",HEndflag=" + Convert.ToString(oModel.HEndFlag ? 1 : 0) + // ",HStopflag=" + Convert.ToString(oModel.HStopflag ? 1 : 0) + // ",HEnglishName='" + oModel.HEnglishName + "'" + // ",HRemark= '" + oModel.HRemark + "' Where HItemID=" + sItemID, ref DBUtility.ClsPub.sExeReturnInfo); //修改子项目代码 //oCn.RunProc("exec h_p_Gy_UpdateNumber '" + MvarItemKey + "','" + oModel.HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); ////将上级 为非末级 //oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); // oCn.CnClose(); oCn.CnDispose(); oCn.Commit(); return true; } catch (Exception e) { oCn.RollBack(); throw (e); } } //根据代码判断信息 public override bool HavParentCode(string sCode, Int64 sItemID) { DataSet DS; try { //DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HStopflag=0 and HNumber='" + sCode + "' and HItemID<>" + sItemID, MvarItemKey, ref Pub_Class.ClsPub.sExeReturnInfo); //if (DS.Tables[0].Rows.Count == 0) // return false; //else //{ // oModel.HItemID = Convert.ToInt64(DS.Tables[0].Rows[0]["HItemID"]); return true; //} } catch (Exception e) { throw (e); } } //判断条码 入库数量是否超过条码本身额定数量 public bool IsBarCode(string sBarCode, string sBillType, bool sRedBlueFlag, ref double sQty, ref string sReturn) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //DataSet DS; //try //{ // DS = oCn.RunProcReturn("exec h_p_K3_IsBarCode '" + sBarCode + "'," + sQty.ToString(), "h_p_K3_IsBarCode", ref DBUtility.ClsPub.sExeReturnInfo); // if (DS.Tables[0].Rows.Count == 0) // { // sQty = sQty; // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "正常！"; // return true; //不存在 入库数量超过条码本身额定数量 条码 // } // else // { // if (DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HQty"]) <= 0) // { // sQty = 0; // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "此条码已被其他单据扫描！"; // return false; // } // else // { // sQty = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HQty"]); // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "已获取未扫描数量！"; return true; // } // } //} //catch (Exception e) //{ // sReturn = e.Message; // throw (e); //} } //判断条码临时表中是否存在 public bool IsBarCode(string sBarCode, long HInterID, long HErpClsID, string sBillType) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet DS; try { //if (HErpClsID == 2) //{ // return true; //} DS = oCn.RunProcReturn("Select 1 from KF_PonderationBillMain_Audit_Temp Where HInterID=" + HInterID.ToString() + " and HSourceLine=0 and HBarCode='" + sBarCode + "' and HBillType='" + sBillType + "'", "KF_PonderationBillMain_Audit_Temp", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) { oCn.CnClose(); oCn.CnDispose(); return true; //不存在相同条码 } else { oCn.CnClose(); oCn.CnDispose(); return false; } } catch (Exception e) { throw (e); } } //判断条码临时表中是否存在 public bool IsBarCode(string sBarCode, long HInterID, string sBillType) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet DS; try { DS = oCn.RunProcReturn("Select * from KF_PonderationBillMain_Audit_Temp Where HInterID=" + HInterID.ToString() + " and HBarCode='" + sBarCode + "' and HBillType='" + sBillType + "'", "KF_PonderationBillMain_Audit_Temp", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) { oCn.CnClose(); oCn.CnDispose(); return true; //不存在相同条码 } else { oCn.CnClose(); oCn.CnDispose(); return false; } } catch (Exception e) { throw (e); } } //判断箱号条码临时表中是否存在 public bool IsBarCode_Pack(string sBarCode_Pack, long HInterID, string sBillType) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet DS; try { DS = oCn.RunProcReturn("Select * from KF_PonderationBillMain_Audit_Temp Where HInterID=" + HInterID.ToString() + " and HBarCode_Pack='" + sBarCode_Pack + "' and HBillType='" + sBillType + "'", "KF_PonderationBillMain_Audit_Temp", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) { oCn.CnClose(); oCn.CnDispose(); return true; //不存在相同箱号条码 } else { oCn.CnClose(); oCn.CnDispose(); return false; } } catch (Exception e) { throw (e); } } ////判断明细表中条码扫描数量是否超过条码本身额定数量 //public bool IsBarCode_Sub(long HInterID, string sBillType, long HMaterID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, ref string sReturn) //{ // SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); // DataSet DS; // DataSet DS2; // string sBarCode; // double sQty; // string sWhere = ""; // try // { // DS = oCn.RunProcReturn("Select HBarCode,sum(HQty) HQty from KF_PonderationBillMain_Audit_Temp Where HQty<>0 and HInterID=" + HInterID.ToString() + // " and HBillType='" + sBillType + "'" + // " and HMaterID=" + HMaterID + // " and (HBatchNo='" + HBatchNo + "' or '" + HBatchNo + "' ='')" + // " and HSourceInterID=" + HSourceInterID + // " and HSourceEntryID=" + HSourceEntryID + // sWhere + // " Group by HBarCode", "KF_PonderationBillMain_Audit_Temp", ref DBUtility.ClsPub.sExeReturnInfo); // if (DS == null || DS.Tables[0].Rows.Count == 0) // { // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "正常！"; // return true; // } // for (int i = 0; i <= DS.Tables[0].Rows.Count - 1; i++) // { // sBarCode = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[i]["HBarCode"].ToString()); // sQty = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[i]["HQty"].ToString()); // DS2 = oCn.RunProcReturn("exec h_p_K3_IsBarCodeQty '" + sBarCode + "'," + sQty.ToString(), "h_p_K3_IsBarCodeQty", ref DBUtility.ClsPub.sExeReturnInfo); // if (DS2.Tables[0].Rows.Count == 0 && DBUtility.ClsPub.isDoule(DS2.Tables[1].Rows[0]["HQty"]) >= sQty) // { // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "正常！"; // return true; // } // else if (DBUtility.ClsPub.isDoule(DS2.Tables[0].Rows[0]["HQty"]) <= 0) // { // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "条码" + sBarCode + "已被其他单据扫描！"; // return false; // } // else if (sQty > DBUtility.ClsPub.isDoule(DS2.Tables[0].Rows[0]["HQty"])) // { // oCn.CnClose(); // oCn.CnDispose(); // sReturn = "条码" + sBarCode + "的扫描数量" + sQty + "大于该条码未扫描数量" + DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HQty"]) + "！"; // return false; // } // else // { // } // } // } // catch (Exception e) // { // sReturn = e.Message; // throw (e); // } // return false; //} //判断源单是否已稽核过 public bool IsAuditBill(long sHInterID, string sHBillType) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet DS; try { DS = oCn.RunProcReturn("Select * from Kf_ICStockBillSub_Audit_WMS Where HInterID=" + sHInterID.ToString() + " and HBillType='" + sHBillType + "'", "Kf_ICStockBillSub_Audit_WMS", ref DBUtility.ClsPub.sExeReturnInfo); if (DS.Tables[0].Rows.Count == 0) { oCn.CnClose(); oCn.CnDispose(); return true; //未稽核过 } else { oCn.CnClose(); oCn.CnDispose(); return false; } } catch (Exception e) { throw (e); } } //删除条码出入库记录 public bool DeleteByICStockBill(Int64 sHInterID, string sHBillType) { try { oCn.RunProc("Delete from Kf_ICStockBillSub_Audit_WMS where HInterID=" + sHInterID.ToString() + " and HBillType='" + sHBillType + "'", ref DBUtility.ClsPub.sExeReturnInfo); return true; } catch (Exception e) { throw (e); } } //生成盘点单时 判断实际条码盘点数量和条码库存数量是否一致 public bool IsCheckStock_ICInventory(long sHInterID) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet DS; try { DS = oCn.RunProcReturn(" exec h_p_Kf_CheckStockBill_ICInventory " + sHInterID, "h_p_Kf_CheckStockBill_ICInventory", ref DBUtility.ClsPub.sExeReturnInfo); if (DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0][0]) == 0) { oCn.CnClose(); oCn.CnDispose(); return true; } else { oCn.CnClose(); oCn.CnDispose(); return false; //实际条码盘点数量和条码库存数量不一致 } } catch (Exception e) { throw (e); } } // 回填条码临时表字段 HRelationInterID=1（条码出入库记录生成成功后回填） public bool UpDateByRelationInterID(Int64 sHInterID, string sHBillType) { try { oCn.RunProc("UpDate KF_PonderationBillMain_Audit_Temp set HRelationInterID=1 Where HInterID=" + sHInterID.ToString() + " and HBillType='" + sHBillType + "'", ref DBUtility.ClsPub.sExeReturnInfo); return true; } catch (Exception e) { throw (e); } } //构造函数 public ClsKF_PonderationBillMain_Audit_Temp_Ctl() { MvarItemKey = "KF_PonderationBillMain_Audit_Temp"; MvarReportTitle = "出入库条码稽核临时表"; oModel = new Model.ClsKF_PonderationBillMain_Audit_Temp(); } } }