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<AjaxUnitList>(dd);
|
|
if (models != null)
|
{
|
PageInfo pageInfo = new PageInfo() { PageIndex = models.pageIndex, PageSize = models.pageSize };
|
|
|
DALUnit provider = new DALUnit();
|
|
List<Unit> entity = provider.GetList(models, ref pageInfo).ToList();
|
|
string json = JsonHelper.IListToJson<Unit>(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<AjaxUnit>(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<ArrayList>(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<ArrayList>(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<AjaxUnit>(dd);
|
ArrayList Matlist = new JavaScriptSerializer().Deserialize<ArrayList>(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());
|
}
|
}
|
}
|
