nothing

王 垚

2021-12-30 6a601b6ca447e193ca0c55e4bc5a59bef7aca4b4

 WebAPI/Controllers/POInStockController.cs

@@ -19,6 +19,8 @@
    {
        private JsonResult objJsonResult = new JsonResult();
        private json objjson = new json();
        //获取系统参数
        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();

        /// <summary>
        /// 更新打印次数
@@ -28,7 +30,7 @@
        /// <returns></returns>
        [Route("UpdatePOInStockBillPrintQty")]
        [HttpGet]
        public object UpdatePOInStockBillPrintQty(string msg,string CurUserName)
        public object UpdatePOInStockBillPrintQty(string msg, string CurUserName)
        {
            try
            {
@@ -287,7 +289,7 @@
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString();
            string msg3 = sArray[1].ToString();

            

            string UserName = "";
            ListModels oListModels = new ListModels();
@@ -310,14 +312,26 @@
                    oItem.HMainSourceInterID = oItem.HInterID;
                    oItem.HInterID = 0;
                    //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
                    if (DBUtility.ClsPub.isStrNull(oItem.HDHDate) == "")
                    if (oSystemParameter.omodel.WMS_CampanyName == "安瑞医疗") //系统参数  客户定制化名称     空白为通用
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "保存失败！没有填写预计到货日期，无法保存！";
                        objJsonResult.data = 1;
                        return objJsonResult;
                        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;
                }
                //表体数据
@@ -348,13 +362,16 @@
                        objJsonResult.data = 1;
                        return objJsonResult;
                    }
                    if (DBUtility.ClsPub.isStrNull(oItemSub.HBatChNo) == "")
                    if (oSystemParameter.omodel.WMS_CampanyName == "安瑞医疗") //系统参数  客户定制化名称     空白为通用
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "保存失败！第" + i.ToString() + "行未填写批号！";
                        objJsonResult.data = 1;
                        return objJsonResult;
                        if (DBUtility.ClsPub.isStrNull(oItemSub.HBatChNo) == "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "保存失败！第" + i.ToString() + "行未填写批号！";
                            objJsonResult.data = 1;
                            return objJsonResult;
                        }
                    }

                    oItemSub.HEntryID = i;
@@ -448,7 +465,7 @@
                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");
                LogService.Write("exec H_p_SRM_POInStockBillList '" + PcWhere + "'");
                //LogService.Write("exec H_p_SRM_POInStockBillList '" + PcWhere + "'");
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objjson.code = "0";
@@ -592,23 +609,23 @@
            {
                SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();

                string kdTbaleName = "AIS20210811135644";
                string kdTbaleName = "AIS20211209082932";
                string sql = string.Format(@"
 SELECT B.HINTERID,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 FROM 
   CG_POINSTOCKBILLSUB B  
 JOIN CG_POINSTOCKBILLMAIN M ON B.HINTERID = M.HINTERID
 JOIN AIS20210811135644..T_PUR_POORDERENTRY C ON B.HSOURCEINTERID = C.FID AND B.HSOURCEENTRYID = C.FENTRYID
 LEFT JOIN AIS20210811135644..T_BD_MATERIAL CM ON C.FMATERIALID =CM.FMASTERID
 LEFT JOIN AIS20210811135644..T_BD_UNIT CU ON C.FUNITID =CU.FUNITID
 JOIN AIS20210811135644..T_PUR_POORDERENTRY_D CD ON    C.FENTRYID = CD.FENTRYID
 LEFT JOIN AIS20210811135644..T_ORG_ORGANIZATIONS CDOO ON CD.FRECEIVEORGID = CDOO.FORGID
 JOIN AIS20210811135644..T_PUR_POORDERENTRY_F CR ON    C.FENTRYID = CR.FENTRYID
 LEFT JOIN AIS20210811135644..T_ORG_ORGANIZATIONS CROO ON CR.FSETTLEORGID = CROO.FORGID
 JOIN AIS20210811135644..T_PUR_POORDER D ON C.FID =D.FID
 LEFT JOIN AIS20210811135644..T_BD_SUPPLIER DS ON D.FSUPPLIERID = DS.FSUPPLIERID
 LEFT JOIN AIS20210811135644..T_ORG_ORGANIZATIONS DOO ON D.FPURCHASEORGID = DOO.FORGID
 JOIN AIS20210811135644..T_PUR_POORDERFIN E ON C.FENTRYID =E.FENTRYID
 LEFT JOIN AIS20210811135644..T_BD_CURRENCY EC ON E. FSETTLECURRID =EC.FCURRENCYID  
 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
 JOIN {0}..T_PUR_POORDER D ON C.FID =D.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);
                DataTable dt = oCn.RunProcReturn(sql, "sltz").Tables[0];
@@ -681,6 +698,7 @@
                        };
                        //LogService.Write(JsonConvert.SerializeObject(jsonRoot));
                        var loginRet = InvokeHelper.Login();
                        LogService.Write("loginRet:" + loginRet);
                        var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();
                        if (isSuccess == 0)
                        {
@@ -690,8 +708,9 @@
                            objjson.data = null;
                            return objjson;
                        }
                        LogService.Write(jsonRoot.ToString());
                        var result = InvokeHelper.Save("PUR_ReceiveBill", jsonRoot.ToString());
                        //LogService.Write(result);
                        LogService.Write(result);
                        if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() == "TRUE")
                        {
                            //更新送货单 主表 ERP单据号 以及 ERP主内玛