using BLL; using Common; using Model; using System; using System.Collections; using System.Collections.Generic; using System.Linq; using System.Web.Mvc; using System.Web.Script.Serialization; using wms; using Json; using Lib; namespace WMS.Areas.BasicInfo.Controllers { public class UnitAjaxController :AjaxPage { // GET: BasicInfo/UnitAjax public ActionResult GetUnitList() { var dd = Request["ajaxdata"]; var models = new JavaScriptSerializer().Deserialize(dd); if (models != null) { PageInfo pageInfo = new PageInfo() { PageIndex = models.pageIndex, PageSize = models.pageSize }; DALUnit provider = new DALUnit(); 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", "响应成功"); ReturnJson.AddProperty("SubCode", 0); ReturnJson.AddProperty("SubMessage", ""); return Content(this.ReturnJson.ToString()); } return Content(null); } public ActionResult AddUnit() { var dd = Request["ajaxdata"]; var models = new JavaScriptSerializer().Deserialize(dd); string Operation = models.Operation; if (models != null) { DALUnit provider = new DALUnit(); if (Operation == "Add") { models.CreatUser = this.LoginUserCode; string sqlWhere = " (UnitNum = '" + models.UnitNum + "' or UnitName = '" + models.UnitName + "') and isdel = '0' "; if (provider.IsExist(sqlWhere)) { 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") { bool value = provider.Update(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", "计量单位信息有误!!!"); } return Content(this.ReturnJson.ToString()); } public ActionResult DeleteUnit() { string dd = Request["list"]; ArrayList models = new JavaScriptSerializer().Deserialize(dd); string[] list = (string[])models.ToArray(typeof(string)); if (models != null) { IDALUnit provider = new DALUnit(); bool value = provider.BatchDelete(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); } 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 AuditUnit() { 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)); IDALUnit provider = new DALUnit(); bool value = provider.AnditUnit(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()); } } }