public string SaveDOC(string WO, string CUS)
{
try
{
var data = (from DL_TR in DbFile.Delivery_PD_Process
join WMS_Pros in DbFile.WMS_PD_Product on DL_TR.Delivery_TAG equals WMS_Pros.Barcode into WMS_Pro1
from WMS_Pro in WMS_Pro1.DefaultIfEmpty()
where DL_TR.Delivery_WO.Equals(WO) && WMS_Pro.PRO_Cus.Equals(CUS) && DL_TR.Delivery_Status.Equals("T")
select new
{
DL_TR.Delivery_WO,
WMS_Pro.PRO_Cus,
DL_TR.Delivery_Doc,
DL_TR.Delivery_TAG,
DL_TR.ID
}).ToList();
var dataDL = DbFile.Delivery_PD_Process.Where(a => a.Delivery_WO.Equals(WO)).FirstOrDefault();
Session["PicNAME"] = WO;
dataDL.Delivery_Doc = WO + ".JPG";
dataDL.Delivery_Pic = WO + ".JPG";
DbFile.SaveChanges();
UploadNotification(WO);
return("S");
}
catch { return("F"); }
}
public string CheckTAG_Return(string WO, string CUS, string BARCODE)
{
try
{
var data = (from DL_TR in DbFile.Delivery_PD_Process
join WMS_Pros in DbFile.WMS_PD_Product on DL_TR.Delivery_TAG equals WMS_Pros.Barcode into WMS_Pro1
from WMS_Pro in WMS_Pro1.DefaultIfEmpty()
where DL_TR.Delivery_WO.Equals(WO) && DL_TR.Delivery_TAG.Equals(BARCODE) && WMS_Pro.PRO_Cus.Equals(CUS) && DL_TR.Delivery_Status.Equals("T")
select new
{
DL_TR.Delivery_TAG
}).ToList();
string jsonlog = new JavaScriptSerializer().Serialize(data);
return(jsonlog);
}
catch { return(null); }
}
public string GETWODoc(string WO)
{
try
{
var data = (from Dl_TR in DbFile.Delivery_PD_Process
join WMS_Pros in DbFile.WMS_PD_Product on Dl_TR.Delivery_TAG equals WMS_Pros.Barcode into WMS_Pro1
from WMS_Pro in WMS_Pro1.DefaultIfEmpty()
where Dl_TR.Delivery_WO.Equals(WO) && Dl_TR.Delivery_Doc == null
select new
{
Dl_TR.Delivery_WO,
Dl_TR.Delivery_TAG,
Dl_TR.Delivery_Truck,
WMS_Pro.PRO_Cus
}).AsEnumerable().GroupBy(k => new { k.PRO_Cus }).Select(k => k.First()).ToList();
string jsonlog = new JavaScriptSerializer().Serialize(data);
return(jsonlog);
}
catch { return(null); }
}
public string CheckTAG_ReturnDOC(string WO, string CUS)
{
try
{
var data = (from DL_TR in DbFile.Delivery_PD_Process
join WMS_Pros in DbFile.WMS_PD_Product on DL_TR.Delivery_TAG equals WMS_Pros.Barcode into WMS_Pro1
from WMS_Pro in WMS_Pro1.DefaultIfEmpty()
where DL_TR.Delivery_WO.Equals(WO) && WMS_Pro.PRO_Cus.Equals(CUS) && DL_TR.Delivery_Status.Equals("T")
select new
{
DL_TR.Delivery_WO,
WMS_Pro.PRO_Cus
}).FirstOrDefault();
Session["PicNAME"] = (data.Delivery_WO) + (data.PRO_Cus);
string jsonlog = new JavaScriptSerializer().Serialize(data);
return(jsonlog);
}
catch { return(null); }
}
