using DBUtility;
|
using Newtonsoft.Json.Linq;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Net;
|
using System.Net.Http;
|
using System.Web.Http;
|
using WebAPI.Models;
|
|
namespace WebAPI.Controllers
|
{
|
public class Sc_PckSplitBillController : ApiController
|
{
|
private JsonResult objJsonResult = new JsonResult();
|
public DataSet ds = new DataSet();
|
public double sRelQty = 0;
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
public WebServer webserver = new WebServer();
|
/// <summary>
|
/// 拆箱单扫描托条码/直接调用webservice
|
/// </summary>
|
/// <returns></returns>
|
[Route("PackSplitBill/SetPackBarCode_Webs")]
|
[HttpGet]
|
public Object SetPackBarCode_Webs(Int64 sInterID, string sBillNo, string sBillType, string HTBarCode, string sMaker,Int64 HOWNERID)
|
{
|
try
|
{
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS();
|
//string sExpressNumber = "";
|
WebSoBar = oWebs.get_CheckTypeByPackBarCode_Pack(sInterID, sBillNo, sBillType,HTBarCode,sMaker,HOWNERID,ref DBUtility.ClsPub.sErrInfo);
|
if (WebSoBar == null)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
|
objJsonResult.data = WebSoBar;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = e.Message + ";" + e.StackTrace;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
}
|
|
/// <summary>
|
/// 装箱单扫描托条码/直接调用webservice
|
/// </summary>
|
/// <returns></returns>
|
[Route("PackUnionBill/SetPackBarCode_Webs1")]
|
[HttpGet]
|
public Object SetPackBarCode_Webs1(Int64 sInterID, string sBillNo, string sBillType, string HTBarCode, string sMaker, Int64 HOWNERID)
|
{
|
try
|
{
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS();
|
//string sExpressNumber = "";
|
WebSoBar = oWebs.get_CheckTypeByPackBarCode_Pack(sInterID, sBillNo, sBillType, HTBarCode, sMaker, HOWNERID, ref DBUtility.ClsPub.sErrInfo);
|
if (WebSoBar == null)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
|
objJsonResult.data = WebSoBar;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = e.Message + ";" + e.StackTrace;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
}
|
|
[Route("PackSplitBill/GetBillEntry_TmpList_Pack")]
|
[HttpGet]
|
public object GetBillEntry_TmpList_Pack(Int64 HBillID, string HBillNo, string HBillType)
|
{
|
try
|
{
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
ds = oWebs.GetBillEntry_TmpList_Pack(HBillID, HBillNo, HBillType, ref DBUtility.ClsPub.sErrInfo);
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "获取信息成功！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
[Route("PackUnionBill/GetBillEntry_TmpList_Pack1")]
|
[HttpGet]
|
public object GetBillEntry_TmpList_Pack1(Int64 HBillID, string HBillNo, string HBillType)
|
{
|
try
|
{
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
ds = oWebs.GetBillEntry_TmpList_Pack(HBillID, HBillNo, HBillType, ref DBUtility.ClsPub.sErrInfo);
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "获取信息成功！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
|
/// <summary>
|
/// 拆箱单扫描拆箱条码/直接调用webservice
|
/// </summary>
|
/// <returns></returns>
|
[Route("PackSplit/get_CheckTypeByBarCode_Json")]
|
[HttpGet]
|
public Object get_CheckTypeByBarCode_Json(string HBarCode,Int64 sInterID, string HBillType, string sBillNo, string HTBarCode, string sMaker, Int64 HOWNERID)
|
{
|
try
|
{
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
if (oWebs.get_CheckTypeByBarCode_PackSplit(HBarCode, sInterID, HBillType, sBillNo, HTBarCode, sMaker, HOWNERID, ref DBUtility.ClsPub.sErrInfo))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "扫码成功！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = e.Message + ";" + e.StackTrace;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
}
|
|
|
/// <summary>
|
/// 拆箱单扫描拆箱条码/直接调用webservice
|
/// </summary>
|
/// <returns></returns>
|
[Route("PackUnionBill/get_CheckTypeByBarCode_Json1")]
|
[HttpGet]
|
public Object get_CheckTypeByBarCode_Json1(string HBarCode, Int64 sInterID, string HBillType, string sBillNo, string HTBarCode, string sMaker, Int64 HOWNERID)
|
{
|
try
|
{
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
if (oWebs.get_CheckTypeByBarCode_PackUnion(HBarCode, sInterID, HBillType, sBillNo, HTBarCode, sMaker, HOWNERID, ref DBUtility.ClsPub.sErrInfo))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "扫码成功！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = e.Message + ";" + e.StackTrace;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
}
|
|
|
[Route("PackSplit/Delete")]
|
[HttpGet]
|
public object Delete(long HInterID, string HBarCode,string HBillType)
|
{
|
string sErrMsg = string.Empty;
|
try
|
{
|
if (DeletePackSplitBill(HInterID, HBarCode, HBillType, ref sErrMsg))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "删除成功！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
}
|
|
|
public bool DeletePackSplitBill(long HInterID, string HBarCode, string HBillType, ref string sErrMsg)
|
{
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
|
if (oWebs.set_DelPonderationBillMain_Temp_Pack(HInterID, HBarCode, HBillType, ref DBUtility.ClsPub.sErrInfo))
|
{
|
sErrMsg = "删除成功！";
|
return true;
|
}
|
else
|
{
|
sErrMsg = "删除失败！";
|
return false;
|
}
|
}
|
|
/// <summary>
|
/// 生成拆箱单
|
/// </summary>
|
/// <returns></returns>
|
[Route("PackSplit/set_SavePackSplitBill_Json")]
|
[HttpGet]
|
public Object set_SavePackSplitBill_Json(long sInterID, string HBillType, string sBillNo,string HTBarCode,string sMaker,long HOWNERID)
|
{
|
try
|
{
|
|
if (set_SavePackSplitBill_New(sInterID, HBillType, sBillNo, HTBarCode, sMaker, HOWNERID, ref DBUtility.ClsPub.sErrInfo))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "生成成功！单据号为：";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "上传失败！" + DBUtility.ClsPub.sErrInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "上传失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
public bool set_SavePackSplitBill_New(long sInterID, string HBillType, string sBillNo, string HTBarCode, string sMaker, long HOWNERID, ref string sErrMsg)
|
{
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
if (oWebs.set_SavePackSplitBill_New(sInterID, HBillType, sBillNo, HTBarCode, sMaker, HOWNERID, ref sErrMsg))
|
{
|
sErrMsg = "保存成功！" + sBillNo;
|
return true;
|
}
|
else
|
{
|
sErrMsg = "单据号：" + sBillNo + ", 单据ID：" + sInterID + ";" + sErrMsg;
|
return false;
|
}
|
}
|
|
#region 生产领料拆码列表
|
|
[Route("Sc_PckSplit/Get_PPickingBillList")]
|
[HttpGet]
|
public Object Get_PPickingBillList(string sWhere)
|
{
|
try
|
{
|
string sql1 = string.Format(@"select * from h_v_Kf_ICStockBillList where HBillType='1204' " + sWhere);
|
DataSet ds=oCn.RunProcReturn(sql1, "h_v_Kf_ICStockBillList");
|
if (ds.Tables[0].Rows.Count == 0 || ds == null)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "查询失败！" + DBUtility.ClsPub.sErrInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "暂无数据";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "上传失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
|
#region 产线关键件绑定SN号查询
|
[Route("Sc_PckSplit/Get_PHPCruxBillList")]
|
[HttpGet]
|
public Object Get_PHPCruxBillList(string HBarCode)
|
{
|
try
|
{
|
string sql1 = string.Format(@"select a.HMaterID,m.HName HMaterName,m.HModel HMaterSpec,a.HQtyMust,0 HQty,'"+ HBarCode + "' as HCPM from Sc_PPBomBillSub a left join Gy_Material m on a.HMaterID=m.HItemID where HICMOEntryID=(select HSourceEntryID from Gy_BarCodeBill where HBarCode='"+HBarCode+"')");
|
DataSet ds = oCn.RunProcReturn(sql1, "Sc_PPBomBillSub");
|
if (ds.Tables[0].Rows.Count == 0 || ds == null)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "查询失败！" + DBUtility.ClsPub.sErrInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
//先存进临时表再返回数据
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "暂无数据";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "上传失败！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
}
|
}
|
