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 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.HQtyMust = DBUtility.ClsPub.isDoule(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"]);
|
}
|
else
|
{
|
oModel.HQtyMust = 0;
|
}
|
|
oCn.RunProc("Insert into " + MvarItemKey + " " +
|
" (HInterID,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.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,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.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.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,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.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 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() + ",'" + 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 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() + ",'" + 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 = DBUtility.ClsPub.isDoule(oDs.Tables[0].Rows[0]["HQtyMust"]);
|
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"]);
|
}
|
oCn.RunProc("Insert into " + MvarItemKey + " " +
|
" (HInterID,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.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,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.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.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,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.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,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.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.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,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.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.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.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HQty.ToString() + ",'" + oModel.HBarCode + "','" + oModel.HMaker + "'", 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 ClsKF_PonderationBillMain_Temp_Ctl()
|
{
|
MvarItemKey = "KF_PonderationBillMain_Temp";
|
MvarReportTitle = "出入库条码临时表";
|
oModel = new Model.ClsKF_PonderationBillMain_Temp();
|
}
|
}
|
}
|
