智云SRM-WEBAPI(目前客户通用API)
保存送货单方法外取消事务;生成送货单前校验完善实物回滚;验证采购订单方法添加防死锁;采购订单列表分页查询;物料标准包装模块;
1个文件已添加
7个文件已修改
463 ■■■■ 已修改文件
WebAPI/Controllers/POInStockController.cs 100 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/POOrderController.cs 61 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/SupMaterPackController.cs 240 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/WebAPIController.cs 48 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/DLL/DAL.dll 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/DLL/Model.dll 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/ListModels.cs 13 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/WebAPI.csproj 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/POInStockController.cs
@@ -457,7 +457,7 @@
                //保存完毕后处理
                bool bResult;
                oCn.BeginTran(); //开始事物
                //oCn.BeginTran(); //开始事物
                if (HOpType.ToString() == "edit"/*oBill.omodel.HInterID != 0 && oBill.omodel.HInterID.ToString() != null && oBill.omodel.HInterID.ToString() != "undefined"*/)
                {
@@ -469,7 +469,7 @@
                }
                if (bResult)
                {
                    oCn.Commit(); //提交事物
                    //oCn.Commit(); //提交事物
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
@@ -480,7 +480,7 @@
                }
                else
                {
                    oCn.RollBack(); //回滚事物
                    //oCn.RollBack(); //回滚事物
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
@@ -491,7 +491,7 @@
            }
            catch (Exception e)
            {
                oCn.RollBack(); //回滚事物
                //oCn.RollBack(); //回滚事物
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "保存失败!" + e.ToString();
@@ -1620,10 +1620,11 @@
        /// <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());
            //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)
@@ -1644,14 +1645,14 @@
                if (objJsonResult.code == "0")
                    return objJsonResult;
                if (mylist.Count != entryList.Count)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "主内码与子内码数量不一致!";
                    objJsonResult.data = null;
                    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++)
                {
                    //采购订单下推生成送货单前控制
@@ -1685,7 +1686,7 @@
                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));
                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_JY t1 left join {0}.T_PUR_POORDERENTRY_R q with(nolock) on q.FENTRYID = t1.HEntryID  where hentryid in ({1})", kdTbaleName, string.Join(", ", entryList));
                DataSet ds = oCn.RunProcReturn(sql2, "H_v_SRM_POOrderBillList");
@@ -1695,6 +1696,7 @@
                    DataRow[] dr = dt.Select("hqty  <=" + 0);
                    if (dr.Count() > 0)
                    {
                        oCn.RollBack();//回滚事务
                        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")}";
@@ -1740,10 +1742,10 @@
                {
                    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
                    FROM Cg_POOrderBillSub B with(nolock)
                    JOIN Cg_POOrderBillMAIN M with(nolock) ON B.HINTERID = M.HINTERID
                    JOIN Gy_Material E with(nolock) ON B.HMaterID = E.HItemID
                    LEFT JOIN {1}.T_PUR_POORDERENTRY C with(nolock) ON B.HInterID = C.FID AND B.HEntryID = C.FENTRYID
                    WHERE ISNULL(C.FENTRYID,0) = 0
                    AND B.HEntryID in ({0})"
                            , entryids, kdTbaleName);
@@ -1752,10 +1754,10 @@
                {
                    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
                    FROM Cg_POOrderBillSub B with(nolock)
                    JOIN Cg_POOrderBillMAIN M with(nolock) ON B.HINTERID = M.HINTERID
                    JOIN Gy_Material E with(nolock) ON B.HMaterID = E.HItemID
                    LEFT JOIN {1}..T_PUR_POORDERENTRY C with(nolock) ON B.HInterID = C.FID AND B.HEntryID = C.FENTRYID
                    WHERE ISNULL(C.FENTRYID,0) = 0
                    AND B.HEntryID in ({0})"
                            , entryids, kdTbaleName);
@@ -1777,12 +1779,12 @@
                {
                    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
                    FROM Cg_POOrderBillSub B with(nolock)
                    JOIN Cg_POOrderBillMAIN M with(nolock) ON B.HINTERID = M.HINTERID
                    JOIN Gy_Material E with(nolock) ON B.HMaterID = E.HItemID
                    JOIN {1}.T_PUR_POORDERENTRY C with(nolock) ON B.HInterID = C.FID AND B.HEntryID = C.FENTRYID
                    LEFT join {1}.T_PUR_POCHANGEENTRY D with(nolock) ON C.FENTRYID = D.FOFENTRYID
                    LEFT join {1}.T_PUR_POCHANGE F with(nolock) ON D.FID = F.FID
                    where b.HEntryID in ({0}) 
                    and F.FDOCUMENTSTATUS <> 'C'"
                            , entryids, kdTbaleName);
@@ -1791,12 +1793,12 @@
                {
                    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
                    FROM Cg_POOrderBillSub B with(nolock)
                    JOIN Cg_POOrderBillMAIN M with(nolock) ON B.HINTERID = M.HINTERID
                    JOIN Gy_Material E with(nolock) ON B.HMaterID = E.HItemID
                    JOIN {1}..T_PUR_POORDERENTRY C with(nolock) ON B.HInterID = C.FID AND B.HEntryID = C.FENTRYID
                    LEFT join {1}..T_PUR_POCHANGEENTRY D with(nolock) ON C.FENTRYID = D.FOFENTRYID
                    LEFT join {1}..T_PUR_POCHANGE F with(nolock) ON D.FID = F.FID
                    where b.HEntryID in ({0}) 
                    and F.FDOCUMENTSTATUS <> 'C'"
                            , entryids, kdTbaleName);
@@ -1818,12 +1820,12 @@
                {
                    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
                    FROM Cg_POOrderBillSub B  with(nolock)
                    JOIN Cg_POOrderBillMAIN M with(nolock) ON B.HINTERID = M.HINTERID
                    JOIN Gy_Material E with(nolock) ON B.HMaterID = E.HItemID
                    JOIN {1}.T_PUR_POORDERENTRY C with(nolock) ON B.HInterID = C.FID AND B.HEntryID = C.FENTRYID
                    LEFT join {1}.t_PUR_XPOOrderENTRY D with(nolock) ON C.FENTRYID = D.FPKIDX
                    LEFT join {1}.t_PUR_XPOOrder F with(nolock) ON D.FID = F.FID
                    where F.FDOCUMENTSTATUS <> 'C' and  b.HEntryID in ({0}) "
                           , entryids, kdTbaleName);
                }
