private void ScreenOff_CheckStateChanged(object sender, EventArgs e)
{
EKanbanDevice.ScreenOff = ScreenOff.Checked;
EKanbanTaskQuery eKanbanTaskQuery = new EKanbanTaskQuery(_SERVER.ServerName.Database);
eKanbanTaskQuery.UpdateEKanbanDevice(EKanbanDevice);
}
public EkanbanHisControl(EKanbanHis ekanbanHis, EKanbanDevice eKanbanDevice, IDbName _database)
{
InitializeComponent();
EKanbanHis = new EKanbanHis();
EKanbanHis = ekanbanHis;
eKanbanTaskQuery = new EKanbanTaskQuery(_database);
SysHistoryQuery = new SysHistoryQuery(_database);
lbCartName.Text = eKanbanDevice.Name;
}
public EKanbanResponse(IDbName _database, int _ekanbanDeviceId)
{
EKanbanTaskQuery eKanbanTaskQuery = new EKanbanTaskQuery(_database);
SequenceQuery sequenceQuery = new SequenceQuery(_database);
ComponentQuery componentQuery = new ComponentQuery(_database);
var ekanbanDevice = eKanbanTaskQuery.GetEKanbanDevice(_ekanbanDeviceId);
var _Interface = eKanbanTaskQuery.GetLastEKanbanInterface(_ekanbanDeviceId);
SizeList = new List <SizeInfo>();
PartList = new List <PartInfo>();
List <OriginalSize> originalSizes = new List <OriginalSize>();
foreach (var item in _Interface.EKanbanLoadings)
{
var Seq = sequenceQuery.GetOriginalSequence(ShareFuncs.GetInt(item.OriginalSequence_Id));
TotalCartQty += ShareFuncs.GetInt(Seq.Quantity);
foreach (var size in Seq.OriginalSizes)
{
originalSizes.Add(size);
}
}
foreach (var item in originalSizes)
{
var foundSizes = SizeList.Where(i => i.SizeId == item.SizeId);
if (foundSizes.Count() > 0)
{
foundSizes.First().SizeQty += ShareFuncs.GetInt(item.Quantity);
}
else
{
SizeList.Add(new SizeInfo(ShareFuncs.GetInt(item.SizeId), ShareFuncs.GetInt(item.Quantity)));
}
}
Interface = new InterfaceInfo(_Interface);
foreach (var item in _Interface.EkanbanComponents)
{
var Component = componentQuery.GetShoeComponent(ShareFuncs.GetInt(item.ShoeComponent_Id));
PartList.Add(new PartInfo(ShareFuncs.ConvertToUnSign(Component.Reference)));
}
//if (DateTime.Now.Hour == 17)
//{
// if (DateTime.Now.Minute > 50)
// {
// ScreenOff = true;
// ekanbanDevice.ScreenOff = true;
// }
//}
//else
//{
// if (DateTime.Now.Hour > 17)
// {
// ScreenOff = true;
// ekanbanDevice.ScreenOff = true;
// }
//}
//if (DateTime.Now.Hour == 6 && DateTime.Now.Minute < 45)
//{
// ScreenOff = false;
// ekanbanDevice.ScreenOff = false;
//}
ekanbanDevice.NetworkStatus = (int)SYS_MODELS._ENUM.SysActionCode.ONLINE;
ekanbanDevice.LastOnline = DateTime.Now;
eKanbanTaskQuery.UpdateEKanbanDevice(ekanbanDevice);
if (ekanbanDevice.ScreenOff == null)
{
ScreenOff = false;
}
else
{
ScreenOff = (bool)ekanbanDevice.ScreenOff;
}
}
public ConfirmResponse(IDbName _database, int _ekanbanDeviceId, int _confirmQty)
{
try
{
EKanbanTaskQuery eKanbanTaskQuery = new EKanbanTaskQuery(_database);
SequenceQuery sequenceQuery = new SequenceQuery(_database);
ComponentQuery componentQuery = new ComponentQuery(_database);
StockQuery stockQuery = new StockQuery(_database);
ScheduleQuery scheduleQuery = new ScheduleQuery(_database);
SysHistoryQuery sysHistoryQuery = new SysHistoryQuery(_database);
var Interface = eKanbanTaskQuery.GetLastEKanbanInterface(_ekanbanDeviceId);
var his = sysHistoryQuery.GetEKanbanHistory(Interface);
if (Interface.SysActionCode == (int)SYS_MODELS._ENUM.SysActionCode.EKANBAN_CONFIRM_ITEM)
{
ConfirmSuccess = true;
EMessage = "EKanban is already conform!";
return;
}
Interface.SysActionCode = (int)SYS_MODELS._ENUM.SysActionCode.EKANBAN_CONFIRM_ITEM;
Interface.LastUpdate = DateTime.Now;
if (!eKanbanTaskQuery.UpdateEKanbanInterface(Interface))
{
ConfirmSuccess = false;
EMessage = "EKanban is already conform!";
return;
}
List <Schedule> schedules = new List <Schedule>();
foreach (var item in Interface.EKanbanLoadings)
{
var sch = scheduleQuery.GetSchedule(ShareFuncs.GetInt(item.OriginalPo_Id));
var Seq = sequenceQuery.GetOriginalSequence(ShareFuncs.GetInt(item.OriginalSequence_Id));
if (sch != null)
{
var stock = stockQuery.GetPrepareStockMeasure(sch);
if (stock != null)
{
StockConfirmSequence stockConfirm = new StockConfirmSequence
{
FinishTime = DateTime.Now,
SequenceNo = Seq.SequenceNo,
SequenceQty = Seq.Quantity,
StockMeasure_Id = stock.id,
};
StockMessage = "Update stock message successfully";
if (!stockQuery.AddNewStockConfirm(stockConfirm))
{
StockMessage = "An error orcured while updating stock";
}
stock.ConfirmUpdateTime = DateTime.Now;
stock.EKanbanConfirmQty += Seq.Quantity;
if (!stockQuery.UpdateStockMeasure(stock))
{
StockMessage = "An error orcured while updating stock";
}
}
}
item.SysActionCode = (int)SYS_MODELS._ENUM.SysActionCode.SEQUENCE_CONFORM;
item.LastUpdate = DateTime.Now;
item.ConfirmQty = _confirmQty;
eKanbanTaskQuery.UpdateEKanbanLoading(item);
string jsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(Interface);
his.Data = jsonStr;
his.DateTime = DateTime.Now;
sysHistoryQuery.UpdateEKanbanHis(his);
EKanbanConfirmHis eKanbanConfirmHis = new EKanbanConfirmHis
{
Conform = true,
DateTime = DateTime.Now,
EKanbanHis_Id = his.id,
OriginalSequence_Id = Seq.id,
SequenceNo = Seq.SequenceNo,
SequenceQty = Seq.Quantity,
};
sysHistoryQuery.AddNewConfirmHistory(eKanbanConfirmHis);
}
ConfirmSuccess = true;
EMessage = "EKanban is conform successfully";
}
catch (Exception e)
{
EMessage = e.Message;
}
}
