using Model;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using WebAPI.BLL;
using WebAPI.Models;
namespace WebAPI.Controllers
{
public class MoveStockBillController : ApiController
{
public DBUtility.ClsPub.Enum_BillStatus BillStatus;
public Int64 HCusID;//客户ID
public Int64 HDeptID;//部门ID
public Int64 HWHID;//仓库ID
public Int64 HSPID;//仓位ID
public string HCusName;
public string HDeptName;
public string HWHName;
public string HSPName;
public Int64 HInterID;//本单ID
public string HBillNo;
public string HSourceBillNo;
public string HSourceBillType;
public string HBillType = "1207";//单据类型
public string sBillCode = "ICStockBill";
public string sTranType = "41";
public bool sRedBlueFlag = false;
public bool SourceFlag = false;
public bool sCheckflag = false;
public Int64 sThirdMaterID = 0;
public string sHSourceBillType = "3720";
public int iCount = 0; //查询次数
public bool bFirst = false;
public bool sGridClick = 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();
private JsonResult objJsonResult = new JsonResult();
private json objjson = new json();
///
/// 返回出入库条码临时表
///
///
[Route("MoveStockBill/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("MoveStockBill/get_InfoByBarCode_Source_Json")]
[HttpGet]
public object get_InfoByBarCode_Source_Json(string sCode, Int64 sInterID, string sBillNo, Double sQty, Int64 HWHID, Int64 HSPID, Int64 SCWhID, Int64 SCSPID)
{
try
{
string sErrMsg = "";
bool sBool = false;
oView = webserver.get_InfoByBarCode_Source(sCode, sInterID, ref sBool, ref sErrMsg);
model.HInterID = DBUtility.ClsPub.isLong(sInterID);
model.HBillNo = DBUtility.ClsPub.isStrNull(sBillNo);
model.HBillType = this.HBillType;
model.HMaker = DBUtility.ClsPub.CurUserName;
//
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 = DBUtility.ClsPub.isLong(HWHID);
model.HStockPlaceID = DBUtility.ClsPub.isLong(HSPID);
model.HSCWHID = SCWhID;
model.HOutStockPlaceID = SCSPID;
//model.HVDAPack = txtHVDAPack2.Text.Trim();
//model.HVDAMaterNum = txtHVDAMaterID.Text.Trim();
//model.HVDAQty = DBUtility.ClsPub.ObjToDouble(txtHVDAQty.Text.Trim());
//
model.HSourceInterID = oView.HSourceInterID;
model.HSourceEntryID = oView.HSourceEntryID;
model.HSourceBillNo = oView.HSourceBillNo;
model.HSourceBillType = oView.HSourceBillType;
model.HRedBlueFlag = false;
model.HPieceQty = 1;
//model.HSTOCKORGID = DBUtility.ClsPub.HORGANIZATIONSID;
//model.HOWNERID = DBUtility.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)
{
throw;
}
}
///
/// 生成调拨单
///
///
[Route("MoveStockBill/set_SaveMoveStockBill_Json")]
[HttpPost]
public object set_SaveMoveStockBill_Json([FromBody]JObject oMain)
{
var _value = oMain["oMain"].ToString();
string msg1 = _value.ToString();
try
{
List lsmain = new List();
ListModels oListModels = new ListModels();
lsmain = oListModels.getMoveStockBillMainByJson(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_SaveMoveStockBill(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;
}
}
///
///
///
///
[Route("MoveStockBill/GetKf_PonderationBillMain_Temp_Sum_Json")]
[HttpGet]
public Object GetKf_PonderationBillMain_Temp_Sum_Json(long HBillID, string HBillType, string sWhere)
{
try
{
ds = webserver.GetKf_PonderationBillMain_Temp_Sum(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("MoveStock/Delete_Json")]
[HttpGet]
//public object Delete_Json(long sInterID, long sMaterID,long sAuxPropID,string sMTONo,long sSourceInterID,long sSourceEntryID,string sBillType)
//{
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(sInterID,sMaterID,sAuxPropID,sMTONo,sSourceInterID,sSourceEntryID,sBillType, ref sErrMsg))
//{
if (webserver.set_DelPonderationBillMain_Temp_InterIDAndSource(HInterID, HMaterID, HAuxPropID, HMTONo, HSourceInterID, HSourceEntryID, sHBillType, ref sErrMsg))
{
objjson.code = "0";
objjson.count = 1;
objjson.Message = "删除成功!";
objjson.data = null;
return objjson;
}
else
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "删除失败!";
objjson.data = null;
return objjson;
}
}
catch (Exception)
{
objjson.code = "0";
objjson.count = 0;
objjson.Message = "删除失败!";
objjson.data = null;
return objjson;
}
}
}
}