using System; using System.Collections.Generic; using System.Text; using System.Data; namespace DAL { public class ClsKF_PonderationBillMain_Temp_Ctl : DBUtility.ClsGy_Base_Ctl { //原代码 用于 替换子项目 public string HOldNumber; public Model.ClsKF_PonderationBillMain_Temp oModel = new Model.ClsKF_PonderationBillMain_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 sSInterID, Int64 sSEntryID, string sHBillType) { try { oCn.RunProc("Delete from " + MvarItemKey + " where HInterID=" + sHInterID.ToString() + " and HMaterID= " + sMaterID.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(); // 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_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_Temp"); // if (oDs != null && oDs.Tables[0].Rows.Count > 0) { 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_Source_sQty(string sQty,ref string sReturn) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); try { DataSet oDs = new DataSet(); DataSet oDs1 = 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_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 from " + MvarItemKey + " where HInterID=" + oModel.HInterID.ToString() + " and HBillType='" + oModel.HBillType + "' and HMaterID=" + oModel.HMaterID.ToString() + " and HQty=0 ", "KF_PonderationBillMain_Temp"); // if (oDs != null && oDs.Tables[0].Rows.Count > 0) { if (sQty == "") { oModel.HQty = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HQtyMust"]); } else { oModel.HQty = DBUtility.ClsPub.isLong(sQty); } 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 " + ",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_sQty(string sQty,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_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_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_Temp"); if (sQty == "") { 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; } } } 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_sQty_FIFO(string sQty, ref string sReturn) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); try { DataSet oDs = new DataSet(); DataSet oDs1 = 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_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 1 from Kf_ICInventory_FIFO_Tmp where HBillType='" + oModel.HBillType + "' and HMaterID=" + oModel.HMaterID.ToString() + " and HQty=0 and HWhID= " + oModel.HWhID.ToString() + " and HSPID= " + oModel.HStockPlaceID.ToString() + " and HBillNo= '" + oModel.HBillNo + "'", "Kf_ICInventory_FIFO_Tmp"); if (oDs != null && oDs.Tables[0].Rows.Count > 0) { oDs = oCn.RunProcReturn("select HSumQtyMust,HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo from Kf_ICInventory_FIFO_Tmp where HBillType='" + oModel.HBillType + "' and HMaterID=" + oModel.HMaterID.ToString() + " and HQty=0 and HWhID= " + oModel.HWhID.ToString() + " and HSPID= " + oModel.HStockPlaceID.ToString() + " and HBillNo= '" + oModel.HBillNo + "'", "Kf_ICInventory_FIFO_Tmp"); // if (oDs != null && oDs.Tables[0].Rows.Count > 0) { if (sQty == "") { oModel.HQty = DBUtility.ClsPub.isDoule(oDs.Tables[0].Rows[0]["HSumQtyMust"]); if (oModel.HQty < 0) { sReturn = "检查数量是否小于等于实！"; return false; } } else { oModel.HQty = DBUtility.ClsPub.isDoule(sQty); if (oModel.HQty < 0) { sReturn = "输入的数量不能小于0！"; return false; } } 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; } else { sReturn = "物料、批次、仓位没有对应上，重新扫描！"; return false; } } 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_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(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_Source_CLD(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_CLD_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_Source_CLD_CG(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_CLD_SourceBill_Check_Add_CG " + 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_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_Source_FIFO_CLD(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_CLD_SourceBill_Check_FIFO_Add '" + 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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_Temp Where HInterID=" + HInterID.ToString() + " and HBarCode='" + sBarCode + "' and HBillType='" + sBillType + "'", "KF_PonderationBillMain_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_Temp Where HInterID=" + HInterID.ToString() + " and HBarCode='" + sBarCode + "' and HBillType='" + sBillType + "'", "KF_PonderationBillMain_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_Temp Where HInterID=" + HInterID.ToString() + " and HBarCode_Pack='" + sBarCode_Pack + "' and HBillType='" + sBillType + "'", "KF_PonderationBillMain_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_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_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 ClsKF_PonderationBillMain_Temp_Ctl() { MvarItemKey = "KF_PonderationBillMain_Temp"; MvarReportTitle = "出入库条码临时表"; oModel = new Model.ClsKF_PonderationBillMain_Temp(); } } }