using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
|
namespace DAL
|
{
|
public class ClsKF_PonderationBillMain_Audit_Temp_View : DBUtility.ClsGy_Base_View
|
{
|
|
//
|
public Model.ClsKF_PonderationBillMain_Audit_Temp omodel = new Model.ClsKF_PonderationBillMain_Audit_Temp();
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
|
public ClsKF_PonderationBillMain_Audit_Temp_View()
|
{
|
base.MvarReportTitle = "出入库条码稽核临时表";
|
base.MvarItemKey = "KF_PonderationBillMain_Audit_Temp";
|
base.SQLName = "Select HItemID from KF_PonderationBillMain_Audit_Temp Order by HItemID ";
|
}
|
//
|
public void Dispose()
|
{
|
GC.SuppressFinalize(this);
|
}
|
//
|
|
//根据扫描条码 数量 判断条码档案数量
|
public bool CheckQtyByBarCodeBill(long InterID, string sBillType, string sBatchNo, string sBarCode, ref double sRelQty)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("exec h_p_Kf_CheckBarCodeQty " + InterID.ToString() + ",'" + sBillType + "','" + sBatchNo + "','" + sBarCode + "'," + sRelQty.ToString(), "h_p_Kf_CheckBarCodeQty", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
{
|
sRelQty = sRelQty;
|
return true;
|
}
|
else
|
{
|
double sQtyMust = 0;
|
sQtyMust = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HQtyMust"]);
|
sRelQty = sQtyMust;
|
return false;
|
}
|
}
|
catch (Exception e)
|
{
|
sRelQty = 0;
|
throw (e);
|
}
|
}
|
|
////判断明细表中条码库存、K3库存 是否充足 （仓库仓位批次）
|
//public bool CheckQtyByBarCode_Sub(long HInterID, string sBillType, long HMaterID, Int64 HWhID, Int64 HSPID, Int64 HSCWhID, Int64 HSCSPID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, string sWhere, ref string sReturn)
|
//{
|
// DataSet DSBarCode;
|
// DataSet DS;
|
// DataSet DSk3;
|
// string sBarCode;
|
// string sBatchNo;
|
// Int64 sHWHID;
|
// Int64 sHSPID;
|
// double sQty;
|
// try
|
// {
|
// DSBarCode=GetBarCodeByID_View(HInterID, sBillType, HMaterID, HWhID, HSPID, HSCWhID, HSCSPID, HBatchNo, HSourceInterID, HSourceEntryID, sWhere);
|
// if (DSBarCode == null || DSBarCode.Tables[0].Rows.Count == 0)
|
// {
|
// sReturn = "正常！";
|
// return true;
|
// }
|
// for (int i = 0; i <= DSBarCode.Tables[0].Rows.Count - 1; i++)
|
// {
|
// sBarCode = DBUtility.ClsPub.isStrNull(DSBarCode.Tables[0].Rows[i]["HBarCode"].ToString());
|
// sBatchNo = DBUtility.ClsPub.isStrNull(DSBarCode.Tables[0].Rows[i]["HBatchNo"].ToString());
|
// sHWHID = DBUtility.ClsPub.isInt(DSBarCode.Tables[0].Rows[i]["HWHID"].ToString());
|
// sHSPID = DBUtility.ClsPub.isInt(DSBarCode.Tables[0].Rows[i]["HStockPlaceID"].ToString());
|
// sQty = DBUtility.ClsPub.isDoule(DSBarCode.Tables[0].Rows[i]["HQty"].ToString());
|
|
// DS = oCn.RunProcReturn("exec h_p_KF_ICInventory_WMS '" + sBarCode + "'," + sHWHID.ToString() + "," + sHSPID.ToString() + ",'" + sBatchNo + "'", "h_p_KF_ICInventory_WMS", ref DBUtility.ClsPub.sExeReturnInfo);
|
// DSk3 = oCn.RunProcReturn("exec h_p_k3_icinventory '" + sBarCode + "'," + sHWHID.ToString() + "," + sHSPID.ToString(), "h_p_k3_icinventory", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DS.Tables[0].Rows.Count == 0)
|
// {
|
// sReturn = "条码" + sBarCode + "无条码库存！";
|
// return false;
|
// }
|
// else if (DSk3.Tables[0].Rows.Count == 0)
|
// {
|
// sReturn = "条码" + sBarCode + "无K3库存！";
|
// return false;
|
// }
|
// else
|
// {
|
// double sKCQty = 0;
|
// double sKCQtyk3 = 0;
|
// sKCQty = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HQty"]);
|
// sKCQtyk3 = DBUtility.ClsPub.isDoule(DSk3.Tables[0].Rows[0]["HQty"]);
|
// if (sQty > sKCQty && sQty > sKCQtyk3)
|
// {
|
// sReturn = "条码" + sBarCode + "的扫描数量" + sQty + "大于条码库存数量" + sKCQty + "，大于K3库存数量" + sKCQtyk3 + "！";
|
// return false;
|
// }
|
// else if (sQty > sKCQty && sQty < sKCQtyk3)
|
// {
|
// sReturn = "条码" + sBarCode + "的扫描数量" + sQty + "大于条码库存数量" + sKCQty + "！";
|
// return false;
|
// }
|
// else if (sQty < sKCQty && sQty > sKCQtyk3)
|
// {
|
// sReturn = "条码" + sBarCode + "的扫描数量" + sQty + "，大于K3库存数量" + sKCQtyk3 + "！";
|
// return false;
|
// }
|
// else
|
// {
|
|
// }
|
// }
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// sReturn = e.Message;
|
// throw (e);
|
// }
|
// return false;
|
//}
|
|
//根据条码 数量 判断条码库存 是否充足 （仓库仓位）
|
public bool CheckQtyByBarCode(string sBarCode, long HWHID, long HSPID, string sBatchNo, double sQty, ref double sRelQty)
|
{
|
DataSet DS;
|
DataSet DSk3;
|
try
|
{
|
DS = oCn.RunProcReturn("exec h_p_KF_ICInventory_WMS '" + sBarCode + "'," + HWHID.ToString() + "," + HSPID.ToString() + ",'" + sBatchNo + "'", "h_p_KF_ICInventory_WMS", ref DBUtility.ClsPub.sExeReturnInfo);
|
DSk3 = oCn.RunProcReturn("exec h_p_k3_icinventory '" + sBarCode + "'," + HWHID.ToString() + "," + HSPID.ToString(), "h_p_k3_icinventory", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0 || DSk3.Tables[0].Rows.Count == 0)
|
{
|
sRelQty = 0;
|
return false;
|
}
|
else
|
{
|
double sKCQty = 0;
|
double sKCQtyk3 = 0;
|
sKCQty = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HQty"]);
|
sKCQtyk3 = DBUtility.ClsPub.isDoule(DSk3.Tables[0].Rows[0]["HQty"]);
|
if (sQty > sKCQty && sQty > sKCQtyk3)
|
{
|
sRelQty = sKCQtyk3;
|
return false;
|
}
|
else if (sQty > sKCQty && sQty < sKCQtyk3)
|
{
|
sRelQty = sKCQty;
|
return false;
|
}
|
else if (sQty < sKCQty && sQty > sKCQtyk3)
|
{
|
sRelQty = sKCQtyk3;
|
return false;
|
}
|
else
|
{
|
sRelQty = sQty;
|
return true;
|
}
|
}
|
}
|
catch (Exception e)
|
{
|
sRelQty = 0;
|
throw (e);
|
}
|
}
|
|
//根据条码 数量 判断条码库存 是否充足 并且带出 仓库仓位
|
public bool CheckQtyByBarCode(long InterID, string sBillType, string sBarCode, ref long HWHID, ref long HSPID, double sQty, ref double sRelQty)
|
{
|
DataSet DS;
|
DataSet DSk3;
|
try
|
{
|
//单条码，一张单据一条条码
|
//DS = oCn.RunProcReturn("exec h_p_KF_ICInventory_WMS_GetWHAndSP_Single " + InterID.ToString() + ",'" + sBillType + "','" + sBarCode + "'," + HWHID.ToString() + "," + HSPID.ToString(), "h_p_KF_ICInventory_WMS_GetWHAndSP_Single", ref DBUtility.ClsPub.sExeReturnInfo);
|
//原判断条码库存
|
DS = oCn.RunProcReturn("exec h_p_KF_ICInventory_WMS_GetWHAndSP_Audit " + InterID.ToString() + ",'" + sBillType + "','" + sBarCode + "'," + HWHID.ToString() + "," + HSPID.ToString(), "h_p_KF_ICInventory_WMS_GetWHAndSP_Audit", ref DBUtility.ClsPub.sExeReturnInfo);
|
//DS = oCn.RunProcReturn("exec h_p_KF_ICInventory_WMS_GetWHAndSP " + InterID.ToString() + ",'" + sBillType + "','" + sBarCode + "'", "h_p_KF_ICInventory_WMS_GetWHAndSP", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
{
|
sRelQty = 0;
|
return false;
|
}
|
else
|
{
|
double sKFQty = 0;
|
double sKFQtyk3 = 0;
|
sKFQty = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HKFQty"]);
|
HWHID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HWhID"]);
|
HSPID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HSPID"]);
|
DSk3 = oCn.RunProcReturn("exec h_p_K3_ICInventory_WMS_GetWHAndSP_Audit " + InterID.ToString() + ",'" + sBillType + "','" + sBarCode + "'," + HWHID.ToString() + "," + HSPID.ToString(), "h_p_K3_ICInventory_WMS_GetWHAndSP_Audit", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DSk3.Tables[0].Rows.Count == 0)
|
{
|
sRelQty = 0;
|
return false;
|
}
|
sKFQtyk3 = DBUtility.ClsPub.isDoule(DSk3.Tables[0].Rows[0]["HKFQty"]);
|
if (sQty > sKFQty && sQty > sKFQtyk3)
|
{
|
sRelQty = sKFQtyk3;
|
return false;
|
}
|
else if (sQty > sKFQty && sQty < sKFQtyk3)
|
{
|
sRelQty = sKFQty;
|
return false;
|
}
|
else if (sQty < sKFQty && sQty > sKFQtyk3)
|
{
|
sRelQty = sKFQtyk3;
|
return false;
|
}
|
else
|
{
|
sRelQty = sQty;
|
return true;
|
}
|
}
|
}
|
catch (Exception e)
|
{
|
sRelQty = 0;
|
throw (e);
|
}
|
}
|
|
//根据条码 判断条码是否在待稽核列表
|
public bool CheckInfoByBarCode_Audit(long HInterID, string sBarCode)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("exec h_p_KF_CheckInfoByBarCode_Audit " + HInterID.ToString() + ",'" + sBarCode + "'", "h_p_KF_CheckInfoByBarCode_Audit", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
{
|
return false;
|
}
|
else
|
{
|
return true;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
//返回项目信息
|
public override bool GetInfoByID(Int64 sItemID)
|
{
|
DataSet DS ;
|
try
|
{
|
DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HItemID='" + sItemID + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return false;
|
else
|
{
|
return GetInfo(DS);
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
|
//根据代码返回项目信息
|
public DataSet GetInfoByID_View_Check(long HInterID, string sBillType, string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("Select * from h_v_KF_PonderationBillMain_Audit_Temp_Wh_SP Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_KF_PonderationBillMain_Audit_Temp_Wh_SP", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
//根据代码返回项目信息(盘点)
|
public DataSet GetInfoByID_View_CheckStcok(long HInterID, string sBillType, string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("exec h_p_KF_PonderationBillMain_Audit_Temp_CheckStock " + HInterID.ToString() + ",'" + sBillType + "'", "h_p_KF_PonderationBillMain_Audit_Temp_CheckStock", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
|
//根据代码返回项目信息
|
public DataSet GetInfoByID_View_FIFO(long HInterID, string sBillType, string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("select * from h_v_Kf_ICInventory_FIFO_Tmp Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_Kf_ICInventory_FIFO_Tmp", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
//根据代码返回项目信息
|
public DataSet GetInfoByID_View_FIFO(long HInterID, string sBillType, long HMaterID, string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("select * from h_v_Kf_ICInventory_FIFO_Tmp_New Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' and HMaterID=" + HMaterID.ToString() + sWhere, "h_v_Kf_ICInventory_FIFO_Tmp_New", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
////根据代码返回项目信息
|
//public DataSet GetCusAndBarCodeByID_View(long HInterID, string sWhere)
|
//{
|
// DataSet DS;
|
// try
|
// {
|
// DS = oCn.RunProcReturn("Select * from h_v_K3_GetCusAndBarCodeList Where HInterID=" + HInterID.ToString() + sWhere, "h_v_K3_GetCusAndBarCodeList", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DS.Tables[0].Rows.Count == 0)
|
// return null;
|
// else
|
// {
|
// return DS;
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// throw (e);
|
// }
|
//}
|
|
//根据代码返回项目信息
|
public DataSet GetBarCodeByID_View(long HInterID, string sBillType, long HMaterID, string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("Select * from KF_PonderationBillMain_Audit_Temp Where HQty<>0 and HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' and HMaterID=" + HMaterID + sWhere, "KF_PonderationBillMain_Audit_Temp", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
////根据代码返回项目信息
|
//public DataSet GetBarCodeByID_View(long HInterID, string sBillType, long HMaterID, Int64 HWhID, Int64 HSPID, Int64 HSCWhID, Int64 HSCSPID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, string sWhere)
|
//{
|
// DataSet DS;
|
// try
|
// {
|
// DS = oCn.RunProcReturn("Select HBarCode,sum(HQty) HQty from KF_PonderationBillMain_Audit_Temp Where HQty<>0 and HInterID=" + HInterID.ToString() +
|
// " and HBillType='" + sBillType + "'" +
|
// " and HMaterID=" + HMaterID +
|
// " and HWHID=" + HWhID +
|
// " and HStockPlaceID=" + HSPID +
|
// " and HSCWHID=" + HSCWhID +
|
// " and HOutStockPlaceID=" + HSCSPID +
|
// " and HBatchNo='" + HBatchNo + "'" +
|
// " and HSourceInterID=" + HSourceInterID +
|
// " and HSourceEntryID=" + HSourceEntryID +
|
// sWhere +
|
// " Group by HBarCode", "KF_PonderationBillMain_Audit_Temp", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DS.Tables[0].Rows.Count == 0)
|
// return null;
|
// else
|
// {
|
// return DS;
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// throw (e);
|
// }
|
//}
|
|
|
|
//根据代码返回项目信息
|
public DataSet GetBarCodeByID_View(long HInterID, string sBillType, long HMaterID, Int64 HWhID, Int64 HSPID, Int64 HSCWhID, Int64 HSCSPID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("Select HBatchNo,HBarCode,HWHID,HStockPlaceID,HSCWHID,HOutStockPlaceID,sum(HQty) HQty from KF_PonderationBillMain_Audit_Temp Where HQty<>0 and HInterID=" + HInterID.ToString() +
|
" and HBillType='" + sBillType + "'" +
|
" and HMaterID=" + HMaterID +
|
//" and HWHID=" + HWhID +
|
//" and HStockPlaceID=" + HSPID +
|
//" and HSCWHID=" + HSCWhID +
|
//" and HOutStockPlaceID=" + HSCSPID +
|
" and (HBatchNo='" + HBatchNo + "' or '" + HBatchNo + "' ='')" +
|
" and HSourceInterID=" + HSourceInterID +
|
" and HSourceEntryID=" + HSourceEntryID +
|
sWhere +
|
" Group by HBatchNo,HBarCode,HWHID,HStockPlaceID,HSCWHID,HOutStockPlaceID", "KF_PonderationBillMain_Audit_Temp", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
//根据代码返回项目信息
|
public override bool GetInfoByNumber(string sNumber)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HBarCode='" + sNumber + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return false;
|
else
|
{
|
return GetInfo(DS);
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
//返回项目信息
|
public override bool GetInfo(DataSet Ds)
|
{
|
try
|
{
|
omodel = new Model.ClsKF_PonderationBillMain_Audit_Temp();
|
omodel.HItemID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HItemID"]);
|
omodel.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"]);
|
omodel.HBarCode = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBarCode"]);
|
omodel.HMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMaterID"]);
|
omodel.HProcID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HProcID"]);
|
omodel.HWhID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HWhID"]);
|
omodel.HSCWHID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSCWHID"]);
|
omodel.HStockPlaceID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HStockPlaceID"]);
|
omodel.HOutStockPlaceID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HOutStockPlaceID"]);
|
omodel.HGroupID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HGroupID"]);
|
omodel.HQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HQty"]);
|
omodel.HPieceQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HPieceQty"]);
|
omodel.HAddr = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HAddr"]);
|
omodel.HAuditFlag = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HAuditFlag"]);
|
//
|
omodel.HSourceBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSourceBillType"]);
|
omodel.HSourceInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSourceInterID"]);
|
omodel.HSourceEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSourceEntryID"]);
|
return true;
|
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
//根据代码返回项目信息
|
public DataSet GetCusAndBarCodeByID_View(long HInterID, string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("Select * from h_v_K3_GetCusAndBarCodeList Where HInterID=" + HInterID.ToString() + sWhere, "h_v_K3_GetCusAndBarCodeList", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
|
//根据代码返回项目信息
|
public DataSet GetInfoByID_View(long HInterID, string sBillType, string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("Select * from h_v_KF_PonderationBillMain_Audit_Temp Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_KF_PonderationBillMain_Audit_Temp", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
//根据代码返回项目信息
|
public DataSet GetInfoByID_View_Sum(long HInterID, string sBillType, string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("Select * from h_v_KF_PonderationBillMain_Audit_Temp_Sum Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_KF_PonderationBillMain_Audit_Temp_Sum", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
//根据代码返回项目信息（未上传）
|
public DataSet GetInfoByID_View(string sBillType, string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("Select * from h_v_KF_PonderationBillMain_Audit_Temp_OffLine Where HBillType='" + sBillType + "' " + sWhere, "h_v_KF_PonderationBillMain_Audit_Temp_OffLine", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
//返回缓存列表信息
|
public DataSet GetKF_PonderationBillMain_Audit_TempList(string sBillType, string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("exec h_p_KF_GetPonderationBillMain_Audit_TempList '" + sBillType + "','" +sWhere + "'", "h_p_KF_GetPonderationBillMain_Audit_TempList", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
//返回缓存列表信息（倒箱单）
|
public DataSet GetKF_PonderationBillMain_Audit_TempList_ChangeBox(string sBillType, string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("exec h_p_KF_GetPonderationBillMain_Audit_TempList_ChangeBox '" + sBillType + "','" + sWhere + "'", "h_p_KF_GetPonderationBillMain_Audit_TempList_ChangeBox", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
////根据代码返回项目信息
|
//public DataSet GetInfoByID_View(long HInterID, string sBillType, string sWhere)
|
//{
|
// DataSet DS;
|
// try
|
// {
|
// DS = oCn.RunProcReturn("Select * from h_v_KF_PonderationBillMain_Audit_Temp Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_KF_PonderationBillMain_Audit_Temp", ref DBUtility.ClsPub.sExeReturnInfo);
|
// if (DS.Tables[0].Rows.Count == 0)
|
// return null;
|
// else
|
// {
|
// return DS;
|
// }
|
// }
|
// catch (Exception e)
|
// {
|
// throw (e);
|
// }
|
//}
|
|
public DataSet GetMaterByBarCode_View(string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn(" exec h_p_KF_ICInventory_BarCodeMater_Main '" + sWhere + "'","h_p_KF_ICInventory_BarCodeMater_Main", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
|
public DataSet GetICInventoryByBarCode_View(string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn(" exec h_p_KF_ICInventory_BarCodeMater_Sub '" + sWhere + "'","h_p_KF_ICInventory_BarCodeMater_Sub", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
|
public DataSet GetMaterByBarCodeSP_View(string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn(" exec h_p_KF_ICInventory_BarCodeSP_Sub '" + sWhere + "'","h_p_KF_ICInventory_BarCodeSP_Sub", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
|
public DataSet GetICInventoryByBarCodeSP_View(string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn(" exec h_p_KF_ICInventory_BarCodeSP_Main '" + sWhere + "'","h_p_KF_ICInventory_BarCodeSP_Main", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
|
|
|
//返回即时库存
|
public DataSet Get_ICInventoryByBarCodeList(string sBarCode, long sHWHID, long sHSPID, string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("exec h_p_KF_ICInventoryByBarCodeList '" + sBarCode + "'," + sHWHID.ToString() + "," + sHSPID.ToString(), "h_p_KF_ICInventoryByBarCodeList", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
//根据物料返回即时库存
|
public DataSet Get_ICInventoryByMaterID(long sHMaterID, string sWhere)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("exec h_p_KF_ICInventoryByMaterID " + sHMaterID.ToString(), "h_p_KF_ICInventoryByMaterID", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return null;
|
else
|
{
|
return DS;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
//判断扫描记录，是否按照先进先出规则
|
public bool CheckICInventory_FIFO_Tmp(long InterID, string sBillType, ref string sReturn)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("exec h_p_Kf_ICInventory_FIFO_Tmp_Check " + InterID.ToString() + "," + sBillType.ToString(), "h_p_Kf_ICInventory_FIFO_Tmp_Check", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0 || DS == null)
|
{
|
oCn.CnClose();
|
oCn.CnDispose();
|
sReturn = "null未知错误";
|
return false; //不存在 入库数量超过条码本身额定数量 条码
|
}
|
else
|
{
|
if (DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0][0]) == 1)
|
{
|
oCn.CnClose();
|
oCn.CnDispose();
|
sReturn = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][1]);
|
return false;
|
}
|
else
|
{
|
oCn.CnClose();
|
oCn.CnDispose();
|
sReturn = "正常！";
|
return true;
|
}
|
}
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
//根据VDA箱号 数量 判断扫描数量 是否匹配
|
public bool CheckQtyByVDAPack(long InterID, string sBillType, string sVDAPack, ref string sReturn)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("select sum(HQty) HQty,HVDAQty from KF_PonderationBillMain_Audit_Temp where HInterID=" + InterID.ToString() + " and HBillType='" + sBillType + "' and HVDAPack='" + sVDAPack + "' group by HVDAQty", "KF_PonderationBillMain_Audit_Temp", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
{
|
return false;
|
}
|
else
|
{
|
double sQty = 0;
|
double sVDAQty = 0;
|
sQty = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HQty"]);
|
sVDAQty = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HVDAQty"]);
|
if (sQty != sVDAQty)
|
{
|
sReturn = "本托数量与 VDA数量不一致！";
|
return false;
|
}
|
else
|
{
|
sReturn = "正常";
|
return true;
|
}
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
|
|
|
}
|
}
|
