564 lines
26 KiB
C#
564 lines
26 KiB
C#
using AUTS_Server.Models;
|
|
using AUTS_Server.Service;
|
|
using Microsoft.AspNetCore.Http;
|
|
using Microsoft.AspNetCore.Mvc;
|
|
using ProjectIntegration;
|
|
using SqlSugar;
|
|
using System.Security.Cryptography;
|
|
using uts_bomei;
|
|
using uts_manage;
|
|
using XAct.Users;
|
|
|
|
namespace AUTS_Server.Controllers
|
|
{
|
|
[Route("ITblShipping")]
|
|
[ApiController]
|
|
public class ITblShippingController : ControllerBase
|
|
{
|
|
private readonly ISqlSugarClient db;
|
|
private readonly ILogHelperForService log;
|
|
public ITblShippingController(ISqlSugarClient db, ILogHelperForService log)
|
|
{
|
|
this.db = db;
|
|
this.log = log;
|
|
}
|
|
/// <summary>
|
|
/// 添加或更新出货单
|
|
/// </summary>
|
|
/// <param name="shipping"></param>
|
|
[HttpPost]
|
|
[Route("AddOrUpdateShipping")]
|
|
public Returninfo AddOrUpdateShipping([FromBody] JudgeTheDatabase shipping)
|
|
{
|
|
Returninfo rinfo = new Returninfo();
|
|
try
|
|
{
|
|
switch (shipping.JudgeDatabase)
|
|
{
|
|
case "uts_bomei":
|
|
if (shipping.ID == 0)
|
|
{
|
|
//添加
|
|
tbl_shipping tblshipping = shipping;
|
|
tblshipping.CreateDateTime = DateTime.Now;
|
|
int result = db.AsTenant().GetConnection(4).Insertable<tbl_shipping>(tblshipping).ExecuteCommand();
|
|
if (result > 0)
|
|
{
|
|
//添加成功
|
|
rinfo.status = 200;
|
|
rinfo.message = "添加成功";
|
|
rinfo.isok = true;
|
|
}
|
|
else
|
|
{
|
|
//添加失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "添加失败";
|
|
rinfo.isok = false;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
//修改
|
|
tbl_shipping list = db.AsTenant().GetConnection(4).Queryable<tbl_shipping>().Where(it => it.ID == shipping.ID).First();
|
|
if (list != null)
|
|
{
|
|
list.ShippingCode = shipping.ShippingCode;
|
|
list.Destination = shipping.Destination;
|
|
list.Voucher = shipping.Voucher;
|
|
list.Remark = shipping.Remark;
|
|
list.UpdateTime = DateTime.Now;
|
|
list.Status = shipping.Status;
|
|
list.ShippingType = shipping.ShippingType;
|
|
list.ProjectID = shipping.ProjectID;
|
|
list.QTY = shipping.QTY;
|
|
list.MO = shipping.MO;
|
|
list.Customer = shipping.Customer;
|
|
list.BindedColorBoxQTY = shipping.BindedColorBoxQTY;
|
|
list.Loader = shipping.Loader;
|
|
list.EndDateTime = shipping.EndDateTime;
|
|
list.StartDateTime = shipping.StartDateTime;
|
|
list.Creator = shipping.Creator;
|
|
list.ShippingCode = shipping.ShippingCode;
|
|
list.CreateDateTime = shipping.CreateDateTime;
|
|
int result = db.AsTenant().GetConnection(4).Updateable(list).Where(it => it.ID == shipping.ID).ExecuteCommand();
|
|
if (result > 0)
|
|
{
|
|
//修改成功
|
|
rinfo.status = 200;
|
|
rinfo.message = "修改成功";
|
|
rinfo.isok = true;
|
|
}
|
|
else
|
|
{
|
|
//修改失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "修改失败";
|
|
rinfo.isok = false;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
//修改失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "没有找到该记录";
|
|
rinfo.isok = false;
|
|
}
|
|
|
|
}
|
|
break;
|
|
case "uts_dtl":
|
|
if (shipping.ID == 0)
|
|
{
|
|
//添加
|
|
tbl_shipping tblshipping = shipping;
|
|
tblshipping.CreateDateTime = DateTime.Now;
|
|
int result = db.AsTenant().GetConnection(3).Insertable<tbl_shipping>(tblshipping).ExecuteCommand();
|
|
if (result > 0)
|
|
{
|
|
//添加成功
|
|
rinfo.status = 200;
|
|
rinfo.message = "添加成功";
|
|
rinfo.isok = true;
|
|
}
|
|
else
|
|
{
|
|
//添加失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "添加失败";
|
|
rinfo.isok = false;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
//修改
|
|
tbl_shipping list = db.AsTenant().GetConnection(3).Queryable<tbl_shipping>().Where(it => it.ID == shipping.ID).First();
|
|
if (list != null)
|
|
{
|
|
list.ShippingCode = shipping.ShippingCode;
|
|
list.Destination = shipping.Destination;
|
|
list.Voucher = shipping.Voucher;
|
|
list.Remark = shipping.Remark;
|
|
list.UpdateTime = DateTime.Now;
|
|
list.Status = shipping.Status;
|
|
list.ShippingType = shipping.ShippingType;
|
|
list.ProjectID = shipping.ProjectID;
|
|
list.QTY = shipping.QTY;
|
|
list.MO = shipping.MO;
|
|
list.Customer = shipping.Customer;
|
|
list.BindedColorBoxQTY = shipping.BindedColorBoxQTY;
|
|
list.Loader = shipping.Loader;
|
|
list.EndDateTime = shipping.EndDateTime;
|
|
list.StartDateTime = shipping.StartDateTime;
|
|
list.Creator = shipping.Creator;
|
|
list.ShippingCode = shipping.ShippingCode;
|
|
list.CreateDateTime = shipping.CreateDateTime;
|
|
int result = db.AsTenant().GetConnection(3).Updateable(list).Where(it => it.ID == shipping.ID).ExecuteCommand();
|
|
if (result > 0)
|
|
{
|
|
//修改成功
|
|
rinfo.status = 200;
|
|
rinfo.message = "修改成功";
|
|
rinfo.isok = true;
|
|
}
|
|
else
|
|
{
|
|
//修改失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "修改失败";
|
|
rinfo.isok = false;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
//修改失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "没有找到该数据";
|
|
rinfo.isok = false;
|
|
}
|
|
}
|
|
break;
|
|
case "uts_inhaos":
|
|
if (shipping.ID == 0)
|
|
{
|
|
//添加
|
|
tbl_shipping tblshipping = shipping;
|
|
tblshipping.CreateDateTime = DateTime.Now;
|
|
int result = db.AsTenant().GetConnection(2).Insertable<tbl_shipping>(tblshipping).ExecuteCommand();
|
|
if (result > 0)
|
|
{
|
|
//添加成功
|
|
rinfo.status = 200;
|
|
rinfo.message = "添加成功";
|
|
rinfo.isok = true;
|
|
}
|
|
else
|
|
{
|
|
//添加失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "添加失败";
|
|
rinfo.isok = false;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
//修改
|
|
tbl_shipping list = db.AsTenant().GetConnection(2).Queryable<tbl_shipping>().Where(it => it.ID == shipping.ID).First();
|
|
if (list != null)
|
|
{
|
|
list.ShippingCode = shipping.ShippingCode;
|
|
list.Destination = shipping.Destination;
|
|
list.Voucher = shipping.Voucher;
|
|
list.Remark = shipping.Remark;
|
|
list.UpdateTime = DateTime.Now;
|
|
list.Status = shipping.Status;
|
|
list.ShippingType = shipping.ShippingType;
|
|
list.ProjectID = shipping.ProjectID;
|
|
list.QTY = shipping.QTY;
|
|
list.MO = shipping.MO;
|
|
list.Customer = shipping.Customer;
|
|
list.BindedColorBoxQTY = shipping.BindedColorBoxQTY;
|
|
list.Loader = shipping.Loader;
|
|
list.EndDateTime = shipping.EndDateTime;
|
|
list.StartDateTime = shipping.StartDateTime;
|
|
list.Creator = shipping.Creator;
|
|
list.ShippingCode = shipping.ShippingCode;
|
|
list.CreateDateTime = shipping.CreateDateTime;
|
|
int result = db.AsTenant().GetConnection(2).Updateable(list).Where(it => it.ID == shipping.ID).ExecuteCommand();
|
|
if (result > 0)
|
|
{
|
|
//修改成功
|
|
rinfo.status = 200;
|
|
rinfo.message = "修改成功";
|
|
rinfo.isok = true;
|
|
}
|
|
else
|
|
{
|
|
//修改失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "修改失败";
|
|
rinfo.isok = false;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
//修改失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "没有找到该数据";
|
|
rinfo.isok = false;
|
|
}
|
|
}
|
|
break;
|
|
case "uts_zongqing":
|
|
if (shipping.ID == 0)
|
|
{
|
|
//添加
|
|
tbl_shipping tblshipping = shipping;
|
|
tblshipping.CreateDateTime = DateTime.Now;
|
|
int result = db.AsTenant().GetConnection(1).Insertable<tbl_shipping>(tblshipping).ExecuteCommand();
|
|
if (result > 0)
|
|
{
|
|
//添加成功
|
|
rinfo.status = 200;
|
|
rinfo.message = "添加成功";
|
|
rinfo.isok = true;
|
|
}
|
|
else
|
|
{
|
|
//添加失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "添加失败";
|
|
rinfo.isok = false;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
//修改
|
|
tbl_shipping list = db.AsTenant().GetConnection(1).Queryable<tbl_shipping>().Where(it => it.ID == shipping.ID).First();
|
|
if (list != null)
|
|
{
|
|
list.ShippingCode = shipping.ShippingCode;
|
|
list.Destination = shipping.Destination;
|
|
list.Voucher = shipping.Voucher;
|
|
list.Remark = shipping.Remark;
|
|
list.UpdateTime = DateTime.Now;
|
|
list.Status = shipping.Status;
|
|
list.ShippingType = shipping.ShippingType;
|
|
list.ProjectID = shipping.ProjectID;
|
|
list.QTY = shipping.QTY;
|
|
list.MO = shipping.MO;
|
|
list.Customer = shipping.Customer;
|
|
list.BindedColorBoxQTY = shipping.BindedColorBoxQTY;
|
|
list.Loader = shipping.Loader;
|
|
list.EndDateTime = shipping.EndDateTime;
|
|
list.StartDateTime = shipping.StartDateTime;
|
|
list.Creator = shipping.Creator;
|
|
list.ShippingCode = shipping.ShippingCode;
|
|
list.CreateDateTime = shipping.CreateDateTime;
|
|
int result = db.AsTenant().GetConnection(1).Updateable(list).Where(it => it.ID == shipping.ID).ExecuteCommand();
|
|
if (result > 0)
|
|
{
|
|
//修改成功
|
|
rinfo.status = 200;
|
|
rinfo.message = "修改成功";
|
|
rinfo.isok = true;
|
|
}
|
|
else
|
|
{
|
|
//修改失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "修改失败";
|
|
rinfo.isok = false;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
//修改失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "没有找到该数据";
|
|
rinfo.isok = false;
|
|
}
|
|
}
|
|
break;
|
|
default:
|
|
rinfo.status = 400;
|
|
rinfo.message = "没有找到该数据库";
|
|
rinfo.isok = false;
|
|
break;
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
rinfo.status = 400;
|
|
rinfo.message = "系统异常";
|
|
rinfo.isok = false;
|
|
log.WriteLine("添加修改"+shipping.JudgeDatabase + "出货单信息失败，错误信息为：" + ex.Message);
|
|
}
|
|
return rinfo;
|
|
}
|
|
/// <summary>
|
|
/// 删除出货单接口
|
|
/// </summary>
|
|
/// <param name="determine"></param>
|
|
/// <returns></returns>
|
|
[HttpPost]
|
|
[Route("DeleteShipping")]
|
|
public Returninfo DeleteShipping([FromBody] DetermineTheDatabase determine)
|
|
{
|
|
Returninfo rinfo = new Returninfo();
|
|
try
|
|
{
|
|
switch (determine.JudgeDatabase)
|
|
{
|
|
case "uts_bomei":
|
|
tbl_shipping blist = db.AsTenant().GetConnection(4).Queryable<tbl_shipping>().Where(x => x.ID == determine.id).First();
|
|
if (blist != null)
|
|
{
|
|
int countss = db.AsTenant().GetConnection(4).Deleteable(blist).Where(x => x.ID == blist.ID).ExecuteCommand();
|
|
if (countss > 0)
|
|
{
|
|
//修改成功
|
|
rinfo.status = 200;
|
|
rinfo.message = "删除成功";
|
|
rinfo.isok = true;
|
|
}
|
|
else
|
|
{
|
|
//修改失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "删除失败";
|
|
rinfo.isok = false;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
rinfo.status = 400;
|
|
rinfo.message = "没有找到该数据";
|
|
rinfo.isok = false;
|
|
}
|
|
break;
|
|
case "uts_dtl":
|
|
|
|
tbl_shipping dlist = db.AsTenant().GetConnection(3).Queryable<tbl_shipping>().Where(x => x.ID == determine.id).First();
|
|
if (dlist != null)
|
|
{
|
|
int countss = db.AsTenant().GetConnection(3).Deleteable(dlist).Where(x => x.ID == dlist.ID).ExecuteCommand();
|
|
if (countss > 0)
|
|
{
|
|
//修改成功
|
|
rinfo.status = 200;
|
|
rinfo.message = "删除成功";
|
|
rinfo.isok = true;
|
|
}
|
|
else
|
|
{
|
|
//修改失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "删除失败";
|
|
rinfo.isok = false;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
rinfo.status = 400;
|
|
rinfo.message = "没有找到该数据";
|
|
rinfo.isok = false;
|
|
}
|
|
break;
|
|
case "uts_inhaos":
|
|
tbl_shipping ilist = db.AsTenant().GetConnection(2).Queryable<tbl_shipping>().Where(x => x.ID == determine.id).First();
|
|
if (ilist != null)
|
|
{
|
|
int countss = db.AsTenant().GetConnection(2).Deleteable(ilist).Where(x => x.ID == ilist.ID).ExecuteCommand();
|
|
if (countss > 0)
|
|
{
|
|
//修改成功
|
|
rinfo.status = 200;
|
|
rinfo.message = "删除成功";
|
|
rinfo.isok = true;
|
|
}
|
|
else
|
|
{
|
|
//修改失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "删除失败";
|
|
rinfo.isok = false;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
rinfo.status = 400;
|
|
rinfo.message = "没有找到该数据";
|
|
rinfo.isok = false;
|
|
}
|
|
break;
|
|
case "uts_zongqing":
|
|
tbl_shipping zlist = db.AsTenant().GetConnection(1).Queryable<tbl_shipping>().Where(x => x.ID == determine.id).First();
|
|
if (zlist != null)
|
|
{
|
|
int countss = db.AsTenant().GetConnection(1).Deleteable(zlist).Where(x => x.ID == zlist.ID).ExecuteCommand();
|
|
if (countss > 0)
|
|
{
|
|
//修改成功
|
|
rinfo.status = 200;
|
|
rinfo.message = "删除成功";
|
|
rinfo.isok = true;
|
|
}
|
|
else
|
|
{
|
|
//修改失败
|
|
rinfo.status = 400;
|
|
rinfo.message = "删除失败";
|
|
rinfo.isok = false;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
rinfo.status = 400;
|
|
rinfo.message = "没有找到该数据";
|
|
rinfo.isok = false;
|
|
}
|
|
break;
|
|
default:
|
|
rinfo.status = 400;
|
|
rinfo.message = "没有找到该数据库";
|
|
rinfo.isok = false;
|
|
break;
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
|
|
rinfo.status = 500;
|
|
rinfo.message = "系统异常";
|
|
rinfo.isok = false;
|
|
log.WriteLine("删除"+ determine.JudgeDatabase + "出货单信息失败，错误信息为：" + ex.Message);
|
|
}
|
|
|
|
return rinfo;
|
|
}
|
|
|
|
[HttpGet("SelectShippingAllinfo")]
|
|
|
|
public SelectShippingInfo SelectShippingAllinfo([FromBody] SelectShippingAllinfo selectShipping)
|
|
{
|
|
SelectShippingInfo info = new SelectShippingInfo();
|
|
int totalCount = 0;
|
|
try
|
|
{
|
|
switch (selectShipping.JudgeDatabase)
|
|
{
|
|
case "uts_bomei":
|
|
List<tbl_shipping> blist = db.AsTenant().GetConnection(4).Queryable<tbl_shipping>().ToPageList(selectShipping.page, 10, ref totalCount);
|
|
info.list = blist;
|
|
info.pagecount = (totalCount % 12) == 0 ? (totalCount / 12) : (totalCount / 12) + 1;
|
|
info.shippingcount = totalCount;
|
|
break;
|
|
case "uts_dtl":
|
|
List<tbl_shipping> zlist = db.AsTenant().GetConnection(3).Queryable<tbl_shipping>().ToPageList(selectShipping.page, 10, ref totalCount);
|
|
info.list = zlist;
|
|
info.pagecount = (totalCount % 12) == 0 ? (totalCount / 12) : (totalCount / 12) + 1;
|
|
info.shippingcount = totalCount;
|
|
break;
|
|
case "uts_inhaos":
|
|
List<tbl_shipping> ilist = db.AsTenant().GetConnection(2).Queryable<tbl_shipping>().ToPageList(selectShipping.page, 10, ref totalCount);
|
|
info.list = ilist;
|
|
info.pagecount = (totalCount % 12) == 0 ? (totalCount / 12) : (totalCount / 12) + 1;
|
|
info.shippingcount = totalCount;
|
|
break;
|
|
case "uts_zongqing":
|
|
List<tbl_shipping> zqlist = db.AsTenant().GetConnection(1).Queryable<tbl_shipping>().ToPageList(selectShipping.page, 10, ref totalCount);
|
|
info.list = zqlist;
|
|
info.pagecount = (totalCount % 12) == 0 ? (totalCount / 12) : (totalCount / 12) + 1;
|
|
info.shippingcount = totalCount;
|
|
break;
|
|
default:
|
|
info.list = null;
|
|
info.pagecount = 0;
|
|
info.shippingcount = 0;
|
|
break;
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
info.list = null;
|
|
info.pagecount = 0;
|
|
info.shippingcount = 0;
|
|
log.WriteLine("查询"+ selectShipping.JudgeDatabase + "出货单信息失败，错误信息为："+ex.Message);
|
|
throw;
|
|
}
|
|
|
|
return info;
|
|
}
|
|
}
|
|
public class JudgeTheDatabase : tbl_shipping
|
|
{
|
|
//数据库索引
|
|
public string JudgeDatabase { get; set; }
|
|
}
|
|
public class DetermineTheDatabase
|
|
{
|
|
public int id { get; set; }
|
|
//数据库索引
|
|
public string JudgeDatabase { get; set; }
|
|
}
|
|
|
|
public class SelectShippingAllinfo
|
|
{
|
|
public int page { get; set; }
|
|
//数据库索引
|
|
public string JudgeDatabase { get; set; }
|
|
}
|
|
public class SelectShippingInfo
|
|
{
|
|
//原始数据
|
|
public List<tbl_shipping> list { get; set; }
|
|
//数据总数
|
|
public int shippingcount { set; get; }
|
|
//分页数
|
|
public int pagecount { set; get; }
|
|
}
|
|
|
|
|
|
}
|