using BLL.DAL; using Common; using Json; using Lib; using Model; using System.Collections; using System.Collections.Generic; using System.Linq; using System.Web.Mvc; using System.Web.Script.Serialization; using wms.Task; namespace wms.Areas.Wcs.Controllers { public class StackerMonitorController : MasterPage { [LoginFilter] public ActionResult Index() { ViewBag.Title = "跺机监控"; return View(); } [LoginFilter] public ActionResult AddEdit() { ViewBag.AccessList = LocalHelper.GetDictionaryCodeHtml("Access"); ViewBag.DepotsRow = LocalHelper.GetDepotsNumHtml2("DepotsRow"); ViewBag.DepotsColumn = LocalHelper.GetDepotsNumHtml2("DepotsColumn"); ViewBag.DepotsLayer = LocalHelper.GetDepotsNumHtml2("DepotsLayer"); return View(); } [LoginFilter] public ActionResult AddEditStacker() { string id = Request.QueryString.Get("Id"); if (id != null) //编辑 { var provider = new DAL_ManualControl(); var data = provider.GetStacker(id); ViewBag.TaskNo = data.TaskNo; ViewBag.PalletNo = data.PalletNo; ViewBag.StartRow = data.StartRow; ViewBag.StartCol = data.StartColumn; ViewBag.StartLayer = data.StartLayer; ViewBag.EndRow = data.EndRow; ViewBag.EndCol = data.EndColumn; ViewBag.EndLayer = data.EndLayer; ViewBag.WcsPos = data.WcsPos; ViewBag.DjType = LocalHelper.GetDjHtml(data.DjType); ViewBag.Option = "Edit"; } else //添加 { ViewBag.TaskNo = ""; ViewBag.PalletNo = ""; ViewBag.StartRow = ""; ViewBag.StartCol = ""; ViewBag.StartLayer = ""; ViewBag.EndRow = ""; ViewBag.EndCol = ""; ViewBag.EndLayer = ""; ViewBag.WcsPos = ""; ViewBag.DjType = LocalHelper.GetDjHtml(); ViewBag.Option = "Add"; } return View(); } public ActionResult StackerDetail() { try { string id = Request.QueryString.Get("Id"); DAL_ManualControl provider = new DAL_ManualControl(); if (id != null) { var data = TaskAction.GetPlcOrWcsPosVal(id); ViewBag.PlcTaskNo = data.PlcTaskNo; ViewBag.PlcPalletNo = data.PlcPalletNo; ViewBag.TaskNo = data.TaskNo; ViewBag.PalletNo = data.PalletNo; ViewBag.StartRow = data.StartRow; ViewBag.StartCol = data.StartColumn; ViewBag.StartLayer = data.StartLayer; ViewBag.EndRow = data.EndRow; ViewBag.EndCol = data.EndColumn; ViewBag.EndLayer = data.EndLayer; ViewBag.PlcPos = data.PlcPos; ViewBag.WcsPos = data.WcsPos; } else { } return View(); } catch (System.Exception) { return View(); } } } public class StackerMonitorAjaxController : AjaxPage { //private static DataTable PlcInfoDt; // 获取所有设备 public ActionResult GetPlcStackerList() { var dd = Request["ajaxdata"]; var models = new JavaScriptSerializer().Deserialize(dd); if (models != null) { DAL_ManualControl provider = new DAL_ManualControl(); PageInfo pageInfo = new PageInfo() { PageIndex = models.pageIndex, PageSize = models.pageSize }; List entity = provider.GetList(models, ref pageInfo).ToList(); string json = JsonHelper.IListToJson(entity, "List"); string pjson = ConvertJson.Serializer(pageInfo); ReturnJson.AddProperty("Result", new JsonObject(json)); ReturnJson.AddProperty("PageInfo", new JsonObject(pjson)); ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "响应成功"); return Content(this.ReturnJson.ToString()); } return Content(null); } public ActionResult AddEditStacker() { var dd = Request["ajaxdata"]; var models = new JavaScriptSerializer().Deserialize(dd); if (TaskAction.fuwu == true) { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "请将联机模式改为手动模式"); } else { if (models != null) { if (models.Operation == "Add") { var provider = new DAL_ManualControl(); var value = provider.AddEditStacker(models, this.LoginUserCode,"Add"); if (value == "") { ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "添加成功"); } else { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "添加失败:" + value); } } else if (models.Operation == "Edit") { var provider = new DAL_ManualControl(); var value = provider.AddEditStacker(models, this.LoginUserCode,"Edit"); if (value == "") { ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "添加成功"); } else { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "添加失败:" + value); } } } else { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "信息有误!"); } } return Content(this.ReturnJson.ToString()); } //获取当前工位交互流程字为多少 //[HttpGet] //public ActionResult GetPlcOrWcsPos(string ip,string stat,string plcpos,string aa) public ActionResult GetPlcOrWcsPos() { //private static PlcInfoDt; var dd = Request["ajaxdata1"]; var models = new JavaScriptSerializer().Deserialize(dd); string PlcPos = ""; PlcPos = TaskAction.GetPlcOrWcsPos(models.Ip, models.Stat, models.Plcpos); return Content(PlcPos); } public ActionResult AddManualControl() { var dd = Request["ajaxdata"]; var models = new JavaScriptSerializer().Deserialize(dd); string Operation = models.Operation; if (models != null) { DAL_ManualControl provider = new DAL_ManualControl(); if (Operation == "Add") { //models.CreatUser = this.LoginUserCode; //string sqlWhere = " (BrandCode = '" + models.BrandCode + "' or BrandName = '" + models.BrandName + "') and isdel = '0' "; //if (provider.IsExist(sqlWhere)) //{ //} //else //{ // ReturnJson.AddProperty("Code", -1); // ReturnJson.AddProperty("Message", "该品牌已存在!"); //} bool value = provider.Add(models, this.LoginUserCode); if (value) { ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "添加成功"); } else { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "添加失败"); } } else if (Operation == "Edit") { //if (provider.IsExist(models)) //{ // if (provider.Update(models, this.LoginUserCode)) // { // ReturnJson.AddProperty("Code", 1); // ReturnJson.AddProperty("Message", "编辑品牌信息成功"); // } // else // { // ReturnJson.AddProperty("Code", -1); // ReturnJson.AddProperty("Message", "编辑品牌信息失败"); // } //} //else //{ // ReturnJson.AddProperty("Code", -1); // ReturnJson.AddProperty("Message", "该品牌已存在!"); //} } } else { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "品牌信息有误!!!"); } return Content(this.ReturnJson.ToString()); } public ActionResult GetDictionaryItems() { try { var dd = Request["ajaxdata"]; var modelItems = new JavaScriptSerializer().Deserialize(dd); if (modelItems != null) { // 实例化分页信息 PageInfo pageInfo = new PageInfo() { PageIndex = modelItems.PageIndex, PageSize = modelItems.PageSize }; // 数据库交互,获取库区集合and分页信息。 DAL_ManualControl provider = new DAL_ManualControl(); List entity = provider.GetDictionaryItems(modelItems, ref pageInfo).ToList(); // Data =》json string json = JsonHelper.IListToJson(entity, "List"); string pjson = ConvertJson.Serializer(pageInfo); // controller => view ReturnJson.AddProperty("Result", new JsonObject(json)); ReturnJson.AddProperty("PageInfo", new JsonObject(pjson)); ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "加载库区集合成功!"); return Content(this.ReturnJson.ToString()); } return Content(null); } catch (System.Exception) { return Content(null); } } public ActionResult GetIsAuto() { try { var jg = LocalHelper.GetIsAuto("WCSAuto"); return Content(jg); } catch (System.Exception) { return Content(null); } } public ActionResult UpdateIsAuto() { string dd = Request["list"]; ArrayList models = new JavaScriptSerializer().Deserialize(dd); string[] list = (string[])models.ToArray(typeof(string)); if (models != null) { DAL_ManualControl provider = new DAL_ManualControl(); bool value = provider.IsAutoUpdate(list); if (value) { ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "成功"); } else { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "失败"); } return Content(this.ReturnJson.ToString()); } return Content(null); } } }