using BLL.DAL; using Commom.Utility; using Common; using Json; using Lib; using Model; using System.Collections; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web.Mvc; using System.Web.Script.Serialization; namespace wms.Areas.Business.Controllers { public class CheckTaskController : MasterPage { // GET: Business/CheckTask [LoginFilter] public ActionResult Index() { ViewBag.Title = "盘点任务"; ViewBag.StatuList = LocalHelper.GetDictionaryHtml("CDStatu"); return View(); } [LoginFilter] public ActionResult Edit() { Session["Items"] = null; ViewBag.Title = "编辑库存"; string Guid = Request.QueryString.Get("Guid"); DALCheckTask provider = new DALCheckTask(); DataTable dt = provider.GetCheckTask(Guid); Session["Items"] = dt; return View(); } } public class CheckTaskAjaxController : AjaxPage { public ActionResult GetList() { try { var dd = Request["aaa"]; var modelItems = new JavaScriptSerializer().Deserialize(dd); if (modelItems != null) { // 实例化分页信息 PageInfo pageInfo = new PageInfo() { PageIndex = modelItems.PageIndex, PageSize = modelItems.PageSize }; modelItems.DepartGuid = this.LoginDepartNum; // 数据库交互,获取库区集合and分页信息。 DALCheckTask provider = new DALCheckTask(); List entity = provider.GetList(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 GetItems() { try { var dd = Request["bbb"]; var modelItems = new JavaScriptSerializer().Deserialize(dd); if (modelItems != null) { // 数据库交互,获取库区集合and分页信息。 DataTable dt = (DataTable)Session["Items"]; string strWhere = "1=1 "; if (!string.IsNullOrEmpty(modelItems.MatNo)) { strWhere += "and MatNo like '%" + modelItems.MatNo + "%'"; } if (!string.IsNullOrEmpty(modelItems.MatName)) { strWhere += "and MatName like '%" + modelItems.MatName + "%'"; } if (!string.IsNullOrEmpty(modelItems.Palno)) { strWhere += "and Palno like '%" + modelItems.Palno + "%'"; } if (!string.IsNullOrEmpty(modelItems.LingNo)) { strWhere += "and LingNo like '%" + modelItems.LingNo + "%'"; } DataRow[] rows = dt.Select(strWhere); IList entity = ModelConvertHelper.DataRowToModel(rows); // Data =》json string json = JsonHelper.IListToJson(entity, "List"); // controller => view ReturnJson.AddProperty("Result", new JsonObject(json)); ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "加载托盘物料明细成功!"); return Content(this.ReturnJson.ToString()); } return Content(null); } catch (System.Exception) { return Content(null); } } public ActionResult SetItems() { var dd = Request["bbb"]; var models = new JavaScriptSerializer().Deserialize(dd); if (models != null) { DALCheckTask provider = new DALCheckTask(); if (provider.SetItems(this.LoginUserCode, models)) { // 刷新页面信息 DataTable dt = (DataTable)Session["Items"]; DataRow[] dr = dt.Select("Guid = " + models.Guid.AddQuotes()); if (dr != null) { dr[0].SetField("AQuant", models.AQuant); } ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "保存成功"); } else { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "保存失败"); } return Content(this.ReturnJson.ToString()); } return Content(null); } public ActionResult CreateOrder() { var Guid = Request["aaa"]; try { if (!string.IsNullOrEmpty(Guid)) { DALCheckTask provider = new DALCheckTask(); if (provider.CreateOrder(Guid, this.LoginUserCode)) { ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "盘点出库指令已下发"); } else { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "盘点出库指令下发失败"); } } } catch { return Content(null); } return Content(this.ReturnJson.ToString()); } /// /// 盘点任务自动出库 /// /// public ActionResult AutoOrders() { //var Guid = Request["aaa"]; try { //if (!string.IsNullOrEmpty(Guid)) //{ DALCheckTask provider = new DALCheckTask(); if (provider.AutoOrders(this.LoginUserCode)) { ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "盘点出库指令已下发!"); } else { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "等待上条指令完成!"); } //} } catch (System.Exception) { return Content(null); } return Content(this.ReturnJson.ToString()); } } }