智云SRM-WEBAPI(目前客户通用API)
王 垚
2022-01-11 0a20d7aa20c8b1a6503ad18ceff60213c777a474
WebAPI/Controllers/POInStockController.cs
@@ -289,7 +289,9 @@
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString();
            string msg3 = sArray[1].ToString();
            //LogService.Write("msg1:" + msg1);
            //LogService.Write("msg2:" + msg2);
            //LogService.Write("msg3:" + msg3);
            string UserName = "";
            ListModels oListModels = new ListModels();
@@ -343,10 +345,12 @@
                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)
                {
                    //增加判断 送货数量超出采购订单数量
                    i++;
                    if (oItemSub.HQty <= 0)
                    {
@@ -612,7 +616,7 @@
                SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
                //采购订单 生成送货单列表
                if (!String.IsNullOrEmpty(HBillNo))
                    HInterID = GetHinterIDByBillNo(HBillNo).ToString();
                    HInterID = GetHinterIDByBillNo(HBillNo, "Aduit").ToString();
                if (HInterID == "0")
                {
                    objjson.code = "0";
@@ -790,12 +794,12 @@
        [HttpGet]
        public object GetHinterID(string HBillNo)
        {
            int HinterID = GetHinterIDByBillNo(HBillNo);
            int HinterID = GetHinterIDByBillNo(HBillNo, "Print");
            if (HinterID == 0)
            {
                objjson.code = "0";
                objjson.count = 0;
                objjson.Message = "操作失败,请先保存订单";
                objjson.Message = "操作失败,请先保存并审核订单";
                objjson.data = HinterID;
                return objjson;
            }
@@ -806,11 +810,13 @@
            return objjson;
        }
        public int GetHinterIDByBillNo(string HBillNo)
        public int GetHinterIDByBillNo(string HBillNo, string type)
        {
            SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
            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"]);
@@ -828,11 +834,11 @@
                DAL.ClsCg_POInStockBill oBill = new DAL.ClsCg_POInStockBill();
                //先删除 金蝶数据
                objjson = DeleteKingDee(HInterID);
                LogService.Write(objjson.ToString());
                //LogService.Write(objjson.ToString());
                if (objjson.code == "0")
                    return objjson;
                WebAPIController.Add_Log("送货单删除,单号:" + HBillNo, HUserName, "送货单删除");
                WebAPIController.Add_Log("送货单删除", HUserName, "送货单删除,单号:" + HBillNo);
                oCN.BeginTran();
                oBill.DeleteRelation(ref DBUtility.ClsPub.sExeReturnInfo, Convert.ToInt32(HInterID));
                oCN.RunProc("Delete From Cg_POInStockBillMain where HInterID = " + HInterID);
@@ -885,7 +891,7 @@
                    }
                    //LogService.Write("");
                    var result = InvokeHelper.Delete("PUR_ReceiveBill", JsonConvert.SerializeObject(sJson));
                    LogService.Write("api结果删除:" + result);
                    //LogService.Write("api结果删除:" + result);
                    if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
                    {
                        objjson.code = "0";
@@ -988,6 +994,14 @@
        public object TestSaverPOInStock([FromBody] string[] ids)
        {
            List<string> mylist = new List<string>(ids.Distinct());
            if (mylist.Count > 1)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "操作失败!请选择相同采购订单数据行下推!";
                objJsonResult.data = null;
                return objJsonResult;
            }
            try
            {
                string HinterID = "";