blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
ch
2022-07-31 cee2c78bdc4aa9f309b68bc489c97282c9b7cb65 
 WebAPI/Controllers/SCGL/Èռƻ®¹ÜÀí/JIT_CompleteController..cs


@@ -25,11 +25,16 @@


        /// <returns></returns>


        [Route("JIT_Complete/JIT_CompleteDetailList")]


        [HttpGet]


        public object JIT_CompleteDetailList(string sWhere, string HMainICMOEntryID)


        public object JIT_CompleteDetailList(string sWhere, string HMainICMOEntryID,string HMainICMOInterID,string HICMOInterID)


        {


            try


            {


                ds = oCN.RunProcReturn("select * from h_v_JIT_MOMaterReadysBill where ä¸»ç”Ÿäº§è®¢å•å­å†…码 = '" + HMainICMOEntryID + "' " + sWhere + "  order by æ—¥è®¡åˆ’日期,物料ID  desc ", "h_v_JIT_MOMaterReadysBill");


                string sql = "";


                if (HMainICMOEntryID != "-1" && HMainICMOInterID != "-1" && HICMOInterID != "-1")


                {


                    sql = "and ä¸»ç”Ÿäº§è®¢å•å­å†…码 = '" + HMainICMOEntryID + "' and ä¸»ç”Ÿäº§è®¢å•ä¸»å†…码='" + HMainICMOInterID + "' and æ—¥è®¡åˆ’订单主内码='" + HICMOInterID + "'";


                }


                ds = oCN.RunProcReturn("select * from h_v_JIT_MOMaterReadysBill where 1=1 " +sql + sWhere + "  order by æ—¥è®¡åˆ’日期,物料ID  desc ", "h_v_JIT_MOMaterReadysBill");




                objJsonResult.code = "1";


                objJsonResult.count = 1;