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
|
{
|
public class OtherInStockController : ApiController
|
{
|
public Int64 HSupID;//供应商ID
|
public Int64 HDeptID;//部门ID
|
public Int64 HWhID;//仓库ID
|
public Int64 HSPID;//仓位ID
|
|
public string HSupName;
|
public string HDeptName;
|
public string HWhName;
|
public string HSPName;
|
|
public Int64 HInterID;//本单ID
|
public string HBillNo;
|
//public string HSourceBillNo;
|
public string HBillType = "1203";//单据类型
|
public string sBillCode = "ICStockBill";
|
public string sTranType = "10";
|
public bool sRedBlueFlag = false;
|
public bool SourceFlag = false;
|
//public string sSourceType = "1103";
|
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 WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS();
|
public WebS.WebService1 oWebs = new WebS.WebService1();
|
//public double sRelQty = 0;
|
// private DataBaseServices objDataBaseServices = new DataBaseServices();
|
private JsonResult objJsonResult = new JsonResult();
|
public ClsKf_ICStockBill_WMS oBar = new Model.ClsKf_ICStockBill_WMS();
|
// private string msgModel = "{{\"count\":{0},\"code\":{0},\"message\":\"{1}\",\"result\":{2}}}";
|
Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
|
public static string GetSession(string sMsg)
|
{
|
try
|
{
|
string s = Common.GetSession();
|
return s;
|
}
|
catch (Exception e)
|
{
|
return "";
|
}
|
}
|
|
/// <summary>
|
/// 一键扫码
|
/// </summary>
|
/// <returns></returns>
|
[Route("OtherInStockBill/get_InfoByBarCode_Source_Json")]
|
[HttpGet]
|
public Object get_CheckTypeByBarCode_Json(string sCode, Int64 sInterID, string sBillNo, string sMaker, Int64 WhID, Int64 SPID, Double sQty, bool sRedBlue, bool SourceFlag, string sSourceBillNo, string sSourceType, Int64 HOWNERID)
|
{
|
|
string sErrMsg = "";
|
bool bResult;
|
//获取系统参数
|
if (oSystemParameter.ShowBill(ref sErrMsg) == true)
|
{
|
if (oSystemParameter.omodel.WMS_CampanyName == "森楷") //系统参数 客户定制化名称 空白为通用
|
{
|
DataSet ds;
|
string sql = "select HBarCode,HSourceInterID,HSourceEntryID,HSourceBillNo from Gy_BarCodeBill with(nolock) where HBarCode = '" + sCode + "'";
|
string HDataBaseName = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "DataBaseName");//获取金蝶数据库名称
|
string HSourceBillNo = "";
|
Int64 HSourceInterID = 0;
|
|
ds = oCn.RunProcReturn(sql, "Gy_BarCodeBill");
|
//判断条码信息是否在条码档案中
|
if (ds == null || ds.Tables[0].Rows.Count < 1)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "条码档案中不存在条码编号：" + sCode;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
//获取入库申请单单号/主ID
|
HSourceBillNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HSourceBillNo"]);
|
HSourceInterID = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[0]["HSourceInterID"]);
|
//根据入库申请单单号判断单据信息是否已经同步到金蝶
|
sql = string.Format(@"select * from FROM {0}..T_STK_MISCELLANEOUS with(nolock) where FBILLNO = '" + HSourceBillNo + "'", HDataBaseName);
|
ds = oCn.RunProcReturn(sql, "T_STK_MISCELLANEOUS");
|
//入库申请单没有同步到金蝶则进行同步
|
if (ds == null || ds.Tables[0].Rows.Count < 1)
|
{
|
sql = "exec h_p_Kf_StockInRequestBillToErp " + HSourceInterID + "," + HSourceBillNo;
|
ds = oCn.RunProcReturn(sql, "h_p_Kf_StockInRequestBillToErp");
|
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
oCn.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "webapi入库申请单同步，获取信息失败";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
JObject model = new JObject();
|
model.Add("FBillType", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["FBillType"]) }); //单据类型
|
model.Add("FDate", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["日期"])); //单据日期
|
model.Add("FStockOrgId", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["库存组织代码"]) }); //库存组织代码
|
model.Add("FBillNo", HSourceBillNo); //单据号
|
model.Add("FStockDirect", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["库存方向"])); //库存方向
|
model.Add("FDEPTID", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["部门代码"]) }); //生产车间
|
model.Add("F_paez_Text", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["入库码单"])); //入库码单
|
model.Add("F_paez_Integer2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["筒子数"])); //筒子数
|
model.Add("F_paez_Integer1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["筒管只数"])); //筒管只数
|
model.Add("F_paez_Integer3", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["定长"])); //定长
|
model.Add("F_paez_BaseProperty4", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["筒重"])); //筒重
|
model.Add("F_paez_Base", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["工号"])); //工号
|
model.Add("F_paez_Combo", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["班次代码"])); //班次
|
model.Add("F_paez_BaseProperty1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["批号"])); //批号
|
model.Add("F_paez_Integer", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["箱数"])); //箱数
|
model.Add("F_paez_Decimal2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["总重"])); //总重
|
model.Add("F_paez_BaseProperty2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["成品编码"])); //成品编码
|
model.Add("F_paez_BaseProperty5", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["品名"])); //品名
|
model.Add("F_paez_Base1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["线号"])); //线号
|
|
model.Add("F_paez_BaseProperty", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["机台"])); //机台
|
model.Add("F_paez_Decimal", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["箱重"])); //箱重
|
//model.Add("F_WJUK_Text", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["来源"])); //来源
|
model.Add("FDEPTID1", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["部门代码"]) });//部门
|
model.Add("F_paez_BaseProperty6", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["捻向"])); //捻向
|
model.Add("F_paez_BaseProperty7", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["管色"])); //管色
|
model.Add("F_paez_Assistant", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["等级"])); //等级
|
model.Add("F_paez_Text11", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["最小箱号"])); //最小箱号
|
//model.Add("F_paez_Text3", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["文本"])); //文本
|
model.Add("F_paez_Text4", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["最大箱号"])); //最大箱号
|
//model.Add("F_paez_PrintTimes", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["打印次数"])); //打印次数
|
//model.Add("F_paez_Text5", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["线号"])); //条码打印
|
model.Add("F_paez_BaseProperty10", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["部门代码"]) }); //生产部门
|
model.Add("F_paez_Combo1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["是否内外贸"])); //是否内外贸
|
model.Add("F_paez_Combo2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["产品类型"])); //产品类型
|
model.Add("F_paez_Combo3", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["满版状态"])); //满版状态
|
model.Add("F_paez_BaseProperty11", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["规格型号"])); //规格型号
|
model.Add("F_paez_BaseProperty12", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["网别"])); //网别
|
model.Add("F_TFKO_Text4", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["箱号前缀"])); //箱号前缀
|
model.Add("F_paez_WB", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["网别"])); //网别1
|
|
|
JArray Fentity = new JArray();
|
foreach (DataRow item in ds.Tables[1].Rows)
|
{
|
JObject FentityModel = new JObject();
|
FentityModel.Add("FSrcEntryId", item["FSRCENTRYID"].ToString());// 源单分录内码、
|
FentityModel.Add("FIsNew", item["FIsNew"].ToString());// 源单类型
|
FentityModel.Add("FMaterialId", new JObject() { ["FNumber"] = item["FMaterialId"].ToString() }); // 物料编码
|
FentityModel.Add("FREPORTTYPE", new JObject() { ["FNumber"] = item["FREPORTTYPE"].ToString() }); // 生产汇报类型
|
FentityModel.Add("FProductType", item["FPRODUCTTYPE"].ToString());// 产品类型
|
FentityModel.Add("FUNITID", new JObject() { ["FNumber"] = item["FUNITID"].ToString() });//单位
|
FentityModel.Add("FWORKSHIPID", new JObject() { ["FNumber"] = item["FWORKSHOPID"].ToString() });//生产车间
|
FentityModel.Add("FMTONO", item["FMTONO"].ToString());// 计划跟踪号
|
FentityModel.Add("FCheckProduct", item["FCheckProduct"].ToString());// 产品检验
|
FentityModel.Add("FISENTRUST", item["FISENTRUST"].ToString());// 组织委托加工
|
FentityModel.Add("FSrcBillType", item["FSRCBILLTYPE"].ToString());// 源单类型
|
FentityModel.Add("FMOBILLNO", item["FMOBILLNO"].ToString());// 生产订单
|
FentityModel.Add("FSrcBillNo", item["FSrcBillNo"].ToString());// 源单编号
|
FentityModel.Add("FMoEntrySeq", item["FMoEntrySeq"].ToString());//生产订单行号
|
FentityModel.Add("FPROJECTNO", item["FPROJECTNO"].ToString());// 项目编号
|
FentityModel.Add("FSTDMANHOUR", item["FSTDMANHOUR"].ToString());// 单位标准工时
|
FentityModel.Add("FHRPREPARETIME", item["FHRPREPARETIME"].ToString());// 人员准备工时
|
FentityModel.Add("FMACPREPARETIME", item["FMACPREPARETIME"].ToString());// 机器准备工时
|
FentityModel.Add("FSrcInterId", item["FSrcInterId"].ToString());// 源单内码
|
FentityModel.Add("FSrcEntrySeq", item["FSrcEntrySeq"].ToString());// 源单行号
|
FentityModel.Add("FMoId", item["FMoId"].ToString());//生产订单内码
|
FentityModel.Add("FMoEntryId", item["FMoEntryId"].ToString());//生产订单分录号
|
FentityModel.Add("FBaseUnitID", new JObject() { ["FNumber"] = item["FBaseUnitID"].ToString() });//单位
|
FentityModel.Add("FSTOCKINORGID", new JObject() { ["FNumber"] = item["FSTOCKINORGID"].ToString() });//入库组织
|
FentityModel.Add("FOwnerTypeId", item["FOwnerTypeId"].ToString());// 货主类型
|
FentityModel.Add("FOwnerId", new JObject() { ["FNumber"] = item["FOwnerId"].ToString() });// 货主
|
FentityModel.Add("FSTOCKID", new JObject() { ["FNumber"] = item["FSTOCKID"].ToString() });//仓库
|
FentityModel.Add("FCostRate", item["FCOSTRATE"].ToString());// 成本权重
|
FentityModel.Add("FSNUNITID", new JObject() { ["FNumber"] = item["FSNUNITID"].ToString() });//序列号单位
|
FentityModel.Add("FISBACKFLUSH", item["FISBACKFLUSH"].ToString());// 倒冲领料
|
FentityModel.Add("FMOMAINENTRYID", item["FMOMAINENTRYID"].ToString());// 生产订单主产品分录
|
FentityModel.Add("FQAIP", item["FQAIP"].ToString());//紧急放行
|
FentityModel.Add("FREQSRC", item["FREQSRC"].ToString());//需求来源
|
FentityModel.Add("FREQBILLNO", item["FREQBILLNO"].ToString());//需求单据
|
FentityModel.Add("FREQBILLID", item["FREQBILLID"].ToString());// 需求单据内码
|
FentityModel.Add("FREQENTRYSEQ", item["FREQENTRYSEQ"].ToString());//需求单据行号
|
FentityModel.Add("FREQENTRYID", item["FREQENTRYID"].ToString());// 需求单据分录内码
|
FentityModel.Add("FBASEQUAQTY", item["FBASEQUAQTY"].ToString());// 基本单位合格数量
|
FentityModel.Add("FQUAQTY", item["FQUAQTY"].ToString());//合格数量
|
FentityModel.Add("FFailQty", item["FFailQty"].ToString());//不合格数量
|
FentityModel.Add("FScrapQty", item["FScrapQty"].ToString());//报废数量
|
FentityModel.Add("FBASEFINISHQTY", item["FBASEFINISHQTY"].ToString());//基本单位完成数量
|
FentityModel.Add("FFINISHQTY", item["FFINISHQTY"].ToString());//完成数量
|
FentityModel.Add("FLot", new JObject() { ["FNumber"] = item["FLot"].ToString() });//批号
|
FentityModel.Add("FBOMID", new JObject() { ["FNumber"] = item["FBOMID"].ToString() });// BOM版本
|
|
JArray Fentity2 = new JArray();
|
JObject FentityModel2 = new JObject();
|
FentityModel2.Add("FEntity_Link_FFlowId", item["FEntity_Link_FFlowId"].ToString());
|
FentityModel2.Add("FEntity_Link_FFlowLineId", item["FEntity_Link_FFlowLineId"].ToString());
|
FentityModel2.Add("FEntity_Link_FRuleId", item["FEntity_Link_FRuleId"].ToString());
|
FentityModel2.Add("FEntity_Link_FSTableName", item["FEntity_Link_FSTableName"].ToString());
|
FentityModel2.Add("FEntity_Link_FSBillId", item["FEntity_Link_FSBillId"].ToString());
|
FentityModel2.Add("FEntity_Link_FSId", item["FEntity_Link_FSId"].ToString());
|
Fentity2.Add(FentityModel2);
|
FentityModel.Add("FEntity_Link", Fentity2);
|
FentityModel.Add("FBFLowId", new JObject() { ["FID"] = item["FBFLOWID"].ToString() });
|
Fentity.Add(FentityModel);
|
}
|
model.Add("FEntity", Fentity); //明细信息
|
JObject jsonRoot = new JObject()
|
{
|
["Creator"] = "",
|
["NeedUpDateFields"] = new JArray(),
|
["NeedReturnFields"] = new JArray(),
|
//["IsDeleteEntry"] = "true",
|
//["SubSystemId"] = "",
|
//["IsVerifyBaseDataField"] = "false",
|
["IsDeleteEntry"] = "true",
|
["SubSystemId"] = "",
|
["IsVerifyBaseDataField"] = "true",
|
["IsEntryBatchFill"] = "false",
|
["ValidateFlag"] = "true",
|
["NumberSearch"] = "true",
|
["IsAutoAdjustField"] = "false",
|
["InterationFlags"] = "",
|
["IgnoreInterationFlag"] = "",
|
//["IsAutoSubmitAndAudit"] = true,//自动调用提交和审核功能
|
["Model"] = model
|
};
|
|
//从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码
|
if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
|
{
|
oCn.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "入库申请单同步获取登录账号密码失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
var loginRet = InvokeHelper.Login();
|
var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();
|
if (isSuccess == 0)
|
{
|
oCn.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "登录金蝶失败！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
string result = InvokeHelper.Save("PRD_MORPT", JsonConvert.SerializeObject(jsonRoot));//保存
|
|
if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
|
{
|
LogService.Write(JsonConvert.SerializeObject(jsonRoot));
|
oCn.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "入库申请单同步金蝶云失败！单号:" + HSourceBillNo + result + jsonRoot;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
//提交审核
|
string result1 = string.Empty;
|
string result2 = string.Empty;
|
var fID = JObject.Parse(result)["Result"]["Id"].ToString();
|
var fBillNo = JObject.Parse(result)["Result"]["Number"].ToString();
|
var json = new
|
{
|
Ids = fID,
|
};
|
if (oSystemParameter.omodel.Sc_ICMOReportBill_AutoCheck == "Y") //系统参数 自动审核
|
{
|
result1 = InvokeHelper.Submit("PRD_MORPT", JsonConvert.SerializeObject(json));//提交
|
result2 = InvokeHelper.Audit("PRD_MORPT", JsonConvert.SerializeObject(json));//审核
|
|
if (JObject.Parse(result1)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
|
{
|
oCn.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "入库申请单单号:" + ",提交失败" + result1;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
if (JObject.Parse(result2)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
|
{
|
oCn.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "入库申请单单号:" + ",审核失败" + result2;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
}
|
}
|
}
|
}
|
}
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "获取系统参数失败！ " + sErrMsg;
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
string sExpressNumber = "";
|
WebSoBar = oWebs.get_CheckTypeByBarCode_All(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 = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = DBUtility.ClsPub.sErrInfo;
|
objJsonResult.data = oBar;
|
return objJsonResult;
|
}
|
}
|
/// <summary>
|
/// 一键扫码(红字)
|
/// </summary>
|
/// <returns></returns>
|
[Route("OtherInStockBill/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)
|
{
|
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>
|
/// <returns></returns>
|
[Route("OtherInStockBill/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;
|
}
|
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="msg"></param>
|
/// <param name="msg2"></param>
|
/// <returns></returns>
|
[Route("OtherInStockBill/get_InfoByBarCode_Source_Json")]
|
[HttpGet]
|
public object get_InfoByBarCode_Source_Json(string sBarCode, Int64 sInterID, string sBillNo, Double sQty, Int64 whID, Int64 spID)
|
{
|
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 = whID;
|
model.HStockPlaceID = spID;
|
model.HSourceInterID = oView.HSourceInterID;
|
model.HSourceEntryID = oView.HSourceEntryID;
|
model.HSourceBillNo = oView.HSourceBillNo;
|
model.HSourceBillType = oView.HSourceBillType;
|
model.HRedBlueFlag = false;
|
model.HPieceQty = 1;
|
model.HSTOCKORGID = ClsPub.HORGANIZATIONSID;
|
model.HOWNERID = ClsPub.HORGANIZATIONSID;
|
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("OtherInStockBill/set_SaveOtherInBackBill_Json")]
|
[HttpPost]
|
public object set_SaveOtherInBackBill_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;
|
if (webserver.set_SaveOtherInBackBill_New(lsmain[0], 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>
|
/// 生成其他入库单
|
/// </summary>
|
/// <returns></returns>
|
//[Route("OtherInStockBill/set_SaveOtherInStockBill_Json")]
|
//[HttpPost]
|
//public object set_SaveOtherInStockBill_Json([FromBody]JObject oMain)
|
//{
|
// var _value = oMain["oMain"].ToString();
|
// string msg1 = _value.ToString();
|
|
// try
|
// {
|
// List<Model.ClsKf_OtherInBillMain> lsmain = new List<Model.ClsKf_OtherInBillMain>();
|
// ListModels oListModels = new ListModels();
|
// lsmain = oListModels.getOtherInBillMainByJson(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_OtherInBillMain websLsmain = new WebS.ClsKf_OtherInBillMain();
|
// 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;
|
// websLsmain.HSTOCKORGID = lsmain[0].HSTOCKORGID;
|
// websLsmain.HOWNERID = lsmain[0].HSTOCKORGID;
|
|
// WebS.ClsXt_SystemParameterMain oSystemParameterMain = new WebS.ClsXt_SystemParameterMain();
|
// if (webserver.set_SaveOtherInBill_New(websLsmain, sSourceBillType, oSystemParameterMain, 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("OtherInStockBill/set_SaveOtherInStockBill_Json")]
|
[HttpPost]
|
public object set_SaveOtherInStockBill_Json([FromBody]JObject oMain)
|
{
|
var _value = oMain["oMain"].ToString();
|
string msg1 = _value.ToString();
|
|
try
|
{
|
List<Model.ClsKf_OtherInBillMain> lsmain = new List<Model.ClsKf_OtherInBillMain>();
|
ListModels oListModels = new ListModels();
|
lsmain = oListModels.getOtherInBillMainByJson(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_OtherInBillMain websLsmain = new WebS.ClsKf_OtherInBillMain();
|
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;
|
websLsmain.HSTOCKORGID = lsmain[0].HSTOCKORGID;
|
websLsmain.HOWNERID = lsmain[0].HSTOCKORGID;
|
websLsmain.HKeeperID = lsmain[0].HKeeperID;
|
websLsmain.HSecManagerID = lsmain[0].HSecManagerID;
|
websLsmain.HBillerID = lsmain[0].HBillerID;
|
websLsmain.HBillType = "1203";//固定值
|
websLsmain.HBillSubType = lsmain[0].HBillSubType;
|
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
WebS.ClsXt_SystemParameterMain oSystemParameterMain = new WebS.ClsXt_SystemParameterMain();
|
if (oWebs.set_SaveOtherInBill_New(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //成功！
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //失败！
|
//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("OtherInBill/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;
|
// }
|
//}
|
|
|
//刷新表体 返回出入库条码临时表（领料出库简洁版）
|
[Route("OtherInStockBill/DisBillEntryList_Webs_New_Json1")]
|
[HttpGet]
|
public object DisBillEntryList_Webs_New_Json1(long HBillID, string HBillNo, string HBillType, string sMouldManagerCtl, string sFIFOCtl)
|
{
|
try
|
{
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
ds = oWebs.GetBillEntry_TmpList(HBillID, HBillNo, HBillType, ref sMouldManagerCtl, ref sFIFOCtl, ref DBUtility.ClsPub.sErrInfo);
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
//DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);
|
}
|
else
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "获取信息成功！";
|
objJsonResult.data = new
|
{
|
list = ds.Tables[0],
|
list2 = ds.Tables[4]
|
};
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "没有返回任何记录！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
[Route("OtherInBill/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("MateBill/Delete_Json1")]
|
[HttpGet]
|
public object Delete_Json1(long HInterID, long HMaterID, long HAuxPropID, string HMTONo, long HSourceInterID, long HSourceEntryID, string sHBillType)
|
{
|
string sErrMsg = string.Empty;
|
WebS.WebService1 oWebs = new WebS.WebService1();
|
try
|
{
|
if (oWebs.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("OtherInBill/DisBillEntryList_Mate_Webs_Json")]
|
[HttpGet]
|
public object DisBillEntryList_Mate_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("OtherInBillList/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;
|
}
|
|
}
|
|
[Route("OtherInBillList/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;
|
}
|
}
|
}
|
|
}
|
