智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zzr99
2022-01-20 5b0c45a5813e7cbff1cf4871dbeb239b7e3900bc 
 WebAPI/Controllers/ProductInController.cs


@@ -59,6 +59,37 @@


                return "";


            }


        }




        /// <summary>


        /// 产品入库缓存列表编辑前判断单据是否已上传  直接调WebService


        /// </summary>


        /// <returns></returns>


        //[Route("ProductIn/ProductInTempList_Modify")]


        //[HttpGet]


        //public Object ProductInTempList_Modify(Int64 sInterID,string sBillNo, string sBillType)


        //{


            


        //    //oBar = webserver.get_CheckTypeByBarCode(sCode, sInterID, sBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, ref DBUtility.ClsPub.sErrInfo);


        //    WebS.WebService1 oWebs = new WebS.WebService1();


        //    if (oWebs.TempList_Modify(sInterID, sBillNo, sBillType, ref sErrMsg))


        //    {


        //        objJsonResult.code = "0";


        //        objJsonResult.count = 0;


        //        objJsonResult.Message = DBUtility.ClsPub.sErrInfo;


        //        objJsonResult.data = null;


        //        return objJsonResult;


        //    }


        //    else


        //    {


        //        objJsonResult.code = "0";


        //        objJsonResult.count = 1;


        //        objJsonResult.Message = DBUtility.ClsPub.sErrInfo;


        //        objJsonResult.data = null;


        //        return objJsonResult;


        //    }


        //}






        /// <summary>


        /// 产品入库/扫条码/直接调用webservice


        /// </summary>


@@ -165,6 +196,212 @@


            }


        }




        ///// <summary>


        ///// 产品入库缓存列表刷新信息


        ///// </summary>


        ///// <returns></returns>


        //[Route("ProductIn/DisBillEntryList_Json1")]


        //[HttpGet]


        //public object DisBillEntryList_Json1(string HBillType,string sHMaker, Int64 HOrgID)


        //{


        //    try


        //    {


        //        ds = webserver.GetKf_PonderationBillMain_TempList_New(HBillType, sHMaker, HOrgID);


        //        if (ds == null || ds.Tables[0].Rows.Count <= 0)


        //        {


        //            objJsonResult.code = "0";


        //            objJsonResult.count = 0;


        //            objJsonResult.Message = "没有返回任何记录！";


        //            objJsonResult.data = null;


        //            return objJsonResult;


        //            //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);


        //        }


        //        else


        //        {


        //            objJsonResult.code = "0";


        //            objJsonResult.count = 1;


        //            objJsonResult.Message = "获取信息成功！";


        //            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;


        //    }


        //}








        /// <summary>


        /// 生产入库缓存列表编辑按钮 获取表体信息


        /// </summary>


        /// <param name="HSourceBillNo"></param>


        /// <returns></returns>


        [Route("ProdIn/ProdInDetaiNew")]


        [HttpGet]


        public object ProdInDetaiNew(string HInterID)


        {




            DataSet ds;


            List<object> list = new List<object>();


            string Swhere = "";


            try


            {


                if (HInterID != "" || HInterID != null)


                {


                    Swhere = " and hmainid='" + HInterID + "'";


                }


                else


                {


                    Swhere = HInterID;


                }


                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                //获取销售出库编辑数据


                string sql = "select  数量 HQty,应收数量 HQtyMust,物料代码 HMaterNumber,物料名称 HMaterName,规格型号 HMaterModel,源单主内码 HSourceInterID,源单子内码 HSourceEntryID,源单单号 HSourceBillNo,批次 HBatchNo,辅助属性 HAuxPropID,计划跟踪号 HMTONo,ck HWHID  from h_v_SelloutDetail where 1 = 1 " + Swhere + "";


                ds = oCN.RunProcReturn(sql, "h_v_SelloutDetail");




                list.Add(ds.Tables[0]);


                objJsonResult.code = "0";


                objJsonResult.count = 1;


                objJsonResult.Message = "获取信息成功！";


                objJsonResult.list = list;


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + e.ToString();


                objJsonResult.data = null;


            }


            return objJsonResult;


        }






        /// <summary>


        /// 编辑页面返回产品入库条码临时表信息


        /// </summary>


        /// <returns></returns>


        [Route("Web/GetHBarCodeShowBillSub")]


        [HttpGet]


        public object GetHBarCodeShowBillSub(long HInterID, long HMaterID, Int64 HAuxPropID, string HMTONo, Int64 HWhID, Int64 HSPID, Int64 HSCWhID, Int64 HSCSPID, string HBatchNo, Int64 HSourceInterID, Int64 HSourceEntryID, string sBillType, string sWhere)


        {


            try


            {


                ds = webserver.GetBarCode_Temp(HInterID, HMaterID, HAuxPropID, HMTONo, HWhID, HSPID, HSCWhID, HSCSPID, HBatchNo, HSourceInterID, HSourceEntryID, sBillType, sWhere);


                if (ds == null || ds.Tables[0].Rows.Count <= 0)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "没有返回任何记录！";


                    objJsonResult.data = null;


                    return objJsonResult;


                    //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);


                }


                else


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


                    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;


            }


        }




        //点击编辑  公用窗体删除方法


        [Route("Kf_BarCodeEditDlg/DeltetBill")]


        [HttpGet]


        public object DeltetBill(long HInterID,string HBarCode,string HBillType)


        {


            string sErrMsg = string.Empty;


            try


            {


                if (webserver.set_DelPonderationBillMain_Temp_BarCode(HInterID,HBarCode, HBillType, ref sErrMsg))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "删除成功！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "删除失败！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


            }


            catch (Exception)


            {




                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "删除失败！";


                objJsonResult.data = null;


                return objJsonResult;


            }




        }






        /// <summary>


        /// 返回产品入库扫码明细  


        /// </summary>


        /// <returns></returns>


        [Route("ProductIn/DisPlayBarCodeList_Json")]


        [HttpGet]


        public object DisPlayBarCodeList_Json(long HBillID, string HBillNo, string HBillType, string sMouldManagerCtl, string sFIFOCtl)


        {


            try


            {


                ds = webserver.GetBarcodeList(HBillID, HBillNo, HBillType, ref sMouldManagerCtl, ref sFIFOCtl, ref DBUtility.ClsPub.sErrInfo);


                if (ds == null || ds.Tables[3].Rows.Count <= 0)


                {




                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "没有返回任何记录！";


                    objJsonResult.data = null;


                    return objJsonResult;


                    //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);


                }


                else


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


                    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;


            }


        }




        [Route("ProductIn/DisBillEntryList_Mate_Webs_Json")]


        [HttpGet]


        public object DisBillEntryList_Mate_Webs_Json(string HBillType, string sWhere)


