using DBUtility;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
using SQLHelper;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Diagnostics;
|
using System.IO;
|
using System.Linq;
|
using System.Net;
|
using System.Net.Http;
|
using System.Text.RegularExpressions;
|
using System.Web;
|
using System.Web.Http;
|
using WebAPI.Code;
|
using WebAPI.Models;
|
using WebAPI.Utility;
|
|
namespace WebAPI.Controllers
|
{
|
public class POInStockController : ApiController
|
{
|
private JsonResult objJsonResult = new JsonResult();
|
private json objjson = new json();
|
//获取系统参数
|
Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
|
/// <summary>
|
/// 更新打印次数
|
/// </summary>
|
/// <param name="msg"></param>
|
/// <param name="msg2"></param>
|
/// <returns></returns>
|
[Route("UpdatePOInStockBillPrintQty")]
|
[HttpGet]
|
public object UpdatePOInStockBillPrintQty(string msg, string CurUserName)
|
{
|
try
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//写入 System_Log 操作日志表
|
WebAPIController.Add_Log("送货单打印", CurUserName, "送货单打印");
|
oCn.RunProc("exec H_p_SRM_POInStockBill_PrintQty " + msg.ToString());
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "更新打印次数成功！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "更新打印次数失败！" + e.ToString();
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
/// <summary>
|
/// 生成送货单单据号、日期
|
/// </summary>
|
/// <param name="sMsg"></param>
|
/// <returns></returns>
|
[Route("GetNewPOInStockBillNo")]
|
[HttpGet]
|
public object GetNewPOInStockBillNo(string sMsg, string sMsg3)
|
{
|
try
|
{
|
DataSet ds = new DataSet();
|
DataSet da = new DataSet();
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
if (DBUtility.ClsPub.isLong(sMsg) == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败！无效的主键";
|
objjson.data = null;
|
return objjson;
|
}
|
if (DBUtility.ClsPub.isStrNull(sMsg3) == "")
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败！无效的单据类型";
|
objjson.data = null;
|
return objjson;
|
}
|
string HBillNo, HInnerBillNo, HDate;
|
string HInterID = "-1";
|
HBillNo = DBUtility.ClsPub.CreateBillCode_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo, true);
|
HInnerBillNo = DBUtility.ClsPub.CreateBillCode_SRMProd("777", ref DBUtility.ClsPub.sExeReturnInfo, true);//送货单号
|
HDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
|
|
da = oCn.RunProcReturn("exec h_p_Xt_GetMaxBillID '" + 1103 + "'", "h_p_Xt_GetMaxBillID");
|
if (da == null || da.Tables[0].Rows.Count == 0)
|
{
|
HInterID = "1";
|
}
|
else
|
{
|
HInterID = ClsPub.isStrNull(da.Tables[0].Rows[0]["HBillNo"]);
|
}
|
|
//HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
|
//创建临时表
|
DataTable dt = new DataTable();
|
//创建表中的列
|
dt.Columns.Add("HBillNo", typeof(string));//添加列
|
dt.Columns.Add("HInnerBillNo", typeof(string));//添加列
|
dt.Columns.Add("HDate", typeof(string));//添加列
|
dt.Columns.Add("HInterID", typeof(string));//添加列
|
DataRow row = dt.NewRow();
|
//给列赋值
|
row["HBillNo"] = HBillNo;
|
row["HInnerBillNo"] = HInnerBillNo;
|
row["HDate"] = HDate;
|
row["HInterID"] = HInterID;
|
//把有值的列添加到表
|
dt.Rows.Add(row);
|
//把表添加到dataset
|
ds.Tables.Add(dt);
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "获取失败！没有返回任何记录";
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 10000;
|
objjson.Message = "获取成功";
|
objjson.data = ds.Tables[0];
|
return objjson;
|
}
|
}
|
catch (Exception e)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + e.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
/// <summary>
|
/// 生成送货单表头信息
|
/// </summary>
|
/// <param name="sMsg"></param>
|
/// <returns></returns>
|
[Route("GetNewPOInStockShowBillMain")]
|
[HttpGet]
|
public object GetNewPOInStockShowBillMain(string sMsg, string sMsg3)
|
{
|
try
|
{
|
DataSet ds;
|
string ShowItem = " * ";//显示的字段
|
if (DBUtility.ClsPub.isLong(sMsg) == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败！无效的主键";
|
objjson.data = null;
|
return objjson;
|
}
|
if (DBUtility.ClsPub.isStrNull(sMsg3) == "")
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败！无效的单据类型";
|
objjson.data = null;
|
return objjson;
|
}
|
ds = ShowNewBillMainTo(DBUtility.ClsPub.isLong(sMsg), DBUtility.ClsPub.isStrNull(sMsg3), ShowItem, ref DBUtility.ClsPub.sExeReturnInfo);
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 1;
|
objjson.Message = "获取失败！没有返回任何记录";
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 10000;
|
objjson.Message = "获取成功";
|
objjson.data = ds.Tables[0];
|
return objjson;
|
}
|
}
|
catch (Exception e)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + e.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
/// <summary>
|
/// 生成送货单明细表体信息
|
/// </summary>
|
/// <param name="sMsg"></param>
|
/// <param name="sMsg2"></param>
|
/// <returns></returns>
|
[Route("GetNewPOInStockShowBillSub")]
|
[HttpGet]
|
public object GetNewPOInStockShowBillSub(string sMsg, string sMsg2, string sMsg3)
|
{
|
|
try
|
{
|
DataSet ds = null;
|
string ShowItem = " * ";//显示的字段
|
if (DBUtility.ClsPub.isLong(sMsg) == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败！无效的主键";
|
objjson.data = null;
|
return objjson;
|
}
|
if (DBUtility.ClsPub.isStrNull(sMsg3) == "")
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败！无效的单据类型";
|
objjson.data = null;
|
return objjson;
|
}
|
ds = ShowNewBillSubTo(DBUtility.ClsPub.isLong(sMsg), DBUtility.ClsPub.isStrNull(sMsg2), DBUtility.ClsPub.isStrNull(sMsg3), ShowItem, ref DBUtility.ClsPub.sExeReturnInfo);
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败";
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 10000;
|
objjson.Message = "获取成功";
|
objjson.data = ds.Tables[0];
|
return objjson;
|
}
|
//return s;
|
}
|
catch (Exception e)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + e.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
|
/// <summary>
|
/// 更新物流单号
|
/// </summary>
|
/// <returns></returns>
|
[Route("SavePOInStock")]
|
[HttpGet]
|
public object SavePOInStock(string HmainId, string HDeliveryNo)
|
{
|
try
|
{
|
string sql = $"update Cg_POInStockBillMain set HDeliveryNo ='{HDeliveryNo}' where HInterID in ({HmainId})";
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
oCn.RunProc(sql);
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "操作成功！";
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
/// <summary>
|
/// 保存送货单
|
/// </summary>
|
/// <param name="msg"></param>
|
/// <param name="msg2"></param>
|
/// <returns></returns>
|
[Route("SaverPOInStock")]
|
[HttpPost]
|
public object SaverPOInStock([FromBody] JObject msg)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
var _value = msg["msg"].ToString();
|
string msg1 = _value.ToString();
|
string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
|
string msg2 = sArray[0].ToString();
|
string msg3 = sArray[1].ToString();
|
string UserName = "";
|
string HOpType = "";
|
if (sArray.Length > 2)
|
{
|
HOpType = sArray[2].ToString();
|
}
|
|
ListModels oListModels = new ListModels();
|
try
|
{
|
//获取客户名称
|
string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);
|
DAL.ClsCg_POInStockBill oBill = new DAL.ClsCg_POInStockBill();
|
List<Model.ClsCg_POInStockBillMain> lsmain = new List<Model.ClsCg_POInStockBillMain>();
|
msg2 = msg2.Replace("\\", "");
|
msg2 = msg2.Replace("\n", ""); //\n
|
lsmain = oListModels.getObjectByJson_POInStockMain(msg2);
|
|
/* 添加编辑功能后屏蔽
|
string billno = lsmain[0].HBillNo;
|
string yzsql = $"select count(*) as rows from Cg_POInStockBillMain where HBillNo = '{billno}'";
|
DataTable yzdt = oCn.RunProcReturn(yzsql, "yzds").Tables[0];
|
if (Convert.ToInt32(yzdt.Rows[0][0]) > 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "保存成功！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
*/
|
|
//根据收料通知单号校验是否已生成
|
//string jysql = $"select * from ":
|
foreach (Model.ClsCg_POInStockBillMain oItem in lsmain)
|
{
|
//oItem.HMaker = "";
|
UserName = oItem.HMaker;
|
oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
|
oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
|
//oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));
|
oItem.HCurID = 1;
|
oItem.HExRate = 1;
|
oItem.HMainSourceInterID = oItem.HInterID;
|
//oItem.HInterID = 0;
|
//oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (FCusName.Contains("安瑞")) //系统参数 客户定制化名称 空白为通用
|
{
|
if (DBUtility.ClsPub.isStrNull(oItem.HDHDate) == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！没有填写预计到货日期，无法保存！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
if (DBUtility.ClsPub.isStrNull(oItem.HDeliveryNo) == "")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！没有填写物流单号，无法保存！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
|
oBill.omodel = oItem;
|
}
|
//表体数据
|
//按 },{来拆分数组 //去掉【和】
|
msg3 = msg3.Substring(1, msg3.Length - 2);
|
msg3 = msg3.Replace("\\", "");
|
msg3 = msg3.Replace("\n", ""); //\n
|
//msg2 = msg2.Replace("'", "’");
|
List<Model.ClsCg_POInStockBillSub> ls = new List<Model.ClsCg_POInStockBillSub>();
|
|
ls = oListModels.getObjectByJson_POInStockSub(msg3);
|
int i = 0;
|
foreach (Model.ClsCg_POInStockBillSub oItemSub in ls)
|
{
|
//if (FCusName.Contains("凯贝奈特")) //系统参数 客户定制化名称 空白为通用
|
//{
|
// if (oItemSub.HBatChNo.Length != 8 || Regex.IsMatch(oItemSub.HBatChNo, @"^[0-9]+$") == false)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！第" + i.ToString() + "行 生产日期D/C 格式错误无法保存！正确格式为8位数的纯数字日期";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
|
// //获取年月日
|
// string year = oItemSub.HBatChNo.Substring(0, 4);
|
// string month = oItemSub.HBatChNo.Substring(4, 2);
|
// string day = oItemSub.HBatChNo.Substring(6, 2);
|
|
// //验证合法性
|
// if (Convert.ToInt32(year) < 1900 || Convert.ToInt32(year) > 2100)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！第" + i.ToString() + "行 生产日期D/C 日期不合法无法保存！正确格式为8位数的纯数字日期";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
// if (Convert.ToInt32(month) > 12 || Convert.ToInt32(day) > 31)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "保存失败！第" + i.ToString() + "行 生产日期D/C 日期不合法无法保存！";
|
// objJsonResult.data = 1;
|
// return objJsonResult;
|
// }
|
|
//}
|
|
//判断采购订单状态
|
objJsonResult = TestPOOrder(oItemSub.HPOOrderEntryID.ToString());
|
|
if (objJsonResult.code == "0")
|
return objJsonResult;
|
//增加判断 送货数量超出采购订单数量
|
i++;
|
if (oItemSub.HQty <= 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！第" + i.ToString() + "行数量不大于0无法保存！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
if (Convert.ToDecimal(oItemSub.HQty) > Convert.ToDecimal(oItemSub.HRQty))
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！第" + i.ToString() + "行数量不能大于未关联数量！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
oItemSub.HEntryID = i;
|
oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
|
//oItemSub.HRemark = "";
|
oItemSub.HCloseMan = "";
|
oItemSub.HCloseType = false;
|
oBill.DetailColl.Add(oItemSub);
|
}
|
//保存前判断(单据号重复，笔录项目)
|
//保存
|
//保存完毕后处理
|
bool bResult;
|
|
oCn.BeginTran(); //开始事物
|
|
if (HOpType.ToString() == "edit"/*oBill.omodel.HInterID != 0 && oBill.omodel.HInterID.ToString() != null && oBill.omodel.HInterID.ToString() != "undefined"*/)
|
{
|
bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
|
}
|
else
|
{
|
bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
|
}
|
if (bResult)
|
{
|
oCn.Commit(); //提交事物
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "保存成功！";
|
WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
else
|
{
|
oCn.RollBack(); //回滚事物
|
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
catch (Exception e)
|
{
|
oCn.RollBack(); //回滚事物
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！" + e.ToString();
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
|
/// <summary>
|
/// 送货单列表
|
/// </summary>
|
/// <param name="msg"></param>
|
/// <param name="NowPage"></param>
|
/// <param name="OnePage"></param>
|
/// <returns></returns>
|
[Route("GetPOInStockBill")]
|
[HttpPost]
|
//送货单列表
|
public object GetPOInStockBill([FromBody] JObject msg)
|
{
|
string HSupIDs = msg["HSupIDs"].ToString(); string sqlWhere = msg["sqlWhere"].ToString();
|
try
|
{
|
Stopwatch sw = new Stopwatch();
|
sw.Start();//开始计时
|
string VsWhere = "";
|
string PcWhere = "";
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet ds;
|
//其他过滤
|
string sql = " Where hsupid in (" + HSupIDs.Trim() + ")" + sqlWhere;
|
//转换特殊字符
|
if (Common.SQLtoChange(sql, ref VsWhere, ref PcWhere) == false)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "转换特殊字符失败";
|
objjson.data = null;
|
return objjson;
|
}
|
//获取总行数
|
//Int64 RowTotal = Common.GetRowTotal("H_v_SRM_POInStockBillList", VsWhere, ref DBUtility.ClsPub.sExeReturnInfo);
|
//获取返回数据
|
ds = oCn.RunProcReturn("exec H_p_SRM_POInStockBillList '" + PcWhere + "'", "H_p_SRM_POInStockBillList");
|
|
List<object> columnNameList = new List<object>();
|
foreach (DataColumn col in ds.Tables[0].Columns)
|
{
|
Type dataType = col.DataType;
|
string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
|
columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
|
}
|
|
LogService.Write("送货单列表加载sql:exec H_p_SRM_POInStockBillList '" + PcWhere + "'");
|
LogService.Write("数据查询返回" + sw.Elapsed);
|
sw.Stop();//结束计时
|
objjson.code = "0";
|
objjson.count = 10000;
|
objjson.Message = "获取成功";
|
objjson.data = ds.Tables[0];
|
objjson.list = columnNameList;
|
return objjson;
|
}
|
catch (Exception e)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + e.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
|
}
|
/// <summary>
|
/// 送货单表头信息
|
/// </summary>
|
/// <param name="sMsg"></param>
|
/// <returns></returns>
|
[Route("GetPOInStockShowBillMain")]
|
[HttpGet]
|
public object GetPOInStockShowBillMain(string sMsg)
|
{
|
try
|
{
|
DataSet ds;
|
string s = "";
|
string ShowItem = " * ";//显示的字段
|
if (DBUtility.ClsPub.isLong(sMsg) == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败";
|
objjson.data = null;
|
return objjson;
|
}
|
DAL.ClsCg_POInStockBill oClsCg_POInStockBill = new DAL.ClsCg_POInStockBill();
|
ds = oClsCg_POInStockBill.ShowBillMainTo(DBUtility.ClsPub.isLong(sMsg), ShowItem, ref DBUtility.ClsPub.sExeReturnInfo);
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败";
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 10000;
|
objjson.Message = "获取成功";
|
objjson.data = ds.Tables[0];
|
return objjson;
|
}
|
}
|
catch (Exception e)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + e.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
/// <summary>
|
/// 送货单明细表体信息
|
/// </summary>
|
/// <param name="sMsg"></param>
|
/// <param name="sMsg2"></param>
|
/// <returns></returns>
|
[Route("GetPOInStockShowBillSub")]
|
[HttpGet]
|
public object GetPOInStockShowBillSub(string sMsg)
|
{
|
//string sMsg="28";
|
//string sMsg2 = "28,5;"
|
try
|
{
|
DataSet ds = null;
|
//string s = "";
|
//string sMsg3 = "'" + sMsg2 + "'";
|
string ShowItem = " * ";//显示的字段
|
if (DBUtility.ClsPub.isLong(sMsg) == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败";
|
objjson.data = null;
|
return objjson;
|
}
|
DAL.ClsCg_POInStockBill oClsCg_POInStockBill = new DAL.ClsCg_POInStockBill();
|
ds = oClsCg_POInStockBill.ShowBillSubTo(DBUtility.ClsPub.isLong(sMsg), ShowItem, ref DBUtility.ClsPub.sExeReturnInfo);
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
//return DBUtility.ClsPub.sExeReturnInfo;
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败";
|
objjson.data = null;
|
return objjson;
|
}
|
else
|
{
|
objjson.code = "0";
|
objjson.count = 10000;
|
objjson.Message = "获取成功";
|
objjson.data = ds.Tables[0];
|
return objjson;
|
}
|
//return s;
|
}
|
catch (Exception e)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "获取失败" + e.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
[Route("AuditPOInStockBill")]
|
[HttpGet]
|
public object AuditPOInStockBill(string HInterID, string CurUserName, string HBillNo)
|
{
|
json objjson = new json();
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
try
|
{
|
//采购订单 生成送货单列表
|
if (!String.IsNullOrEmpty(HBillNo))
|
HInterID = GetHinterIDByBillNo(HBillNo, "Aduit").ToString();
|
if (HInterID == "0")
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "操作失败,请先保存订单";
|
objjson.data = null;
|
return objjson;
|
}
|
var kdTbaleName = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "DataBaseName");
|
string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);
|
string sql = string.Empty;
|
DataTable dt = new DataTable();
|
List<string> fidList = new List<string>();
|
string parameterSql = $"select HValue from Xt_SystemParameter where HKey ='Cg_POInStockBill_ErpAduit'";
|
//var HValue = oCn.RunProcReturn(parameterSql, "dt").Tables[0].Rows[0][0].ToString();
|
string HValue = "Y";
|
string CustomFields = "";//自定义字段
|
|
oCn.BeginTran(); //开始事物
|
|
if (HValue == "Y")
|
{
|
//==================================== Begin 送货单审核前控制 Begin ====================================
|
DataSet ds;
|
|
string[] sArray = HInterID.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
|
|
for (int i = 0; i < sArray.Length; i++)
|
{
|
ds = oCn.RunProcReturn("exec h_p_SRM_Cg_POInStockBill_BeforeCheckCtrl " + sArray[i] + ",'" + HBillNo + "','" + CurUserName + "'", "h_p_SRM_Cg_POInStockBill_BeforeCheckCtrl");
|
if (ds == null)
|
{
|
oCn.RollBack(); //回滚事物
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "审核前判断失败！无数据返回";
|
objjson.data = null;
|
return objjson;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCn.RollBack(); //回滚事物
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemarkBack"]);
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
|
//====================================== End 送货单审核前控制 End ======================================
|
if (FCusName == "夏宝电器")
|
{
|
// 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,D.F_XBKF_COMBO1,CR.FPRICE,CR.FTAXPRICE,CR.FTAXRATE,D.FPURCHASERID,isnull(T4.FNUMBER,'') AS FPURCHASERNUMBER,D.F_XBKF_BASE1,isnull(T5.FNUMBER,'') AS FRECEIVEMENNUMBER
|
//,C.FGiveAway AS FGiveAway
|
//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}.h_v_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_HR_EMPINFO T5 ON D.F_XBKF_BASE1 = T5.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);
|
// dt = oCn.RunProcReturn(sql, "sltz").Tables[0];
|
|
sql = string.Format($"exec h_p_Cg_POInStock_GetInfoToERP '{HInterID}'");
|
dt = oCn.RunProcReturn(sql, "sltz").Tables[0];
|
|
if (dt.Rows.Count > 0)
|
{
|
foreach (DataRow dr in dt.Rows)
|
{
|
if (fidList.Contains(dr["FID"].ToString() + dr["HINTERID"].ToString()))
|
continue;
|
else
|
fidList.Add(dr["FID"].ToString() + dr["HINTERID"].ToString());
|
|
DataRow[] drs = dt.Select("FID = " + dr["FID"].ToString() + " and 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("F_xbkf_Base", new JObject() { ["Fnumber"] = dr["FRECEIVEMENNUMBER"].ToString() }); //收料员
|
model.Add("FOwnerTypeIdHead", "BD_Supplier");// 货主类型
|
model.Add("FOwnerIdHead", new JObject() { ["Fnumber"] = dr["FSUPPLIERNUMBER"].ToString() });//货主 供应商
|
model.Add("F_XBKF_COMBO", dr["F_xbkf_Combo1"].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("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());//税率
|
FentityModel.Add("FGiveAway", item["FGiveAway"].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)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = loginRet;
|
objjson.data = null;
|
return objjson;
|
}
|
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();
|
string 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
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = result;
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
}
|
}
|
else if (FCusName == "凯贝奈特") {
|
CustomFields = ",D.F_aaaa_Base";
|
|
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
|
,B.HExpressNumberSub,B.HExpressSupplierSub,B.HRemark,B.HPlanArrivalDate,B.HBoxNumber,B.HBatChNo,D.FBILLTYPEID
|
,isnull(VW.FNUMBER,'') AS FReceiverNUMBER,isnull(B.HKFDate,'') As FProduceDate,B.HTAXPRICE_T AS F_AAAA_PRICE1
|
,C.FGiveAway AS FGiveAway
|
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
|
LEFT JOIN {0}..V_BD_WAREHOUSEWORKERS_L VWL ON M.HReceiveGoodsMan = VWL.FNAME
|
LEFT JOIN {0}..V_BD_WAREHOUSEWORKERS VW ON VWL.fid = VW.fid
|
WHERE b.hinterid in ({1}) and M.HERPInterID = 0
|
", kdTbaleName, HInterID, CustomFields);
|
dt = oCn.RunProcReturn(sql, "sltz").Tables[0];
|
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";
|
}
|
if (FCusName == "凯贝奈特")
|
{
|
//1厂
|
if (dr["FBILLTYPEID"].ToString() == "60cfe60fa16dd8")
|
{
|
fTypeName = "SLD08_SYS";
|
}
|
//2厂
|
if (dr["FBILLTYPEID"].ToString() == "60cfe634a1708f")
|
{
|
fTypeName = "SLD09_SYS";
|
}
|
//3厂
|
if (dr["FBILLTYPEID"].ToString() == "83d822ca3e374b4ab01e5dd46a0062bd")
|
{
|
fTypeName = "SLD10_SYS";
|
}
|
//标准采购订单
|
if (dr["FBILLTYPEID"].ToString() == "65a5124e3be263")
|
{
|
fTypeName = "SLD01_SYS";
|
}
|
model.Add("FReceiverId", new JObject() { ["Fnumber"] = dr["FReceiverNUMBER"].ToString() }); //收料员
|
}
|
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("FLot", new JObject() { ["Fnumber"] = item["HBatChNo"].ToString() }); // 批号
|
FentityModel.Add("FProduceDate", item["FProduceDate"].ToString());//生产日期
|
FentityModel.Add("F_aaaa_Price1", item["F_aaaa_Price1"].ToString());//含税重量单价/吨
|
|
FentityModel.Add("F_bsv_Text1", item["HExpressSupplierSub"].ToString());//物流单位 (瑞琪)
|
FentityModel.Add("F_bsv_Text2", item["HExpressNumberSub"].ToString());//物流单号 (瑞琪)
|
FentityModel.Add("FDescription", item["HRemark"].ToString());//表体备注 (瑞琪)
|
FentityModel.Add("F_bsv_dhrq", item["HPlanArrivalDate"].ToString());//到货日期 (瑞琪)
|
FentityModel.Add("F_bsv_xh", item["HBoxNumber"].ToString());//箱号 (瑞琪)
|
FentityModel.Add("FPrice", item["FPRICE"].ToString());//单价
|
FentityModel.Add("FTaxPrice", item["FTAXPRICE"].ToString());//含税单价
|
FentityModel.Add("FEntryTaxRate", item["FTAXRATE"].ToString());//税率
|
FentityModel.Add("FGiveAway", item["FGiveAway"].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)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = loginRet;
|
objjson.data = null;
|
return objjson;
|
}
|
//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();
|
string 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
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = result;
|
objjson.data = null;
|
return objjson;
|
}
|
|
}
|
}
|
else
|
{
|
LogService.Write("收料通知单审核无数据：" + sql);
|
}
|
}
|
else
|
{
|
// 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
|
//,B.HExpressNumberSub,B.HExpressSupplierSub,case when B.HRemark = 'CLOUD导入' then '' else B.HRemark end HRemark,B.HPlanArrivalDate,B.HBoxNumber,B.HBatChNo,D.FBILLTYPEID
|
//,CU2.FNUMBER AS FPRICEUNITNUMBER
|
//,C.FGiveAway AS FGiveAway
|
//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
|
//LEFT JOIN {0}..T_PUR_POORDERENTRY_F CF ON C.FID = CF.FID AND C.FENTRYID = CF.FENTRYID
|
//LEFT JOIN {0}..T_BD_UNIT CU2 ON CF.FPRICEUNITID =CU2.FUNITID
|
// WHERE b.hinterid in ({1}) and M.HERPInterID = 0
|
//", kdTbaleName, HInterID, CustomFields);
|
|
sql = string.Format($"exec h_p_Cg_POInStock_GetInfoToERP '{HInterID}'");
|
dt = oCn.RunProcReturn(sql, "sltz").Tables[0];
|
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());//税率
|
FentityModel.Add("FLot", new JObject() { ["Fnumber"] = item["HBatChNo"].ToString() }); // 批号
|
|
FentityModel.Add("F_bsv_Text1", item["HExpressSupplierSub"].ToString());//物流单位 (瑞琪)
|
FentityModel.Add("F_bsv_Text2", item["HExpressNumberSub"].ToString());//物流单号 (瑞琪)
|
FentityModel.Add("FDescription", item["HRemark"].ToString());//表体描述 (瑞琪)
|
|
if (FCusName == "添康科技")
|
{
|
FentityModel.Add("F_RXSD_TEXT_QTR", item["HPOOREntryRemark"].ToString());//表体备注
|
}
|
|
FentityModel.Add("F_bsv_dhrq", item["HPlanArrivalDate"].ToString());//到货日期 (瑞琪)
|
FentityModel.Add("F_bsv_xh", item["HBoxNumber"].ToString());//箱号 (瑞琪)
|
FentityModel.Add("FGiveAway", item["FGiveAway"].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)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = loginRet;
|
objjson.data = null;
|
return objjson;
|
}
|
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")
|
{
|
LogService.Write("SRM-收料通知单审核失败JSON：" + jsonRoot.ToString());
|
//更新送货单 主表 ERP单据号 以及 ERP主内玛
|
string FBillNo = JObject.Parse(result)["Result"]["Number"].ToString();
|
string 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
|
{
|
LogService.Write("SRM-收料通知单审核失败JSON：" + jsonRoot.ToString() );
|
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = result;
|
objjson.data = null;
|
return objjson;
|
}
|
|
}
|
}
|
else
|
{
|
LogService.Write("收料通知单审核无数据：" + sql);
|
}
|
}
|
//==================================== Begin 送货单审核后控制 Begin ====================================
|
for (int i = 0; i < sArray.Length; i++)
|
{
|
ds = oCn.RunProcReturn("exec h_p_SRM_Cg_POInStockBill_AfterCheckCtrl " + sArray[i] + ",'" + HBillNo + "','" + CurUserName + "'", "h_p_SRM_Cg_POInStockBill_AfterCheckCtrl");
|
if (ds == null)
|
{
|
oCn.RollBack(); //回滚事物
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "审核后判断失败！无数据返回";
|
objjson.data = null;
|
return objjson;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
oCn.RollBack(); //回滚事物
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemarkBack"]);
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
//====================================== End 送货单审核后控制 End ======================================
|
}
|
|
////更新物流字段 （瑞与琪）
|
//oCn.RunProc("exec h_p_Cg_LocalToKingDee_POInStock " + HBillNo + "," + HInterID);
|
|
//更新主表状态 审核
|
sql = string.Format(@"update Cg_POInStockBillMain set
|
HBillStatus = 2 ,
|
HChecker ='{0}',
|
HCheckDate = getdate()
|
where HInterID in ({1})", CurUserName, HInterID);
|
oCn.RunProc(sql);
|
|
oCn.Commit(); //提交事物
|
|
objjson.code = "1";
|
objjson.count = 1;
|
objjson.Message = "操作成功";
|
objjson.data = null;
|
return objjson;
|
}
|
catch (Exception ex)
|
{
|
oCn.RollBack(); //回滚事物
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "操作失败" + ex.Message.ToString();
|
objjson.data = null;
|
return objjson;
|
}
|
|
}
|
[Route("GetHinterID")]
|
[HttpGet]
|
public object GetHinterID(string HBillNo)
|
{
|
int HinterID = GetHinterIDByBillNo(HBillNo, "Print");
|
if (HinterID == 0)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "操作失败,请先保存并审核订单";
|
objjson.data = HinterID;
|
return objjson;
|
}
|
objjson.code = "1";
|
objjson.count = 1;
|
objjson.Message = "操作成功";
|
objjson.data = HinterID;
|
return objjson;
|
}
|
|
[Route("DeAuditPOInStockBill")]
|
[HttpGet]
|
public object DeAuditPOInStockBill(string HInterID,string HBillNo, string CurUserName)
|
{
|
json objjson = new json();
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
|
//==================================== Begin 反审核送货单 Begin ====================================
|
DataSet ds;
|
|
ds = oCn.RunProcReturn("exec h_p_SRM_Cg_POInStockBill_DeAudit " + HInterID + ",'" + HBillNo + "','" + CurUserName + "'", "h_p_SRM_Cg_POInStockBill_DeAudit");
|
if (ds == null)
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "反审核前判断失败！无数据返回";
|
objjson.data = null;
|
return objjson;
|
}
|
if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "反审核失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemarkBack"]);
|
objjson.data = null;
|
return objjson;
|
}
|
//====================================== End 反审核送货单 End ======================================
|
|
objjson.code = "1";
|
objjson.count = 1;
|
objjson.Message = "操作成功";
|
objjson.data = "";
|
return objjson;
|
}
|
|
public int GetHinterIDByBillNo(string HBillNo, string type)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
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;
|
}
|
[Route("DeltetPOInStockBill")]
|
[HttpGet]
|
public object DeltetPOInStockBill(string HInterID, string HUserName)
|
{
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
try
|
{
|
DAL.ClsCg_POInStockBill oBill = new DAL.ClsCg_POInStockBill();
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//获取客户名称
|
string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);
|
//夏宝需要先在金蝶删除收料通知单后才能在供应商协同平台删除送货单
|
if (FCusName == "夏宝电器" || FCusName == "添康科技")
|
{
|
string sqlBeforeDel = $"exec h_p_SRM_POInStockBeforeDelCtrl " + HInterID;
|
|
DataSet ds = oCn.RunProcReturn(sqlBeforeDel, "h_p_SRM_POInStockBeforeDelCtrl");
|
|
if (ds == null || ds.Tables[0].Rows.Count <= 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "删除送货单发生异常，没有任何返回记录！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
if (ds.Tables[0].Rows[0]["HBackCount"].ToString() == "1")
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = ds.Tables[0].Rows[0]["HRemarkBack"].ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
}
|
else
|
{
|
//先删除 金蝶数据
|
objjson = DeleteKingDee(HInterID);
|
}
|
|
|
//LogService.Write(objjson.ToString());
|
if (objjson.code == "0")
|
return objjson;
|
|
oCN.BeginTran();
|
string sql = $"select HInterID,HBillNo from Cg_POInStockBillMain where HInterID in ({HInterID})";
|
DataTable dt = oCN.RunProcReturn(sql, "deleteTable").Tables[0];
|
foreach (DataRow dr in dt.Rows)
|
{
|
WebAPIController.Add_Log("送货单删除", HUserName, "送货单删除，单号：" + dr["HBillNo"]);
|
oBill.DeleteRelation(ref DBUtility.ClsPub.sExeReturnInfo, Convert.ToInt32(dr["HInterID"]));
|
oCN.RunProc($"Delete From Cg_POInStockBillMain where HInterID in ({dr["HInterID"]})");
|
oCN.RunProc($"Delete From Cg_POInStockBillSub where HInterID in ({dr["HInterID"]})");
|
}
|
oCN.Commit();
|
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 = "Exception！" + e.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
//审核 删除 删除金蝶数据库对应 收料通知到数据
|
public json DeleteKingDee(string hinterid)
|
{
|
var kdTbaleName = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "DataBaseName");
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
//string sql = string.Format("select HinterID,HERPBillNO,HERPInterID from Cg_POInStockBillMain where HERPInterID>0 and hinterid in (" + hinterid + ")");
|
//string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);
|
var sql = $"select HinterID,HERPBillNO,HERPInterID from Cg_POInStockBillMain t1 join {kdTbaleName}..T_PUR_RECEIVE t2 on t1.HERPInterID = t2.FID where HERPInterID>0 and hinterid in (" + hinterid + ")";
|
DataTable dt = oCN.RunProcReturn(sql, "deleteDt").Tables[0];
|
if (dt.Rows.Count == 0)
|
{
|
objjson.code = "1";
|
objjson.count = 1;
|
objjson.Message = "Sucess！";
|
objjson.data = null;
|
return objjson;
|
}
|
List<string> HERPInterIdList = new List<string>();
|
foreach (DataRow dr in dt.Rows)
|
{
|
HERPInterIdList.Add(dr["HERPInterID"].ToString());
|
}
|
var sJson = new
|
{
|
Ids = string.Join(",", HERPInterIdList)
|
};
|
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;
|
}
|
//LogService.Write("");
|
var result = InvokeHelper.Delete("PUR_ReceiveBill", JsonConvert.SerializeObject(sJson));
|
//LogService.Write("api结果删除：" + result);
|
if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
|
{
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "对应金蝶收料通知单删除失败 ！\r\n" + result;
|
objjson.data = null;
|
return objjson;
|
}
|
objjson.code = "1";
|
objjson.count = 1;
|
objjson.Message = "Sucess！";
|
objjson.data = null;
|
return objjson;
|
|
}
|
//[Route("POInStockAccept")]
|
//[HttpGet]
|
///// <summary>
|
///// 订单接受
|
///// </summary>
|
///// <param name="HInterID"></param>
|
///// <returns></returns>
|
//public object POInStockAccept(string HInterID,string HEntryID,long HBillType,string HUser)
|
//{
|
// try
|
// {
|
// if (DBUtility.ClsPub.isLong(HInterID) == 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "接受失败！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// DAL.ClsSRM_POInStockBill oBill = new DAL.ClsSRM_POInStockBill();
|
// oBill.WebAccept_Sub(DBUtility.ClsPub.isLong(HInterID), DBUtility.ClsPub.isLong(HEntryID), DBUtility.ClsPub.isLong(HBillType), DBUtility.ClsPub.isStrNull(HUser), ref DBUtility.ClsPub.sExeReturnInfo);
|
// objJsonResult.code = "0";
|
// 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;
|
// }
|
//}
|
// [Route("POInStockRefuse")]
|
// [HttpGet]
|
// /// <summary>
|
// /// 订单拒绝
|
// /// </summary>
|
// /// <param name="HInterID"></param>
|
// /// <returns></returns>
|
// public object POInStockRefuse(string HInterID, string HEntryID,string HBackRemark, long HBillType,string HUser)
|
// {
|
// try
|
// {
|
// if (DBUtility.ClsPub.isLong(HInterID) == 0)
|
// {
|
// objJsonResult.code = "0";
|
// objJsonResult.count = 0;
|
// objJsonResult.Message = "失败！";
|
// objJsonResult.data = null;
|
// return objJsonResult;
|
// }
|
// DAL.ClsSRM_POInStockBill oBill = new DAL.ClsSRM_POInStockBill();
|
// oBill.WebRefuse_Sub(DBUtility.ClsPub.isLong(HInterID), DBUtility.ClsPub.isLong(HEntryID), DBUtility.ClsPub.isStrNull(HBackRemark), DBUtility.ClsPub.isLong(HBillType),DBUtility.ClsPub.isStrNull(HUser), ref DBUtility.ClsPub.sExeReturnInfo);
|
// objJsonResult.code = "0";
|
// 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;
|
// }
|
// }
|
[Route("TestSaverPOInStock")]
|
[HttpGet]
|
/// <summary>
|
/// 生成送货单前验证金蝶采购订单是否删除和关闭，然后更新关联数量
|
/// </summary>
|
/// <param name="HInterID"></param>
|
/// <returns></returns>
|
public object TestSaverPOInStock(string ids, string entryids)
|
{
|
List<string> mylist = new List<string>(ids.Split(','));//.Distinct()
|
List<string> entryList = new List<string>(entryids.Split(','));//.Distinct()
|
//List<string> mylist = new List<string>(ids.Split(',').Distinct());
|
//List<string> entryList = new List<string>(entryids.Split(',').Distinct());
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (FCusName == "夏宝电器" && mylist.Count > 1)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "操作失败！请选择相同采购订单数据行下推！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
try
|
{
|
DataSet ds2;
|
oCn.BeginTran(); //开始事物
|
|
//采购订单下推生成送货单 时候 判断是否有生成采购订单变更单 如果有且变更单状态不为已审核 限制下推
|
objJsonResult = TestPOOrder(entryids);
|
if (objJsonResult.code == "0")
|
return objJsonResult;
|
|
if (mylist.Count != entryList.Count)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "主内码与子内码数量不一致！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
for (int i = 0;i < mylist.Count;i++)
|
{
|
//采购订单下推生成送货单前控制
|
string sql = "exec h_p_SRM_POOrderBill_BeforePushDownCtrl " + mylist[i] + "," + entryList[i];
|
ds2 = oCn.RunProcReturn(sql, "h_p_SRM_POOrderBill_BeforePushDownCtrl");
|
|
if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
|
{
|
LogService.Write("送货数量同步进入回滚");
|
oCn.RollBack(); //回滚事物
|
objjson.code = "0";
|
objjson.count = 0;
|
objjson.Message = "审核前判断失败！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HRemarkBack"]);
|
objjson.data = null;
|
return objjson;
|
}
|
}
|
|
for (int i = 0; i < mylist.Count; i++)
|
{
|
//更新关联数量
|
var HinterID = mylist[i].ToString();
|
var HEntryID = entryList[i].ToString();
|
LogService.Write("送货数量同步： exec h_p_SRM_UpDatePPBomRelationQty" + HinterID + "," + HEntryID);
|
oCn.RunProc($"exec h_p_SRM_UpDatePPBomRelationQty {HinterID},{HEntryID},{i+1}");
|
}
|
|
//判断未关联数量是否为0
|
//安瑞：AIS20220914133941 瑞与琪：AIS20220308151944 本地：AIS20210811135644 夏宝：srv_lnk.AIS20211130140219.dbo. 凯贝：AIS20210820164804 添康：AIS20240809105013
|
//DataSet ds = oCn.RunProcReturn($"select T1.hqty-T1.hrelationqty+q.FMRBQTY as hqty,q.FRemainReceiveQty as 剩余收料数量,T1.hrelationqty as 已发货数量,T1.hqty as 订单数量,单据号,物料编码 from H_v_SRM_POOrderBillList t1 left join AIS20210811135644..T_PUR_POORDERENTRY_R q on q.FENTRYID=t1.HEntryID where hentryid in ({string.Join(", ", entryList)})", "H_v_SRM_POOrderBillList");
|
|
var kdTbaleName = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "DataBaseName");
|
|
string sql2 = string.Format(@"select T1.hqty - T1.hrelationqty + q.FMRBQTY as hqty, q.FRemainReceiveQty as 剩余收料数量, T1.hrelationqty as 已发货数量, T1.hqty as 订单数量, 单据号, 物料编码 from H_v_SRM_POOrderBillList t1 left join {0}..T_PUR_POORDERENTRY_R q on q.FENTRYID = t1.HEntryID where hentryid in ({1})", kdTbaleName, string.Join(", ", entryList));
|
|
DataSet ds = oCn.RunProcReturn(sql2, "H_v_SRM_POOrderBillList");
|
|
DataTable dt = ds.Tables[0];
|
if (dt.Rows.Count > 0)
|
{
|
DataRow[] dr = dt.Select("hqty <=" + 0);
|
if (dr.Count() > 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = $"请检查数据，单据号：{dr[0]["单据号"]},物料编码：{dr[0]["物料编码"]},可以发货数量为0，已全部生成送货单！,订单数量：{Convert.ToDouble(dr[0]["订单数量"]).ToString("f2")},已发货数量：{Convert.ToDouble(dr[0]["已发货数量"]).ToString("f2")},剩余收料数量：{Convert.ToDouble(dr[0]["剩余收料数量"]).ToString("f2")}";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
oCn.Commit(); //提交事物
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "操作成功!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "失败！" + e.Message.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
/// <summary>
|
/// 验证 采购订单
|
/// </summary>
|
/// <param name="entryids">采购订单FENTRYID</param>
|
/// <returns></returns>
|
public JsonResult TestPOOrder(string entryids)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
try
|
{
|
//获取系统参数--客户名称
|
string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);
|
var kdTbaleName = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "DataBaseName");
|
string sql = "";
|
//验证金蝶采购订单是否存在
|
if (FCusName == "夏宝电器")
|
{
|
sql = string.Format(@"
|
select M.HBillNo,B.HMaterID,E.HNumber,E.HName
|
FROM Cg_POOrderBillSub B
|
JOIN Cg_POOrderBillMAIN M ON B.HINTERID = M.HINTERID
|
JOIN Gy_Material E ON B.HMaterID = E.HItemID
|
LEFT JOIN {1}.T_PUR_POORDERENTRY C ON B.HInterID = C.FID AND B.HEntryID = C.FENTRYID
|
WHERE ISNULL(C.FENTRYID,0) = 0
|
AND B.HEntryID in ({0})"
|
, entryids, kdTbaleName);
|
}
|
else
|
{
|
sql = string.Format(@"
|
select M.HBillNo,B.HMaterID,E.HNumber,E.HName
|
FROM Cg_POOrderBillSub B
|
JOIN Cg_POOrderBillMAIN M ON B.HINTERID = M.HINTERID
|
JOIN Gy_Material E ON B.HMaterID = E.HItemID
|
LEFT JOIN {1}..T_PUR_POORDERENTRY C ON B.HInterID = C.FID AND B.HEntryID = C.FENTRYID
|
WHERE ISNULL(C.FENTRYID,0) = 0
|
AND B.HEntryID in ({0})"
|
, entryids, kdTbaleName);
|
}
|
|
DataSet ds = oCn.RunProcReturn(sql, "temp");
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据号：" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + ",物料编码：" + ds.Tables[0].Rows[0]["HNumber"].ToString() + "，对应的金蝶采购订单已删除，不能下推送货单！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
|
//采购订单下推生成送货单 时候 判断是否有生成采购订单变更单 如果有且变更单状态不为已审核 限制下推
|
if (FCusName == "夏宝电器")
|
{
|
sql = string.Format(@"
|
select M.HBillNo,B.HMaterID,E.HNumber,E.HName,F.FBILLNO
|
FROM Cg_POOrderBillSub B
|
JOIN Cg_POOrderBillMAIN M ON B.HINTERID = M.HINTERID
|
JOIN Gy_Material E ON B.HMaterID = E.HItemID
|
JOIN {1}.T_PUR_POORDERENTRY C ON B.HInterID = C.FID AND B.HEntryID = C.FENTRYID
|
LEFT join {1}.T_PUR_POCHANGEENTRY D ON C.FENTRYID = D.FOFENTRYID
|
LEFT join {1}.T_PUR_POCHANGE F ON D.FID = F.FID
|
where b.HEntryID in ({0})
|
and F.FDOCUMENTSTATUS <> 'C'"
|
, entryids, kdTbaleName);
|
}
|
else
|
{
|
sql = string.Format(@"
|
select M.HBillNo,B.HMaterID,E.HNumber,E.HName,F.FBILLNO
|
FROM Cg_POOrderBillSub B
|
JOIN Cg_POOrderBillMAIN M ON B.HINTERID = M.HINTERID
|
JOIN Gy_Material E ON B.HMaterID = E.HItemID
|
JOIN {1}..T_PUR_POORDERENTRY C ON B.HInterID = C.FID AND B.HEntryID = C.FENTRYID
|
LEFT join {1}..T_PUR_POCHANGEENTRY D ON C.FENTRYID = D.FOFENTRYID
|
LEFT join {1}..T_PUR_POCHANGE F ON D.FID = F.FID
|
where b.HEntryID in ({0})
|
and F.FDOCUMENTSTATUS <> 'C'"
|
, entryids, kdTbaleName);
|
}
|
|
ds = oCn.RunProcReturn(sql, "temp");
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据号：" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + ",物料编码：" + ds.Tables[0].Rows[0]["HNumber"].ToString() + "，存在对应采购订单变更单:" + ds.Tables[0].Rows[0]["FBILLNO"].ToString() + "未审核，不能下推送货单！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
|
//采购订单下推生成送货单 时候 判断是否有生成采购订单新变更单 如果有且变更单状态不为已审核 限制下推
|
if (FCusName == "夏宝电器")
|
{
|
sql = string.Format(@"
|
select M.HBillNo,B.HMaterID,E.HNumber,E.HName,F.FBILLNO
|
FROM Cg_POOrderBillSub B
|
JOIN Cg_POOrderBillMAIN M ON B.HINTERID = M.HINTERID
|
JOIN Gy_Material E ON B.HMaterID = E.HItemID
|
JOIN {1}.T_PUR_POORDERENTRY C ON B.HInterID = C.FID AND B.HEntryID = C.FENTRYID
|
LEFT join {1}.t_PUR_XPOOrderENTRY D ON C.FENTRYID = D.FPKIDX
|
LEFT join {1}.t_PUR_XPOOrder F ON D.FID = F.FID
|
where F.FDOCUMENTSTATUS <> 'C' and b.HEntryID in ({0}) "
|
, entryids, kdTbaleName);
|
}
|
else
|
{
|
sql = string.Format(@"
|
select M.HBillNo,B.HMaterID,E.HNumber,E.HName,F.FBILLNO
|
FROM Cg_POOrderBillSub B
|
JOIN Cg_POOrderBillMAIN M ON B.HINTERID = M.HINTERID
|
JOIN Gy_Material E ON B.HMaterID = E.HItemID
|
JOIN {1}..T_PUR_POORDERENTRY C ON B.HInterID = C.FID AND B.HEntryID = C.FENTRYID
|
LEFT join {1}..t_PUR_XPOOrderENTRY D ON C.FENTRYID = D.FPKIDX
|
LEFT join {1}..t_PUR_XPOOrder F ON D.FID = F.FID
|
where F.FDOCUMENTSTATUS <> 'C' and b.HEntryID in ({0}) "
|
, entryids, kdTbaleName);
|
}
|
|
ds = oCn.RunProcReturn(sql, "temp");
|
if (ds.Tables[0].Rows.Count > 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "单据号：" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + ",物料编码：" + ds.Tables[0].Rows[0]["HNumber"].ToString() + "，存在对应采购订单新变更单:" + ds.Tables[0].Rows[0]["FBILLNO"].ToString() + "未审核，不能下推送货单！";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "操作成功!";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "失败！" + e.Message.ToString();
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
}
|
|
|
/// <summary>
|
/// 采购订单生成送货单按钮 显示单据头
|
/// </summary>
|
/// <param name="lngBillKey"></param>
|
/// <param name="HBillType"></param>
|
/// <param name="sShowItem"></param>
|
/// <param name="sReturn"></param>
|
/// <returns></returns>
|
public DataSet ShowNewBillMainTo(Int64 lngBillKey, string HBillType, string sShowItem, ref string sReturn)
|
{
|
try
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//查询主表
|
DataSet Ds;
|
Ds = oCn.RunProcReturn(" exec h_p_SRM_POInStockBillMain_ForWeb " + lngBillKey.ToString() + ",'" + HBillType + "'", "h_p_SRM_POInStockBillMain_ForWeb");
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
sReturn = "单据头未找到！";
|
return null;
|
}
|
sReturn = "显示单据头成功！";
|
return Ds;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
return null;
|
}
|
}
|
|
/// <summary>
|
/// 采购订单生成送货单按钮 显示单据体
|
/// </summary>
|
/// <param name="lngBillKey"></param>
|
/// <param name="lngBillKey2"></param>
|
/// <param name="HBillType"></param>
|
/// <param name="sShowItem"></param>
|
/// <param name="sReturn"></param>
|
/// <returns></returns>
|
public DataSet ShowNewBillSubTo(Int64 lngBillKey, string lngBillKey2, string HBillType, string sShowItem, ref string sReturn)
|
{
|
string s = "";
|
try
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//查询主表
|
DataSet Ds;
|
Ds = oCn.RunProcReturn(" exec h_p_SRM_POInStockBillSub_ForWeb '" + lngBillKey2 + "','" + HBillType + "'", "h_p_SRM_POInStockBillSub_ForWeb");
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
sReturn = "单据体未找到！";
|
return null;
|
}
|
sReturn = "显示单据体成功！";
|
return Ds;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message; //+ s
|
return null;
|
}
|
}
|
|
#region 送货单编辑获取单据数据
|
[Route("Cg_POInStockBill/cx")]
|
[HttpGet]
|
public object Cg_POInStockBill_cx(long HInterID)
|
{
|
try
|
{
|
//查询主表
|
DataSet ds;
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
|
ds = oCn.RunProcReturn("select * from h_v_SRM_POInStockBillEdit where hmainid =" + HInterID, "h_v_SRM_POInStockBillEdit");
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "false！没有返回送货单信息，请核对送货单是否存在";
|
objJsonResult.data = null;
|
return objJsonResult;
|
}
|
else
|
{
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "Sucess！";
|
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;
|
}
|
}
|
#endregion
|
|
}
|
}
|
