using BLL; using BLL.DAL; using Common; using Json; using Lib; using Model; using System; using System.Collections; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using System.Web.Script.Serialization; namespace wms.Areas.Business.Controllers { public class PalletBindAjaxController: AjaxPage { [LoginFilter] public ActionResult GetBindList() { var dd = Request["ajaxdata"]; var models = new JavaScriptSerializer().Deserialize(dd); if (models != null) { PageInfo pageInfo = new PageInfo() { PageIndex = models.pageIndex, PageSize = models.pageSize }; IDALPalletBind provider = new DALPalletBind(); //List entity = provider.GetList().ToList(); List entity = provider.GetList(models).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", "响应成功"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); return Content(this.ReturnJson.ToString()); } return Content(null); } [LoginFilter] public ActionResult Add() { var dd = Request["ajaxdata"]; var models = new JavaScriptSerializer().Deserialize(dd); var PalletNo = models.PalletNo; List list = Session["TEMPDATA_CACHE_PALLETBIND"] as List; if (list != null) { if (models != null) { IDALPalletBind dalPb = new DALPalletBind(); models.CreateUser = this.LoginUserCode; DateTime t = DateTime.Now; models.CreateTime = t; bool value = false; value = dalPb.Update(models, list); if (value) { Session["TEMPDATA_CACHE_PALLETBIND"] = null; ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "托盘物料绑定成功"); } else { ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "托盘物料绑定失败"); } ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); return Content(this.ReturnJson.ToString()); } } else { //编辑,返回组盘明细 Session["TEMPDATA_CACHE_PalletBind"] = null; IDALPalletBind pb = new DALPalletBind(); IList lst = new List(); pb.GetPalletBind(PalletNo, ref lst); Session["TEMPDATA_CACHE_PalletBind"] = lst; string json = JsonHelper.IListToJson(lst, "List"); ReturnJson.AddProperty("Result", new JsonObject(json)); ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "OK"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); return Content(this.ReturnJson.ToString()); } return Content(null); } [LoginFilter] public ActionResult AddBinding() { var dd = Request["ajaxdata"]; var models = new JavaScriptSerializer().Deserialize(dd); if (models != null) { List list = Session["TEMPDATA_CACHE_PALLETBIND"] as List; if (!list.IsEmpty()) { //修改绑定 bool firstAdd = true; for(int i=0; i(list, "List"); ReturnJson.AddProperty("Result", new JsonObject(json)); ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "绑定失败, 该物料绑定总数量超过入库单物料数量"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); return Content(this.ReturnJson.ToString()); } firstAdd = false; list[i].MatCount = models.MatCount; } } if(firstAdd) list.Add(models); Session["TEMPDATA_CACHE_PALLETBIND"] = list; string json1 = JsonHelper.IListToJson(list, "List"); ReturnJson.AddProperty("Result", new JsonObject(json1)); ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "响应成功"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); } else { list = new List(); IDALPalletBind pb = new DALPalletBind(); int ordCount = 0, bindCount = 0, remainCount = 0; pb.GetRemainBindCount(models.OrdNo, models.MatNo, ref ordCount, ref bindCount, ref remainCount); if ((remainCount <= 0) || remainCount < int.Parse(models.MatCount)) { Session["TEMPDATA_CACHE_PALLETBIND"] = list; string json2 = JsonHelper.IListToJson(list, "List"); ReturnJson.AddProperty("Result", new JsonObject(json2)); ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "绑定失败, 该物料绑定总数量超过入库单物料数量"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); return Content(this.ReturnJson.ToString()); } //添加绑定 list = new List(); list.Add(models); Session["TEMPDATA_CACHE_PALLETBIND"] = list; string json = JsonHelper.IListToJson(list, "List"); ReturnJson.AddProperty("Result", new JsonObject(json)); ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "响应成功"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); } return Content(this.ReturnJson.ToString()); } return Content(null); } [LoginFilter] public ActionResult Init() { Session["TEMPDATA_CACHE_PALLETBIND"] = null; List list = new List(); string json = JsonHelper.IListToJson(list, "List"); ReturnJson.AddProperty("Result", new JsonObject(json)); ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "响应成功"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); return Content(this.ReturnJson.ToString()); } [LoginFilter] public ActionResult GetErpin() { ViewBag.LingNo = ""; var dd = Request["ajaxdata"]; var models = new JavaScriptSerializer().Deserialize(dd); if (models != null) { IDALPalletBind idpl = new DALPalletBind(); IList lst = new List(); bool r = idpl.GetErpinByMatNo(models.MatNo, ref lst); int erpinCount = lst.Count; List list = Session["TEMPDATA_CACHE_PALLETBIND"] as List; if(erpinCount == 0) { List lt = new List(); string json = JsonHelper.IListToJson(lt, "List"); ReturnJson.AddProperty("Result", new JsonObject(json)); ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "入库单中未找到要入库的物料,请先创建入库单"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); return Content(this.ReturnJson.ToString()); } else { List lt = new List(); string json = JsonHelper.IListToJson(lt, "List"); ReturnJson.AddProperty("Result", new JsonObject(json)); ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "该物料存在,可进行绑定操作"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", lst[0].LingNo); ReturnJson.AddProperty("OrdNo", lst[0].OrdNo); ReturnJson.AddProperty("LingNo", lst[0].LingNo); ReturnJson.AddProperty("TuNo", lst[0].TuNo); ReturnJson.AddProperty("PageNo", lst[0].PageNo); List matList = new List(); string matListJson = JsonHelper.IListToJson(matList, "MatList"); ReturnJson.AddProperty("MatListResult", new JsonObject(matListJson)); return Content(this.ReturnJson.ToString()); } } return Content(null); } [LoginFilter] public ActionResult DelBinding() { var dd = Request["ajaxdata"]; var models = new JavaScriptSerializer().Deserialize(dd); if(models != null) { List list = Session["TEMPDATA_CACHE_PALLETBIND"] as List; if (!list.IsEmpty()) { for(int i=0; i(list, "List"); ReturnJson.AddProperty("Result", new JsonObject(json)); ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "响应成功"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); } else { Session["TEMPDATA_CACHE_PALLETBIND"] = list; string json = JsonHelper.IListToJson(list, "List"); ReturnJson.AddProperty("Result", new JsonObject(json)); ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "响应失败,列表为空"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); } return Content(this.ReturnJson.ToString()); } return Content(null); } [LoginFilter] public ActionResult Del() { string dd = Request["list"]; string PalletNo = Request["PalletNo"]; string LingNo = Request["LingNo"]; //ArrayList models = new JavaScriptSerializer().Deserialize(dd); //string[] list = (string[])models.ToArray(typeof(string)); string[] list = { PalletNo }; if (list != null) { IDALPalletBind dalPB = new DALPalletBind(); bool value = false; value = dalPB.Del(list); if (value) { ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "删除组盘成功"); } else { ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "删除组盘失败"); } ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); return Content(this.ReturnJson.ToString()); } return Content(null); } [LoginFilter] public ActionResult Detail() { var dd = Request["ajaxdata"]; var models = new JavaScriptSerializer().Deserialize(dd); var PalletNo = models.PalletNo; var LingNo = models.LingNo; var OrdNo = models.OrdNo; if (string.IsNullOrEmpty(PalletNo))//新增 { if (models != null) { List list = Session["TEMPDATA_CACHE_PALLETBIND"] as List; IDALPalletBind dalPb = new DALPalletBind(); models.CreateUser = this.LoginUserCode; bool value = false; //if (editPallet == null)// //{ value = dalPb.Add(models, list); if (value) { Session["TEMPDATA_CACHE_PALLETBIND"] = null; ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "托盘物料绑定成功"); } else { ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "托盘物料绑定失败"); } ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); //} //else //{ // value = dalPb.Update(models,list); // if (value) // { // Session["TEMPDATA_CACHE_PALLETBIND"] = null; // ReturnJson.AddProperty("Code", 1); // ReturnJson.AddProperty("Message", "托盘物料绑定成功"); // } // else // { // ReturnJson.AddProperty("Code", -1); // ReturnJson.AddProperty("Message", "托盘物料绑定失败"); // } // ReturnJson.AddProperty("SubCode", 0); // ReturnJson.AddProperty("SubMessage", ""); //} return Content(this.ReturnJson.ToString()); } } else { //编辑,返回组盘明细 Session["TEMPDATA_CACHE_PalletBind"] = null; IDALPalletBind pb = new DALPalletBind(); IList lst = new List(); pb.GetPalletBind(PalletNo, ref lst); Session["TEMPDATA_CACHE_PalletBind"] = lst; string json = JsonHelper.IListToJson(lst, "List"); ReturnJson.AddProperty("Result", new JsonObject(json)); ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "OK"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); return Content(this.ReturnJson.ToString()); } return Content(null); } public ActionResult ErpIn() { var dd = Request["ajaxdata"]; var models = new JavaScriptSerializer().Deserialize(dd); DAL_Pub pub = new DAL_Pub(); models.CreateUser = this.LoginUserCode; models.CMDStatu = 0; models.CMDType = "in"; pub.GetEmptyPos(ref models.OldAddre); models.IsDel = 0; int ret = -1; ret = pub.GenPalletInOrder(models); if (ret == 0) { //IDALPalletBind pb = new DALPalletBind(); //bool br = pb.UpdateAfterPalletIn(models.Palno, "2"); //if(!br) // br = pb.UpdateAfterPalletIn(models.Palno, "2"); ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "入库指令发送成功"); } else { ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "入库指令发送失败"); } return Content(this.ReturnJson.ToString()); } public ActionResult ErpClose() { var dd = Request["ajaxdata"]; var models = new JavaScriptSerializer().Deserialize(dd); var PalletNo = models.PalletNo; var LingNo = models.LingNo; var OrdNo = models.OrdNo; if (string.IsNullOrEmpty(PalletNo))//新增 { if (models != null) { List list = Session["TEMPDATA_CACHE_PALLETBIND"] as List; IDALPalletBind dalPb = new DALPalletBind(); models.CreateUser = this.LoginUserCode; bool value = false; //if (editPallet == null)// //{ value = dalPb.Add(models, list); if (value) { Session["TEMPDATA_CACHE_PALLETBIND"] = null; ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "托盘物料绑定成功"); } else { ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "托盘物料绑定失败"); } ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); //} //else //{ // value = dalPb.Update(models,list); // if (value) // { // Session["TEMPDATA_CACHE_PALLETBIND"] = null; // ReturnJson.AddProperty("Code", 1); // ReturnJson.AddProperty("Message", "托盘物料绑定成功"); // } // else // { // ReturnJson.AddProperty("Code", -1); // ReturnJson.AddProperty("Message", "托盘物料绑定失败"); // } // ReturnJson.AddProperty("SubCode", 0); // ReturnJson.AddProperty("SubMessage", ""); //} return Content(this.ReturnJson.ToString()); } } else { //编辑,返回组盘明细 Session["TEMPDATA_CACHE_PalletBind"] = null; IDALPalletBind pb = new DALPalletBind(); IList lst = new List(); pb.GetPalletBind(PalletNo, ref lst); Session["TEMPDATA_CACHE_PalletBind"] = lst; string json = JsonHelper.IListToJson(lst, "List"); ReturnJson.AddProperty("Result", new JsonObject(json)); ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "OK"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); return Content(this.ReturnJson.ToString()); } return Content(null); ; } } }