基础资料，保存/审核送货单凯贝奈特新增判断，excel导入送货单查询语句修改，

yusijie

2023-08-30 2a6faaafeaf0651ca7459a22a8110e611fd2a042

 WebAPI/Controllers/POOrderController.cs

@@ -306,5 +306,51 @@
                return objJsonResult;
            }
        }

        [Route("Cg_Poorder/UpdateSupSendGoodsDateRemark")]
        [HttpGet]
        /// <summary>
        /// 更新回复交期 -- 凯贝奈特
        /// </summary>
        /// <param name=""></param>
        /// <returns></returns>
        public object UpdateSupSendGoodsDateRemark(string HInterID, string HEntryID,string HSupSendGoodsDateRemark)
        {
            try
            {
                if (HInterID == null || HInterID == "" || HInterID == "undefined" || HEntryID == null || HEntryID == "" || HEntryID == "undefined")
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "操作失败！主内码或子内码为空";
                    objJsonResult.data = 1;
                    return objJsonResult;
                }         

                string sql = "";

                sql = "update Cg_POOrderBillSub set HSupSendGoodsDateRemark = '" + HSupSendGoodsDateRemark + "' where HInterID = " + HInterID + " and HEntryID = " + HEntryID;
                oCn.RunProc(sql);

                //凯贝奈特
                sql = "update AIS20210820164804..T_PUR_POORDERENTRY set F_aaaa_Date1 = '" + HSupSendGoodsDateRemark + "' where FID = " + HInterID + " and FENTRYID = " + HEntryID;
                oCn.RunProc(sql);

                objJsonResult.code = "1";
                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;
            }
        }

    }
}