public RespSchedule(IDbName database, string line, int month, string poNumber)
{
try
{
BeamCutQuery = new BeamCutQuery(database);
ScheduleQuery = new ScheduleQuery(database);
BuildingQuery = new BuildingQuery(database);
var productionLine = BuildingQuery.FindProductionLine(line);
if (productionLine == null)
{
Exception = new RespException(true, "Line name is not found", EKB_SYS_REQUEST.BEAM_GET_SCHEDULE);
return;
}
DateTime SearchTime = new DateTime(DateTime.Now.Year, month, DateTime.Now.Day);
var scheduleclass = ScheduleQuery.GetScheduleClass(SearchTime);
if (scheduleclass == null)
{
Exception = new RespException(true, "Invalid schedule time", EKB_SYS_REQUEST.BEAM_GET_SCHEDULE);
return;
}
var schedules = ScheduleQuery.GetSchedules(poNumber);
if (schedules == null)
{
Exception = new RespException(true, "Sequence have no item", EKB_SYS_REQUEST.BEAM_GET_SCHEDULE);
return;
}
//var temp = schedules.Where(i => i.ScheduleClass_Id == scheduleclass.id);
//if (temp.Count() > 0)
// schedules = temp.ToList();
List <Schedule> newSchedule = new List <Schedule>();
foreach (var item in productionLine)
{
schedules.Where(i => i.ProductionLine_Id == item.id);
if (schedules.Count() > 0)
{
newSchedule.AddRange(schedules.ToList());
}
}
newSchedule = newSchedule.Take(15).ToList();
ScheduleList = new List <Schedule_t>();
foreach (var item in newSchedule)
{
ScheduleList.Add(new Schedule_t(database, item));
}
Exception = new RespException(false, "Get schedule: OK", EKB_SYS_REQUEST.BEAM_GET_SCHEDULE);
}
catch (Exception e)
{
Exception = new RespException(true, e.Message, EKB_SYS_REQUEST.BEAM_GET_SCHEDULE);
}
}
public RespSchedule(IDbName database, int machineId, int workerid)
{
BeamCutQuery = new BeamCutQuery(database);
ScheduleQuery = new ScheduleQuery(database);
BuildingQuery = new BuildingQuery(database);
var orders = BeamCutQuery.GetBDeviceOrder(machineId, workerid, DateTime.Now.ToString("dd/MM/yyyy"));
if (orders == null)
{
Exception = new RespException(true, "Order is empty", EKB_SYS_REQUEST.BEAM_GET_SCHEDULE);
return;
}
List <Schedule> schedules = new List <Schedule>();
foreach (var item in orders)
{
var temp = ScheduleQuery.GetSchedule(item);
if (temp != null)
{
schedules.Add(temp);
}
}
ScheduleList = new List <Schedule_t>();
foreach (var item in schedules)
{
ScheduleList.Add(new Schedule_t(database, item));
}
Exception = new RespException(false, "Get Order: OK", EKB_SYS_REQUEST.BEAM_GET_SCHEDULE);
}
// stop cut
public RespCutting(IDbName database, int binterfaceId, int beamCounter)
{
BeamCutQuery = new BeamCutQuery(database);
StockQuery = new StockQuery(database);
EmployeeQuery = new EmployeeQuery(database);
SequenceQuery = new SequenceQuery(database);
ScheduleQuery = new ScheduleQuery(database);
ComponentQuery = new ComponentQuery(database);
try
{
var bInterface = BeamCutQuery.GetBeamInterfaceById(binterfaceId);
if (bInterface == null)
{
Exception = new RespException(true, "Can not find BInterface", EKB_SYS_REQUEST.BEAM_STOP_CUTTING);
return;
}
bInterface.Finish = true;
bInterface.BeamCutCounter = beamCounter;
bInterface.StopCutTime = DateTime.Now;
if (!BeamCutQuery.UpdateBeamInterface(bInterface))
{
Exception = new RespException(true, "Can not update BInterface", EKB_SYS_REQUEST.BEAM_STOP_CUTTING);
return;
}
Exception = new RespException(false, "Stop cutting: OK", EKB_SYS_REQUEST.BEAM_STOP_CUTTING);
}
catch (Exception e)
{
Exception = new RespException(true, e.Message, EKB_SYS_REQUEST.BEAM_STOP_CUTTING);
}
}
public RespComponent(IDbName _database, int _scheduleId, int originalPoId)
{
try
{
ComponentQuery componentQuery = new ComponentQuery(_database);
ScheduleQuery scheduleQuery = new ScheduleQuery(_database);
SequenceQuery SequenceQuery = new SequenceQuery(_database);
var schedule = scheduleQuery.GetSchedule(_scheduleId);
var originalPo = SequenceQuery.GetOriginalPo(originalPoId);
if (schedule == null)
{
if (originalPo == null)
{
Exception = new RespException(true, "Can not find original po", EKB_SYS_REQUEST.BEAM_GET_COMPONENT);
return;
}
schedule = scheduleQuery.GetSchedule(originalPo);
if (schedule == null)
{
Exception = new RespException(true, "Can not find schedule", EKB_SYS_REQUEST.BEAM_GET_COMPONENT);
return;
}
}
var components = componentQuery.GetModelComponents(schedule.Model);
if (components == null)
{
Exception = new RespException(true, "Can not find component list", EKB_SYS_REQUEST.BEAM_GET_COMPONENT);
return;
}
components = components.OrderByDescending(i => i.CuttingType.id).ToList();
ComponentList = new List <Component_t>();
foreach (var item in components)
{
ComponentList.Add(new Component_t(item));
}
Exception = new RespException(false, "Get component: Ok", EKB_SYS_REQUEST.BEAM_GET_COMPONENT);
}
catch (Exception e)
{
Exception = new RespException(true, e.Message, EKB_SYS_REQUEST.BEAM_GET_COMPONENT);
}
}
public BDeviceCutTime(IDbName database, int deviceId, int totalCutTime)
{
BeamCutQuery = new BeamCutQuery(database);
var statistic = BeamCutQuery.GetBMachineStatistic(deviceId, DateTime.Now);
if (statistic == null)
{
statistic = BeamCutQuery.AddNewBcutStatistic(deviceId, DateTime.Now);
}
if (statistic.BDeviceCutTimeRecords != null)
{
foreach (var item in statistic.BDeviceCutTimeRecords)
{
TotalCutTime += ShareFuncs.GetInt(item.TotalCutTime);
}
}
var lastRecord = BeamCutQuery.Get_DeviceLastRecord(deviceId);
if (lastRecord != null)
{
DateTime updateTime = (DateTime)lastRecord.UpdateTime;
if (updateTime.DayOfYear == DateTime.Now.DayOfYear &&
updateTime.Minute == DateTime.Now.Minute &&
updateTime.Hour == DateTime.Now.Hour)
{
// duplicate update detected
Exception = new RespException(false, "The cut time has been recorded", EKB_SYS_REQUEST.CUT_TIME_RECORD);
return;
}
}
BDeviceCutTimeRecord record = new BDeviceCutTimeRecord
{
TotalCutTime = totalCutTime,
BeamCutDevice_Id = deviceId,
BMachineStatistic_Id = statistic.id,
};
if (!BeamCutQuery.AddNewBCutTimeRecord(record))
{
Exception = new RespException(true, "Add new record failed", EKB_SYS_REQUEST.CUT_TIME_RECORD);
return;
}
TotalCutTime += totalCutTime;
}
public RespSchedule(IDbName database, string line, string poNumber)
{
try
{
BeamCutQuery = new BeamCutQuery(database);
ScheduleQuery = new ScheduleQuery(database);
BuildingQuery = new BuildingQuery(database);
var productionLine = BuildingQuery.FindProductionLine(line);
if (productionLine == null)
{
Exception = new RespException(true, "Line name is not found", EKB_SYS_REQUEST.BEAM_GET_SCHEDULE);
return;
}
var schedules = ScheduleQuery.GetSchedules(poNumber);
if (schedules == null)
{
Exception = new RespException(true, "Sequence have no item", EKB_SYS_REQUEST.BEAM_GET_SCHEDULE);
return;
}
List <Schedule> newSchedule = new List <Schedule>();
foreach (var item in productionLine)
{
schedules.Where(i => i.ProductionLine_Id == item.id);
if (schedules.Count() > 0)
{
newSchedule.AddRange(schedules.ToList());
}
}
newSchedule = newSchedule.Take(15).ToList();
ScheduleList = new List <Schedule_t>();
foreach (var item in newSchedule)
{
ScheduleList.Add(new Schedule_t(database, item));
}
Exception = new RespException(false, "Get schedule: OK", EKB_SYS_REQUEST.BEAM_GET_SCHEDULE);
}
catch (Exception e)
{
Exception = new RespException(true, e.Message, EKB_SYS_REQUEST.BEAM_GET_SCHEDULE);
}
}
public RespUserInfo(IDbName database, string rfid)
{
employeeQuery = new EmployeeQuery(database);
var employee = employeeQuery.GetEmployee(rfid);
if (employee == null)
{
Exception = new RespException(true, "Invalid RFID number", EKB_SYS_REQUEST.GET_USER_INFO);
return;
}
id = employee.id;
UserName = ShareFuncs.ConvertToUnSign(employee.Name);
Pass = true;
UserCode = employee.UserCode;
UserRFID = employee.RFID_Code;
Department = employee.Department.Code;
JobTitle = employee.JobTitle.Job;
}
public RespBeamDevice(IDbName database, string sysCode, string name)
{
try
{
BeamCutQuery BeamCutQuery = new BeamCutQuery(database);
var bdevice = BeamCutQuery.GetBeamCutDevice(sysCode, name);
if (bdevice == null)
{
Exception = new RespException(true, "Beam machine not found", SYS_MODELS._ENUM.EKB_SYS_REQUEST.GET_DEVICE_INFO);
return;
}
SystemCode = bdevice.MachineCode;
Name = bdevice.Name;
id = bdevice.id;
}
catch (Exception e)
{
Exception = new RespException(true, e.Message, SYS_MODELS._ENUM.EKB_SYS_REQUEST.GET_DEVICE_INFO);
}
}
public RespSize(IDbName _database, int seq1Id, int seq2Id)
{
try
{
SequenceQuery sequenceQuery = new SequenceQuery(_database);
BeamCutQuery beamCutQuery = new BeamCutQuery(_database);
List <OriginalPOsequence> SeqList = new List <OriginalPOsequence>();
var CloneSizes = beamCutQuery.GetBeamCutSizes(seq1Id, seq2Id);
if (CloneSizes == null)
{
Exception = new RespException(true, "CloneSizes is NULL", EKB_SYS_REQUEST.BEAM_GET_SIZE);
return;
}
SizeList = new List <Size_t>();
foreach (var size in CloneSizes)
{
SizeList.Add(new Size_t
{
SizeId = ShareFuncs.GetInt(size.SizeId),
SizeQty = ShareFuncs.GetInt(size.SizeQty),
CuttingQty = ShareFuncs.GetInt(size.CutQty),
Finish = (size.SizeQty == size.CutQty ? true : false)
});
RespTotalCuttingQty += ShareFuncs.GetInt(size.CutQty);
RespTotalQty += ShareFuncs.GetInt(size.SizeQty);
}
Exception = new RespException(false, "Get Size: OK", EKB_SYS_REQUEST.BEAM_GET_SIZE);
}
catch (Exception e)
{
Exception = new RespException(true, e.Message, EKB_SYS_REQUEST.BEAM_GET_SIZE);
}
}
public RespSchedule(IDbName database, string line, int month, int startId)
{
try
{
BeamCutQuery = new BeamCutQuery(database);
ScheduleQuery = new ScheduleQuery(database);
BuildingQuery = new BuildingQuery(database);
var productionLine = BuildingQuery.FindProductionLine(line);
DateTime SearchTime = new DateTime(DateTime.Now.Year, month, DateTime.Now.Day);
if (productionLine == null)
{
Exception = new RespException(true, "Line name is not found", EKB_SYS_REQUEST.BEAM_GET_SCHEDULE);
return;
}
var schedules = ScheduleQuery.GetSchedules(SearchTime);
if (schedules == null)
{
Exception = new RespException(true, $"Can not find the schedule for month:{month}", EKB_SYS_REQUEST.BEAM_GET_SCHEDULE);
return;
}
List <Schedule> newSchedule = new List <Schedule>();
foreach (var item in productionLine)
{
var temp = schedules.Where(i => i.ProductionLine_Id == item.id);
if (temp.Count() > 0)
{
newSchedule.AddRange(temp.ToList());
}
}
ScheduleList = new List <Schedule_t>();
var tempSch = newSchedule.Where(i => i.id > startId).Take(15).ToList();
if (tempSch.Count() > 0)
{
newSchedule = newSchedule.Where(i => i.id > startId).Take(15).ToList();
}
else
{
newSchedule = newSchedule.Take(15).ToList();
}
ScheduleList = new List <Schedule_t>();
foreach (var item in newSchedule)
{
var bInterface = BeamCutQuery.GetBeamInterfaceByScheduleId(item.id);
var sch = new Schedule_t(database, item);
if (bInterface != null)
{
sch.Cutting = true;
}
ScheduleList.Add(sch);
}
Exception = new RespException(false, "Get schedule: OK", EKB_SYS_REQUEST.BEAM_GET_SCHEDULE);
}
catch (Exception e)
{
Exception = new RespException(true, e.Message, EKB_SYS_REQUEST.BEAM_GET_SCHEDULE);
}
}
public BLastCut(IDbName database, int bdeviceId, int bInterfaceId)
{
BeamCutQuery = new BeamCutQuery(database);
StockQuery = new StockQuery(database);
EmployeeQuery = new EmployeeQuery(database);
SequenceQuery = new SequenceQuery(database);
ScheduleQuery = new ScheduleQuery(database);
ComponentQuery = new ComponentQuery(database);
try
{
var bInterface = BeamCutQuery.GetLastInterface(bdeviceId);
if (bInterface == null)
{
Exception = new RespException(true, "Can not find BInterface", EKB_SYS_REQUEST.BEAM_GET_LAST_CUT);
bInterface = BeamCutQuery.GetBeamInterfaceById(bInterfaceId);
if (bInterface == null)
{
Exception = new RespException(true, "Can not find BInterface", EKB_SYS_REQUEST.BEAM_GET_LAST_CUT);
return;
}
}
var bpo = BeamCutQuery.GetBeamCutPo(ShareFuncs.GetInt(bInterface.BeamCutPo_Id));
if (bpo == null)
{
Exception = new RespException(true, "Can not find clone Po", EKB_SYS_REQUEST.BEAM_GET_LAST_CUT);
return;
}
var originalPo = SequenceQuery.GetOriginalPo(ShareFuncs.GetInt(bInterface.OriginalPo_Id));
if (originalPo == null)
{
Exception = new RespException(true, "Can not find Po", EKB_SYS_REQUEST.BEAM_GET_LAST_CUT);
return;
}
BinterfaceId = bInterface.id;
PoNumber = originalPo.PoNumber;
StartSeq = ShareFuncs.GetInt(bInterface.StartSeqNo);
StopSeq = ShareFuncs.GetInt(bInterface.StopSeqNo);
if (bInterface.StartCutTime != null)
{
StartTime = ((DateTime)bInterface.StartCutTime).ToString("hh:mm tt, dd/MM/yyyy");
}
if (bInterface.StopCutTime != null)
{
StopTime = ((DateTime)bInterface.StopCutTime).ToString("hh:mm tt, dd/MM/yyyy");
}
CutQty = ShareFuncs.GetInt(bInterface.CuttingQty);
CutTime = ShareFuncs.GetInt(bInterface.BeamCutCounter);
Employee_Id = ShareFuncs.GetInt(bInterface.Employee_Id);
Schedule_Id = ShareFuncs.GetInt(bInterface.Schedule_Id);
BeamCutPo_Id = ShareFuncs.GetInt(bInterface.BeamCutPo_Id);
BeamCutStartSeq_Id = ShareFuncs.GetInt(bInterface.BeamCutStartSeq_Id);
Component_Id = ShareFuncs.GetInt(bpo.Component_Id);
BeamCutStopSeq_Id = ShareFuncs.GetInt(bInterface.BeamCutStopSeq_Id);
Finish = bInterface.Finish != null ? (bool)bInterface.Finish : false;
PoQty = ShareFuncs.GetInt(originalPo.Quantity);
OriginalPo_Id = ShareFuncs.GetInt(bInterface.OriginalPo_Id);
var component = ComponentQuery.GetShoeComponent(ShareFuncs.GetInt(bpo.Component_Id));
if (component != null)
{
string comp = ShareFuncs.ConvertToUnSign(component.Reference);
Component = comp;
}
Exception = new RespException(false, "Get last cut: OK", EKB_SYS_REQUEST.BEAM_GET_LAST_CUT);
}
catch (Exception e)
{
Exception = new RespException(true, e.Message, EKB_SYS_REQUEST.BEAM_GET_LAST_CUT);
}
}
public RespPoInfo(IDbName _database, int scheduleId, int originalPoId, int componentId)
{
try
{
ScheduleQuery scheduleQuery = new ScheduleQuery(_database);
SequenceQuery sequenceQuery = new SequenceQuery(_database);
BeamCutQuery beamCutQuery = new BeamCutQuery(_database);
SequenceQuery SequenceQuery = new SequenceQuery(_database);
ComponentQuery componentQuery = new ComponentQuery(_database);
var schedule = scheduleQuery.GetSchedule(scheduleId);
var originalPo = SequenceQuery.GetOriginalPo(originalPoId);
var shoeComponent = componentQuery.GetShoeComponent(componentId);
if (schedule == null)
{
if (originalPo == null)
{
Exception = new RespException(true, "Can not find schedule", EKB_SYS_REQUEST.BEAM_GET_PO_INFO);
return;
}
schedule = scheduleQuery.GetSchedule(originalPo);
if (schedule == null)
{
Exception = new RespException(true, "Can not find schedule", EKB_SYS_REQUEST.BEAM_GET_PO_INFO);
return;
}
}
if (shoeComponent == null)
{
Exception = new RespException(true, "Can not find component", EKB_SYS_REQUEST.BEAM_GET_PO_INFO);
return;
}
PoInfo = new PoInfo(_database, schedule);
if (originalPo == null)
{
Exception = new RespException(true, "Empty sequence file", EKB_SYS_REQUEST.BEAM_GET_PO_INFO);
return;
}
var clonePo = beamCutQuery.FindClonePo(originalPo.id, componentId);
if (clonePo != null)
{
ClonePoId = clonePo.id;
SeqList = new List <SeqInfo>();
foreach (var item in clonePo.BeamCutSeqs)
{
SeqList.Add(new SeqInfo
{
id = item.id,
CuttingQty = ShareFuncs.GetInt(item.CutQty),
SeqNo = ShareFuncs.GetInt(item.SequenceNo),
SeqQty = ShareFuncs.GetInt(item.SequenceQty),
Finish = item.Finish == true ? true : false,
});
}
}
else
{
var bClonePo = beamCutQuery.CloneOriginalPo(originalPo, shoeComponent);
if (bClonePo == null)
{
Exception = new RespException(true, "An error occured while requesting po information", EKB_SYS_REQUEST.BEAM_GET_PO_INFO);
return;
}
ClonePoId = bClonePo.id;
SeqList = new List <SeqInfo>();
foreach (var item in bClonePo.BeamCutSeqs)
{
SeqList.Add(new SeqInfo
{
id = item.id,
CuttingQty = ShareFuncs.GetInt(item.CutQty),
SeqNo = ShareFuncs.GetInt(item.SequenceNo),
SeqQty = ShareFuncs.GetInt(item.SequenceQty),
Finish = item.Finish == true ? true : false,
});
}
}
Exception = new RespException(false, "Get Poinfo: OK", EKB_SYS_REQUEST.BEAM_GET_PO_INFO);
}
catch (Exception e)
{
Exception = new RespException(true, e.Message, EKB_SYS_REQUEST.BEAM_GET_PO_INFO);
}
}
public RespConfirmSize(IDbName database, int bInterfaceId, int sizeId, int sizeQty)
{
try
{
BeamCutQuery = new BeamCutQuery(database);
StockQuery = new StockQuery(database);
EmployeeQuery = new EmployeeQuery(database);
SequenceQuery = new SequenceQuery(database);
ScheduleQuery = new ScheduleQuery(database);
ComponentQuery = new ComponentQuery(database);
var beamInterface = BeamCutQuery.GetBeamInterfaceById(bInterfaceId);
if (beamInterface == null)
{
Exception = new RespException(true, "Can not find BInterface", EKB_SYS_REQUEST.BEAM_CONFIRM_SIZE);
return;
}
var bdevice = BeamCutQuery.GetBeamCutDevice(beamInterface.BeamCutDevice_Id);
if (bdevice == null)
{
Exception = new RespException(true, "Can not find beam cut device", EKB_SYS_REQUEST.BEAM_CONFIRM_SIZE);
return;
}
var clonePo = BeamCutQuery.GetBeamCutPo(ShareFuncs.GetInt(beamInterface.BeamCutPo_Id));
if (clonePo == null)
{
Exception = new RespException(true, "Can not find clone Po", EKB_SYS_REQUEST.BEAM_CONFIRM_SIZE);
return;
}
var seq1 = BeamCutQuery.GetBeamCutSeq(ShareFuncs.GetInt(beamInterface.BeamCutStartSeq_Id));
var seq2 = BeamCutQuery.GetBeamCutSeq(ShareFuncs.GetInt(beamInterface.BeamCutStopSeq_Id));
int cutQty = 0;
int totalQty = 0;
int currentQty = 0;
int addQty = 0;
int seqTotalQty = 0;
int seqQty = 0;
foreach (var seq in clonePo.BeamCutSeqs)
{
if (seq.SequenceNo >= seq1.SequenceNo && seq.SequenceNo <= seq2.SequenceNo)
{
if (seq.Finish == false)
{
var sizes = BeamCutQuery.GetBeamCutSize(seq.id);
int seqcutQty = ShareFuncs.GetInt(seq.CutQty);
foreach (var size in sizes)
{
if (size.SizeId == sizeId)
{
if (size.Finished != true && sizeQty > 0)
{
int oldval = ShareFuncs.GetInt(size.CutQty);
int addval = ShareFuncs.GetInt(size.SizeQty) - oldval;
if (sizeQty >= addval)
{
addval = ShareFuncs.GetInt(size.SizeQty) - oldval;
size.CutQty = size.SizeQty;
size.Finished = true;
seqcutQty += addval;
sizeQty -= addval;
addQty += addval;
}
else
{
size.CutQty += sizeQty;
seqcutQty += sizeQty;
addQty += sizeQty;
sizeQty = 0;
}
size.BeamCutDevice_Id = beamInterface.BeamCutDevice_Id;
size.Worker_Id = beamInterface.Employee_Id;
size.LastUpdate = DateTime.Now;
BeamCutQuery.UpdateBeamSize(size);
}
totalQty += ShareFuncs.GetInt(size.SizeQty);
cutQty += ShareFuncs.GetInt(size.CutQty);
}
currentQty += ShareFuncs.GetInt(size.CutQty);
}
seq.BeamCutDevice_Id = beamInterface.BeamCutDevice_Id;
seq.Worker_Id = beamInterface.Employee_Id;
seq.CutQty = seqcutQty;
seq.LastUpdate = DateTime.Now;
seq.Finish = seq.CutQty == seq.SequenceQty ? true : false;
BeamCutQuery.UpdateBeamCutSeq(seq);
}
seqTotalQty += ShareFuncs.GetInt(seq.CutQty);
seqQty += ShareFuncs.GetInt(seq.SequenceQty);
}
}
if (seqTotalQty == seqQty)
{
StopCutting = true;
}
int oldVal = beamInterface.CuttingQty != null ? (int)beamInterface.CuttingQty : 0;
beamInterface.LastConfirmSize = DateTime.Now;
beamInterface.CuttingQty = addQty + oldVal;
BeamCutQuery.UpdateBeamInterface(beamInterface);
clonePo.LastUpdate = DateTime.Now;
clonePo.CuttingQuantity += addQty;
if (clonePo.CuttingQuantity == clonePo.PoQuantity)
{
clonePo.Finish = true;
clonePo.FinishTime = DateTime.Now;
}
BeamCutQuery.UpdateBeamCutPo(clonePo);
var statistic = BeamCutQuery.GetBMachineStatistic(ShareFuncs.GetInt(beamInterface.BeamCutDevice_Id), DateTime.Now);
if (statistic == null)
{
statistic = BeamCutQuery.AddNewBcutStatistic(ShareFuncs.GetInt(beamInterface.BeamCutDevice_Id), DateTime.Now);
}
BDeviceCutTimeRecord record = new BDeviceCutTimeRecord
{
TotalCutTime = 0,
BeamCutDevice_Id = bdevice.id,
ConfirmQuantity = addQty,
BMachineStatistic_Id = statistic.id,
};
if (!BeamCutQuery.AddNewBCutTimeRecord(record))
{
Exception = new RespException(true, "Add new record failed", EKB_SYS_REQUEST.BEAM_CONFIRM_SIZE);
}
int temp = statistic.TotalCutQty != null ? (int)statistic.TotalCutQty : 0;
statistic.TotalCutQty = temp + addQty;
BeamCutQuery.UpdateBStatistic(statistic);
RespTotalCuttingQty = ShareFuncs.GetInt(beamInterface.CuttingQty);
SizeId = sizeId;
CutQty = cutQty;
Finish = (totalQty == cutQty ? true : false);
Exception = new RespException(false, "Confirm Size: OK", EKB_SYS_REQUEST.BEAM_CONFIRM_SIZE);
}
catch (Exception e)
{
Exception = new RespException(true, e.Message, EKB_SYS_REQUEST.BEAM_CONFIRM_SIZE);
}
}
public RespFinishAll(IDbName database, int bInterfaceId, int cutCounter)
{
BeamCutQuery BeamCutQuery = new BeamCutQuery(database);
StockQuery StockQuery = new StockQuery(database);
EmployeeQuery EmployeeQuery = new EmployeeQuery(database);
SequenceQuery SequenceQuery = new SequenceQuery(database);
ScheduleQuery ScheduleQuery = new ScheduleQuery(database);
ComponentQuery ComponentQuery = new ComponentQuery(database);
try
{
var bInterface = BeamCutQuery.GetBeamInterfaceById(bInterfaceId);
if (bInterface == null)
{
Exception = new RespException(true, "Can not find BInterface", EKB_SYS_REQUEST.FINISH_ALL);
return;
}
var clonePo = BeamCutQuery.GetBeamCutPo(ShareFuncs.GetInt(bInterface.BeamCutPo_Id));
if (clonePo == null)
{
Exception = new RespException(true, "Invalid clone Po Id", EKB_SYS_REQUEST.BEAM_START_CUTTING);
return;
}
int addQty = 0;
foreach (var seq in clonePo.BeamCutSeqs)
{
var currentSeq = BeamCutQuery.GetBeamCutSeq(seq.id);
if (currentSeq.SequenceNo < bInterface.SequenceNo + bInterface.TotalSequence)
{
foreach (var size in seq.BeamCutSizes)
{
addQty += ShareFuncs.GetInt(size.SizeQty - size.CutQty);
size.CutQty = size.SizeQty;
size.Finished = true;
size.LastUpdate = DateTime.Now;
BeamCutQuery.UpdateBeamSize(size);
}
currentSeq.CutQty += addQty;
currentSeq.LastUpdate = DateTime.Now;
currentSeq.Finish = true;
BeamCutQuery.UpdateBeamCutSeq(currentSeq);
}
}
bInterface.BeamCutCounter += cutCounter;
bInterface.CuttingQty += addQty;
bInterface.StopCutTime = DateTime.Now;
if (!BeamCutQuery.UpdateBeamInterface(bInterface))
{
Exception = new RespException(true, "Can not update BInterface", EKB_SYS_REQUEST.FINISH_ALL);
return;
}
}
catch (Exception e)
{
Exception = new RespException(true, e.Message, EKB_SYS_REQUEST.FINISH_ALL);
}
}
public RespUserInfo(IDbName database, NewUser new_user)
{
employeeQuery = new EmployeeQuery(database);
var checkUser = employeeQuery.GetEmployee(new_user.RFID);
if (checkUser != null)
{
Exception = new RespException(true, "Worker has been added", EKB_SYS_REQUEST.GET_USER_INFO);
return;
}
var temp1 = employeeQuery.GetEmployee(new_user.Code);
int id = 0;
if (temp1 != null)
{
temp1.RFID_Code = new_user.RFID;
employeeQuery.UpdateEmployee(temp1);
id = temp1.id;
}
else
{
var dep = employeeQuery.GetDepartment(new_user.Dep);
if (dep == null)
{
dep = employeeQuery.AddNewDepartment(new_user.Dep);
if (dep == null)
{
Exception = new RespException(true, "Can not add new department", EKB_SYS_REQUEST.GET_USER_INFO);
return;
}
}
Employee employee = new Employee
{
Name = new_user.Name,
RFID_Code = new_user.RFID,
Department_Id = dep.id,
Position_Id = 3,
JobTitle_Id = 2,
Building_Id = 1,
UserCode = new_user.Code,
};
var NewEmployee = employeeQuery.AddNewBeamWorker(employee);
if (NewEmployee == null)
{
Exception = new RespException(true, "Can not add new user", EKB_SYS_REQUEST.GET_USER_INFO);
return;
}
id = NewEmployee.id;
}
var empl = employeeQuery.GetEmployee(id);
id = empl.id;
UserName = ShareFuncs.ConvertToUnSign(empl.Name);
Pass = true;
UserCode = empl.UserCode;
UserRFID = empl.RFID_Code;
Department = empl.Department.Code;
JobTitle = empl.JobTitle.Job;
}
// start cutting construction
public RespCutting(IDbName database, int deviceId, int workerId, int clonePoId, int seq1Id, int seq2Id, int binterfaceId)
{
BeamCutQuery = new BeamCutQuery(database);
StockQuery = new StockQuery(database);
EmployeeQuery = new EmployeeQuery(database);
SequenceQuery = new SequenceQuery(database);
ScheduleQuery = new ScheduleQuery(database);
ComponentQuery = new ComponentQuery(database);
try
{
var worker = EmployeeQuery.GetEmployee(workerId);
if (worker == null)
{
Exception = new RespException(true, "Invalid worker Id", EKB_SYS_REQUEST.BEAM_START_CUTTING);
return;
}
var bdevice = BeamCutQuery.GetBeamCutDevice(deviceId);
if (bdevice == null)
{
Exception = new RespException(true, "Invalid device Id", EKB_SYS_REQUEST.BEAM_START_CUTTING);
return;
}
var clonePo = BeamCutQuery.GetBeamCutPo(clonePoId);
if (clonePo == null)
{
Exception = new RespException(true, "Invalid clone Po Id", EKB_SYS_REQUEST.BEAM_START_CUTTING);
return;
}
var originalPo = SequenceQuery.GetOriginalPo(clonePo.OriginalPo_Id);
if (originalPo == null)
{
Exception = new RespException(true, "Can not find original po", EKB_SYS_REQUEST.BEAM_START_CUTTING);
return;
}
var component = ComponentQuery.GetShoeComponent(clonePo.Component_Id);
if (component == null)
{
Exception = new RespException(true, "Can not find component", EKB_SYS_REQUEST.BEAM_START_CUTTING);
return;
}
var schedule = ScheduleQuery.GetSchedule(originalPo);
if (schedule == null)
{
Exception = new RespException(true, "Can not find schedule", EKB_SYS_REQUEST.BEAM_START_CUTTING);
return;
}
var order = BeamCutQuery.GetBDeviceOrder(originalPo, deviceId);
var startSeq = BeamCutQuery.GetBeamCutSeq(seq1Id);
var stopSeq = BeamCutQuery.GetBeamCutSeq(seq2Id);
if (startSeq == null || stopSeq == null)
{
Exception = new RespException(true, "Invalid clone Seq Id", EKB_SYS_REQUEST.BEAM_START_CUTTING);
return;
}
int[] qty = BeamCutQuery.GetTotalSelectSequenceQty(startSeq, stopSeq);
if (qty == null)
{
qty = new int[] { 0, 0 }
}
;
int bId = binterfaceId;
BeamCutInterface binterface = BeamCutQuery.GetBeamInterfaceById(binterfaceId);
int scheduleId = 0;
if (schedule != null)
{
scheduleId = schedule.id;
}
if (binterface == null)
{
binterface = new BeamCutInterface
{
Employee_Id = workerId,
BeamCutDevice_Id = deviceId,
BeamCutPo_Id = clonePoId,
OriginalPo_Id = clonePo.OriginalPo_Id,
BeamCutStartSeq_Id = seq1Id,
BeamCutStopSeq_Id = seq2Id,
TotalSelectedQty = qty[0],
TotalSelectCutQty = qty[1],
Schedule_Id = scheduleId,
StartSeqNo = startSeq.SequenceNo,
StopSeqNo = stopSeq.SequenceNo,
StartCutTime = DateTime.Now,
CuttingQty = 0,
BeamCutCounter = 0,
BDeviceOrder_Id = order != null ? order.id : 0,
};
var beamInterface = BeamCutQuery.AddNewBeamCutInterface(binterface);
if (beamInterface == null)
{
Exception = new RespException(true, "Add new BInterface error", EKB_SYS_REQUEST.BEAM_START_CUTTING);
return;
}
bId = beamInterface.id;
}
StockMeasure stockMeasure = StockQuery.GetStockMeasure(schedule);
if (stockMeasure == null)
{
var stock = StockQuery.AddNewStockMeasure(schedule);
}
Exception = new RespException(false, "Start cutting: OK", EKB_SYS_REQUEST.BEAM_START_CUTTING);
InterfaceId = bId;
}
catch (Exception e)
{
Exception = new RespException(true, e.Message, EKB_SYS_REQUEST.BEAM_START_CUTTING);
}
}