@@ -210,6 +447,7 @@


        [HttpGet]


        public object set_SavePonderationBillMain_Temp_Source_Fast_Json(string HSourceBillType, string HSourceBillNo, Int64 sInterID, string sBillNo)


        {


            string aa = "";


            try


            {


               // DataSet ds = new DataSet();


@@ -217,13 +455,18 @@


                string sWhere = " Where 单据号 like '%" + HSourceBillNo.Trim() + "%'";


                if (HSourceBillType == "3710")


                {


                    aa = "执行了";


                    ds = webserver.GetSc_ICMOBillList(sWhere + "  ");


                }


                if (HSourceBillType == "3711")


                {


                    ds = webserver.GetSc_ICMOReportBillList(sWhere + "  ");


                }


                else


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "没有返回任何记录,源单类型有错误！";


                    objJsonResult.Message = "没有返回任何记录,源单类型有错误！"+aa;


                    objJsonResult.data = null;


                    return objJsonResult; ;


                }


@@ -465,6 +708,7 @@


            //string sSourceBillType = lsmain[0].HBillType;


            //BLL.ClsKf_ProductInBill bll = new BLL.ClsKf_ProductInBill();


            //return bll.set_SaveProductInBill_New(lsmain[0], sSourceBillType, ref DBUtility.ClsPub.sErrInfo);


            


            try


            {


                List<Model.ClsKf_ProductInBillMain> lsmain = new List<Model.ClsKf_ProductInBillMain>();


@@ -481,8 +725,13 @@


                websLsmain.HBillNo = lsmain[0].HBillNo;


                websLsmain.HDeptID = lsmain[0].HDeptID;


                websLsmain.HEmpID = lsmain[0].HEmpID;


                websLsmain.HKeeperID= lsmain[0].HKeeperID;


                websLsmain.HRemark = lsmain[0].HRemark;


                websLsmain.HMaker = lsmain[0].HMaker;


                websLsmain.HWHID = lsmain[0].HWHID;


                websLsmain.HSupID = lsmain[0].HSupID;


                websLsmain.HExplanation = lsmain[0].HExplanation;






                if (webserver.set_SaveProductInBill_New(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo))


                {


@@ -511,14 +760,14 @@


            }


        }




        [Route("ProductIn/Delete_Json")]


        [Route("ProductIn/Delete_Json_AN")]


        [HttpGet]


        public object Delete_Json(long HInterID, long HMaterID, long HAuxPropID, string HMTONo, long HSourceInterID, long HSourceEntryID, string sHBillType)


        public object Delete_Json_AN(long HInterID, long HMaterID, long HAuxPropID, string HMTONo, long HSourceInterID, long HSourceEntryID, string sHBillType)


        {


            string sErrMsg = string.Empty;


            try


            {


                if (webserver.set_DelPonderationBillMain_Temp_InterIDAndSource(HInterID, HMaterID, HAuxPropID, HMTONo, HSourceInterID, HSourceEntryID, sHBillType, ref sErrMsg))


                if (webserver.DeleteBill_AN(HInterID, HMaterID, HAuxPropID, HMTONo, HSourceInterID, HSourceEntryID, sHBillType, ref sErrMsg))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


@@ -535,12 +784,49 @@


                    return objJsonResult;


                }


            }


            catch (Exception)


            catch (Exception e)


            {




                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "删除失败！";


                objJsonResult.Message = "删除失败！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }




        }






        [Route("ProductIn/Delete_Json")]


        [HttpGet]


        public object Delete_Json(long HInterID, string HBillNo, string HBillType, string HBarCode)


        {


            string sErrMsg = string.Empty;


            try


            {


                if (webserver.DeleteBill(HInterID, HBillNo, HBillType, HBarCode, ref sErrMsg))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "删除成功！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "删除失败！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


            }


            catch (Exception e)


            {




                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "删除失败！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }