using System; using System.Collections.Generic; using System.Linq; using System.Web.Script.Serialization; using Model; using Common; using Json; using BLL; using System.Collections; using System.Data; using System.Text; using wms; using System.Web.Mvc; using Lib; namespace WMS { public class MatAjaxController : AjaxPage { // GET: BasicInfo/MatAjax public ActionResult GetMatList() { var dd = Request["ajaxdata"]; var models = new JavaScriptSerializer().Deserialize(dd); if (models != null) { PageInfo pageInfo = new PageInfo() { PageIndex = models.pageIndex, PageSize = models.pageSize }; DALMatNo provider = new DALMatNo(); 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); } // GET: BasicInfo/MatAjax public ActionResult Auto(string MatNo) { IDALMatNo provider = new DALMatNo(); List value = provider.GetList(MatNo).ToList(); StringBuilder sb = new StringBuilder(); JsonObject jsonObject = null; if (value != null) { foreach (Material svalue in value) { jsonObject = new JsonObject(); jsonObject.AddProperty("MatNo", svalue.MatNo); jsonObject.AddProperty("MatName", svalue.MatName); jsonObject.AddProperty("PackFormat", svalue.PackFormat); jsonObject.AddProperty("UnitFrist", svalue.Unit); //jsonObject.AddProperty("Demo1", svalue.Demo1); sb.Append(jsonObject.ToString() + "\n"); } } if (sb.Length == 0) { sb.Append("\n"); } return Content(sb.ToString()); } public ActionResult AddMat() { var dd = Request["ajaxdata"]; var models = new JavaScriptSerializer().Deserialize(dd); string Operation = models.Operation; if (models != null) { DALMatNo provider = new DALMatNo(); if (Operation == "Add") { models.CreateUser = this.LoginUserCode; //models.MatNo = provider.GetMatNo(); if (provider.IsExist(models)) { 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 { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "该物料已存在!!!"); } } else if (Operation == "Edit") { if (provider.IsExist(models)) { models.UpdateUser = this.LoginUserCode; bool value = provider.Update(models); if (value) { 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 DeleteMat() { string dd = Request["list"]; ArrayList models = new JavaScriptSerializer().Deserialize(dd); string[] list = (string[])models.ToArray(typeof(string)); if (models != null) { DALMatNo provider = new DALMatNo(); string strAlert = "";// provider.IsChecks(list); liudl 删除验证需要后续业务确认后才能增加 if (strAlert.Length <= 0) { bool value = provider.BatchDelete(list,this.LoginUserCode); if (value) { ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "删除物料成功"); } else { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "删除物料失败"); } } else { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "删除失败!" + strAlert); } return Content(this.ReturnJson.ToString()); } return Content(null); } public ActionResult OutExcel() { string dd = Request["list"]; if (dd != null) { ArrayList models = new JavaScriptSerializer().Deserialize(dd); string[] list = (string[])models.ToArray(typeof(string)); IDALMatNo provider = new DALMatNo(); DataTable dt = provider.GetDataTable(list); string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("物料信息{0}.xls", DateTime.Now.ToString("YYYYMMddHHmmss")); NPOIExcel excel = new NPOIExcel("物料信息", "物料", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); ReturnJson.AddProperty("Code", 1000); ReturnJson.AddProperty("Message", Microsoft.JScript.GlobalObject.escape((object)("/UploadFiles/" + filename))); } else { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "没有选择要导出的数据!!"); } return Content(this.ReturnJson.ToString()); } public ActionResult AuditMat() { string dd = Request["ajaxdata"]; if (dd != null) { var models = new JavaScriptSerializer().Deserialize(dd); ArrayList Matlist = new JavaScriptSerializer().Deserialize(models.list); string[] list = (string[])Matlist.ToArray(typeof(string)); IDALMatNo provider = new DALMatNo(); bool value = provider.AuditMat(list, models.Operation,LoginUserCode); //= provider.BatchDelete(list); if (value) { ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "物料审核操作成功"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); } else { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "物料审核操作失败"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); } return Content(this.ReturnJson.ToString()); } else { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "没有选择数据!!"); } return Content(this.ReturnJson.ToString()); } public ActionResult IsCheckMatNo() { string MatNo = Request["aaa"]; DALMatNo provider = new DALMatNo(); if (!provider.IsCheckMatNo(MatNo)) { ReturnJson.AddProperty("Code", -1); ReturnJson.AddProperty("Message", "物料重复禁止录入!"); } else { ReturnJson.AddProperty("Code", 1); ReturnJson.AddProperty("Message", "验证通过可以录入!"); } return Content(this.ReturnJson.ToString()); } } }