using DBUtility;
|
using Model;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
using SQLHelper;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.IO;
|
using System.Linq;
|
using System.Net;
|
using System.Net.Http;
|
using System.Web;
|
using System.Web.Http;
|
using WebAPI;
|
using WebAPI.Code;
|
using WebAPI.Models;
|
using WebAPI.Utility;
|
|
namespace WebAPI.Controllers
|
{
|
/**
|
* 外购入库Controller
|
*/
|
public class POStockInBillController : ApiController
|
{
|
public Int64 HSupID;//供应商ID
|
public Int64 HDeptID;//部门ID
|
public Int64 HWhID;//仓库ID
|
public Int64 HSPID;//仓位ID
|
|
public string HSupName = string.Empty;
|
public string HDeptName = string.Empty;
|
public string HWhName = string.Empty;
|
public string HSPName = string.Empty;
|
|
public Int64 HInterID;//本单ID
|
public string HBillNo;
|
public string HSourceBillNo = string.Empty;
|
public string HBillType = "1201";//单据类型
|
public string sBillCode = "ICStockBill";
|
public string sTranType = "1";
|
public bool sRedBlueFlag = false;
|
public bool SourceFlag = false;
|
//public string sSourceType = "1103";
|
public string sSourceTypeName = "采购订单";
|
public string sRedBlue2 = "蓝字";
|
//public bool sRedBlue = false;
|
public WebServer webserver = new WebServer();
|
public DataSet ds = new DataSet();
|
public ClsGy_BarCodeBill_WMS_Model_View oView = new ClsGy_BarCodeBill_WMS_Model_View();
|
public ClsKF_PonderationBillMain_Temp model = new ClsKF_PonderationBillMain_Temp();
|
public ClsKf_ICStockBill_WMS oBar = new Model.ClsKf_ICStockBill_WMS();
|
Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
|
public double sRelQty = 0;
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
// private DataBaseServices objDataBaseServices = new DataBaseServices();
|
|
private JsonResult objJsonResult = new JsonResult();
|
// private string msgModel = "{{\"count\":{0},\"code\":{0},\"message\":\"{1}\",\"result\":{2}}}";
|
|
public static string GetSession(string sMsg)
|
{
|
try
|
{
|
string s = Common.GetSession();
|
return s;
|
}
|
catch (Exception e)
|
{
|
return "";
|
}
|
}
|
|
/// <summary>
|
/// 外购入库/扫条码/直接调用webservice
|
/// </summary>
|
/// <returns></returns>
|
[Route("POStockInBill/get_CheckTypeByBarCode_Json")]
|
[HttpGet]
|
public Object get_CheckTypeByBarCode_Json(string sCode, Int64 sInterID, string sBillNo, string sBillType, string sMaker, Int64 WhID, Int64 SPID, Double sQty, bool sRedBlue, bool SourceFlag, string sSourceBillNo, string sSourceType, Int64 HOWNERID)
|
{
|
try
|
{
|
var sJXCode = POStockInBillController.JX_Json(sCode, sInterID, HBillType, HOWNERID, HBillNo, sMaker);
|
//if (sRedBlue == true)
|
//{
|
// HBillType = "1239";
|
//}
|
//oBar = webserver.get_CheckTypeByBarCode(sCode, sInterID, sBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, ref DBUtility.ClsPub.sErrInfo);
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS();
|
string sExpressNumber = "";
|
WebSoBar = oWebs.get_CheckTypeByBarCode_All(sJXCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, ref DBUtility.ClsPub.sErrInfo);
|
//WebSoBar = oWebs.get_ba(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, 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("ICMOReportBill/get_CheckTypeByBarCode_Json1")]
|
[HttpGet]
|
public Object get_CheckTypeByBarCode_Json1(string sCode, Int64 sInterID, string sBillType, string sBillNo, string sMaker, Int64 WhID, Int64 SPID, Double sQty, bool sRedBlue, bool SourceFlag, string sSourceBillNo, string sSourceType, Int64 HOWNERID)
|
{
|
try
|
{
|
//if (sRedBlue == true)
|
//{
|
// HBillType = "1239";
|
//}
|
//oBar = webserver.get_CheckTypeByBarCode(sCode, sInterID, sBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, ref DBUtility.ClsPub.sErrInfo);
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS();
|
string sExpressNumber = "";
|
WebSoBar = oWebs.get_CheckTypeByBarCode_All(sCode, sInterID, sBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, 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("kf_PoStockInBill/JX_Json")]
|
[HttpGet]
|
public static string JX_Json(string sBarCodeNew, Int64 hinterid, string HBillType,Int64 HOrgID,string HBillNo,string HMaker)
|
{
|
try
|
{
|
//1.判断系统参数是否安瑞 不是安瑞 直接跳掉
|
//如果是安瑞 走下面
|
|
//解析条码
|
//如果在条码档案里面 不处理 没有的话 存入条码档案
|
|
//根据解析的物料 + 批次 判断 条码临时表 记录是否存在 没有的话 进行扫源单的动作
|
|
|
//加了 生产日期 有效期至 保质期标志
|
|
Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
|
//if (oSystemParameter.omodel.WMS_CampanyName == "安瑞")
|
//{
|
string HTM = "";
|
//采购入库
|
if (HBillType == "1201")
|
{
|
string[] sArray = sBarCodeNew.Split('@');
|
string HMaterNumber = "";
|
HMaterNumber = sArray[0];
|
Int64 HQty = 0;
|
HQty = ClsPub.isInt(sArray[4]);
|
string HBarchNo = "";
|
HBarchNo = sArray[6];
|
|
DateTime HSCRQ = ClsPub.isDate(sArray[3]);
|
DateTime HYXQZ = ClsPub.isDate(sArray[5]);
|
|
//采购订单号
|
string HPOOrderBillNo = "";
|
HPOOrderBillNo = ClsPub.isStrNull(sArray[8]);
|
|
|
|
Int64 HMaterID = 0;
|
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet Dss;
|
Dss = oCn.RunProcReturn(" select HNumber from h_v_CLD_ORGANIZATIONSList where HItemID= " + HOrgID, "h_v_CLD_ORGANIZATIONSList");
|
string HOrgNumber = Pub_Class.ClsPub.isStrNull(Dss.Tables[0].Rows[0]["HNumber"]);
|
|
DataSet Dss1;
|
Dss1 = oCn.RunProcReturn(" select HItemID,HName,HModel,HUnitID from Gy_Material where HNumber= '" + HMaterNumber + "' and huseorgid = " + HOrgID, "Gy_Material");
|
HMaterID = Pub_Class.ClsPub.isLong(Dss1.Tables[0].Rows[0]["HItemID"]);
|
string HMaterName = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HName"]);
|
string HMaterModel = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HModel"]);
|
Int64 HUnitID = Pub_Class.ClsPub.isInt(Dss1.Tables[0].Rows[0]["HUnitID"]);
|
|
|
HTM = HOrgNumber + HMaterID + HBarchNo;
|
|
//如果条码档案不存在 进行存入条码档案的动作
|
//根据物料 + 批次 + 采购订单号 找到对应的收料通知单号
|
DataSet Dss2;
|
Dss2 = oCn.RunProcReturn(" select fid,FMATERIALID,FENTRYID,FBILLNO from h_v_RECEIVEQuery where FSRCBILLNO= '" + HPOOrderBillNo + "' and FMATERIALID = " + HMaterID, "h_v_RECEIVEQuery");
|
HMaterID = Pub_Class.ClsPub.isLong(Dss2.Tables[0].Rows[0]["FMATERIALID"]);
|
Int64 HSourceInterID = Pub_Class.ClsPub.isLong(Dss2.Tables[0].Rows[0]["fid"]);
|
Int64 HSourceEntryID = Pub_Class.ClsPub.isLong(Dss2.Tables[0].Rows[0]["FENTRYID"]);
|
string HSourceBillNo = Pub_Class.ClsPub.isStrNull(Dss2.Tables[0].Rows[0]["FBILLNO"]);
|
//判断条码档案是否存在该条码
|
//如果存在 再判断扫码临时表是否存在该条码
|
//如果不存在 进行扫源单的方法
|
DataSet Dss5;
|
Dss5 = oCn.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + HTM + "'", "Gy_BarCodeBill");
|
if (Dss5.Tables[0].Rows.Count > 0)
|
{
|
DataSet Dss6;
|
Dss6 = oCn.RunProcReturn(" select * from KF_PonderationBillMain_Temp where HBarCode= '" + HTM + "' and HInterID = " + hinterid.ToString() + " and HBillType = '" + HBillType + "' and hsourcebillno = '" + HSourceBillNo + "' ", "KF_PonderationBillMain_Temp");
|
if (Dss6.Tables[0].Rows.Count > 0)
|
{
|
|
}
|
else
|
{
|
POStockInBillController POStockInBill = new POStockInBillController();
|
POStockInBill.set_SavePonderationBillMain_Temp_Source_Fast_Json("1103", HSourceBillNo, hinterid, HBillNo);
|
|
}
|
}
|
else
|
{
|
|
|
|
string ModName = "85";
|
var HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
|
Int64 HSupID = 0;
|
oCn.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +
|
",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
|
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
|
",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " +
|
",HCusID,HCusType,HEndDate,HProduceDate,HExpiryDate,HWorkLineName,HBarCodeDate " +
|
",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " +
|
",HGiveAwayFlag,HSeOrderSEQ,HInitSourceEntryID " +
|
",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HExpirationDateFlag " +
|
") values ("
|
+ "'" + HTM + "','批次条码'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty.ToString()
|
+ ",'" + HBarchNo + "'," + HSupID.ToString() + ",0,'" + ClsPub.CurUserName + "',getdate(),0," + HQty.ToString()
|
+ ", " + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo.ToString() + "','1103',0"
|
+ ", 0,'',0,0,0,''"
|
+ ",0,'','','" + HSCRQ.ToShortDateString() + "','" + HYXQZ.ToShortDateString() + "','',getdate()"
|
+ ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",''," + HInterID.ToString() + ",1"
|
+ ",0,0,0"
|
+ ",'" + HMaterName + "','" + HMaterModel + "','',0,'','',1)");
|
DataSet Dss7;
|
Dss7 = oCn.RunProcReturn(" select * from KF_PonderationBillMain_Temp where HBarCode= '" + HTM + "' and HInterID = " + hinterid.ToString() + " and HBillType = '" + HBillType + "' and hsourcebillno = '" + HSourceBillNo + "' ", "KF_PonderationBillMain_Temp");
|
if (Dss7.Tables[0].Rows.Count > 0)
|
{
|
|
}
|
else
|
{
|
POStockInBillController POStockInBill = new POStockInBillController();
|
POStockInBill.set_SavePonderationBillMain_Temp_Source_Fast_Json("1103", HSourceBillNo, hinterid, HBillNo);
|
|
}
|
|
}
|
}
|
//产品入库
|
if(HBillType == "1202")
|
{
|
string HMaterNumber = "";
|
HMaterNumber = sBarCodeNew.Substring(0, 10);
|
string HSCRQ = "";
|
HSCRQ = "20" + sBarCodeNew.Substring(10, 6);
|
Int64 Year = ClsPub.isInt(HSCRQ.Substring(0, 4));
|
Int64 Month = ClsPub.isInt(HSCRQ.Substring(4, 2));
|
Int64 Day = ClsPub.isInt(HSCRQ.Substring(6, 2));
|
|
string HBatchNo = "";
|
HBatchNo = sBarCodeNew.Substring(16, 11);
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
DataSet ds;
|
Int64 HMaterID = 0;
|
DataSet Dss1;
|
Dss1 = oCN.RunProcReturn(" select HItemID,HName,HModel,HUnitID from Gy_Material where HNumber= '" + HMaterNumber + "' and huseorgid = " + HOrgID, "Gy_Material");
|
HMaterID = Pub_Class.ClsPub.isLong(Dss1.Tables[0].Rows[0]["HItemID"]);
|
string HMaterName = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HName"]);
|
string HMaterModel = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HModel"]);
|
Int64 HUnitID = Pub_Class.ClsPub.isInt(Dss1.Tables[0].Rows[0]["HUnitID"]);
|
ds = oCN.RunProcReturn("select * from h_v_SCStockInCheckBill_Json where HYear =" + Year + " and HMonth = " + Month + " and HDay = " + Day + " and HMaterID = " + HMaterID.ToString() + "and 批次 = '" + HBatchNo.ToString() + "'", "h_v_SCStockInCheckBill_Json");
|
Int64 HSourceInterID = Pub_Class.ClsPub.isLong(ds.Tables[0].Rows[0]["HSourceInterID"]);
|
Int64 HSourceEntryID = Pub_Class.ClsPub.isLong(ds.Tables[0].Rows[0]["HSourceEntryID"]);
|
string HSourceBillNo = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBillNo"]);
|
DataSet Dss;
|
Dss = oCN.RunProcReturn(" select HNumber from h_v_CLD_ORGANIZATIONSList where HItemID= " + HOrgID, "h_v_CLD_ORGANIZATIONSList");
|
string HOrgNumber = Pub_Class.ClsPub.isStrNull(Dss.Tables[0].Rows[0]["HNumber"]);
|
HTM = HOrgNumber + HMaterID + HBatchNo;
|
|
|
DateTime HSCRQ1 = ClsPub.isDate(Year + "-" + Month + "-" + Day);
|
|
|
string HYXQZ = "20" + sBarCodeNew.Substring(27, 6);
|
Int64 Year1 = ClsPub.isInt(HYXQZ.Substring(0, 4));
|
Int64 Month1 = ClsPub.isInt(HYXQZ.Substring(4, 2));
|
Int64 Day1 = ClsPub.isInt(HYXQZ.Substring(6, 2));
|
DateTime HYXQZ1 = ClsPub.isDate(Year1 + "-" + Month1 + "-" + Day1);
|
|
Int64 HQty = 0;
|
HQty = ClsPub.isInt(sBarCodeNew.Substring(33,3));
|
|
DataSet Dss5;
|
Dss5 = oCN.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + HTM + "'", "Gy_BarCodeBill");
|
if (Dss5.Tables[0].Rows.Count > 0)
|
{
|
DataSet Dss6;
|
Dss6 = oCN.RunProcReturn(" select * from KF_PonderationBillMain_Temp where HBarCode= '" + HTM + "' and HInterID = " + hinterid.ToString() + " and HBillType = '" + HBillType + "' and hsourcebillno = '" + HSourceBillNo + "' ", "KF_PonderationBillMain_Temp");
|
if (Dss6.Tables[0].Rows.Count > 0)
|
{
|
|
}
|
else
|
{
|
|
WEBSController WEBS = new WEBSController();
|
WEBS.get_SourceBarCode_ProductIn_Json(hinterid, HBillNo, HBillType, HSourceBillNo, "3714", HMaker,HOrgID);
|
|
}
|
}
|
else
|
{
|
|
|
|
string ModName = "85";
|
var HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
|
Int64 HSupID = 0;
|
oCN.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +
|
",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
|
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
|
",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " +
|
",HCusID,HCusType,HEndDate,HProduceDate,HExpiryDate,HWorkLineName,HBarCodeDate " +
|
",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " +
|
",HGiveAwayFlag,HSeOrderSEQ,HInitSourceEntryID " +
|
",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HExpirationDateFlag " +
|
") values ("
|
+ "'" + HTM + "','批次条码'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty.ToString()
|
+ ",'" + HBatchNo + "'," + HSupID.ToString() + ",0,'" + ClsPub.CurUserName + "',getdate(),0," + HQty.ToString()
|
+ ", " + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo.ToString() + "','3714',0"
|
+ ", 0,'',0,0,0,''"
|
+ ",0,'','','" + HSCRQ1.ToShortDateString() + "','" + HYXQZ1.ToShortDateString() + "','',getdate()"
|
+ ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",''," + HInterID.ToString() + ",1"
|
+ ",0,0,0"
|
+ ",'" + HMaterName + "','" + HMaterModel + "','',0,'','',1)");
|
DataSet Dss7;
|
Dss7 = oCN.RunProcReturn(" select * from KF_PonderationBillMain_Temp where HBarCode= '" + HTM + "' and HInterID = " + hinterid.ToString() + " and HBillType = '" + HBillType + "' and hsourcebillno = '" + HSourceBillNo + "' ", "KF_PonderationBillMain_Temp");
|
if (Dss7.Tables[0].Rows.Count > 0)
|
{
|
|
}
|
else
|
{
|
WEBSController WEBS = new WEBSController();
|
WEBS.get_SourceBarCode_ProductIn_Json(hinterid, HBillNo, HBillType, HSourceBillNo, "3714", HMaker, HOrgID);
|
|
}
|
|
}
|
|
}
|
//生产退料
|
if (HBillType == "1244")
|
{
|
string HMaterNumber = "";
|
HMaterNumber = sBarCodeNew.Substring(0, 10);
|
string HSCRQ = "";
|
HSCRQ = "20" + sBarCodeNew.Substring(10, 6);
|
Int64 Year = ClsPub.isInt(HSCRQ.Substring(0, 4));
|
Int64 Month = ClsPub.isInt(HSCRQ.Substring(4, 2));
|
Int64 Day = ClsPub.isInt(HSCRQ.Substring(6, 2));
|
|
string HBatchNo = "";
|
HBatchNo = sBarCodeNew.Substring(16, 11);
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
Int64 HMaterID = 0;
|
DataSet Dss1;
|
Dss1 = oCN.RunProcReturn(" select HItemID,HName,HModel,HUnitID from Gy_Material where HNumber= '" + HMaterNumber + "' and huseorgid = " + HOrgID, "Gy_Material");
|
HMaterID = Pub_Class.ClsPub.isLong(Dss1.Tables[0].Rows[0]["HItemID"]);
|
string HMaterName = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HName"]);
|
string HMaterModel = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HModel"]);
|
Int64 HUnitID = Pub_Class.ClsPub.isInt(Dss1.Tables[0].Rows[0]["HUnitID"]);
|
DataSet Dss;
|
Dss = oCN.RunProcReturn(" select HNumber from h_v_CLD_ORGANIZATIONSList where HItemID= " + HOrgID, "h_v_CLD_ORGANIZATIONSList");
|
string HOrgNumber = Pub_Class.ClsPub.isStrNull(Dss.Tables[0].Rows[0]["HNumber"]);
|
HTM = HOrgNumber + HMaterID + HBatchNo;
|
|
|
DateTime HSCRQ1 = ClsPub.isDate(Year + "-" + Month + "-" + Day);
|
|
|
string HYXQZ = "20" + sBarCodeNew.Substring(27, 6);
|
Int64 Year1 = ClsPub.isInt(HYXQZ.Substring(0, 4));
|
Int64 Month1 = ClsPub.isInt(HYXQZ.Substring(4, 2));
|
Int64 Day1 = ClsPub.isInt(HYXQZ.Substring(6, 2));
|
DateTime HYXQZ1 = ClsPub.isDate(Year1 + "-" + Month1 + "-" + Day1);
|
|
Int64 HQty = 0;
|
HQty = ClsPub.isInt(sBarCodeNew.Substring(33, 3));
|
|
DataSet Dss5;
|
Dss5 = oCN.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + HTM + "'", "Gy_BarCodeBill");
|
if (Dss5.Tables[0].Rows.Count > 0)
|
{
|
|
}
|
else
|
{
|
|
|
|
string ModName = "85";
|
var HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
|
Int64 HSupID = 0;
|
oCN.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +
|
",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
|
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
|
",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " +
|
",HCusID,HCusType,HEndDate,HProduceDate,HExpiryDate,HWorkLineName,HBarCodeDate " +
|
",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " +
|
",HGiveAwayFlag,HSeOrderSEQ,HInitSourceEntryID " +
|
",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HExpirationDateFlag " +
|
") values ("
|
+ "'" + HTM + "','批次条码'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty.ToString()
|
+ ",'" + HBatchNo + "'," + HSupID.ToString() + ",0,'" + ClsPub.CurUserName + "',getdate(),0," + HQty.ToString()
|
+ ", 0,0,'','',0"
|
+ ", 0,'',0,0,0,''"
|
+ ",0,'','','" + HSCRQ1.ToShortDateString() + "','" + HYXQZ1.ToShortDateString() + "','',getdate()"
|
+ ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",''," + HInterID.ToString() + ",1"
|
+ ",0,0,0"
|
+ ",'" + HMaterName + "','" + HMaterModel + "','',0,'','',1)");
|
|
}
|
|
}
|
//调拨单
|
if (HBillType == "1207")
|
{
|
string HMaterNumber = "";
|
HMaterNumber = sBarCodeNew.Substring(0, 10);
|
string HSCRQ = "";
|
HSCRQ = "20" + sBarCodeNew.Substring(10, 6);
|
Int64 Year = ClsPub.isInt(HSCRQ.Substring(0, 4));
|
Int64 Month = ClsPub.isInt(HSCRQ.Substring(4, 2));
|
Int64 Day = ClsPub.isInt(HSCRQ.Substring(6, 2));
|
|
string HBatchNo = "";
|
HBatchNo = sBarCodeNew.Substring(16, 11);
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
Int64 HMaterID = 0;
|
DataSet Dss1;
|
Dss1 = oCN.RunProcReturn(" select HItemID,HName,HModel,HUnitID from Gy_Material where HNumber= '" + HMaterNumber + "' and huseorgid = " + HOrgID, "Gy_Material");
|
HMaterID = Pub_Class.ClsPub.isLong(Dss1.Tables[0].Rows[0]["HItemID"]);
|
string HMaterName = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HName"]);
|
string HMaterModel = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HModel"]);
|
Int64 HUnitID = Pub_Class.ClsPub.isInt(Dss1.Tables[0].Rows[0]["HUnitID"]);
|
DataSet Dss;
|
Dss = oCN.RunProcReturn(" select HNumber from h_v_CLD_ORGANIZATIONSList where HItemID= " + HOrgID, "h_v_CLD_ORGANIZATIONSList");
|
string HOrgNumber = Pub_Class.ClsPub.isStrNull(Dss.Tables[0].Rows[0]["HNumber"]);
|
HTM = HOrgNumber + HMaterID + HBatchNo;
|
|
|
DateTime HSCRQ1 = ClsPub.isDate(Year + "-" + Month + "-" + Day);
|
|
|
string HYXQZ = "20" + sBarCodeNew.Substring(27, 6);
|
Int64 Year1 = ClsPub.isInt(HYXQZ.Substring(0, 4));
|
Int64 Month1 = ClsPub.isInt(HYXQZ.Substring(4, 2));
|
Int64 Day1 = ClsPub.isInt(HYXQZ.Substring(6, 2));
|
DateTime HYXQZ1 = ClsPub.isDate(Year1 + "-" + Month1 + "-" + Day1);
|
|
Int64 HQty = 0;
|
HQty = ClsPub.isInt(sBarCodeNew.Substring(33, 3));
|
|
DataSet Dss5;
|
Dss5 = oCN.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + HTM + "'", "Gy_BarCodeBill");
|
if (Dss5.Tables[0].Rows.Count > 0)
|
{
|
|
}
|
else
|
{
|
|
|
|
string ModName = "85";
|
var HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
|
Int64 HSupID = 0;
|
oCN.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +
|
",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
|
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
|
",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " +
|
",HCusID,HCusType,HEndDate,HProduceDate,HExpiryDate,HWorkLineName,HBarCodeDate " +
|
",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " +
|
",HGiveAwayFlag,HSeOrderSEQ,HInitSourceEntryID " +
|
",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HExpirationDateFlag " +
|
") values ("
|
+ "'" + HTM + "','批次条码'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty.ToString()
|
+ ",'" + HBatchNo + "'," + HSupID.ToString() + ",0,'" + ClsPub.CurUserName + "',getdate(),0," + HQty.ToString()
|
+ ", 0,0,'','',0"
|
+ ", 0,'',0,0,0,''"
|
+ ",0,'','','" + HSCRQ1.ToShortDateString() + "','" + HYXQZ1.ToShortDateString() + "','',getdate()"
|
+ ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",''," + HInterID.ToString() + ",1"
|
+ ",0,0,0"
|
+ ",'" + HMaterName + "','" + HMaterModel + "','',0,'','',1)");
|
|
}
|
|
}
|
//其他出库单
|
if (HBillType == "1206")
|
{
|
string HMaterNumber = "";
|
HMaterNumber = sBarCodeNew.Substring(0, 10);
|
string HSCRQ = "";
|
HSCRQ = "20" + sBarCodeNew.Substring(10, 6);
|
Int64 Year = ClsPub.isInt(HSCRQ.Substring(0, 4));
|
Int64 Month = ClsPub.isInt(HSCRQ.Substring(4, 2));
|
Int64 Day = ClsPub.isInt(HSCRQ.Substring(6, 2));
|
|
string HBatchNo = "";
|
HBatchNo = sBarCodeNew.Substring(16, 11);
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
Int64 HMaterID = 0;
|
DataSet Dss1;
|
Dss1 = oCN.RunProcReturn(" select HItemID,HName,HModel,HUnitID from Gy_Material where HNumber= '" + HMaterNumber + "' and huseorgid = " + HOrgID, "Gy_Material");
|
HMaterID = Pub_Class.ClsPub.isLong(Dss1.Tables[0].Rows[0]["HItemID"]);
|
string HMaterName = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HName"]);
|
string HMaterModel = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HModel"]);
|
Int64 HUnitID = Pub_Class.ClsPub.isInt(Dss1.Tables[0].Rows[0]["HUnitID"]);
|
DataSet Dss;
|
Dss = oCN.RunProcReturn(" select HNumber from h_v_CLD_ORGANIZATIONSList where HItemID= " + HOrgID, "h_v_CLD_ORGANIZATIONSList");
|
string HOrgNumber = Pub_Class.ClsPub.isStrNull(Dss.Tables[0].Rows[0]["HNumber"]);
|
HTM = HOrgNumber + HMaterID + HBatchNo;
|
|
|
DateTime HSCRQ1 = ClsPub.isDate(Year + "-" + Month + "-" + Day);
|
|
|
string HYXQZ = "20" + sBarCodeNew.Substring(27, 6);
|
Int64 Year1 = ClsPub.isInt(HYXQZ.Substring(0, 4));
|
Int64 Month1 = ClsPub.isInt(HYXQZ.Substring(4, 2));
|
Int64 Day1 = ClsPub.isInt(HYXQZ.Substring(6, 2));
|
DateTime HYXQZ1 = ClsPub.isDate(Year1 + "-" + Month1 + "-" + Day1);
|
|
Int64 HQty = 0;
|
HQty = ClsPub.isInt(sBarCodeNew.Substring(33, 3));
|
|
DataSet Dss5;
|
Dss5 = oCN.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + HTM + "'", "Gy_BarCodeBill");
|
if (Dss5.Tables[0].Rows.Count > 0)
|
{
|
|
}
|
else
|
{
|
|
|
|
string ModName = "85";
|
var HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
|
Int64 HSupID = 0;
|
oCN.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +
|
",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
|
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
|
",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " +
|
",HCusID,HCusType,HEndDate,HProduceDate,HExpiryDate,HWorkLineName,HBarCodeDate " +
|
",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " +
|
",HGiveAwayFlag,HSeOrderSEQ,HInitSourceEntryID " +
|
",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HExpirationDateFlag " +
|
") values ("
|
+ "'" + HTM + "','批次条码'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty.ToString()
|
+ ",'" + HBatchNo + "'," + HSupID.ToString() + ",0,'" + ClsPub.CurUserName + "',getdate(),0," + HQty.ToString()
|
+ ", 0,0,'','',0"
|
+ ", 0,'',0,0,0,''"
|
+ ",0,'','','" + HSCRQ1.ToShortDateString() + "','" + HYXQZ1.ToShortDateString() + "','',getdate()"
|
+ ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",''," + HInterID.ToString() + ",1"
|
+ ",0,0,0"
|
+ ",'" + HMaterName + "','" + HMaterModel + "','',0,'','',1)");
|
|
}
|
|
}
|
//领料出库校验
|
if (HBillType == "1204")
|
{
|
string[] sArray = sBarCodeNew.Split('@');
|
string HMaterNumber = "";
|
HMaterNumber = sArray[0];
|
Int64 HQty = 0;
|
HQty = ClsPub.isInt(sArray[4]);
|
string HBarchNo = "";
|
HBarchNo = sArray[6];
|
|
DateTime HSCRQ = ClsPub.isDate(sArray[3]);
|
DateTime HYXQZ = ClsPub.isDate(sArray[5]);
|
|
//采购订单号
|
string HPOOrderBillNo = "";
|
HPOOrderBillNo = ClsPub.isStrNull(sArray[8]);
|
|
|
|
Int64 HMaterID = 0;
|
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet Dss;
|
Dss = oCn.RunProcReturn(" select HNumber from h_v_CLD_ORGANIZATIONSList where HItemID= " + HOrgID, "h_v_CLD_ORGANIZATIONSList");
|
string HOrgNumber = Pub_Class.ClsPub.isStrNull(Dss.Tables[0].Rows[0]["HNumber"]);
|
|
DataSet Dss1;
|
Dss1 = oCn.RunProcReturn(" select HItemID,HName,HModel,HUnitID from Gy_Material where HNumber= '" + HMaterNumber + "' and huseorgid = " + HOrgID, "Gy_Material");
|
HMaterID = Pub_Class.ClsPub.isLong(Dss1.Tables[0].Rows[0]["HItemID"]);
|
string HMaterName = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HName"]);
|
string HMaterModel = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HModel"]);
|
Int64 HUnitID = Pub_Class.ClsPub.isInt(Dss1.Tables[0].Rows[0]["HUnitID"]);
|
|
|
HTM = HOrgNumber + HMaterID + HBarchNo;
|
|
|
DataSet Dss5;
|
Dss5 = oCn.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + HTM + "'", "Gy_BarCodeBill");
|
if (Dss5.Tables[0].Rows.Count > 0)
|
{
|
|
}
|
else
|
{
|
|
string ModName = "85";
|
var HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
|
Int64 HSupID = 0;
|
oCn.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +
|
",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
|
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
|
",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " +
|
",HCusID,HCusType,HEndDate,HProduceDate,HExpiryDate,HWorkLineName,HBarCodeDate " +
|
",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " +
|
",HGiveAwayFlag,HSeOrderSEQ,HInitSourceEntryID " +
|
",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HExpirationDateFlag " +
|
") values ("
|
+ "'" + HTM + "','批次条码'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty.ToString()
|
+ ",'" + HBarchNo + "'," + HSupID.ToString() + ",0,'" + ClsPub.CurUserName + "',getdate(),0," + HQty.ToString()
|
+ ", " + 0 + "," + 0 + ",'','',0"
|
+ ", 0,'',0,0,0,''"
|
+ ",0,'','','" + HSCRQ.ToShortDateString() + "','" + HYXQZ.ToShortDateString() + "','',getdate()"
|
+ ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",''," + HInterID.ToString() + ",1"
|
+ ",0,0,0"
|
+ ",'" + HMaterName + "','" + HMaterModel + "','',0,'','',1)");
|
|
}
|
|
}
|
//生产补料校验
|
if (HBillType == "1254")
|
{
|
string[] sArray = sBarCodeNew.Split('@');
|
string HMaterNumber = "";
|
HMaterNumber = sArray[0];
|
Int64 HQty = 0;
|
HQty = ClsPub.isInt(sArray[4]);
|
string HBarchNo = "";
|
HBarchNo = sArray[6];
|
|
DateTime HSCRQ = ClsPub.isDate(sArray[3]);
|
DateTime HYXQZ = ClsPub.isDate(sArray[5]);
|
|
//采购订单号
|
string HPOOrderBillNo = "";
|
HPOOrderBillNo = ClsPub.isStrNull(sArray[8]);
|
|
|
|
Int64 HMaterID = 0;
|
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet Dss;
|
Dss = oCn.RunProcReturn(" select HNumber from h_v_CLD_ORGANIZATIONSList where HItemID= " + HOrgID, "h_v_CLD_ORGANIZATIONSList");
|
string HOrgNumber = Pub_Class.ClsPub.isStrNull(Dss.Tables[0].Rows[0]["HNumber"]);
|
|
DataSet Dss1;
|
Dss1 = oCn.RunProcReturn(" select HItemID,HName,HModel,HUnitID from Gy_Material where HNumber= '" + HMaterNumber + "' and huseorgid = " + HOrgID, "Gy_Material");
|
HMaterID = Pub_Class.ClsPub.isLong(Dss1.Tables[0].Rows[0]["HItemID"]);
|
string HMaterName = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HName"]);
|
string HMaterModel = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HModel"]);
|
Int64 HUnitID = Pub_Class.ClsPub.isInt(Dss1.Tables[0].Rows[0]["HUnitID"]);
|
|
|
HTM = HOrgNumber + HMaterID + HBarchNo;
|
|
|
DataSet Dss5;
|
Dss5 = oCn.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + HTM + "'", "Gy_BarCodeBill");
|
if (Dss5.Tables[0].Rows.Count > 0)
|
{
|
|
}
|
else
|
{
|
|
string ModName = "85";
|
var HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
|
Int64 HSupID = 0;
|
oCn.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +
|
",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
|
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
|
",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " +
|
",HCusID,HCusType,HEndDate,HProduceDate,HExpiryDate,HWorkLineName,HBarCodeDate " +
|
",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " +
|
",HGiveAwayFlag,HSeOrderSEQ,HInitSourceEntryID " +
|
",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HExpirationDateFlag " +
|
") values ("
|
+ "'" + HTM + "','批次条码'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty.ToString()
|
+ ",'" + HBarchNo + "'," + HSupID.ToString() + ",0,'" + ClsPub.CurUserName + "',getdate(),0," + HQty.ToString()
|
+ ", " + 0 + "," + 0 + ",'','',0"
|
+ ", 0,'',0,0,0,''"
|
+ ",0,'','','" + HSCRQ.ToShortDateString() + "','" + HYXQZ.ToShortDateString() + "','',getdate()"
|
+ ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",''," + HInterID.ToString() + ",1"
|
+ ",0,0,0"
|
+ ",'" + HMaterName + "','" + HMaterModel + "','',0,'','',1)");
|
|
}
|
|
}
|
//销售出库校验
|
if (HBillType == "1205")
|
{
|
string HMaterNumber = "";
|
HMaterNumber = sBarCodeNew.Substring(0, 10);
|
string HSCRQ = "";
|
HSCRQ = "20" + sBarCodeNew.Substring(10, 6);
|
Int64 Year = ClsPub.isInt(HSCRQ.Substring(0, 4));
|
Int64 Month = ClsPub.isInt(HSCRQ.Substring(4, 2));
|
Int64 Day = ClsPub.isInt(HSCRQ.Substring(6, 2));
|
|
string HBatchNo = "";
|
HBatchNo = sBarCodeNew.Substring(16, 11);
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
Int64 HMaterID = 0;
|
DataSet Dss1;
|
Dss1 = oCN.RunProcReturn(" select HItemID,HName,HModel,HUnitID from Gy_Material where HNumber= '" + HMaterNumber + "' and huseorgid = " + HOrgID, "Gy_Material");
|
HMaterID = Pub_Class.ClsPub.isLong(Dss1.Tables[0].Rows[0]["HItemID"]);
|
string HMaterName = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HName"]);
|
string HMaterModel = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HModel"]);
|
Int64 HUnitID = Pub_Class.ClsPub.isInt(Dss1.Tables[0].Rows[0]["HUnitID"]);
|
DataSet Dss;
|
Dss = oCN.RunProcReturn(" select HNumber from h_v_CLD_ORGANIZATIONSList where HItemID= " + HOrgID, "h_v_CLD_ORGANIZATIONSList");
|
string HOrgNumber = Pub_Class.ClsPub.isStrNull(Dss.Tables[0].Rows[0]["HNumber"]);
|
HTM = HOrgNumber + HMaterID + HBatchNo;
|
|
|
DateTime HSCRQ1 = ClsPub.isDate(Year + "-" + Month + "-" + Day);
|
|
|
string HYXQZ = "20" + sBarCodeNew.Substring(27, 6);
|
Int64 Year1 = ClsPub.isInt(HYXQZ.Substring(0, 4));
|
Int64 Month1 = ClsPub.isInt(HYXQZ.Substring(4, 2));
|
Int64 Day1 = ClsPub.isInt(HYXQZ.Substring(6, 2));
|
DateTime HYXQZ1 = ClsPub.isDate(Year1 + "-" + Month1 + "-" + Day1);
|
|
Int64 HQty = 0;
|
HQty = ClsPub.isInt(sBarCodeNew.Substring(33, 3));
|
|
DataSet Dss5;
|
Dss5 = oCN.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + HTM + "'", "Gy_BarCodeBill");
|
if (Dss5.Tables[0].Rows.Count > 0)
|
{
|
|
}
|
else
|
{
|
|
|
|
string ModName = "85";
|
var HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
|
Int64 HSupID = 0;
|
oCN.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +
|
",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
|
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
|
",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " +
|
",HCusID,HCusType,HEndDate,HProduceDate,HExpiryDate,HWorkLineName,HBarCodeDate " +
|
",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " +
|
",HGiveAwayFlag,HSeOrderSEQ,HInitSourceEntryID " +
|
",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HExpirationDateFlag " +
|
") values ("
|
+ "'" + HTM + "','批次条码'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty.ToString()
|
+ ",'" + HBatchNo + "'," + HSupID.ToString() + ",0,'" + ClsPub.CurUserName + "',getdate(),0," + HQty.ToString()
|
+ ", 0,0,'','',0"
|
+ ", 0,'',0,0,0,''"
|
+ ",0,'','','" + HSCRQ1.ToShortDateString() + "','" + HYXQZ1.ToShortDateString() + "','',getdate()"
|
+ ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",''," + HInterID.ToString() + ",1"
|
+ ",0,0,0"
|
+ ",'" + HMaterName + "','" + HMaterModel + "','',0,'','',1)");
|
|
}
|
|
}
|
//objJsonResult.code = "0";
|
//objJsonResult.count = 1;
|
//objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
|
//objJsonResult.data = ;
|
return HTM;
|
|
}
|
catch (Exception e)
|
{
|
//objJsonResult.code = "0";
|
//objJsonResult.count = 1;
|
//objJsonResult.Message = e.Message + ";" + e.StackTrace;
|
//objJsonResult.data = null;
|
return e.Message + ";" + e.StackTrace;
|
}
|
|
}
|
|
|
|
|
|
|
|
/// <summary>
|
/// 一键扫码红字
|
/// </summary>
|
/// <returns></returns>
|
[Route("POStockInBill/get_CheckTypeByBarCode_All_Json")]
|
[HttpGet]
|
public Object get_CheckTypeByBarCode_All_Json(string sCode, Int64 sInterID, string HBillType, string sBillNo, string sMaker, Int64 WhID, Int64 SPID, Double sQty, bool sRedBlue, bool SourceFlag, string sSourceBillNo, string sSourceType, Int64 HOWNERID, string sExpressNumber)
|
{
|
if (sRedBlue == true)
|
{
|
HBillType = "1239";
|
}
|
oBar = webserver.get_CheckTypeByBarCode_All(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, ref DBUtility.ClsPub.sErrInfo);
|
if (oBar == 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 = oBar;
|
return objJsonResult;
|
}
|
}
|
|
/// <summary>
|
/// 根据源单及源单类型 返回 相关信息
|
/// </summary>
|
/// <param name="HSourceBillNo"></param>
|
/// <returns></returns>
|
[Route("POStockInBill/get_GetCg_POOrderBillList")]
|
[HttpGet]
|
public object get_GetCg_POOrderBillList(string HSourceBillType, string HSourceBillNo, Int64 sInterID, string sBillNo)
|
{
|
try
|
{
|
string sWhere = " Where 单据号 like '%" + HSourceBillNo.Trim() + "'";
|
//根据源单类型来调用不同的WEBS方法 new
|
if (HSourceBillType == "1102")
|
{
|
ds = webserver.GetCg_POOrderBillList(sWhere + " ");
|
}
|
else if (HSourceBillType == "1103")
|
{
|
ds = webserver.GetCg_PoInStockBillList(sWhere + " and isnull(HBillSubType,0)=12510 ");
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录,源单类型有错误！";
|
objJsonResult.data = null;
|
return objJsonResult; ;
|
}
|
//
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + HSourceBillType;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "返回记录成功！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
|
}
|
}
|
catch (Exception ex)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
|
/// <summary>
|
/// 写入临时表 扫源单的方法
|
/// </summary>
|
/// <param name="HSourceBillNo"></param>
|
/// <returns></returns>
|
[Route("POStockInBill/set_SavePonderationBillMain_Temp_Source_Fast_Json")]
|
[HttpGet]
|
public object set_SavePonderationBillMain_Temp_Source_Fast_Json(string HSourceBillType, string HSourceBillNo, Int64 sInterID, string sBillNo)
|
{
|
try
|
{
|
// DataSet ds = new DataSet();
|
// WebServer webserver = new WebServer();
|
string sWhere = " Where 单据号 like '%" + HSourceBillNo.Trim() + "'";
|
//根据源单类型来调用不同的WEBS方法 new
|
if (HSourceBillType == "1102")
|
{
|
ds = webserver.GetCg_POOrderBillList(sWhere + " ");
|
}
|
else if (HSourceBillType == "1103")
|
{
|
ds = webserver.GetCg_PoInStockBillList(sWhere + "");
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录,源单类型有错误！";
|
objJsonResult.data = null;
|
return objJsonResult; ;
|
}
|
//
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + HSourceBillType;
|
objJsonResult.data = null;
|
return objJsonResult;
|
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
|
}
|
else
|
{
|
HSupID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HSupID"]);
|
HSupName = Convert.ToString(ds.Tables[0].Rows[0]["HSupName"]);
|
HDeptID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HDeptID"]);
|
HDeptName = Convert.ToString(ds.Tables[0].Rows[0]["HDeptName"]);
|
if (webserver.set_SavePonderationBillMain_Temp_Source_Fast(sInterID, sBillNo, HBillType, HSourceBillNo, HSourceBillType, "蓝字", ref DBUtility.ClsPub.sErrInfo))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "返回记录成功！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "写入临时表失败！" + DBUtility.ClsPub.sErrInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
}
|
catch (Exception ex)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
|
|
/// <summary>
|
/// 写入临时表 扫源单的方法
|
/// </summary>
|
/// <param name="HSourceBillNo"></param>
|
/// <returns></returns>
|
[Route("ICMOReportBill/set_SavePonderationBillMain_Temp_Source_Fast_Json_New")]
|
[HttpGet]
|
public object set_SavePonderationBillMain_Temp_Source_Fast_Json_New(string HSourceBillType, string HSourceBillNo, Int64 sInterID, string sBillNo)
|
{
|
try
|
{
|
LogService.Write("执行成功!");
|
// DataSet ds = new DataSet();
|
// WebServer webserver = new WebServer();
|
string sWhere = " Where 单据号 like '%" + HSourceBillNo.Trim() + "'";
|
//根据源单类型来调用不同的WEBS方法 new
|
if (HSourceBillType == "3710")
|
{
|
ds = webserver.GetSc_ICMOBillList(sWhere + " ");
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录,源单类型有错误！";
|
objJsonResult.data = null;
|
return objJsonResult; ;
|
}
|
//
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + HSourceBillType;
|
objJsonResult.data = null;
|
return objJsonResult;
|
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
|
}
|
else
|
{
|
HDeptID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HDeptID"]);
|
HDeptName = Convert.ToString(ds.Tables[0].Rows[0]["HDeptName"]);
|
if (webserver.set_SavePonderationBillMain_Temp_Source_Fast(sInterID, sBillNo, "3711", HSourceBillNo, HSourceBillType, "蓝字", ref DBUtility.ClsPub.sErrInfo))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "返回记录成功！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "写入临时表失败！" + DBUtility.ClsPub.sErrInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
}
|
catch (Exception ex)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
|
|
|
|
|
[Route("Kf_QCStockInCheckBill_Fast/BarCode_Json")]
|
[HttpGet]
|
public object BarCode_Json(string HBarCode,Int64 HOrgID)
|
{
|
try
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
//string[] sArray = HBarCode.Split('@');
|
//string HMaterNumber = "";
|
//HMaterNumber = sArray[0];
|
|
////采购订单号
|
//string HPOOrderBillNo = "";
|
//HPOOrderBillNo = ClsPub.isStrNull(sArray[8]);
|
|
|
|
//Int64 HMaterID = 0;
|
|
|
//DataSet Dss1;
|
//Dss1 = oCn.RunProcReturn(" select HItemID,HName,HModel,HUnitID from Gy_Material where HNumber= '" + HMaterNumber + "' and huseorgid = " + HOrgID, "Gy_Material");
|
//HMaterID = Pub_Class.ClsPub.isLong(Dss1.Tables[0].Rows[0]["HItemID"]);
|
|
|
////根据物料 + 批次 + 采购订单号 找到对应的收料通知单号
|
//DataSet Dss2;
|
//Dss2 = oCn.RunProcReturn(" select fid,FMATERIALID,FENTRYID,FBILLNO from h_v_RECEIVEQuery where FSRCBILLNO= '" + HPOOrderBillNo + "' and FMATERIALID = " + HMaterID, "h_v_RECEIVEQuery");
|
//HMaterID = Pub_Class.ClsPub.isLong(Dss2.Tables[0].Rows[0]["FMATERIALID"]);
|
//string HSourceBillNo = Pub_Class.ClsPub.isStrNull(Dss2.Tables[0].Rows[0]["FBILLNO"]);
|
|
|
string HTM = "";
|
string[] sArray = HBarCode.Split('@');
|
string HMaterNumber = "";
|
HMaterNumber = sArray[0];
|
Int64 HQty = 0;
|
HQty = ClsPub.isInt(sArray[4]);
|
string HBarchNo = "";
|
HBarchNo = sArray[6];
|
|
DateTime HSCRQ = ClsPub.isDate(sArray[3]);
|
DateTime HYXQZ = ClsPub.isDate(sArray[5]);
|
|
//采购订单号
|
string HPOOrderBillNo = "";
|
HPOOrderBillNo = ClsPub.isStrNull(sArray[8]);
|
|
|
|
Int64 HMaterID = 0;
|
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet Dss;
|
Dss = oCn.RunProcReturn(" select HNumber from h_v_CLD_ORGANIZATIONSList where HItemID= " + HOrgID, "h_v_CLD_ORGANIZATIONSList");
|
string HOrgNumber = Pub_Class.ClsPub.isStrNull(Dss.Tables[0].Rows[0]["HNumber"]);
|
|
DataSet Dss1;
|
Dss1 = oCn.RunProcReturn(" select HItemID,HName,HModel,HUnitID from Gy_Material where HNumber= '" + HMaterNumber + "' and huseorgid = " + HOrgID, "Gy_Material");
|
HMaterID = Pub_Class.ClsPub.isLong(Dss1.Tables[0].Rows[0]["HItemID"]);
|
string HMaterName = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HName"]);
|
string HMaterModel = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HModel"]);
|
Int64 HUnitID = Pub_Class.ClsPub.isInt(Dss1.Tables[0].Rows[0]["HUnitID"]);
|
|
|
HTM = HOrgNumber + HMaterID + HBarchNo;
|
|
//如果条码档案不存在 进行存入条码档案的动作
|
//根据物料 + 批次 + 采购订单号 找到对应的收料通知单号
|
DataSet Dss2;
|
Dss2 = oCn.RunProcReturn(" select fid,FMATERIALID,FENTRYID,FBILLNO from h_v_RECEIVEQuery where FSRCBILLNO= '" + HPOOrderBillNo + "' and FMATERIALID = " + HMaterID, "h_v_RECEIVEQuery");
|
HMaterID = Pub_Class.ClsPub.isLong(Dss2.Tables[0].Rows[0]["FMATERIALID"]);
|
Int64 HSourceInterID = Pub_Class.ClsPub.isLong(Dss2.Tables[0].Rows[0]["fid"]);
|
Int64 HSourceEntryID = Pub_Class.ClsPub.isLong(Dss2.Tables[0].Rows[0]["FENTRYID"]);
|
string HSourceBillNo = Pub_Class.ClsPub.isStrNull(Dss2.Tables[0].Rows[0]["FBILLNO"]);
|
//判断条码档案是否存在该条码
|
//如果存在 再判断扫码临时表是否存在该条码
|
//如果不存在 进行扫源单的方法
|
DataSet Dss5;
|
Dss5 = oCn.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + HTM + "'", "Gy_BarCodeBill");
|
if (Dss5.Tables[0].Rows.Count > 0)
|
{
|
DataSet ds;
|
ds = oCN.RunProcReturn("select * from h_v_QCStockInCheckBill_Json where HSourceBillNo ='" + HSourceBillNo.ToString() + "'", "h_v_QCStockInCheckBill_Json");
|
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;
|
}
|
}
|
else
|
{
|
|
|
|
string ModName = "85";
|
var HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
|
Int64 HSupID = 0;
|
oCn.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +
|
",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
|
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
|
",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " +
|
",HCusID,HCusType,HEndDate,HProduceDate,HExpiryDate,HWorkLineName,HBarCodeDate " +
|
",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " +
|
",HGiveAwayFlag,HSeOrderSEQ,HInitSourceEntryID " +
|
",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HExpirationDateFlag " +
|
") values ("
|
+ "'" + HTM + "','批次条码'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty.ToString()
|
+ ",'" + HBarchNo + "'," + HSupID.ToString() + ",0,'" + ClsPub.CurUserName + "',getdate(),0," + HQty.ToString()
|
+ ", " + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo.ToString() + "','1103',0"
|
+ ", 0,'',0,0,0,''"
|
+ ",0,'','','" + HSCRQ.ToShortDateString() + "','" + HYXQZ.ToShortDateString() + "','',getdate()"
|
+ ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",''," + HInterID.ToString() + ",1"
|
+ ",0,0,0"
|
+ ",'" + HMaterName + "','" + HMaterModel + "','',0,'','',1)");
|
DataSet ds;
|
ds = oCN.RunProcReturn("select * from h_v_QCStockInCheckBill_Json where HSourceBillNo ='" + HSourceBillNo.ToString() + "'", "h_v_QCStockInCheckBill_Json");
|
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;
|
}
|
}
|
//ds = oCN.RunProcReturn("select * from h_v_QCStockInCheckBill_Json where 条码编号 ='" + HBarCode.ToString() + "'", "h_v_QCStockInCheckBill_Json");
|
|
}
|
catch (Exception e)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
|
[Route("Kf_SCStockInCheckBill_Fast/BarCode_Json1")]
|
[HttpGet]
|
public object BarCode_Json1(string HBarCode,Int64 HOrgID)
|
{
|
try
|
{
|
|
//根据拆分的物料ID + 批次 + 生产日期 能找到唯一的工序汇报单
|
string HMaterNumber = "";
|
HMaterNumber = HBarCode.Substring(0, 10);
|
string HSCRQ = "";
|
HSCRQ = "20" + HBarCode.Substring(10, 6);
|
Int64 Year = ClsPub.isInt(HSCRQ.Substring(0, 4));
|
Int64 Month = ClsPub.isInt(HSCRQ.Substring(4, 2));
|
Int64 Day = ClsPub.isInt(HSCRQ.Substring(6, 2));
|
|
string HBatchNo = "";
|
HBatchNo = HBarCode.Substring(16, 11);
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
DataSet ds;
|
Int64 HMaterID = 0;
|
DataSet Dss1;
|
Dss1 = oCN.RunProcReturn(" select HItemID,HName,HModel,HUnitID from Gy_Material where HNumber= '" + HMaterNumber + "' and huseorgid = " + HOrgID, "Gy_Material");
|
HMaterID = Pub_Class.ClsPub.isLong(Dss1.Tables[0].Rows[0]["HItemID"]);
|
string HMaterName = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HName"]);
|
string HMaterModel = Pub_Class.ClsPub.isStrNull(Dss1.Tables[0].Rows[0]["HModel"]);
|
Int64 HUnitID = Pub_Class.ClsPub.isInt(Dss1.Tables[0].Rows[0]["HUnitID"]);
|
|
|
DateTime HSCRQ1 = ClsPub.isDate(Year + "-" + Month + "-" + Day);
|
|
|
|
Int64 HQty = 0;
|
HQty = ClsPub.isInt(HBarCode.Substring(33, 3));
|
|
|
ds = oCN.RunProcReturn("select * from h_v_SCStockInCheckBill_Json where HYear =" + Year.ToString() + "and HMonth = " + Month.ToString() + "and HDay = " + Day.ToString() + " and HMaterID = " + HMaterID.ToString() + "and 批次 = '" + HBatchNo.ToString() + "'", "h_v_SCStockInCheckBill_Json");
|
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>
|
/// 返回出入库条码临时表
|
/// </summary>
|
/// <returns></returns>
|
[Route("POStockInBill/DisBillEntryList_Webs_Json")]
|
[HttpGet]
|
public object DisBillEntryList_Webs_Json(long HBillID, string HBillType, string sWhere)
|
{
|
try
|
{
|
ds = webserver.GetKf_PonderationBillMain_Temp(HBillID, HBillType, sWhere);
|
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>
|
/// 扫码入库时获取仓库仓位信息
|
/// </summary>
|
/// <param name="sHInterID"></param>
|
/// <param name="sHBillType"></param>
|
/// <param name="sBarCode"></param>
|
/// <param name="sHWHID"></param>
|
/// <param name="sHSPID"></param>
|
/// <returns></returns>
|
[Route("POStockInBill/Get_CheckWhAndSP_Josn")]
|
[HttpGet]
|
public object Get_CheckWhAndSP_Josn(Int64 sHInterID, string sHBillType, string sBarCode, Int64 sHWHID, Int64 sHSPID)
|
{
|
long WhID = sHWHID;
|
long SPID = sHSPID;
|
|
if (webserver.Get_CheckWhAndSP(sHInterID, sHBillType, sBarCode, sHWHID, SPID, ref WhID, ref SPID, 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;
|
}
|
}
|
/// <summary>
|
/// //根据物料条码得到对应源单信息并将源单信息新增到条码出入库临时表，带出表头部门、供应商
|
/// </summary>
|
/// <param name="sBarCode"></param>
|
/// <param name="sInterID"></param>
|
/// <param name="sBillNo"></param>
|
/// <param name="sQty"></param>
|
/// <returns></returns>
|
[Route("POStockInBill/set_SavePonderationBillMain_Temp_Source_SourceBillType_Json")]
|
[HttpGet]
|
public object set_SavePonderationBillMain_Temp_Source_SourceBillType_Json(string sBarCode, Int64 sInterID, string sBillNo, Double sQty)
|
{
|
if (SourceFlag)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "获取失败+";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
|
if (webserver.set_SavePonderationBillMain_Temp_Source_SourceBillType(sInterID, sBillNo, HBillType, sBarCode, sRedBlue2, ref HSourceBillNo, ref sSourceTypeName, ref HSupID, ref HSupName, ref HDeptID, ref HDeptName, ref DBUtility.ClsPub.sErrInfo))
|
{
|
//----------创建虚表------------------------
|
DataTable dt_Main = new DataTable("Json");
|
dt_Main.Columns.Add("HSourceBillNo", typeof(string));
|
dt_Main.Columns.Add("sSourceTypeName", typeof(string));
|
dt_Main.Columns.Add("HSupName", typeof(string));
|
dt_Main.Columns.Add("HSupID", typeof(int));
|
dt_Main.Columns.Add("HDeptName", typeof(string));
|
dt_Main.Columns.Add("HDeptID", typeof(int));
|
dt_Main.Columns.Add("SourceFlag", typeof(bool));
|
//---------创建新行------------------------
|
DataRow dr_main = dt_Main.NewRow();//创建新行
|
dt_Main.Rows.Add(dr_main);//将新行加入到表中
|
dr_main["HSourceBillNo"] = DBUtility.ClsPub.isStrNull(HSourceBillNo);
|
dr_main["sSourceTypeName"] = DBUtility.ClsPub.isLong(sSourceTypeName);
|
dr_main["HSupName"] = DBUtility.ClsPub.isStrNull(HSupName);
|
dr_main["HSupID"] = DBUtility.ClsPub.isLong(HSupID);
|
dr_main["HDeptName"] = DBUtility.ClsPub.isStrNull(HDeptName);
|
dr_main["HDeptID"] = DBUtility.ClsPub.isLong(HDeptID);
|
dr_main["SourceFlag"] = DBUtility.ClsPub.isBool(true);
|
|
if (dt_Main == null || dt_Main.Rows.Count <= 0)
|
{
|
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 = "获取成功";
|
objJsonResult.data = dt_Main;
|
return objJsonResult;
|
}
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
}
|
/// <summary>
|
/// 根据条码得到相应信息(条码档案) 扫条码的方法
|
/// </summary>
|
/// <param name="sBarCode"></param>
|
/// <param name="sInterID"></param>
|
/// <param name="sBillNo"></param>
|
/// <param name="sQty"></param>
|
/// <returns></returns>
|
[Route("POStockInBill/get_InfoByBarCode_Source_Json")]
|
[HttpGet]
|
public object get_InfoByBarCode_Source_Json(string sBarCode, Int64 sInterID, string sBillNo, Double sQty, Int64 HWHID, Int64 HSPID)
|
{
|
// string sRedBlue = "蓝字";
|
try
|
{
|
string sErrMsg = "";
|
bool sBool = false;
|
oView = webserver.get_InfoByBarCode_Source(sBarCode, sInterID, ref sBool, ref sErrMsg);
|
model.HInterID = DBUtility.ClsPub.isLong(sInterID);
|
model.HBillNo = DBUtility.ClsPub.isStrNull(sBillNo);
|
model.HBillType = this.HBillType;
|
model.HMaker = "";
|
//
|
model.HMaterID = oView.HMaterID;
|
model.HAuxPropID = oView.HAuxPropID;
|
model.HErpClsID = oView.HErpClsID;
|
model.HQty = oView.HQty;
|
model.HQtyMust = oView.HinitQty;
|
model.HBarCode = oView.HBarCode;
|
model.HBatchNo = oView.HBatchNo;
|
model.HMTONo = oView.HMTONo;
|
|
model.HWhID = HWHID;
|
model.HStockPlaceID = HSPID;
|
model.HSourceInterID = oView.HSourceInterID;
|
model.HSourceEntryID = oView.HSourceEntryID;
|
model.HSourceBillNo = oView.HSourceBillNo;
|
model.HSourceBillType = oView.HSourceBillType;
|
model.HRedBlueFlag = false;
|
model.HPieceQty = 1;
|
model.HSTOCKORGID = 0;
|
model.HOWNERID = 0;
|
if (webserver.set_SavePonderationBillMain_Temp_Qty(model, sQty, 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;
|
}
|
}
|
/// <summary>
|
/// 生成外购入库单(红字)
|
/// </summary>
|
/// <returns></returns>
|
[Route("POStockInBill/set_SavePOStockInBackBill_Json")]
|
[HttpPost]
|
public object set_SavePOStockInBackBill_Json([FromBody] JObject oMain)
|
{
|
var _value = oMain["oMain"].ToString();
|
string msg1 = _value.ToString();
|
try
|
{
|
List<Model.ClsKf_ICStockBillMain> lsmain = new List<Model.ClsKf_ICStockBillMain>();
|
ListModels oListModels = new ListModels();
|
lsmain = oListModels.getICStockBillMainByJson(msg1);
|
lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));
|
string sSourceBillType = lsmain[0].HBillType;
|
|
WebAPI.WebS.ClsKf_ICStockBillMain websLsmain = new WebS.ClsKf_ICStockBillMain();
|
|
websLsmain.HInterID = lsmain[0].HInterID;
|
websLsmain.HDate = lsmain[0].HDate;
|
websLsmain.HBillNo = lsmain[0].HBillNo;
|
websLsmain.HDeptID = lsmain[0].HDeptID;
|
websLsmain.HEmpID = lsmain[0].HEmpID;
|
websLsmain.HRemark = lsmain[0].HRemark;
|
websLsmain.HMaker = lsmain[0].HMaker;
|
|
if (webserver.set_SavePOStockInBackBill_New(websLsmain, sSourceBillType, 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;
|
}
|
}
|
/// <summary>
|
/// 外购入库/提交/直接调webservice
|
/// </summary>
|
/// <returns></returns>
|
[Route("POStockInBill/set_SavePOStockInBill_Json")]
|
[HttpPost]
|
public object set_SavePOStockInBill_Json([FromBody] JObject oMain)
|
{
|
var _value = oMain["oMain"].ToString();
|
string msg1 = _value.ToString();
|
try
|
{
|
List<Model.ClsKf_POStockInBillMain> lsmain = new List<Model.ClsKf_POStockInBillMain>();
|
ListModels oListModels = new ListModels();
|
lsmain = oListModels.getPOStockInBillMainByJson(msg1);
|
lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));
|
string sSourceBillType = lsmain[0].HBillType;
|
|
WebAPI.WebS.ClsKf_POStockInBillMain websLsmain = new WebS.ClsKf_POStockInBillMain();
|
|
websLsmain.HInterID = lsmain[0].HInterID;
|
websLsmain.HBillNo = lsmain[0].HBillNo;
|
websLsmain.HBillType = "1201";//固定值
|
websLsmain.HDate = lsmain[0].HDate;
|
websLsmain.HDeptID = lsmain[0].HDeptID;
|
websLsmain.HWHID = lsmain[0].HWHID;
|
websLsmain.HSCWHID = 0;
|
//websLsmain.HSPID = lsmain[0].HSPID;
|
websLsmain.HSupID = lsmain[0].HSupID;
|
websLsmain.HKeeperID = lsmain[0].HKeeperID;
|
websLsmain.HSecManagerID = lsmain[0].HSecManagerID;
|
websLsmain.HEmpID = 0;
|
websLsmain.HManagerID = 0;
|
websLsmain.HBillerID = lsmain[0].HBillerID;
|
websLsmain.HRemark = "";
|
websLsmain.HExplanation = lsmain[0].HExplanation;
|
websLsmain.HInnerBillNo = "";
|
websLsmain.HRedBlueFlag = false;//false蓝字 true红字
|
websLsmain.HMainSourceBillType = lsmain[0].HBillType;
|
websLsmain.HMaker = lsmain[0].HMaker;
|
websLsmain.HSTOCKORGID = lsmain[0].HSTOCKORGID;
|
websLsmain.HOWNERID = lsmain[0].HSTOCKORGID;
|
|
if (webserver.set_SavePOStockInBill_New(websLsmain, sSourceBillType, 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;
|
}
|
}
|
|
|
/// <summary>
|
/// 生产汇报单/提交/直接调webservice
|
/// </summary>
|
/// <returns></returns>
|
[Route("ICMOReportBill/set_SaveICMOReportBill_Json")]
|
[HttpPost]
|
public object set_SaveICMOReportBill_Json([FromBody] JObject oMain)
|
{
|
var _value = oMain["oMain"].ToString();
|
string msg1 = _value.ToString();
|
try
|
{
|
List<Model.ClsSc_ICMOReportBillMain> lsmain = new List<Model.ClsSc_ICMOReportBillMain>();
|
ListModels oListModels = new ListModels();
|
lsmain = oListModels.getICMOReportBillMainByJson(msg1);
|
lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));
|
string sSourceBillType = lsmain[0].HBillType;
|
|
WebAPI.WebS.ClsSc_ICMOReportBillMain websLsmain = new WebS.ClsSc_ICMOReportBillMain();
|
|
websLsmain.HInterID = lsmain[0].HInterID;
|
websLsmain.HBillNo = lsmain[0].HBillNo;
|
websLsmain.HBillType = "3711";//固定值
|
websLsmain.HDate = lsmain[0].HDate;
|
websLsmain.HDeptID = lsmain[0].HDeptID;
|
websLsmain.HEmpID = 0;
|
websLsmain.HBillerID = lsmain[0].HBillerID;
|
websLsmain.HRemark = "";
|
websLsmain.HMainSourceBillType = lsmain[0].HBillType;
|
|
|
if (webserver.set_SaveICMOReportBill_Json(websLsmain, sSourceBillType, 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;
|
}
|
}
|
|
[Route("POStockInBill/GetSpName_Json")]
|
[HttpGet]
|
public object GetSpName_Json(long HSpID, long HWHID, long HStockOrgID, ref string sErrMsg)
|
{
|
try
|
{
|
ds = webserver.GetSPInfoByIDandHWHIDandOrg(HSpID, HWHID, HStockOrgID, ref sErrMsg);
|
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("POStockInBill/Delete_Json")]
|
[HttpGet]
|
public object Delete_Json(long HInterID, long HMaterID, long HAuxPropID, string HMTONo, long HSourceInterID, long HSourceEntryID, string sHBillType)
|
{
|
string sErrMsg = string.Empty;
|
try
|
{
|
if (webserver.set_DelPonderationBillMain_Temp_InterIDAndSource(HInterID, HMaterID, HAuxPropID, HMTONo, HSourceInterID, HSourceEntryID, sHBillType, 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)
|
{
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
}
|
|
[Route("POStockInBill/DisBillEntryList_Mate_Webs_Json")]
|
[HttpGet]
|
public object DisBillEntryList_Mate_Webs_Json(long HInterID, string sBillType, string sWhere)
|
{
|
try
|
{
|
ds = webserver.GetKf_PonderationBillMain_Temp(HInterID, sBillType, sWhere);
|
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("POStockInBillList/DisBillEntryList_Mate_Webs_Json")]
|
[HttpGet]
|
public object DisBillEntryList_Webs_Json(string HBillType, string sWhere)
|
{
|
try
|
{
|
ds = webserver.GetKf_PonderationBillMain_TempList(HBillType, sWhere);
|
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("POStockInBillList/Delete_Json")]
|
[HttpGet]
|
public object Delete_Json(long sHInterID)
|
{
|
string sErrMsg = string.Empty;
|
try
|
{
|
if (webserver.DeleteBillList(sHInterID, 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)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
}
|
|
#region 到货确认
|
[Route("POStockInBillList/Get_ReciveBill")]
|
[HttpGet]
|
public object get_InfoByBillNo(string HBillno)
|
{
|
try
|
{
|
json result = Get_ReciveBillCheckDate(HBillno);
|
return result;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
public int GetHinterIDByBillNo(string HBillNo, string type)
|
{
|
SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
|
int HInterID = 0;
|
string sql = "select HInterID from CG_POINSTOCKBILLMAIN where HBILLNO = '" + HBillNo + "'";
|
if (type == "Print")
|
sql += " and HBillStatus = '2' ";//打印判断是否审核
|
DataTable dt = oCn.RunProcReturn(sql, "HInterID").Tables[0];
|
if (dt.Rows.Count > 0)
|
HInterID = Convert.ToInt32(dt.Rows[0]["HInterID"]);
|
return HInterID;
|
}
|
|
/// <summary>
|
/// 到货确认扫收料通知单号 获取表体和表头数据
|
/// </summary>
|
/// <param name="HBarCode"></param>
|
/// <returns></returns>
|
public json Get_ReciveBillCheckDate(string HBarCode)
|
{
|
json objjson = new json();
|
try
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet Ds;
|
string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);//客户名称
|
if (FCusName.Contains("安瑞"))
|
Ds = oCn.RunProcReturn("exec h_p_GetPOInStockByBarCode'" + HBarCode + "'", "h_p_GetPOInStockByBarCode");
|
else
|
Ds = oCn.RunProcReturn("exec h_p_KF_PonderationBillMain_Temp_Add_POInStockCheck2 '" + HBarCode + "'", "h_p_KF_PonderationBillMain_Temp_Add_POInStockCheck2");
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "没有返回任何记录！";
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 0)
|
{
|
objjson.code = "1";
|
objjson.count = 1;
|
objjson.Message = "Sucess！";
|
objjson.data = Ds.Tables[0];
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]);
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
}
|
catch (Exception e)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "没有返回任何记录！" + e.ToString();
|
objjson.data = null;
|
return objjson;
|
|
}
|
}
|
|
[Route("POStockInBillList/AuditPOInStockBillPost")]
|
[HttpPost]
|
public object AuditPOInStockBill([FromBody] JObject msg)
|
{
|
try
|
{
|
string _msg = msg["msg"].ToString();
|
_msg = _msg.Replace("\\", "");
|
_msg = _msg.Replace("\n", "");
|
List<Models.ReciveBill_FastModel> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ReciveBill_FastModel>>(_msg);
|
DAL.ClsCg_POInStockBill oBill = new DAL.ClsCg_POInStockBill();
|
var hinterID = list[0].HInterID;
|
var FID = list[0].FID;
|
string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);//客户名称
|
string FisRealess = oSystemParameter.GetSingleSystemParameter("Cg_POInStockBill_ErpAduit", ref DBUtility.ClsPub.sExeReturnInfo);//送货单到货确认后同步金蝶云收料通知单
|
string FishaveBarcode = oSystemParameter.GetSingleSystemParameter("Cg_POInStockBill_BarCodeCtl", ref DBUtility.ClsPub.sExeReturnInfo);//到货确认必须扫码箱条码
|
var kdTbaleName = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "DataBaseName");
|
string sql = string.Empty;
|
#region 校验是否扫描条码
|
if (FishaveBarcode == "Y")
|
{
|
var HInterID = list[0].HInterID;
|
string jysql = string.Format(@"select * from KF_PonderationBillMain_Temp where HSourceInterID = {0}", HInterID);
|
DataTable jyDt = oCn.RunProcReturn(jysql, "jysql").Tables[0];
|
if (jyDt.Rows.Count == 0 || jyDt == null)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "请扫描条码";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
#region 金蝶审核后会重新同步单据到mes 故不需要更新mes的收料通知单
|
oCn.BeginTran();
|
foreach (var item in list)
|
{
|
if (item.HSQty == 0)
|
continue;
|
sql = $"update Cg_POInStockBillSub set Hqty = {item.HSQty} where HInterID ={item.HInterID} and HEntryID = {item.HEntryID}";
|
oCn.RunProc(sql);
|
}
|
//更新成功后 同步更新金蝶
|
oCn.Commit();
|
#endregion
|
|
if (FCusName.Contains("安瑞"))
|
{
|
sql = string.Format(@"
|
SELECT T3.FNAME AS FTYPENAME,M.HBILLNO,B.HINTERID,B.HENTRYID,C.FID,C.FENTRYID, D.FBILLNO,B.HQTY,CD.FRECEIVEORGID,CDOO.FNUMBER AS FRECEIVENUMBER
|
,D.FSUPPLIERID,DS.FNUMBER AS FSUPPLIERNUMBER,D.FPURCHASEORGID,DOO.FNUMBER AS FPURCHASEORGNUMBER,CROO.FNUMBER AS FSETTLEORGNUMBER,
|
E.FPRICETIMEPOINT,E.FSETTLECURRID,EC.FNUMBER AS FSETTLECURRNUMBER,C.FMATERIALID,CM.FNUMBER AS FMATERIALNUMBER ,C.FUNITID
|
,CU.FNUMBER AS FUNITNUMBER,CR.FPRICE,CR.FTAXPRICE,CR.FTAXRATE,D.FPURCHASERID,isnull(T4.FNUMBER,'') AS FPURCHASERNUMBER
|
FROM CG_POINSTOCKBILLSUB B
|
JOIN CG_POINSTOCKBILLMAIN M ON B.HINTERID = M.HINTERID
|
JOIN {0}..T_PUR_POORDERENTRY C ON B.HSOURCEINTERID = C.FID AND B.HSOURCEENTRYID = C.FENTRYID
|
LEFT JOIN {0}..T_BD_MATERIAL CM ON C.FMATERIALID =CM.FMATERIALID
|
LEFT JOIN {0}..T_BD_UNIT CU ON C.FUNITID =CU.FUNITID
|
JOIN {0}..T_PUR_POORDERENTRY_D CD ON C.FENTRYID = CD.FENTRYID
|
LEFT JOIN {0}..T_ORG_ORGANIZATIONS CDOO ON CD.FRECEIVEORGID = CDOO.FORGID
|
JOIN {0}..T_PUR_POORDERENTRY_F CR ON C.FENTRYID = CR.FENTRYID
|
LEFT JOIN {0}..T_ORG_ORGANIZATIONS CROO ON CR.FSETTLEORGID = CROO.FORGID
|
LEFT JOIN {0}..T_PUR_POORDER D ON C.FID =D.FID
|
LEFT JOIN {0}..T_BAS_BILLTYPE T2 ON D.FBILLTYPEID = T2.FBILLTYPEID
|
LEFT JOIN {0}..T_BAS_BILLTYPE_L T3 ON T2.FBILLTYPEID = T3.FBILLTYPEID and FLOCALEID = 2052
|
LEFT JOIN {0}..V_BD_BUYER T4 ON D.FPURCHASERID =T4.FID
|
LEFT JOIN {0}..T_BD_SUPPLIER DS ON D.FSUPPLIERID = DS.FSUPPLIERID
|
LEFT JOIN {0}..T_ORG_ORGANIZATIONS DOO ON D.FPURCHASEORGID = DOO.FORGID
|
JOIN {0}..T_PUR_POORDERFIN E ON C.FID =E.FID
|
LEFT JOIN {0}..T_BD_CURRENCY EC ON E. FSETTLECURRID =EC.FCURRENCYID
|
WHERE b.hinterid in ({1}) and M.HERPInterID = 0
|
", kdTbaleName, hinterID);
|
DataTable dt = oCn.RunProcReturn(sql, "sltz").Tables[0];
|
List<string> fidList = new List<string>();
|
if (dt.Rows.Count > 0)
|
{
|
//foreach (DataRow dr in dt.Rows)
|
//{
|
// //采购订单下推生成送货单 时候 判断是否有生成采购订单变更单 如果有且变更单状态不为已审核 限制下推
|
// objJsonResult = TestPOOrder(dr["FEntryID"].ToString());
|
// if (objJsonResult.code == "0")
|
// return objJsonResult;
|
//}
|
foreach (DataRow dr in dt.Rows)
|
{
|
if (fidList.Contains(dr["HINTERID"].ToString()))
|
continue;
|
else
|
fidList.Add(dr["HINTERID"].ToString());
|
DataRow[] drs = dt.Select("HINTERID = " + dr["HINTERID"].ToString());
|
JObject model = new JObject();
|
string fTypeName = "SLD01_SYS";//标准采购订单类型
|
string ywTypeName = "CG";//标准业务类型
|
if (dr["FTYPENAME"].ToString().Contains("委外"))
|
{
|
fTypeName = "SLD03_SYS";
|
ywTypeName = "WW";
|
}
|
if (dr["FTYPENAME"].ToString().Contains("资产"))
|
{
|
fTypeName = "SLD04_SYS";
|
ywTypeName = "ZCCG";
|
}
|
model.Add("FBILLTYPEID", new JObject() { ["Fnumber"] = fTypeName }); //单据类型
|
model.Add("FBusinessType", ywTypeName); //业务类型
|
model.Add("FBILLNO", dr["HBillNo"].ToString()); //单据编号
|
model.Add("FDate", DateTime.Now.ToString("yyyy-MM-dd")); //通知日期
|
model.Add("FStockOrgId", new JObject() { ["Fnumber"] = dr["FRECEIVENUMBER"].ToString() }); // 收料组织
|
model.Add("FPurOrgId", new JObject() { ["Fnumber"] = dr["FPURCHASEORGNUMBER"].ToString() }); //采购组织
|
model.Add("FSupplierId", new JObject() { ["Fnumber"] = dr["FSUPPLIERNUMBER"].ToString() }); //供应商
|
model.Add("FPURCHASERID", new JObject() { ["Fnumber"] = dr["FPURCHASERNUMBER"].ToString() }); //采购员
|
model.Add("FOwnerTypeIdHead", "BD_Supplier");// 货主类型
|
model.Add("FOwnerIdHead", new JObject() { ["Fnumber"] = dr["FSUPPLIERNUMBER"].ToString() });//货主 供应商
|
JArray Fentity = new JArray();
|
foreach (var item in drs)
|
{
|
JObject FentityModel = new JObject();
|
FentityModel.Add("FMaterialId", new JObject() { ["Fnumber"] = item["FMATERIALNUMBER"].ToString() }); // 物料编码
|
FentityModel.Add("FUnitID", new JObject() { ["Fnumber"] = item["FUNITNUMBER"].ToString() }); // 单位
|
FentityModel.Add("FPreDeliveryDate", DateTime.Now.ToString("yyyy-MM-dd")); //预计到货日期
|
FentityModel.Add("FPriceUnitId", new JObject() { ["Fnumber"] = item["FUNITNUMBER"].ToString() }); // 计价单位
|
FentityModel.Add("FStockUnitID", new JObject() { ["Fnumber"] = item["FUNITNUMBER"].ToString() }); // 库存单位
|
FentityModel.Add("FStockID", new JObject() { ["Fnumber"] = "BJCK-SH.01.005" }); // 库存单位
|
FentityModel.Add("FActReceiveQty", Convert.ToDecimal(item["HQTY"])); // 供应商送货数量（提料计划数量 - 已生成送货单数量）
|
FentityModel.Add("FOwnerTypeId", "BD_OwnerOrg");//货主类型
|
FentityModel.Add("FOwnerID", new JObject() { ["Fnumber"] = dr["FPURCHASEORGNUMBER"].ToString() });//货主
|
FentityModel.Add("FSrcId", item["FID"].ToString());//源单内码
|
FentityModel.Add("FSRCFORMID", "PUR_PurchaseOrder");//源单类型
|
FentityModel.Add("FSrcBillNo", item["FBILLNO"].ToString());//源单单号
|
FentityModel.Add("FSRCENTRYID", item["FENTRYID"].ToString());//源单分录内码
|
FentityModel.Add("FORDERBILLNO", item["FBILLNO"].ToString());//源单单号
|
FentityModel.Add("FPOORDERENTRYID", item["FENTRYID"].ToString());//源单分录内码
|
FentityModel.Add("FSRMENTRYID", item["HENTRYID"].ToString());//SRM hentryid
|
FentityModel.Add("FPrice", item["FPRICE"].ToString());//单价
|
FentityModel.Add("FTaxPrice", item["FTAXPRICE"].ToString());//含税单价
|
FentityModel.Add("FEntryTaxRate", item["FTAXRATE"].ToString());//税率
|
|
JArray Fentity2 = new JArray();
|
JObject FentityModel2 = new JObject();
|
FentityModel2.Add("FDetailEntity_Link_FRULEID", "PUR_PurchaseOrder-PUR_ReceiveBill");
|
FentityModel2.Add("FDetailEntity_Link_FSTableName", "t_PUR_POOrderEntry");
|
FentityModel2.Add("FDetailEntity_Link_FSBillId", item["FID"].ToString());
|
FentityModel2.Add("FDetailEntity_Link_FSId", item["FEntryID"].ToString());
|
Fentity2.Add(FentityModel2);
|
FentityModel.Add("FDetailEntity_Link", Fentity2);
|
Fentity.Add(FentityModel);
|
}
|
model.Add("FDetailEntity", Fentity); //明细信息
|
|
JObject _FentityModel = new JObject();
|
_FentityModel.Add("FSettleOrgId", new JObject() { ["Fnumber"] = dr["FSETTLEORGNUMBER"].ToString() }); // 结算组织
|
_FentityModel.Add("FSettleCurrId", new JObject() { ["Fnumber"] = dr["FSETTLECURRNUMBER"].ToString() }); // 结算币别
|
_FentityModel.Add("FPricePoint", 0); // 定价时点
|
model.Add("FinanceEntity ", _FentityModel);//财务信息
|
JObject jsonRoot = new JObject()
|
{
|
["Creator"] = "",
|
["NeedUpDateFields"] = new JArray(),
|
["NeedReturnFields"] = new JArray(),
|
["IsDeleteEntry"] = "false",
|
["SubSystemId"] = "",
|
["IsVerifyBaseDataField"] = "false",
|
["Model"] = model
|
};
|
var loginRet = InvokeHelper.Login();
|
var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();
|
if (isSuccess == 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = loginRet;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
//LogService.Write("jsonRoot:" + jsonRoot.ToString());
|
var result = InvokeHelper.Save("PUR_ReceiveBill", jsonRoot.ToString());
|
//LogService.Write(result);
|
if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() == "TRUE")
|
{
|
//更新送货单 主表 ERP单据号 以及 ERP主内玛
|
string FBillNo = JObject.Parse(result)["Result"]["Number"].ToString();
|
FID = JObject.Parse(result)["Result"]["Id"].ToString();
|
string updateSql = string.Format(@"
|
update a set
|
a.HERPInterID = {0} ,
|
a.HERPBillNO ='{1}'
|
from Cg_POInStockBillMain a
|
join Cg_POInStockBillSub b on a.hinterid = b.hinterid
|
where b.HInterID = ({2})
|
and b. HSOURCEINTERID = {3}
|
and a.HERPInterID = 0
|
", FID, FBillNo, dr["HINTERID"].ToString(), dr["FID"].ToString());
|
oCn.RunProc(updateSql);
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = result;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
}
|
}
|
else
|
{
|
LogService.Write("收料通知单审核无数据：" + sql);
|
}
|
}
|
else //夏宝 ，更新erp信息
|
{
|
JObject jsonRoot = new JObject();
|
jsonRoot.Add("Creator", "");
|
jsonRoot.Add("NeedUpDateFields", new JArray());
|
jsonRoot.Add("NeedReturnFields", new JArray());
|
jsonRoot.Add("IsDeleteEntry", "false");
|
jsonRoot.Add("SubSystemId", "");
|
jsonRoot.Add("IsVerifyBaseDataField", "");
|
|
JObject jsonModel = new JObject();
|
jsonModel.Add("FID", FID);
|
JArray Entry = new JArray();
|
foreach (var item in list)
|
{
|
if (item.HSQty == 0)
|
continue;
|
JObject jsonFPOOrderEntry = new JObject();
|
jsonFPOOrderEntry.Add("FEntryID", item.FEntryID);
|
jsonFPOOrderEntry.Add("FActReceiveQty ", item.HSQty); ;
|
Entry.Add(jsonFPOOrderEntry);
|
}
|
jsonModel.Add("FDetailEntity", Entry);
|
jsonRoot.Add("Model", jsonModel);
|
var loginRet = InvokeHelper.Login();
|
var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();
|
if (isSuccess <= 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = loginRet;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
var result = InvokeHelper.Save("PUR_ReceiveBill", jsonRoot.ToString());
|
//LogService.Write(result);
|
if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
|
{
|
LogService.Write("收料通知单修改失败jsonRoot:" + jsonRoot.ToString());
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "金蝶收料通知单更新失败" + result;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
var json = new
|
{
|
Ids = FID,
|
};
|
//LogService.Write(json);
|
//提交
|
var _result = InvokeHelper.Submit("PUR_ReceiveBill", JsonConvert.SerializeObject(json));
|
var _saveObj = JObject.Parse(_result);
|
if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
|
{
|
LogService.Write("收料通知单提交失败jsonRoot:" + json.ToString());
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "金蝶收料通知单提交失败" + _result;
|
objJsonResult.data = null;
|
return objJsonResult;
|
|
}
|
//审核
|
_result = InvokeHelper.Audit("PUR_ReceiveBill", JsonConvert.SerializeObject(json));
|
_saveObj = JObject.Parse(_result);
|
if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
|
{
|
LogService.Write("收料通知单审核失败jsonRoot:" + json.ToString());
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "金蝶收料通知单审核失败jsonRoot" + _result;
|
objJsonResult.data = null;
|
return objJsonResult;
|
|
}
|
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "操作成功！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
//oCn.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "异常！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
}
|
|
/// <summary>
|
/// 到货确认 扫条码 校验
|
/// </summary>
|
/// <param name="HBarcode"></param>
|
/// <param name="HInterID"></param>
|
/// <returns></returns>
|
[Route("POStockInBillList/Get_ReciveBillByBarcode")]
|
[HttpGet]
|
public object Get_ReciveBillByBarcode(string HBarcode, string HInterID)
|
{
|
try
|
{
|
//var code = HBarcode.Split('#')[0];
|
//校验条码是否存在
|
string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);//客户名称
|
string sql = string.Empty;
|
if (FCusName.Contains("安瑞"))
|
sql = $"select HItemID,HSourceBillNo,HQty,HSourceInterID,HSourceEntryID from Gy_BarCodeBill where HSourceInterID ={HInterID} and HBarCode = '{HBarcode}' and HBarCodeType ='箱号内条码'";
|
else
|
sql = $"select HItemID,HSourceBillNo,HQty,HSourceInterID,HSourceEntryID from Gy_BarCodeBill where HSourceInterID ={HInterID} and HBarCode = '{HBarcode.Split('#')[0]}' and HQty = {HBarcode.Split('#')[1]}";
|
DataSet ds = oCn.RunProcReturn(sql, "H_v_SRM_POOrderBillList");
|
if (ds.Tables[0].Rows.Count == 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "条码不存在！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
}
|
else
|
{
|
//存入条码临时表
|
sql = $"delete from KF_PonderationBillMain_Temp Where HBillNo='{ds.Tables[0].Rows[0]["HSourceBillNo"]}' ";
|
oCn.RunProc(sql);
|
sql = string.Format(@"Insert into KF_PonderationBillMain_Temp
|
(HInterID,HBillNo,HBillType,HMaterID,HProcID,HWhID,HSCWHID
|
,HStockPlaceID,HOutStockPlaceID,HGroupID,HQty,HQtyMust,HPieceQty
|
,HAuxPropID,HBatchNo,HBarCode,HAddr,HMaker,HMakeDate
|
,HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo,HMTONo
|
,HSTOCKORGID,HOWNERID,HExpressNumber,HSubBillType
|
,HRelationInterID,HRelationEntryID,HRelationBillNo,HRedBlueFlag
|
,HCusID)
|
select HInterID,HSourceBillNo,HBillType,HMaterID,0,0,0
|
,0,0,0,HQty,HQty,0
|
,HAuxPropID,HBatchNo,'','','System',getdate()
|
,HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo,HMTONo
|
,HSTOCKORGID,HOWNERID,'',HBillType
|
,0,0,'',0
|
,0 from Gy_BarCodeBill
|
where HItemID = {0}", ds.Tables[0].Rows[0]["HItemID"]);
|
oCn.RunProc(sql);
|
}
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
objJsonResult.data = ds.Tables[0];
|
return objJsonResult;
|
//SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//string sql = $"select * from H_v_SRM_POInStockBillList where 单据号 ='{HBillno}'";
|
//ds = oCn.RunProcReturn(sql, "H_v_SRM_POInStockBillList");
|
//if (ds == null || ds.Tables[0].Rows.Count == 0)
|
//{
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "没有返回任何记录！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
//}
|
//else
|
//{
|
|
//}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
//收料通知单审核 审核提交
|
[Route("POStockInBillList/Exec_ReciveBillCheck")]
|
[HttpGet]
|
public json Exec_ReciveBillCheck(string HBarCode)
|
{
|
json objjson = new json();
|
try
|
{
|
//修改金蝶生产单的状态
|
//访问金蝶
|
var loginRet = InvokeHelper.Login();
|
var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();
|
|
if (isSuccess == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "操作失败,金蝶账号登录异常。" + loginRet;
|
objjson.data = null;
|
return objjson;
|
}
|
var json = new
|
{
|
//CreateOrgId = 0,
|
Numbers = HBarCode,
|
//Ids = (EntyID).Split('-')[0],
|
//PkEntryIds = (EntyID).Split('-')[1]
|
};
|
string result1 = string.Empty;
|
string result2 = string.Empty;
|
DataSet Ds = oCn.RunProcReturn("select FDOCUMENTSTATUS,FID from AIS20210811135644..T_PUR_RECEIVE where FBILLNO='" + HBarCode + "'", "AIS20210811135644..T_PUR_RECEIVE");
|
//判断当前收料通知单状态——已创建则先提交再审核、以提交则只审核
|
if (Ds.Tables[0].Rows[0][0].ToString() == "A" || Ds.Tables[0].Rows[0][0].ToString() == "D")
|
{
|
result1 = InvokeHelper.Submit("PUR_ReceiveBill", JsonConvert.SerializeObject(json));
|
result2 = InvokeHelper.Audit("PUR_ReceiveBill", JsonConvert.SerializeObject(json));
|
}
|
if (Ds.Tables[0].Rows[0][0].ToString() == "B")
|
{
|
result2 = InvokeHelper.Audit("PUR_ReceiveBill", JsonConvert.SerializeObject(json));
|
}
|
//判断审核是否成功
|
if (JObject.Parse(result2)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "审核收料通知单失败！单据号：" + HBarCode;
|
objjson.data = null;
|
return objjson;
|
}
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "审核成功！";
|
objJsonResult.data = 1;
|
return objjson;
|
}
|
catch (Exception e)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "没有返回任何记录！" + e.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
|
}
|
#endregion
|
|
#region PDA销售出库
|
//PDA销售出库整托删除
|
[Route("POStockInBillList/SellOutBillSDeleCode")]
|
[HttpGet]
|
public object SellOutBillSDeleCode(string HBarCode, string HInterID)
|
{
|
try
|
{
|
//根据条码在条码档案中找到对应的托条码，再在临时表中删除该托条码的全部记录
|
string sql = string.Format(@"delete from KF_PonderationBillMain_Temp where HBillType=1205 and HInterID=" + HInterID + " and HBarCode" +
|
" in (select HBarCode from Gy_BarCodeBill where HBarCode_Pack = (select HBarCode_Pack from Gy_BarCodeBill where HBarCode = '" + HBarCode + "'))");
|
oCn.RunProc(sql);
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "整托删除成功！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
}
|
#endregion
|
}
|
}
|
