using Estsh.Core.Controllers;
using Estsh.Core.Model.Result;
using Estsh.Core.Models;
using Estsh.Core.Services.IServices;
using Estsh.Core.Util;
using Microsoft.AspNetCore.Mvc;
using System.Collections;
/***************************************************************************************************
*
* 更新人:sitong.dong
* 描述:发运通道维护
* 修改时间:2022.06.22
* 修改日志:系统迭代升级
*
**************************************************************************************************/
namespace Estsh.Core.Web.Controllers
{
public class RollDefineController : BaseController
{
private IRollDefineService service;
public RollDefineController(IRollDefineService _service)
{
service = _service;
}
//
// GET: /Roll/
public ActionResult Index()
{
return View();
}
///
/// 保存数据
///
///
public ActionResult saveRoll()
{
String editType = Request.Form["editType"].ToString();
String rollNo = Request.Form["rollNo"].ToString();
String ruid = Request.Form["ruid"].ToString();
//bool pdroll= this.service.pdrollNo(rollNo);
//String rollName = Request.Form["rollName"].ToString();
//String rollType = Request.Form["rollType"].ToString();
String maxQty = Request.Form["maxQty"].ToString();
String minQty = Request.Form["minQty"].ToString();
String qty = Request.Form["qty"].ToString();
String custPdlineId = Request.Form["cbCustPDLine"].ToString();
String modelId = "";
try
{
modelId = Request.Form["cbModel"].ToString();
}
catch
{
modelId = "0";
}
GRoll gRoll = new GRoll();
gRoll.RollName = "";
gRoll.RollType = 0;
gRoll.MaxQty = Convert.ToInt32(maxQty);
gRoll.MinQty = Convert.ToInt32(minQty);
gRoll.Qty = Convert.ToInt32(qty);
gRoll.ModelId = Convert.ToInt32(modelId);
gRoll.CustPdlineId = Convert.ToInt32(custPdlineId);
gRoll.ModelId = Convert.ToInt32(modelId);
String message = "";
String flag = "";
if (editType != null && editType.Trim().Equals("edit"))
{
try
{
gRoll.UpdateUserId = CurrentEmp.EmpId;
gRoll.Ruid = Convert.ToInt32(ruid);
gRoll.RollNo = rollNo;
this.service.updateRoll(gRoll);
message = "修改成功";
flag = "OK";
}
catch (Exception e)
{
message = "修改失败!";
flag = "Fail";
throw;
}
}
else
{
try
{
if (this.service.IsExistOrd(rollNo))
{
message = "" + rollNo + ":该编号已存在!";
flag = "Fail";
}
else
{
gRoll.CreateUserId = CurrentEmp.EmpId;
gRoll.RollNo = rollNo;
this.service.insertRoll(gRoll);
message = "添加成功!";
flag = "OK";
}
}
catch (Exception e)
{
message = "添加失败!";
flag = "Fail";
}
}
Hashtable result = new Hashtable();
result.Add("message", message);
result.Add("flag", flag);
return Json(result);
}
///
/// 获取列表数据
///
/// 菜单名称
/// 分页
/// 排序方式
/// 排序列
///
public ActionResult getRollListByPage(String cbPDLineID, String rollNo, String rollName, String rollType, Pager pager, String direction, String sort, String enabled = "Y")
{
if ((string.IsNullOrEmpty(cbPDLineID)) || cbPDLineID == "null")
{
cbPDLineID = "0";
}
String factoryId = CurrentEmp.FactoryId.ToString();
Hashtable result = new Hashtable();
result.Add("pager.pageNo", pager.pageNo);
Hashtable dataHt = this.service.getRollListByPage(cbPDLineID, rollNo, rollName, rollType, pager, direction, sort, factoryId, enabled);
result.Add("rows", dataHt["dataList"]);
result.Add("pager.totalRows", dataHt["totalCount"]);
result.Add("sort", sort);
result.Add("direction", direction);
return Json(result);
}
///
/// 查询数据
///
///
public ActionResult GetQuery()
{
string awhere = string.Empty;
awhere = " ";
if (!string.IsNullOrEmpty(Request.Form["rollNo"]))
{
awhere += " where a.rollNo like '%" + Request.Form["rollNo"].ToString() + "%' ";
}
if (!string.IsNullOrEmpty(Request.Form["rollName"]))
{
awhere += " a.rollName like '%" + Request.Form["rollName"].ToString() + "%' ";
}
if (!string.IsNullOrEmpty(Request.Form["rollType"]))
{
awhere += " a.rollType like '%" + Request.Form["rollType"].ToString() + "%' ";
}
if (awhere.Contains(" and "))
{
awhere = awhere.Remove(awhere.LastIndexOf(" and "));
}
Hashtable reault = new Hashtable();
List list = service.GetQuery(awhere);
reault.Add("rows", list);
return Json(reault);
}
///
/// 获取辊道编号
///
///
public ActionResult GetRollNO()
{
Hashtable reault = new Hashtable();
List list = service.GetRollNO();
reault.Add("list", list);
return Json(reault);
}
///
/// 获取辊道名称
///
///
public ActionResult GetRollName()
{
Hashtable reault = new Hashtable();
List list = service.GetRollName();
reault.Add("list", list);
return Json(reault);
}
///
/// 查看菜单详情
///
///
///
public ActionResult getRollDetail(String rollNo)
{
Hashtable ht = this.service.getRollDetail(rollNo);
ViewData.Add("rollNo", ht["rollNo"]);
ViewData.Add("rollName", ht["rollName"]);
ViewData.Add("rollType", ht["rollType"]);
ViewData.Add("maxQty", ht["maxQty"]);
ViewData.Add("minQty", ht["minQty"]);
ViewData.Add("qty", ht["qty"]);
ViewData.Add("modelId", ht["modelId"]);
return View("ViewRoll");
}
///
/// 编辑
///
///
///
public ActionResult editRoll(String ruid)
{
if (!string.IsNullOrEmpty(ruid))
{
Hashtable ht = this.service.getRollDetail(ruid);
ViewData.Add("editType", "edit");
ViewData.Add("rollNo", ht["rollNo"]);
//ViewData.Add("rollName", ht["rollName"]);
//ViewData.Add("rollType", ht["rollType"]);
ViewData.Add("maxQty", ht["maxQty"]);
ViewData.Add("minQty", ht["minQty"]);
ViewData.Add("qty", ht["qty"]);
ViewData.Add("cbCustPDLine", ht["cbCustPDLine"]);
ViewData.Add("cbModel", ht["modelId"]);
ViewData.Add("ruid", ht["ruid"]);
ViewData.Add("cbModelType", ht["cbModelType"]);
}
else
{
ViewData.Add("editType", "new");
}
return View("EditRollDefine");
}
///
/// 删除数据
///
///
///
public ActionResult deleteRoll(String ids)
{
int delCount = 0;
try
{
delCount = this.service.deleteRoll(ids);
}
catch (Exception e)
{
delCount = -1;
}
Hashtable result = new Hashtable();
result.Add("status", delCount);
return Json(result);
}
///
/// 启用
///
///
///
public ActionResult onEnable(String ids)
{
int delCount = 0;
try
{
delCount = this.service.EnableData(ids);
}
catch (Exception e)
{
delCount = -1;
}
Hashtable result = new Hashtable();
result.Add("status", delCount);
return Json(result);
}
///
/// 禁用
///
///
///
public ActionResult onDisable(String ids)
{
int delCount = 0;
try
{
delCount = this.service.DisableData(ids);
}
catch (Exception e)
{
delCount = -1;
}
Hashtable result = new Hashtable();
result.Add("status", delCount);
return Json(result);
}
///
/// 获取客户产线列表
///
///
public ActionResult GetCustPDLine()
{
Hashtable result = new Hashtable();
List list = this.service.GetCustPDLine();
result.Add("list", list);
return Json(result);
}
///
/// 根据客户产线查询车型
///
///
public ActionResult GetMode_type(string CustPDLine)
{
Hashtable result = new Hashtable();
List list = this.service.GetMode_type(CustPDLine);
result.Add("list", list);
return Json(result);
}
///
/// 根据车型编号查询座椅配置
///
///
public ActionResult GetModelList(int ModelType)
{
Hashtable result = new Hashtable();
List list = this.service.GetModelList(ModelType);
result.Add("list", list);
return Json(result);
}
///
/// 获取客户产线编号
///
///
public ActionResult GetCustID()
{
Hashtable reault = new Hashtable();
List list = this.service.GetCustID();
reault.Add("list", list);
return Json(reault);
}
}
}