@@ -1831,12 +1833,12 @@
                {
                    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
                    FROM Cg_POOrderBillSub B  with(nolock)
                    JOIN Cg_POOrderBillMAIN M with(nolock) ON B.HINTERID = M.HINTERID
                    JOIN Gy_Material E with(nolock) ON B.HMaterID = E.HItemID
                    JOIN {1}..T_PUR_POORDERENTRY C with(nolock) ON B.HInterID = C.FID AND B.HEntryID = C.FENTRYID
                    LEFT join {1}..t_PUR_XPOOrderENTRY D with(nolock) ON C.FENTRYID = D.FPKIDX
                    LEFT join {1}..t_PUR_XPOOrder F with(nolock) ON D.FID = F.FID
                    where F.FDOCUMENTSTATUS <> 'C' and  b.HEntryID in ({0}) "
                           , entryids, kdTbaleName);
                }
WebAPI/Controllers/POOrderController.cs
@@ -86,6 +86,67 @@
            }
        }
        #region
        [Route("GetPOOrderBillList_byPage")]
        [HttpPost]
        //采购订单列表
        public object GetPOOrderBillList_byPage([FromBody] JObject msg)
        {
            string HSupIDs = msg["HSupIDs"].ToString();
            string sqlWhere = msg["sqlWhere"].ToString();
            string page = msg["page"].ToString();
            string size = msg["size"].ToString();
            string Organization = msg["Organization"].ToString();
            try
            {
                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;
                }
                sql = "exec h_p_SRM_POOrderBillListByPage " + page + "," + size + ",'" + Organization + "','" + PcWhere + "'";
                ds = oCn.RunProcReturn(sql, "h_p_SRM_POOrderBillListByPage");
                //添加列名
                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列对象的列名
                }
                objjson.code = "1";
                objjson.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString());
                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;
            }
        }
        #endregion
        /// <summary>
        /// 采购订单表头信息
        /// </summary>
