using Newtonsoft.Json.Linq;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Web.Http;
|
using WebAPI.Models;
|
namespace WebAPI.Controllers
|
{
|
/**
|
* 裁切派工单
|
*/
|
public class Xs_CutWorkSendBillController : ApiController
|
{
|
private json objJsonResult = new json();
|
public DataSet ds = new DataSet();
|
public WebServer webserver = new WebServer();
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
|
|
/// <summary>
|
/// 扫描找货单号获取相关信息
|
/// </summary>
|
/// <returns></returns>
|
[Route("Xs_CutWorkSendBill/getHSEOrderBillNo")]
|
[HttpGet]
|
public object getHSEOrderBillNo(string HSEOrderBillNo)
|
{
|
if (HSEOrderBillNo == null || ("").Equals(HSEOrderBillNo))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "请输入找货单号！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
try
|
{
|
ds = getHSEOrderBillNo_s(HSEOrderBillNo);
|
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 = "1";
|
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>
|
/// <returns></returns>
|
[Route("Xs_CutWorkSendBill/set_SaveCutWorkSendBill")]
|
[HttpPost]
|
public object set_SaveCutWorkSendBill([FromBody] JObject oMain)
|
{
|
string oMainData = oMain["oMain"].ToString();
|
oMainData = oMainData.Substring(8, oMainData.Length - 9);
|
try
|
{
|
List<Xs_CutWorkSendBill> lsmain = new List<Xs_CutWorkSendBill>();
|
ListModels oListModels = new ListModels();
|
List<Xs_CutWorkSendBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Xs_CutWorkSendBill>>(oMainData);
|
int HYear = Pub_Class.ClsPub.isInt(DateTime.Now.Year);
|
int HPeriod = Pub_Class.ClsPub.isInt(DateTime.Now.Month);
|
string HBillType = "9191";
|
oCN.BeginTran();
|
var mainSql = "Insert Into Xs_CutWorkSendBillMain " +
|
"(HYear,HPeriod,HBillType,HInterID,HDate" +
|
",HBillNo,HMaker,HMakeDate,HMainSourceBillType" +
|
",HGroupID)" +
|
" values" +
|
"(" + HYear + "," + HPeriod + ",'" + HBillType + "'," + list[0].HInterID + ",GETDATE(),'"
|
+ list[0].HBillNo + "','" + list[0].HMaker + "',GETDATE(),'1401',"
|
+ list[0].HGroupID + ")";
|
oCN.RunProc(mainSql);
|
for (int i = 0; i < list.Count; i++)
|
{
|
var subSql = "Insert Into Xs_CutWorkSendBillSub " +
|
"(HInterID,HBillNo_bak,HSourceInterID,HSourceBillNo,HSourceBillType" +
|
",HSEOrderBillNo,HSEOrderInterID)" +
|
" values" +
|
"(" + list[i].HInterID + ",'" + list[i].HBillNo + "'," + list[i].HMainSourceInterID + ",'" + list[i].HMainSourceBillNo + "','1401','"
|
+ list[i].HMainSourceBillNo + "'," + list[i].HMainSourceInterID + ")";
|
oCN.RunProc(subSql);
|
//反写金蝶销售订单的裁切派工班组
|
var HGroupSql = "update AIS20200908101915zs..T_SAL_ORDERENTRY set F_XSDD_PGSJ=GETDATE(),F_XSDD_PGBZ=(select HName from Gy_Group where HItemID=" + list[i].HGroupID + ") where FID = " + list[i].HMainSourceInterID + "";
|
oCN.RunProc(HGroupSql);
|
}
|
oCN.Commit();
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "生成找货单成功！单据号为：" + list[0].HBillNo;
|
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>
|
/// <returns></returns>
|
[Route("Xs_CutWorkSendBill/List")]
|
[HttpGet]
|
public object List(string sWhere)
|
{
|
try
|
{
|
ds = List_s(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 = "1";
|
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;
|
}
|
}
|
|
|
|
#region sql语句
|
|
public static DataSet getHSEOrderBillNo_s(string HSEOrderBillNo)
|
{
|
return new SQLHelper.ClsCN().RunProcReturn(
|
"select FID HMainSourceInterID,FBILLNO HMainSourceBillNo,1 pages,'' HMaker from AIS20200908101915zs..T_SAL_ORDER where FBILLNO ='" + HSEOrderBillNo + "'"
|
, "AIS20200908101915zs..T_SAL_ORDER");
|
}
|
public static DataSet List_s(string sWhere)
|
{
|
return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Xs_CutWorkSendBillList where 1=1 " + sWhere , "h_v_Xs_CutWorkSendBillList");
|
}
|
|
|
#endregion
|
|
}
|
}
|
