/// <summary>
/// GetDateFromTo
/// </summary>
public IList<S_Table_Data> GetDateFromTo(DateTime begin, DateTime end)
{
try
{
IList<S_Table_Data> ret = new List<S_Table_Data>();
//IList<DeliveryPalletInfo> palletList = new List<DeliveryPalletInfo>();
IList<Delivery> getDeliveryList = currentRepository.GetDeliveriesByShipDateRange(begin, end);
foreach (Delivery aDelivery in getDeliveryList)
{
IList<DeliveryPalletInfo> re = currentRepository.GetDeliveryPalletListByDN(aDelivery.DeliveryNo);
foreach (DeliveryPalletInfo aDeliveryPalletInfo in re)
{
if (aDeliveryPalletInfo.deliveryQty == 0)
{
continue;
}
//if (palletList.Contains(aDeliveryPalletInfo))
//{
// continue;
//}
WhPltMasInfo reInfo = palletRepository.GetWHPltMas(aDeliveryPalletInfo.palletNo);
if (null == reInfo)
{
continue;
}
//palletList.Add(aDeliveryPalletInfo);
S_Table_Data newData = new S_Table_Data();
newData.DeliveryNO = aDelivery.DeliveryNo;
newData.ShipmentNO = aDeliveryPalletInfo.shipmentNo;
newData.Model = aDelivery.ModelName;
newData.PalletNO = aDeliveryPalletInfo.palletNo;
newData.CartonQty = aDeliveryPalletInfo.deliveryQty.ToString();
newData.Qty = aDeliveryPalletInfo.deviceQty.ToString();
string reForwarder = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "Carrier");
if (!string.IsNullOrEmpty(reForwarder))
{
newData.Forwarder = reForwarder;
}
string reHAWB = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "BOL");
if (!string.IsNullOrEmpty(reHAWB))
{
newData.HAWB = reHAWB;
}
else
{
reHAWB = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "EmeaCarrier");
if (!string.IsNullOrEmpty(reHAWB))
{
newData.HAWB = reHAWB;
}
}
if (null != reInfo)
{
if (reInfo.wc == "IN")
{
newData.Satus = "IN";
}
else if (reInfo.wc == "OT")
{
newData.Satus = "OT";
}
else if (reInfo.wc == "RW")
{
newData.Satus = "RW";
}
}
IList<PakWhLocMasInfo> reWhLocMas = palletRepository.GetPakWhLocMasListByPlt1OrPlt2(aDeliveryPalletInfo.palletNo);
foreach (PakWhLocMasInfo Loc in reWhLocMas)
{
newData.LOC = Loc.col + Loc.loc.ToString();
break;
}
IList<WhPltLogInfo> reWHLog = palletRepository.GetWhPltLogInfoList(new string[]{"IN"}, aDeliveryPalletInfo.palletNo);
if (reWHLog != null && reWHLog.Count > 0)
{
newData.InWHCdt = reWHLog.OrderByDescending(x => x.cdt).FirstOrDefault().cdt.ToString();
// newData.InWHCdt = Cdt.cdt.ToString();
}
ret.Add(newData);
}
}
ret = ret.OrderBy(x => x.PalletNO).ToList();
return ret;
//foreach (DeliveryPalletInfo aLoc in palletList)
//{
// if (string.IsNullOrEmpty(aLoc.palletNo))
// {
// continue;
// }
// S_Table_Data newData = new S_Table_Data();
// newData.DeliveryNO = "";
// newData.Model = "";
// newData.PalletNO = aLoc.palletNo;
// newData.Qty = "";
// newData.Forwarder = "";
// newData.HAWB = "";
// newData.LOC = "";
// Delivery reDelivery = currentRepository.Find(aLoc.deliveryNo);
// if (null == reDelivery)
// {
// continue;
// }
// if (!string.IsNullOrEmpty(reDelivery.DeliveryNo))
// {
// newData.DeliveryNO = reDelivery.DeliveryNo;
// }
// else
// {
// continue;
// }
// if (!string.IsNullOrEmpty(reDelivery.ModelName))
// {
// newData.Model = reDelivery.ModelName;
// }
// IList<DeliveryPallet> rePalletD = palletRepository.GetDeliveryPalletByDNAndPallet(reDelivery.DeliveryNo, aLoc.palletNo);
// foreach (DeliveryPallet aPalletD in rePalletD)
// {
// newData.Qty = aPalletD.DeliveryQty.ToString();
// break;
// }
// string reForwarder = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "Carrier");
// if (!string.IsNullOrEmpty(reForwarder))
// {
// newData.Forwarder = reForwarder;
// }
// string reHAWB = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "BOL");
// if (!string.IsNullOrEmpty(reHAWB))
// {
// newData.HAWB = reHAWB;
// }
// else
// {
// reHAWB = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "EmeaCarrier");
// if (!string.IsNullOrEmpty(reHAWB))
// {
// newData.HAWB = reHAWB;
// }
// }
// WhPltMasInfo reInfo = palletRepository.GetWHPltMas(aLoc.palletNo);
// if (null != reInfo)
// {
// if (reInfo.wc == "IN")
// {
// newData.Satus = "IN";
// }
// else if (reInfo.wc == "OT")
// {
// newData.Satus = "OT";
// }
// else if (reInfo.wc == "RW")
// {
// newData.Satus = "RW";
// }
// }
// IList<PakWhLocMasInfo> reWhLocMas = palletRepository.GetPakWhLocMasListByPlt1OrPlt2(aLoc.palletNo);
// foreach (PakWhLocMasInfo Loc in reWhLocMas)
// {
// newData.LOC = Loc.col + Loc.loc.ToString();
// break;
// }
// ret.Add(newData);
//}
}
catch (FisException e)
{
logger.Error(e.mErrmsg, e);
throw new Exception(e.mErrmsg);
}
catch (Exception e)
{
logger.Error(e.Message, e);
throw new SystemException(e.Message);
}
}
/// <summary>
/// GetDateFromToNotIN
/// </summary>
public IList<S_Table_Data> GetDateFromToNotIN(DateTime begin, DateTime end)
{
try
{
IList<S_Table_Data> ret = new List<S_Table_Data>();
//IList<DeliveryPalletInfo> palletList = new List<DeliveryPalletInfo>();
IList<Delivery> getDeliveryList = currentRepository.GetDeliveriesByShipDateRange(begin,end);
foreach (Delivery aDelivery in getDeliveryList)
{
IList<DeliveryPalletInfo> re = currentRepository.GetDeliveryPalletListByDN(aDelivery.DeliveryNo);
foreach (DeliveryPalletInfo aDeliveryPalletInfo in re)
{
if (aDeliveryPalletInfo.deliveryQty == 0)
{
continue;
}
//if (palletList.Contains(aDeliveryPalletInfo))
//{
// continue;
//}
if (null != palletRepository.GetWHPltMas(aDeliveryPalletInfo.palletNo))
{
continue;
}
//palletList.Add(aDeliveryPalletInfo);
S_Table_Data newData = new S_Table_Data();
newData.DeliveryNO = aDelivery.DeliveryNo;
newData.ShipmentNO = aDelivery.ShipmentNo;
newData.Model = aDelivery.ModelName;
newData.PalletNO = aDeliveryPalletInfo.palletNo;
newData.CartonQty = aDeliveryPalletInfo.deliveryQty.ToString();
newData.Qty = aDeliveryPalletInfo.deviceQty.ToString();
string reForwarder = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "Carrier");
if (!string.IsNullOrEmpty(reForwarder))
{
newData.Forwarder = reForwarder;
}
string reHAWB = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "BOL");
if (!string.IsNullOrEmpty(reHAWB))
{
newData.HAWB = reHAWB;
}
else
{
reHAWB = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "EmeaCarrier");
if (!string.IsNullOrEmpty(reHAWB))
{
newData.HAWB = reHAWB;
}
}
newData.Satus = "";
newData.LOC = "";
newData.InWHCdt = "";
ret.Add(newData);
}
}
ret = ret.OrderBy(x => x.PalletNO).ToList();
return ret;
//foreach (DeliveryPalletInfo aLoc in palletList)
//{
// if (string.IsNullOrEmpty(aLoc.palletNo))
// {
// continue;
// }
// S_Table_Data newData = new S_Table_Data();
// newData.DeliveryNO = "";
// newData.Model = "";
// newData.PalletNO = aLoc.palletNo;
// newData.Qty = "";
// newData.Forwarder = "";
// newData.HAWB = "";
// newData.LOC = "";
// Delivery reDelivery = currentRepository.Find(aLoc.deliveryNo);
// if (null == reDelivery)
// {
// continue;
// }
// if (!string.IsNullOrEmpty(reDelivery.DeliveryNo))
// {
// newData.DeliveryNO = reDelivery.DeliveryNo;
// }
// else
// {
// continue;
// }
// if (!string.IsNullOrEmpty(reDelivery.ModelName))
// {
// newData.Model = reDelivery.ModelName;
// }
// IList<DeliveryPallet> rePalletD = palletRepository.GetDeliveryPalletByDNAndPallet(reDelivery.DeliveryNo, aLoc.palletNo);
// foreach (DeliveryPallet aPalletD in rePalletD)
// {
// newData.Qty = aPalletD.DeliveryQty.ToString();
// break;
// }
// string reForwarder = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "Carrier");
// if (!string.IsNullOrEmpty(reForwarder))
// {
// newData.Forwarder = reForwarder;
// }
// string reHAWB = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "BOL");
// if (!string.IsNullOrEmpty(reHAWB))
// {
// newData.HAWB = reHAWB;
// }
// else
// {
// reHAWB = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "EmeaCarrier");
// if (!string.IsNullOrEmpty(reHAWB))
// {
// newData.HAWB = reHAWB;
// }
// }
// newData.Satus = "";
// newData.LOC = "";
// ret.Add(newData);
//}
}
catch (FisException e)
{
logger.Error(e.mErrmsg, e);
throw new Exception(e.mErrmsg);
}
catch (Exception e)
{
logger.Error(e.Message, e);
throw new SystemException(e.Message);
}
}
/// <summary>
/// GetDateFromTo
/// </summary>
public IList<S_Table_Data> GetDateFromTo(DateTime begin, DateTime end)
{
try
{
IList<S_Table_Data> ret = new List<S_Table_Data>();
IList<DeliveryPalletInfo> palletList = new List<DeliveryPalletInfo>();
IList<Delivery> getDeliveryList = currentRepository.GetDeliveriesByShipDateRange(begin, end);
foreach (Delivery aDelivery in getDeliveryList)
{
IList<DeliveryPalletInfo> re = currentRepository.GetDeliveryPalletListByDN(aDelivery.DeliveryNo);
foreach (DeliveryPalletInfo aDeliveryPalletInfo in re)
{
if (aDeliveryPalletInfo.deliveryQty == 0)
{
continue;
}
if (palletList.Contains(aDeliveryPalletInfo))
{
continue;
}
if (null == palletRepository.GetWHPltMas(aDeliveryPalletInfo.palletNo))
{
continue;
}
palletList.Add(aDeliveryPalletInfo);
}
}
foreach (DeliveryPalletInfo aLoc in palletList)
{
if (string.IsNullOrEmpty(aLoc.palletNo))
{
continue;
}
S_Table_Data newData = new S_Table_Data();
newData.DeliveryNO = "";
newData.Model = "";
newData.PalletNO = aLoc.palletNo;
newData.Qty = "";
newData.Forwarder = "";
newData.HAWB = "";
newData.LOC = "";
Delivery reDelivery = currentRepository.Find(aLoc.deliveryNo);
if (null == reDelivery)
{
continue;
}
if (!string.IsNullOrEmpty(reDelivery.DeliveryNo))
{
newData.DeliveryNO = reDelivery.DeliveryNo;
}
else
{
continue;
}
if (!string.IsNullOrEmpty(reDelivery.ModelName))
{
newData.Model = reDelivery.ModelName;
}
IList<DeliveryPallet> rePalletD = palletRepository.GetDeliveryPalletByDNAndPallet(reDelivery.DeliveryNo, aLoc.palletNo);
foreach (DeliveryPallet aPalletD in rePalletD)
{
newData.Qty = aPalletD.DeliveryQty.ToString();
break;
}
string reForwarder = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "Carrier");
if (!string.IsNullOrEmpty(reForwarder))
{
newData.Forwarder = reForwarder;
}
string reHAWB = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "BOL");
if (!string.IsNullOrEmpty(reHAWB))
{
newData.HAWB = reHAWB;
}
WhPltMasInfo reInfo = palletRepository.GetWHPltMas(aLoc.palletNo);
if (null != reInfo)
{
if (reInfo.wc == "IN")
{
newData.Satus = "IN";
}
else if (reInfo.wc == "OT")
{
newData.Satus = "OT";
}
else if (reInfo.wc == "RW")
{
newData.Satus = "RW";
}
}
IList<PakWhLocMasInfo> reWhLocMas = palletRepository.GetPakWhLocMasListByPlt1OrPlt2(aLoc.palletNo);
foreach (PakWhLocMasInfo Loc in reWhLocMas)
{
newData.LOC = Loc.col + Loc.loc.ToString();
break;
}
ret.Add(newData);
}
return ret;
}
catch (FisException e)
{
logger.Error(e.mErrmsg, e);
throw new Exception(e.mErrmsg);
}
catch (Exception e)
{
logger.Error(e.Message, e);
throw new SystemException(e.Message);
}
}
/// <summary>
/// Get7Days
/// </summary>
public IList<S_Table_Data> Get7Days()
{
try
{
IList<S_Table_Data> ret = new List<S_Table_Data>();
IList<WhPltMasInfo> palletList = new List<WhPltMasInfo>();
palletList = palletRepository.GetWhPltMasList("IN", 7);
foreach (WhPltMasInfo aLoc in palletList)
{
if (string.IsNullOrEmpty(aLoc.plt))
{
continue;
}
S_Table_Data newData = new S_Table_Data();
newData.DeliveryNO = "";
newData.ShipmentNO = "";
newData.Model = "";
newData.PalletNO = aLoc.plt;
newData.CartonQty = "";
newData.Qty = "";
newData.Forwarder = "";
newData.HAWB = "";
newData.LOC = "";
newData.InWHCdt = "";
IList<DeliveryPallet> reDeliveryPallet = palletRepository.GetDeliveryPallet(aLoc.plt);
if (null != reDeliveryPallet && reDeliveryPallet.Count > 0)
{
//一个
foreach (DeliveryPallet tmp in reDeliveryPallet)
{
Delivery reDelivery = currentRepository.Find(tmp.DeliveryID);
if (null == reDelivery)
{
break;
}
if (!string.IsNullOrEmpty(reDelivery.DeliveryNo))
{
newData.DeliveryNO = reDelivery.DeliveryNo;
}
else
{
break;
}
if (!string.IsNullOrEmpty(reDelivery.ShipmentNo))
{
newData.ShipmentNO = reDelivery.ShipmentNo;
}
if (!string.IsNullOrEmpty(reDelivery.ModelName))
{
newData.Model = reDelivery.ModelName;
}
newData.CartonQty = tmp.DeliveryQty.ToString();
newData.Qty = tmp.DeviceQty.ToString();
string reForwarder = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "Carrier");
if (!string.IsNullOrEmpty(reForwarder))
{
newData.Forwarder = reForwarder;
}
string reHAWB = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "BOL");
if (!string.IsNullOrEmpty(reHAWB))
{
newData.HAWB = reHAWB;
}
else
{
reHAWB = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "EmeaCarrier");
if (!string.IsNullOrEmpty(reHAWB))
{
newData.HAWB = reHAWB;
}
}
newData.Satus = "IN";
IList<PakWhLocMasInfo> reWhLocMas = palletRepository.GetPakWhLocMasListByPlt1OrPlt2(aLoc.plt);
foreach (PakWhLocMasInfo Loc in reWhLocMas)
{
newData.LOC = Loc.col + Loc.loc.ToString();
break;
}
//IList<WhPltLogInfo> reWHLog = palletRepository.GetWhPltLogInfoList(new string[] { "IN" }, aLoc.plt);
//foreach (WhPltLogInfo Cdt in reWHLog)
//{
// newData.InWHCdt = Cdt.cdt.ToString();
// break;
//}
IList<WhPltLogInfo> reWHLog = palletRepository.GetWhPltLogInfoList(new string[] { "IN" }, aLoc.plt); ;
if (reWHLog != null && reWHLog.Count > 0)
{
newData.InWHCdt = reWHLog.OrderByDescending(x => x.cdt).FirstOrDefault().cdt.ToString();
// newData.InWHCdt = Cdt.cdt.ToString();
}
ret.Add(newData);
break;
}
}
}
return ret;
}
catch (FisException e)
{
logger.Error(e.mErrmsg, e);
throw new Exception(e.mErrmsg);
}
catch (Exception e)
{
logger.Error(e.Message, e);
throw new SystemException(e.Message);
}
}
/// <summary>
/// Get7Days
/// </summary>
public IList<S_Table_Data> Get7Days()
{
try
{
IList<S_Table_Data> ret = new List<S_Table_Data>();
IList<WhPltMasInfo> palletList = new List<WhPltMasInfo>();
palletList = palletRepository.GetWhPltMasList("IN", 7);
foreach (WhPltMasInfo aLoc in palletList)
{
if (string.IsNullOrEmpty(aLoc.plt))
{
continue;
}
S_Table_Data newData = new S_Table_Data();
newData.DeliveryNO = "";
newData.Model = "";
newData.PalletNO = aLoc.plt;
newData.Qty = "";
newData.Forwarder = "";
newData.HAWB = "";
newData.LOC = "";
IList<DeliveryPallet> reDeliveryPallet = palletRepository.GetDeliveryPallet(aLoc.plt);
if (null != reDeliveryPallet && reDeliveryPallet.Count > 0)
{
//一个
foreach (DeliveryPallet tmp in reDeliveryPallet)
{
Delivery reDelivery = currentRepository.Find(tmp.DeliveryID);
if (null == reDelivery)
{
break;
}
if (!string.IsNullOrEmpty(reDelivery.DeliveryNo))
{
newData.DeliveryNO = reDelivery.DeliveryNo;
}
else
{
break;
}
if (!string.IsNullOrEmpty(reDelivery.ModelName))
{
newData.Model = reDelivery.ModelName;
}
newData.Qty = tmp.DeliveryQty.ToString();
string reForwarder = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "Carrier");
if (!string.IsNullOrEmpty(reForwarder))
{
newData.Forwarder = reForwarder;
}
string reHAWB = currentRepository.GetDeliveryInfoValue(newData.DeliveryNO, "BOL");
if (!string.IsNullOrEmpty(reHAWB))
{
newData.HAWB = reHAWB;
}
newData.Satus = "IN";
IList<PakWhLocMasInfo> reWhLocMas = palletRepository.GetPakWhLocMasListByPlt1OrPlt2(aLoc.plt);
foreach (PakWhLocMasInfo Loc in reWhLocMas)
{
newData.LOC = Loc.col + Loc.loc.ToString();
break;
}
ret.Add(newData);
break;
}
}
}
return ret;
}
catch (FisException e)
{
logger.Error(e.mErrmsg, e);
throw new Exception(e.mErrmsg);
}
catch (Exception e)
{
logger.Error(e.Message, e);
throw new SystemException(e.Message);
}
}