WebAPI/Controllers/SupMaterPackController.cs
New file
@@ -0,0 +1,240 @@
using DBUtility;
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.Code;
using WebAPI.Models;
namespace WebAPI.Controllers
{
    public class SupMaterPackController : ApiController
    {
        private JsonResult objJsonResult = new JsonResult();
        private json objjson = new json();
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
        DataSet ds;
        //获取系统参数
        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
        #region 物料标准包装
        [Route("SupMaterPackBill/List")]
        [HttpGet]
        public object List(string HSupIDs, string sqlWhere)
        {
            try
            {
                List<object> columnNameList = new List<object>();
                string sql1 = "select * from h_v_SRM_SupMaterPackList where 1 = 1 and hsupid in ( " + HSupIDs.Trim() + ")";
                string sql = sql1 + sqlWhere + " order by hmainid desc";
                ds = oCn.RunProcReturn(sql, "h_v_SRM_SupMaterPackList");
                //添加列名
                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列对象的列名
                }
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess!";
                objJsonResult.list = columnNameList;
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception!" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
        #region 保存最小包装
        [Route("SupMaterPackBill/Save")]
        [HttpPost]
        public object Save([FromBody] JObject msg)
        {
            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 msg4 = sArray[2].ToString();
            string UserName = "";
            ListModels oListModels = new ListModels();
            try
            {
                DAL.ClsSupMaterPackBill oBill = new DAL.ClsSupMaterPackBill();
                List<Model.ClsSupMaterPackBillMain> lsmain = new List<Model.ClsSupMaterPackBillMain>();
                msg2 = msg2.Replace("\\", "");
                msg2 = msg2.Replace("\n", "");  //\n
                lsmain = oListModels.getObjectByJson_ClsSupMaterPackBillMain(msg2);
                foreach (Model.ClsSupMaterPackBillMain oItem in lsmain)
                {
                    //oItem.HMaker = "";
                    UserName = oItem.HMaker;  //制单人
                    oItem.HBillType = "10001";
                    oItem.HBillSubType = "10001";
                    oItem.HBillStatus = 1;
                    DBUtility.ClsPub.CurUserName = UserName;
                    oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
                    if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
                    {
                        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.ClsSupMaterPackBillSub> ls = new List<Model.ClsSupMaterPackBillSub>();
                ls = oListModels.getObjectByJson_ClsSupMaterPackBillSub(msg3);
                int i = 0;
                foreach (Model.ClsSupMaterPackBillSub oItemSub in ls)
                {
                    i++;
                    oItemSub.HEntryID = i;
                    oBill.DetailColl.Add(oItemSub);
                }
                //保存
                //保存完毕后处理
                bool bResult;
                if (Convert.ToInt32(msg4) == 1)
                {
                    // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
                    bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
                }
                else
                {
                    bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
                }
                if (bResult)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "保存成功!";
                    objJsonResult.data = 1;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "保存失败!" + DBUtility.ClsPub.sExeReturnInfo;
                    objJsonResult.data = 1;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "保存失败!" + e.ToString();
                objJsonResult.data = 1;
                return objJsonResult;
            }
        }
        #endregion
        #region 标准包装编辑获取数据
        [Route("SupMaterPackBill/edit")]
        [HttpGet]
        public object SupMaterPackBill_Edit(long HInterID)
        {
            try
            {
                //查询主表
                DataSet ds;
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                ds = oCn.RunProcReturn("select * from h_v_SRM_SupMaterPack_Edit where hmainid =" + HInterID, "h_v_SRM_SupMaterPack_Edit");
                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
        [Route("SupMaterPackBill/delete")]
        [HttpGet]
        public object DeleteSupMaterPackBill(string HInterID, string HUserName)
        {
            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
            try
            {
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                if (objjson.code == "0")
                    return objjson;
                oCN.BeginTran();
                oCN.RunProc($"Delete From SRM_SupMaterPackSub where cast(HMaterID as varchar(200))+cast(HInterID as varchar(200))+cast(HEntryID as varchar(200)) in ({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;
            }
        }
    }
}
WebAPI/Controllers/WebAPIController.cs
@@ -1005,6 +1005,54 @@
            }
        }
        /// <summary>
        /// 获取单据ID,编号
        /// </summary>
        /// <param name="sMsg"></param>
        /// <returns></returns>
        [Route("Web/GetMAXNum_New")]
        [HttpGet]
        public object GetMAXNum_New(string HBillType)
        {
            try
            {
                Int64 HInterID = 0;//显示的字段
                HInterID = CreateBillID(HBillType, ref DBUtility.ClsPub.sExeReturnInfo);
                //----------创建虚表------------------------
                DataTable dt_Main = new DataTable("Json");
                dt_Main.Columns.Add("HInterID", typeof(int));
                //---------创建新行------------------------
                DataRow dr_main = dt_Main.NewRow();//创建新行
                dt_Main.Rows.Add(dr_main);//将新行加入到表中
                dr_main["HInterID"] = DBUtility.ClsPub.isLong(HInterID);
                if (HInterID == 0)
                {
                    objjson.code = "0";
                    objjson.count = 0;
                    objjson.Message = "获取失败";
                    objjson.data = null;
                    return objjson;
                }
                else
                {
                    objjson.code = "0";
                    objjson.count = 1;
                    objjson.Message = "获取成功";
                    objjson.data = dt_Main;
                    return objjson;
                }
            }
            catch (Exception e)
            {
                objjson.code = "0";
                objjson.count = 0;
                objjson.Message = "获取失败" + e.ToString();
                objjson.data = null;
                return objjson;
            }
        }
        //得到最大HINTERID
        public static Int64 CreateBillID(string BillCode, ref string sReturn)
        {
WebAPI/DLL/DAL.dll
Binary files differ
WebAPI/DLL/Model.dll
Binary files differ
WebAPI/ListModels.cs
@@ -106,5 +106,18 @@
            return list;
        }
        public List<Model.ClsSupMaterPackBillMain> getObjectByJson_ClsSupMaterPackBillMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSupMaterPackBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSupMaterPackBillMain>>(jsonString);
            return list;
        }
        public List<Model.ClsSupMaterPackBillSub> getObjectByJson_ClsSupMaterPackBillSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsSupMaterPackBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSupMaterPackBillSub>>(jsonString);
            return list;
        }
    }
}
WebAPI/WebAPI.csproj
@@ -227,6 +227,7 @@
    <Compile Include="Controllers\POOrderController.cs" />
    <Compile Include="Controllers\PublicPageMethodController.cs" />
    <Compile Include="Controllers\ReportController.cs" />
    <Compile Include="Controllers\SupMaterPackController.cs" />
    <Compile Include="Controllers\Xt_grdAlignment_WMESController.cs" />
    <Compile Include="DLL\ClsCg_POInStockBills.cs" />
    <Compile Include="HttpClient.cs" />