public bool ImportSerialToEpicor(SessionInfo _session, PlanningHeadModel model, out string msg)
{
msg = string.Empty;
//boolean IsSuccess = false;
Session currSession;
var resultContinue = GetSerialAllByWorkOrder(model.WorkOrderID).ToList();
try
{
currSession = new Session(_session.UserID, _session.UserPassword, _session.AppServer, Session.LicenseType.Default);
}
catch (Exception ex)
{
msg = ex.Message;
return false;
}
foreach (var item in resultContinue)
{
try
{
LotSelectUpdate lotPart = new LotSelectUpdate(currSession.ConnectionPool);
LotSelectUpdateDataSet dsLot = new LotSelectUpdateDataSet();
lotPart.GetNewPartLot(dsLot, string.IsNullOrEmpty(item.NORNum) ? item.MCSSNo : item.NORNum);
DataRow drLot = dsLot.Tables[0].Rows[0];
drLot.BeginEdit();
drLot["LotNum"] = item.SerialNo;
drLot["PartLotDescription"] = item.SerialNo;
drLot["Number01"] = item.Thick;
drLot["Number02"] = item.Width;
drLot["Number03"] = item.Length;
drLot["Number04"] = item.UnitWeight;
drLot["Number05"] = 1;
drLot["Number08"] = 0;
drLot["Character02"] = item.BussinessType.GetString();
drLot["ShortChar06"] = item.WorkOrderNum.ToString();
drLot["Date05"] = DateTime.Now;
drLot.EndEdit();
lotPart.Update(dsLot);
msg = "Successful";
}
catch (Exception ex)
{
msg = ex.Message;
}
string sql = string.Format(@"UPDATE ucc_pln_SerialGenerated
SET GeneratedFlag = 1 --<GeneratedFlag, tinyint,>
,LastUpdateDate = GETDATE() --<LastUpdateDate, datetime,>
,UpdatedBy = N'{1}' --<UpdatedBy, nvarchar(45),>
,ImportMessage = N'{2}' --<ImportMessage, nvarchar(max),>
WHERE SerialNo = N'{0}'", item.SerialNo, _session.UserID, msg);
Repository.Instance.ExecuteWithTransaction(sql, "Update Import SN");
}
return true;
}
public bool ClearSerialInEpicor(SessionInfo _session, ProductionHeadModel model, out string msg)
{
msg = string.Empty; bool IsSuccess = false; Session currSession;
try
{
currSession = new Session(_session.UserID, _session.UserPassword, _session.AppServer, Session.LicenseType.Default);
}
catch (Exception ex)
{
msg = ex.Message;
return false;
}
foreach (var item in model.SerialLines.Where(i => i.CutSeq.Equals(model.CutSeq)))
{
try
{
LotSelectUpdate lotPart = new LotSelectUpdate(currSession.ConnectionPool);
lotPart.DeleteByID(item.MCSSNo, item.SerialNo);
}
catch (Exception ex)
{
msg = ex.Message + ": Status = " + IsSuccess.ToString();
IsSuccess = false;
}
}
string sql = string.Format(@"DELETE FROM ucc_pln_SerialGenerated WHERE WorkOrderID = {0} ", model.WorkOrderID);
Repository.Instance.ExecuteWithTransaction(sql, "Delete Serial");
return true;
}
public bool ClearSerialInEpicor(SessionInfo _session, PlanningHeadModel model, out string msg)
{
msg = string.Empty;
bool IsSuccess = true;
string sql = string.Empty;
Session currSession = null;
var resultContinue = GetSerialAllByWorkOrder(model.WorkOrderID).ToList();
try
{
currSession = new Session(_session.UserID, _session.UserPassword, _session.AppServer, Session.LicenseType.Default);
}
catch (Exception ex)
{
msg = ex.Message;
IsSuccess = false;
}
foreach (var item in resultContinue)
{
try
{
LotSelectUpdate lotPart = new LotSelectUpdate(currSession.ConnectionPool);
lotPart.DeleteByID(string.IsNullOrEmpty(item.NORNum) ? item.MCSSNo : item.NORNum, item.SerialNo);
}
catch (Exception ex)
{
msg = ex.Message;
IsSuccess = false;
}
//TODO : There are has one more case for delete S/N.
sql += string.Format(@"DELETE FROM ucc_pln_SerialGenerated WHERE WorkOrderID = {0} AND SerialNo = '{1}' {2}{3}{4}"
, item.WorkOrderID, item.SerialNo, Environment.NewLine, "", Environment.NewLine);
}
sql += string.Format(@"UPDATE ucc_pln_PlanHead SET GenSerialFlag = 0 WHERE WorkOrderID = {0} ", model.WorkOrderID);
Repository.Instance.ExecuteWithTransaction(sql, "Delete Serial");
return IsSuccess;
}