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;
|
using WebAPI.Models;
|
|
namespace WebAPI.Controllers
|
{
|
public class Sc_AssemblyBillController : ApiController
|
{
|
public Int64 HInterID; //本单ID
|
public string HBillNo; //本单单号
|
public string HBillType = "3727"; //单据类型
|
public WebServer webserver =new WebServer();
|
public DataSet ds =new DataSet();
|
string sBillNo = "";
|
Int64 sInterID = 0;
|
string sICMOBillNo = "";
|
string sCPBarCode = "";
|
Int64 sCPMaterID = 0;
|
string sCPMaterName = "";
|
private json objjson = new json();
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
//扫描成品条码
|
[Route("Assembly/Get_Assembly_CPBarCode_Json")]
|
[HttpGet]
|
public object Get_Assembly_CPBarCode_Json(string sBarCode,string sBillType)
|
{
|
try
|
{
|
DataTable dt_Main = new DataTable("Json");
|
dt_Main.Columns.Add("sICMOBillNo", typeof(string));
|
dt_Main.Columns.Add("sCPBarCode", typeof(string));
|
dt_Main.Columns.Add("sCPMaterID", typeof(Int64));
|
dt_Main.Columns.Add("sCPMaterName", typeof(string));
|
dt_Main.Columns.Add("sInterID", typeof(Int64));
|
dt_Main.Columns.Add("sBillNo", typeof(string));
|
|
|
|
if (webserver.Get_Assembly_CPBarCode(sBarCode, sBillType, ref sICMOBillNo, ref sCPBarCode, ref sCPMaterID, ref sCPMaterName, ref sBillNo, ref sInterID, ref DBUtility.ClsPub.sErrInfo))
|
{
|
//---------创建新行------------------------
|
DataRow dr_main = dt_Main.NewRow();//创建新行
|
dt_Main.Rows.Add(dr_main);//将新行加入到表中
|
dr_main["sICMOBillNo"] = DBUtility.ClsPub.isStrNull(sICMOBillNo);
|
dr_main["sCPBarCode"] = DBUtility.ClsPub.isStrNull(sCPBarCode);
|
dr_main["sCPMaterID"] = DBUtility.ClsPub.isLong(sCPMaterID);
|
dr_main["sCPMaterName"] = DBUtility.ClsPub.isStrNull(sCPMaterName);
|
dr_main["sInterID"] = DBUtility.ClsPub.isLong(sInterID);
|
dr_main["sBillNo"] = DBUtility.ClsPub.isStrNull(sBillNo);
|
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "获取成功";
|
objjson.data = dt_Main;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
catch (Exception e)
|
{
|
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + e.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
|
}
|
//扫描配件条码
|
[Route("Assembly/Get_Assembly_PJBarCode_Json")]
|
[HttpGet]
|
public object Get_Assembly_PJBarCode_Json(string sPJCode, string sCPCode, long sInterID, string sBillNo, string sMaker, long HWorkerID, string HSNNumber)
|
{
|
try
|
{
|
DataTable dt_Main = new DataTable("Json");
|
dt_Main.Columns.Add("sPJCode", typeof(string));
|
dt_Main.Columns.Add("sCPCode", typeof(string));
|
dt_Main.Columns.Add("sInterID", typeof(Int64));
|
dt_Main.Columns.Add("sBillNo", typeof(string));
|
dt_Main.Columns.Add("sMaker", typeof(string));
|
dt_Main.Columns.Add("HWorkerID", typeof(Int64));
|
dt_Main.Columns.Add("HSNNumber", typeof(string));
|
|
if (webserver.Get_Assembly_PJBarCode(sPJCode, sCPCode, sInterID, sBillNo, sMaker, HWorkerID, HSNNumber, ref DBUtility.ClsPub.sErrInfo))
|
{
|
//---------创建新行------------------------
|
DataRow dr_main = dt_Main.NewRow();//创建新行
|
dt_Main.Rows.Add(dr_main);//将新行加入到表中
|
dr_main["sPJCode"] = DBUtility.ClsPub.isStrNull(sPJCode);
|
dr_main["sCPCode"] = DBUtility.ClsPub.isStrNull(sCPCode);
|
dr_main["sInterID"] = DBUtility.ClsPub.isLong(sInterID);
|
dr_main["sBillNo"] = DBUtility.ClsPub.isStrNull(sBillNo);
|
dr_main["sMaker"] = DBUtility.ClsPub.isStrNull(sMaker);
|
dr_main["HWorkerID"] = DBUtility.ClsPub.isLong(HWorkerID);
|
dr_main["HSNNumber"] = DBUtility.ClsPub.isStrNull(HSNNumber);
|
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "获取成功";
|
objjson.data = dt_Main;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
catch (Exception e)
|
{
|
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + e.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
|
}
|
|
[Route("Assembly/DisBillEntryList_Mate_Webs_Json")]
|
[HttpGet]
|
public object DisBillEntryList_Mate_Webs_Json(long HInterID, string sBillType, string sWhere)
|
{
|
try
|
{
|
ds = webserver.GetSc_AssemblyBill(HInterID, sBillType, sWhere);
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "没有返回任何记录！";
|
objjson.data = null;
|
return objjson;
|
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "获取信息成功！";
|
objjson.data = ds.Tables[0];
|
return objjson;
|
}
|
}
|
catch (Exception e)
|
{
|
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "没有返回任何记录！" + e.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
|
|
#region 产线组装追溯单
|
[Route("Sc_AssemblyBill/HBardCodeList")]
|
[HttpGet]
|
public object HBardCodeList(string HBarCode, string user,string HICMOBillNo)
|
{
|
try
|
{
|
//查看权限
|
if (!DBUtility.ClsPub.Security_Log("Sc_AssemblyBill_Edit", 1, false, user))
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "无保存权限！";
|
objjson.data = null;
|
return objjson;
|
}
|
if (HICMOBillNo == "" || HICMOBillNo == null)
|
{
|
ds = oCN.RunProcReturn(@"select b.FMUSTQTY,a.FMOBILLNO,FERPCLSID,t5.FNAME HMaterName_z,t5.FSPECIFICATION HMaterModel_z ,m.HItemID,b.FMATERIALID,m.HName HMaterName,m.HNumber HMaterNumber,m.HModel HMaterModel,m1.HItemID HMaterID
|
from AIS20210811135644..T_PRD_PPBOM a
|
join AIS20210811135644..T_PRD_PPBOMENTRY b on a.FID = b.FID
|
join AIS20210811135644..T_BD_MATERIAL t3 on a.FMATERIALID = t3.FMATERIALID
|
join AIS20210811135644..T_BD_MATERIAL t31 on b.FMATERIALID = t31.FMATERIALID
|
join AIS20210811135644..T_BD_MATERIAL_L t5 on b.FMATERIALID = t5.FMATERIALID and FLOCALEID=2052
|
join AIS20210811135644..t_BD_MaterialBase t4 on t5.FMATERIALID = t4.FMATERIALID
|
join Gy_BarCodeBill bard on a.FMOBILLNO=bard.HSourceBillNo
|
join Gy_Material m on bard.HMaterID=m.HItemID and t3.FNUMBER=m.HNumber
|
join Gy_Material m1 on t31.FNUMBER=m1.HNumber and t31.FUSEORGID=m1.HUSEORGID
|
where bard.HBarCode='" + HBarCode + "' AND t4.FERPCLSID in ('1', '3')", "Gy_BarCodeBill");
|
if (ds.Tables[0].Rows.Count == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "无源单！";
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "1";
|
objjson.count = 1;
|
objjson.Message = "";
|
objjson.data = ds.Tables[0];
|
}
|
}
|
else
|
{
|
ds = oCN.RunProcReturn(@"select a.FMOBILLNO,FERPCLSID ,t4.FMATERIALID, a.FMATERIALID from AIS20210811135644..T_PRD_PPBOM a
|
join AIS20210811135644..T_PRD_PPBOMENTRY b on a.FID=b.FID
|
JOIN AIS20210811135644..T_BD_MATERIAL T6 ON b.FMATERIALID = T6.FMATERIALID
|
join AIS20210811135644..t_BD_MaterialBase t4 on b.FMATERIALID = t4.FMATERIALID
|
left join Gy_Material m on t6.FNUMBER=m.HNumber and m.HUSEORGID=a.FPRDORGID
|
where a.FMOBILLNO ='" + HICMOBillNo + "' and m.HItemID=(select HMaterID from Gy_BarCodeBill where HBarCode = '" + HBarCode + "' )", "ds2");
|
|
if (ds.Tables[0].Rows.Count == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "配件不属于该生产订单！";
|
objjson.data = null;
|
return objjson;
|
}
|
|
ds = oCN.RunProcReturn(@"select HQty,HSourceBillNo,m.HName HMaterName,m.HItemID HMaterID from Gy_BarCodeBill bard
|
join Gy_Material m on bard.HMaterID=m.HItemID
|
where HBarCode='" + HBarCode + "'", "ds3");
|
|
objjson.code = "1";
|
objjson.count = 1;
|
objjson.Message = "";
|
objjson.data = ds.Tables[0];
|
}
|
return objjson;
|
}
|
catch (Exception e)
|
{
|
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "没有返回任何记录！" + e.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
#endregion
|
|
|
|
|
[Route("Assembly/Delete_Json")]
|
[HttpGet]
|
public object Delete_Json(long sInterID,string sBarCode)
|
{
|
string sErrMsg=string.Empty;
|
try
|
{
|
if (webserver.set_DelSc_AssemblyBill(sInterID, sBarCode,ref sErrMsg))
|
{
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "删除成功！";
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "删除失败！";
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
catch (Exception)
|
{
|
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "删除失败！";
|
objjson.data = null;
|
return objjson;
|
}
|
|
}
|
|
}
|
|
|
}
|
