public JsonResult RefreshData(int PlantID = 0, int ShopID = 0, int CellID = 0, int WorkCenterID = 0)
{
//Don't Delete
//retValList Order : OpTime,CutTime,PonTime,CycleTime,FeedRate,Spindal,Program,IP,MacInv,State,RunMode,Alarm,Emergency,ATCCounter.
int AxisCount = 32;
string IpAddress = db.tblmachinedetails.Where(m => m.MachineID == WorkCenterID && m.IsDeleted == 0).Select(m => m.IPAddress).FirstOrDefault();
string MacInvNo = db.tblmachinedetails.Where(m => m.MachineID == WorkCenterID && m.IsDeleted == 0).Select(m => m.MachineDisplayName).FirstOrDefault();
string AxisCountString = Convert.ToString(db.tblmachinedetails.Where(m => m.MachineID == WorkCenterID && m.IsDeleted == 0).Select(m => m.CurrentControlAxis).FirstOrDefault());
int MacType = Convert.ToInt32(db.tblmachinedetails.Where(m => m.MachineID == WorkCenterID && m.IsDeleted == 0).Select(m => m.MacType).FirstOrDefault());
if (AxisCountString != null)
{
AxisCount = Convert.ToInt32(AxisCountString);
}
VirtualHMI vhmi = new VirtualHMI(IpAddress, MacInvNo); //Initializing the Class;
// int NoOfAxis, out List<string> retValList, out List<AxisDetails> AxisDetailsList
List <string> retValList = new List <string>();
List <AxisDetails> AxisDetailsList = new List <AxisDetails>();
vhmi.VirtualDispRefersh(AxisCount, out retValList, out AxisDetailsList);
foreach (var row in AxisDetailsList)
{
int AxisID = row.AxisID;
string AxisName = db.tbl_axisdet.Where(m => m.MachineID == WorkCenterID && m.AxisID == AxisID).Select(m => m.AxisName).FirstOrDefault();
row.AxisName = AxisName;
}
ViewBag.RetValList = retValList;
ViewBag.AxisDetailsList = AxisDetailsList;
List <string> ModelData = new List <string>();
var ATCCounterVal = db.tblatccounters.Where(m => m.MachineID == WorkCenterID).FirstOrDefault();
if (ATCCounterVal != null)
{
ModelData.Add(ATCCounterVal.Counter.ToString());
}
else
{
ModelData.Add(0.ToString());
}
vhmi.ModalData(ref ModelData);
ViewBag.ModalData = ModelData;
var result = new { RetVal = retValList, AxisDetailsList = AxisDetailsList, ModalData = ModelData };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Index(int PlantID = 0, int ShopID = 0, int CellID = 0, int WorkCenterID = 0)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"].ToString().ToUpper();
ViewBag.roleid = Session["RoleID"];
//int.TryParse( Convert.ToString( TempData["PlantID"]),out PlantID);
//int.TryParse( Convert.ToString( TempData["ShopID"]),out ShopID);
//int.TryParse( Convert.ToString( TempData["CellID"]),out CellID);
//int.TryParse( Convert.ToString( TempData["WorkCenterID"]),out WorkCenterID);
ViewBag.ModalData = null;
ViewBag.RetValList = null;
ViewBag.AxisDetailsList = null;
if (WorkCenterID != 0)
{
//Don't Delete
//retValList Order : OpTime,CutTime,PonTime,CycleTime,FeedRate,Spindal,Program,IP,MacInv,State,RunMode,Alarm,Emergency,ATCCounter.
int AxisCount = 32;
string IpAddress = db.tblmachinedetails.Where(m => m.MachineID == WorkCenterID && m.IsDeleted == 0).Select(m => m.IPAddress).FirstOrDefault();
string MacInvNo = db.tblmachinedetails.Where(m => m.MachineID == WorkCenterID && m.IsDeleted == 0).Select(m => m.MachineDisplayName).FirstOrDefault();
string AxisCountString = Convert.ToString(db.tblmachinedetails.Where(m => m.MachineID == WorkCenterID && m.IsDeleted == 0).Select(m => m.CurrentControlAxis).FirstOrDefault());
int MacType = Convert.ToInt32(db.tblmachinedetails.Where(m => m.MachineID == WorkCenterID && m.IsDeleted == 0).Select(m => m.MacType).FirstOrDefault());
if (AxisCountString != null)
{
AxisCount = Convert.ToInt32(AxisCountString);
}
VirtualHMI vhmi = new VirtualHMI(IpAddress, MacInvNo); //Initializing the Class;
// int NoOfAxis, out List<string> retValList, out List<AxisDetails> AxisDetailsList
List <string> retValList = new List <string>();
List <AxisDetails> AxisDetailsList = new List <AxisDetails>();
vhmi.VirtualDispRefersh(AxisCount, out retValList, out AxisDetailsList);
foreach (var row in AxisDetailsList)
{
int AxisID = row.AxisID;
string AxisName = db.tbl_axisdet.Where(m => m.MachineID == WorkCenterID && m.AxisID == AxisID).Select(m => m.AxisName).FirstOrDefault();
row.AxisName = AxisName;
}
ViewBag.RetValList = retValList;
ViewBag.AxisDetailsList = AxisDetailsList;
List <string> ModelData = new List <string>();
var ATCCounterVal = db.tblatccounters.Where(m => m.MachineID == WorkCenterID).FirstOrDefault();
if (ATCCounterVal != null)
{
ModelData.Add(ATCCounterVal.Counter.ToString());
}
else
{
ModelData.Add(0.ToString());
}
vhmi.ModalData(ref ModelData);
ViewBag.ModalData = ModelData;
ViewData["PlantID"] = new SelectList(db.tblplants.Where(m => m.IsDeleted == 0), "PlantID", "PlantName", PlantID);
ViewData["ShopID"] = new SelectList(db.tblshops.Where(m => m.IsDeleted == 0 && m.PlantID == PlantID), "ShopID", "ShopName", ShopID);
ViewData["CellID"] = new SelectList(db.tblcells.Where(m => m.IsDeleted == 0 && m.PlantID == PlantID && m.ShopID == ShopID), "CellID", "CellName", CellID);
ViewData["WorkCenterID"] = new SelectList(db.tblmachinedetails.Where(m => m.IsDeleted == 0 && m.PlantID == PlantID && m.ShopID == ShopID && m.CellID == CellID && m.IsNormalWC == 0), "MachineID", "MachineDisplayName", WorkCenterID);
}
else
{
ViewData["PlantID"] = new SelectList(db.tblplants.Where(m => m.IsDeleted == 0), "PlantID", "PlantName", PlantID);
ViewData["ShopID"] = new SelectList(db.tblshops.Where(m => m.IsDeleted == 0 && m.PlantID == PlantID), "ShopID", "ShopName", ShopID);
ViewData["CellID"] = new SelectList(db.tblcells.Where(m => m.IsDeleted == 0 && m.PlantID == PlantID && m.ShopID == ShopID), "CellID", "CellName", CellID);
ViewData["WorkCenterID"] = new SelectList(db.tblmachinedetails.Where(m => m.IsDeleted == 0 && m.PlantID == PlantID && m.ShopID == ShopID && m.CellID == CellID && m.IsNormalWC == 0), "MachineID", "MachineDisplayName", WorkCenterID);
}
return(View());
}