} //CheckLoc
public string BackLogTOMasterData()
{//โยกข้อมูลจาก Backlog ==> MasterData
// try
// {
/* var UpdateMSData = (from MS_B in DbFile.Master_Backlog.DefaultIfEmpty()
* join MD_D1 in DbFile.Master_Data on MS_B.B_SO equals MD_D1.B_SO into MDs
* from MD_D in MDs
* select new
* {
* MS_B.B_SO,
* D_SO = MD_D.B_SO
* }).ToList();
*/
// var filteredSO = DbFile.Master_Backlog.Where(a => !DbFile.Master_Data.Select(b => b.B_SO).Contains(a.B_SO)).ToList();
//var filteredSO = DbFile.Master_Backlog.ToList();
/* var filteredSO = (from a in DbFile.Master_Backlog
* where !DbFile.Master_Data.Any(b => b.B_SO == a.B_SO)
* select a).ToList();
* // */
List <Master_Backlog> MSB = DbFile.Master_Backlog.Where(a => !DbFile.Master_Data.Select(b => b.B_SO).Contains(a.B_SO)).ToList();
var data1 = new Master_Data();
foreach (var MSBs in MSB)
{
data1.B_SO = MSBs.B_SO;
data1.B_PO = MSBs.B_PO;
data1.B_Customer = MSBs.B_Customer;
data1.B_Material = MSBs.B_Material;
data1.B_Material_Des = MSBs.B_Material_Des;
// data1.Date_Create = MSBs.Date_Create;
// data1.Date_PFD = MSBs.Date_PFD;
// data1.Date_Delivery = MSBs.Date_Delivery;
data1.B_Cutting_Length = MSBs.B_Cutting_Length;
data1.B_Order_QTY = MSBs.B_Order_QTY;
data1.B_Order_Unit = MSBs.B_Order_Unit;
DbFile.Master_Data.Add(data1);
DbFile.SaveChanges();
}
// DbFile.Master_Data.Add();
/*
* var Data = new List<Master_Data>();
* for (int i = 0; i < resultList.Count; i++)
* {
* Data.Add(new Master_Data
* {
*
* });
* // Data.B_SO = resultList.,
* // Field_Value_EN = product.ListProductFields[i].Field_Value_EN
* };
*/
// DbFile.Master_Data.Add(resultList);
// var SUM_OUT = dataOUT.Sum(a => a.Cal_QTY_Balance);
// var result = DbFile.OTIF_TR_Cal.Where(a => a.Cal_SO.Equals(SO)).Where(b => b.Cal_Machine.Equals(MAC)).Where(c => c.Cal_Status.Equals("IN")).ToList();
// result.ForEach(x => x.Cal_QTY_Balance = (x.Cal_QTY - SUM_OUT));
// DbFile.SaveChanges();
return(null);
// }
// catch { return null; }
} //CheckLoc
}// */
private string SavePrint(int ID)//กวาดข้อมูล Backlog,Planner ไปลงตาราง Master Data
{
try
{
var MS_PL = DbFile.Master_Planner.Where(y => y.ID.Equals(ID)).FirstOrDefault();
var MS_BackLog = DbFile.Master_Backlog.Where(y => y.B_SO == MS_PL.PL_SO).FirstOrDefault();
var MS_Production = DbFile.Master_Production.Where(y => y.PD_SO == MS_PL.PL_SO).FirstOrDefault();
var CheckMData = DbFile.Master_Data.Where(y => y.PL_Tag == MS_PL.PL_Tag).FirstOrDefault();
var MData = new Master_Data();
if (CheckMData != null) //Edit
{
if (MS_BackLog != null)
{
CheckMData.B_SO = MS_BackLog.B_SO;
CheckMData.B_SO = MS_BackLog.B_SO;
CheckMData.B_Customer = MS_BackLog.B_Customer;
CheckMData.B_Material = MS_BackLog.B_Material;
CheckMData.B_Material_Des = MS_BackLog.B_Material_Des;
// CheckMData.Date_Create = MS_BackLog.Date_Create;
// CheckMData.Date_PFD = MS_BackLog.Date_PFD;
// CheckMData.Date_Delivery = MS_BackLog.Date_Delivery;
CheckMData.B_Cutting_Length = MS_BackLog.B_Cutting_Length;
CheckMData.B_Order_QTY = MS_BackLog.B_Order_QTY;
CheckMData.B_Order_Unit = MS_BackLog.B_Order_Unit;
}
if (MS_Production != null)
{
CheckMData.B_Cutting_Length = MS_Production.PD_CuttingLength;
}
CheckMData.PL_Machine = MS_PL.PL_Machine;
CheckMData.PL_Process = MS_PL.PL_Process;
CheckMData.PL_Type = MS_PL.PL_Type;
CheckMData.PL_Qty = MS_PL.PL_Qty;
CheckMData.PL_Tag = MS_PL.PL_Tag;
CheckMData.PL_Qty_T = MS_PL.PL_Qty_T;
CheckMData.PL_Color = MS_PL.PL_Color;
DbFile.SaveChanges();
return("S");
}
else //Add
{
if (MS_BackLog != null)
{
MData.B_SO = MS_BackLog.B_SO;
MData.B_SO = MS_BackLog.B_SO;
MData.B_Customer = MS_BackLog.B_Customer;
MData.B_Material = MS_BackLog.B_Material;
MData.B_Material_Des = MS_BackLog.B_Material_Des;
// MData.Date_Create = MS_BackLog.Date_Create;
// MData.Date_PFD = MS_BackLog.Date_PFD;
// MData.Date_Delivery = MS_BackLog.Date_Delivery;
MData.B_Cutting_Length = MS_BackLog.B_Cutting_Length;
MData.B_Order_QTY = MS_BackLog.B_Order_QTY;
MData.B_Order_Unit = MS_BackLog.B_Order_Unit;
}
else
{
MData.B_SO = MS_PL.PL_SO;
}
if (MS_Production != null)
{
MData.B_Cutting_Length = MS_Production.PD_CuttingLength;
}
MData.PL_Machine = MS_PL.PL_Machine;
MData.PL_Process = MS_PL.PL_Process;
MData.PL_Type = MS_PL.PL_Type;
MData.PL_Qty = MS_PL.PL_Qty;
MData.PL_Tag = MS_PL.PL_Tag;
MData.PL_Qty_T = MS_PL.PL_Qty_T;
MData.PL_Color = MS_PL.PL_Color;
DbFile.Master_Data.Add(MData);
DbFile.SaveChanges();
return("S");
}
}
catch { return("N"); }
}//*/