/// <summary>
/// 根据托盘条码获取托盘明细
/// </summary>
/// <returns></returns>
private bool GetPalletInfoByPalletSerialNo(string SerialNo, ref List <T_OutBarCodeInfo> modelList, ref string strError)
{
bool bSucc = false;
T_PalletDetail_Func palletFunc = new T_PalletDetail_Func();
string strFilter = string.Empty;
decimal SumPalletQty = 0;
List <T_OutBarCodeInfo> HModelList = new List <T_OutBarCodeInfo>();
T_OutBarcode_DB odb = new T_OutBarcode_DB();
//根据托盘号获取托盘明细
strFilter = "palletno = '" + SerialNo + "'";
if (outBarCodeFunc.GetOutBarCodeByPalletNo(SerialNo, ref modelList, ref strError) == false)
{
bSucc = false;
}
else
{
HModelList = modelList.Where(t => t.BarcodeType == 5).ToList();
if (HModelList != null && HModelList.Count > 0)
{
foreach (var item in HModelList)
{
modelList.Find(t => t.ID == item.ID).lstBarCode = odb.GetBarCodeOutAll(item.BarCode);
}
}
modelList.ForEach(t => t.PalletNo = SerialNo);
SumPalletQty = modelList.Sum(t1 => t1.Qty).ToDecimal();
modelList.ForEach(t => t.PalletQty = SumPalletQty);
bSucc = true;
}
return(bSucc);
}
/// <summary>
/// 根据托盘条码获取托盘明细
/// </summary>
/// <returns></returns>
public string GetPalletInfoByPalletNo(string PalletNo)
{
T_PalletDetail_Func func = new T_PalletDetail_Func();
return(func.GetPalletInfoByPalletNo(PalletNo));
}
/// <summary>
/// 获取整箱库存信息
/// </summary>
/// <param name="BarCode"></param>
/// <returns></returns>
public string GetT_OutBarCodeInfoByBoxADF(string BarCode)
{
T_PalletDetail_Func tfunc = new T_PalletDetail_Func();
return(tfunc.GetOutBarCodeInfoByBox(BarCode));
}
/// <summary>
/// 删除整托或者单个托上的箱条码
/// </summary>
/// <param name="UserJson"></param>
/// <param name="PalletDetailJson"></param>
/// <returns></returns>
public string Delete_PalletORBarCodeADF(string UserJson, string PalletDetailJson)
{
T_PalletDetail_Func tfunc = new T_PalletDetail_Func();
return(tfunc.DeletePalletORBarCode(UserJson, PalletDetailJson));
}
/// <summary>
/// 提交装箱或者拆箱数据
/// </summary>
/// <param name="UserJson"></param>
/// <param name="strOldBarCode"></param>
/// <param name="strNewBarCode"></param>
/// <param name="PrintFlag">打印标记1-打印 2-不打印</param>
/// <returns></returns>
public string SaveT_BarCodeToStockADF(string UserJson, string strOldBarCode, string strNewBarCode, string PrintFlag)
{
T_PalletDetail_Func tfunc = new T_PalletDetail_Func();
return(tfunc.SaveBarCodeToStock(UserJson, strOldBarCode, strNewBarCode, PrintFlag));
}
/// <summary>
/// 提交托盘信息
/// </summary>
/// <param name="UserJson"></param>
/// <param name="ModelJson"></param>
/// <returns></returns>
public string SaveT_PalletDetailADF(string UserJson, string ModelJson)
{
T_PalletDetail_Func tfunc = new T_PalletDetail_Func();
return(tfunc.SaveModelListSqlToDBADF(UserJson, ModelJson));
}
/// <summary>
/// 根据ERP单据号删除托盘数据
/// </summary>
/// <param name="ErpVoucherNo"></param>
/// <param name="PalletType"></param>
/// <returns></returns>
public string DeletePalletByErpVoucherNo(string ErpVoucherNo, string PalletType)
{
T_PalletDetail_Func tfunc = new T_PalletDetail_Func();
return(tfunc.DeletePalletByErpVoucherNo(ErpVoucherNo, PalletType));
}
/// <summary>
/// 删除托盘或者托盘序列号
/// </summary>
/// <param name="PalletNo"></param>
/// <param name="SerialNo"></param>
/// <returns></returns>
public string Del_PalletOrSerialNo(String PalletNo, String SerialNo)
{
T_PalletDetail_Func tfunc = new T_PalletDetail_Func();
return(tfunc.Del_PalletOrSerialNo(PalletNo, SerialNo));
}
/// <summary>
/// 获取托盘明细
/// </summary>
/// <param name="VoucherNo"></param>
/// <returns></returns>
public string Get_PalletDetailByVoucherNo(String VoucherNo)
{
T_PalletDetail_Func tfunc = new T_PalletDetail_Func();
return(tfunc.GetPalletDetailByVoucherNo(VoucherNo));
}
/// <summary>
/// 根据托盘编号或者条码获取托盘明细
/// </summary>
/// <param name="PalletNo"></param>
/// <returns></returns>
public string GetT_PalletDetailByNoADF(string BarCode, string PalletModel)
{
T_PalletDetail_Func tfunc = new T_PalletDetail_Func();
return(tfunc.GetPalletDetailByPalletNo(BarCode, PalletModel));
}
/// <summary>
/// 外箱条码没有收货，需要查询是否已经拼托，如果拼托要返回整托信息,如果没有拼托则返回单个条码，用条码类封装
/// </summary>
/// <param name="SerialNo"></param>
/// <param name="?"></param>
/// <param name="?"></param>
/// <returns></returns>
private bool GetPalletInfoBySerialNo(string SerialNo, ref List <T_OutBarCodeInfo> modelList, ref string strError)
{
bool bSucc = false;
string strFilter = string.Empty;
T_OutBarCodeInfo model = new T_OutBarCodeInfo();
T_OutBarCode_Func toc = new T_OutBarCode_Func();
T_PalletDetail_Func palletFunc = new T_PalletDetail_Func();
List <T_PalletDetailInfo> lstPallet = new List <T_PalletDetailInfo>();
T_OutBarCodeInfo outBarCodeModel = new T_OutBarCodeInfo();
List <T_OutBarCodeInfo> HModelList = new List <T_OutBarCodeInfo>();
T_OutBarcode_DB odb = new T_OutBarcode_DB();
decimal SumPalletQty = 0;
//外箱条码不存在
if (outBarCodeFunc.GetOutBarCodeInfoBySerialNo(SerialNo, ref model, ref strError) == false)
{
return(false);
}
strFilter = "palletno = (select palletno from t_Palletdetail where barcode = '" + model.BarCode + "')";
//外箱条码存在，但是没有组托，需要生成新的托盘类，返回客户端
if (palletFunc.GetPalletByPalletNo(strFilter, ref lstPallet, ref strError) == false)
{
if (toc.GetOutBarCodeInfoBySerialNo(SerialNo, ref outBarCodeModel, ref strError) == false)
{
return(false);
}
if (outBarCodeModel.BarcodeType == 5) //混箱
{
model.BarcodeType = 5;
model.lstBarCode = odb.GetBarCodeOutAll(model.BarCode);
}
modelList.Add(model);
bSucc = true;
}
else //已经组托，根据组托条码获取条码类
{
if (outBarCodeFunc.GetOutBarCodeByPalletNo(lstPallet[0].PalletNo, ref modelList, ref strError) == false)
{
bSucc = false;
}
else
{
HModelList = modelList.Where(t => t.BarcodeType == 5).ToList();
if (HModelList != null && HModelList.Count > 0)
{
foreach (var item in HModelList)
{
modelList.Find(t => t.ID == item.ID).lstBarCode = odb.GetBarCodeOutAll(item.BarCode);
}
}
modelList.ForEach(t => t.PalletNo = lstPallet[0].PalletNo);
SumPalletQty = modelList.Sum(t1 => t1.Qty).ToDecimal();
modelList.ForEach(t => t.PalletQty = SumPalletQty);
bSucc = true;
}
}
return(bSucc);
}
