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<AjaxMatList>(dd);
|
|
if (models != null)
|
{
|
PageInfo pageInfo = new PageInfo() { PageIndex = models.pageIndex, PageSize = models.pageSize };
|
|
DALMatNo provider = new DALMatNo();
|
List<Material> entity = provider.GetList(models, ref pageInfo).ToList();
|
|
string json = JsonHelper.IListToJson<Material>(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<Material> 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<AjaxMatInfo>(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<ArrayList>(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<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 AuditMat()
|
{
|
string dd = Request["ajaxdata"];
|
if (dd != null)
|
{
|
var models = new JavaScriptSerializer().Deserialize<AjaxMatInfo>(dd);
|
ArrayList Matlist = new JavaScriptSerializer().Deserialize<ArrayList>(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());
|
}
|
}
|
}
|
