增加了快捷方式

ch

2022-05-24 6dddaea7cf513f9a55cc54d06a2a3feca750e4f6

 WebAPI/WebServer.cs

@@ -5,7 +5,7 @@
using System.Data;
using System.Linq;
using System.Web;
using Kingdee.BOS.WebApi.Client;
//using Kingdee.BOS.WebApi.Client;


namespace WebAPI
@@ -53,6 +53,8 @@
            //DAL.ClsIF_Department_View dal = new DAL.ClsIF_Department_View();
            //return dal.GetList(sWhere);
        }

       

        /// <summary>
        /// 获取物料列表
@@ -122,6 +124,7 @@
            //return dal.GetList(sWhere);
        }
        #endregion


        #region 一键扫码    入库模块

@@ -1121,6 +1124,7 @@

        #endregion


        #region 外购退料    外购入库（红字）   *

        public bool set_SavePOStockInBackBill_New(WebAPI.WebS.ClsKf_ICStockBillMain oMain, string sHSourceType, ref string sErrMsg)
@@ -1990,6 +1994,11 @@
        public DataSet GetKf_ProductInBillList(string sWhere)
        {
            DAL.Cls_S_IF_ProductInBill_Lite dal = new DAL.Cls_S_IF_ProductInBill_Lite();
            return dal.DisSourceBillList(sWhere);
        }
        public DataSet GetKf_MoveStockRequestBillList(string sWhere)
        {
            DAL.Cls_S_IF_MoveStockRequestBill_Lite dal = new DAL.Cls_S_IF_MoveStockRequestBill_Lite();
            return dal.DisSourceBillList(sWhere);
        }
        #endregion
@@ -3832,6 +3841,28 @@
            }
        }

        //根据托条码  获取条码档案列表唯一码信息
        public DataSet GetBarCode(string HBarCode)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            //
            try
            {
                DataSet DS = oCn.RunProcReturn("select HBarCode,HQty from Sc_PackUnionBillSub where HBarCode_Pack ='" + HBarCode.ToString() + "'", "Sc_PackUnionBillSub", ref DBUtility.ClsPub.sExeReturnInfo);
                //DataSet DS = oCn.RunProcReturn("Select * from h_v_Sc_AssemblyBill Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_Sc_AssemblyBill", ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return null;
                else
                {
                    return DS;
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }

        public DataSet GetHBW(long HBadType)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
@@ -3989,6 +4020,25 @@
            //sErrMsg = "保存调拨单失败！" + sErrMsg;
            //return false;
        }

        public bool set_MoveStockStepOutBill(WebAPI.WebS.ClsKf_MoveStockStepOutBillMain oMain, string sHSourceType, ref string sErrMsg)
        {
            WebS.WebService1 oWebs = new WebS.WebService1();
            if (oWebs.set_SaveMoveStockStepOutBill_New(oMain, sHSourceType, ref sErrMsg))
            {
                sErrMsg = "保存成功！" + oMain.HBillNo;
                return true;
            }
            else
            {
                sErrMsg = "单据号：" + oMain.HBillNo + ", 单据ID：" + oMain.HInterID + ";" + sErrMsg;
                return false;
            }

            
        }


        //删除记录
        public bool set_DelPonderationBillMain_Temp_InterIDAndSource(long HInterID, long HMaterID, long HAuxPropID, string HMTONo, long HSourceInterID, long HSourceEntryID, string sHBillType, ref string sErrMsg)
        {
@@ -4022,6 +4072,68 @@
                return false;
            }
        }
        //删除单据临时表信息
        public bool DeleteBill_AN(long HInterID, long HMaterID, long HAuxPropID, string HMTONo, long HSourceInterID, long HSourceEntryID, string sHBillType, ref string sErrMsg)
        {
            //DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl();
            //if (dal.DeleteByInterIDAndSource(HInterID, HMaterID, HAuxPropID, HMTONo, HSourceInterID, HSourceEntryID, sHBillType))
            //{
            //    sErrMsg = "删除成功！";
            //    return true;
            //}
            //else
            //{
            //    sErrMsg = "删除失败！";
            //    return false;
            //}
            WebS.WebService1 oWebs = new WebS.WebService1();

            if (oWebs.set_DelPonderationBillMain_Temp_InterIDAndSource(HInterID, HMaterID, HAuxPropID, HMTONo, HSourceInterID, HSourceEntryID, sHBillType, ref DBUtility.ClsPub.sErrInfo))
            {
                sErrMsg = "删除成功！";
                return true;
            }
            else
            {
                sErrMsg = "删除失败！";
                return false;
            }

            //if (WebSoBar == null)
            //{
            //    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 = WebSoBar;
            //    return objJsonResult;
            //}

        }

        //删除单据临时表信息
        public bool DeleteBill(Int64 sHInterID, string HBillNo, string HBillType, string HBarCode, ref string sErrMsg)
        {
            DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl();
            if (dal.DeleteBill(sHInterID, HBillNo, HBillType, HBarCode))
            {
                sErrMsg = "删除成功！";
                return true;
            }
            else
            {
                sErrMsg = "删除失败！";
                return false;
            }
        }

        //public Model.ClsGy_BarCodeBill_WMS_Model_View get_InfoByBarCode_Source(string sBarCode, Int64 sInterID, ref bool sBool, ref string sErrMsg)
        //{
        //    SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
@@ -4054,7 +4166,7 @@
        //        return null;
        //    }
        //}
 

        #endregion

        #region 外购入库
@@ -4261,6 +4373,19 @@
            //return dal.GetInfoByID_View(HInterID, sBillType, sWhere);
        }

        public bool Get_CheckQtyByBarCode(string sBarcode, long HWHID, long HSPID, long HAuxPropID, string sBatchNo, string HMTONo, double sQty, ref double sRelQty)
        {
            DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View();
            if (dal.CheckQtyByBarCode(sBarcode, HWHID, HSPID, HAuxPropID, sBatchNo, HMTONo, sQty, ref sRelQty))
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        public DataSet GetSPInfoByIDandHWHIDandOrg(long sItemID, long sHWHID, long HUSEORGID, ref string sErrMsg)
        {
            BLL.ClsIF_StockPlace_View bll = new BLL.ClsIF_StockPlace_View();
@@ -4408,11 +4533,20 @@


        //返回缓存列表信息  同步资料
        public DataSet GetKf_PonderationBillMain_TempList_New(string sHBillType, string sHMaker, Int64 sHOWNERID)
        {
            DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View();
            return dal.GetKf_PonderationBillMain_TempList_New(sHBillType, sHMaker, sHOWNERID);
        }


        //返回缓存列表信息  同步资料
        public DataSet GetKf_PonderationBillMain_TempList(string sHBillType, string sWhere)
        {
            DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View();
            return dal.GetKf_PonderationBillMain_TempList(sHBillType, sWhere);
        }




@@ -4484,6 +4618,33 @@
                return false;
            }
        }

        public bool set_SaveICMOReportBill_Json(WebAPI.WebS.ClsSc_ICMOReportBillMain oMain, string sHSourceType, ref string sErrMsg)
        {
            //BLL.ClsKf_POStockInBill bll = new BLL.ClsKf_POStockInBill();
            //return bll.set_SavePOStockInBill_New(oMain, sHSourceType, ref DBUtility.ClsPub.sExeReturnInfo);
            WebS.WebService1 oWebs = new WebS.WebService1();
            if (oWebs.set_SaveICMOReportBill_New(oMain, sHSourceType, ref sErrMsg))
            {
                //判断是否反写成功
                //if (set_UpdateHStatus(oMain.HInterID, oMain.HExplanation.ToString()))
                //{
                    sErrMsg = "保存成功！" + oMain.HBillNo;
                    return true;
                //}
                //else
                //{
                //    sErrMsg = "保存成功！" + oMain.HBillNo + "状态反写失败！";
                //    return true;
                //}
            }
            else
            {
                sErrMsg = "单据号：" + oMain.HBillNo + ", 单据ID：" + oMain.HInterID + ";" + sErrMsg;
                return false;
            }
        }


        /// <summary>
        /// 生成外购入库单K3
@@ -4839,17 +5000,19 @@
            WebS.WebService1 oWebs = new WebS.WebService1();
            if (oWebs.set_SaveProductInBill_New(oMain, sHSourceType, ref sErrMsg))
            {
                //判断是否反写成功
                if (set_UpdateHStatus(oMain.HInterID,oMain.HExplanation.ToString()))
                {
                    sErrMsg = "保存成功！" + oMain.HBillNo;
                    return true;
                }
                else
                {
                    sErrMsg = "保存成功！" + oMain.HBillNo + "状态反写失败！";
                    return true;
                }
                ////判断是否反写成功
                //if (set_UpdateHStatus(oMain.HInterID,oMain.HExplanation.ToString()))
                //{
                //    sErrMsg = "保存成功！" + oMain.HBillNo;
                //    return true;
                //}
                //else
                //{
                //    sErrMsg = "保存成功！" + oMain.HBillNo + "状态反写失败！";
                //    return true;
                //}
                sErrMsg = "保存成功！" + oMain.HBillNo;
                return true;
            }
            else
            {
@@ -6104,48 +6267,48 @@

                     //生成 委外出库 
                     string HReturn;
                     ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
                     string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
                     bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
                     if (bLogin)
                     {
                         var result = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save",
                         new object[] { "SUB_PickMtrl", sJson });
                     //ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
                     //string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
                     //bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
                     //if (bLogin)
                     //{
                     //    var result = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save",
                     //    new object[] { "SUB_PickMtrl", sJson });

                         if (oSystemParameterMain.Kf_EntrustOutBill_AutoCheck == "Y") //系统参数  自动审核 
                         {
                             string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}";
                             var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit",
                             new object[] { "SUB_PickMtrl", sJson2 });
                     //    if (oSystemParameterMain.Kf_EntrustOutBill_AutoCheck == "Y") //系统参数  自动审核 
                     //    {
                     //        string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}";
                     //        var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit",
                     //        new object[] { "SUB_PickMtrl", sJson2 });

                             string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}";
                             var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit",
                             new object[] { "SUB_PickMtrl", sJson3 });
                     //        string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}";
                     //        var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit",
                     //        new object[] { "SUB_PickMtrl", sJson3 });

                             HReturn = result.ToString() + "," + result2.ToString() + "," + result3.ToString();
                         }
                         else
                         {
                             HReturn = result.ToString();
                         }
                         if (HReturn.Contains("\"IsSuccess\":false") == true)
                         {
                             sErrMsg = "生成委外出库单失败！" + HReturn + sJson;
                             oCn.RollBack();
                             return false;
                         }
                         else
                         {
                             oCn.Commit();
                     //        HReturn = result.ToString() + "," + result2.ToString() + "," + result3.ToString();
                     //    }
                     //    else
                     //    {
                     //        HReturn = result.ToString();
                     //    }
                     //    if (HReturn.Contains("\"IsSuccess\":false") == true)
                     //    {
                     //        sErrMsg = "生成委外出库单失败！" + HReturn + sJson;
                     //        oCn.RollBack();
                     //        return false;
                     //    }
                     //    else
                     //    {
                     //        oCn.Commit();
                             return true;
                         }
                     }
                     else
                     {
                         sErrMsg = "生成委外出库单失败！登录失败！";
                         oCn.RollBack();
                         return false;
                     }
                         //}
                     //}
                     //else
                     //{
                     //    sErrMsg = "生成委外出库单失败！登录失败！";
                     //    oCn.RollBack();
                     //    return false;
                     //}
                 }
             }
             catch (Exception e)
@@ -7230,48 +7393,48 @@

                    //生成 其他入库单 1个物料1单
                    string HReturn;
                    ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
                    string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
                    bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
                    if (bLogin)
                    {
                        var result = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save",
                        new object[] { "STK_MISCELLANEOUS", sJson });
                    //ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
                    //string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
                    //bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
                    //if (bLogin)
                    //{
                    //    var result = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save",
                    //    new object[] { "STK_MISCELLANEOUS", sJson });

                        if (oSystemParameterMain.Kf_OtherInBill_AutoCheck == "Y") //系统参数  自动审核 
                        {
                            string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}";
                            var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit",
                            new object[] { "STK_MISCELLANEOUS", sJson2 });
                    //    if (oSystemParameterMain.Kf_OtherInBill_AutoCheck == "Y") //系统参数  自动审核 
                    //    {
                    //        string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}";
                    //        var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit",
                    //        new object[] { "STK_MISCELLANEOUS", sJson2 });

                            string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}";
                            var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit",
                            new object[] { "STK_MISCELLANEOUS", sJson3 });
                    //        string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}";
                    //        var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit",
                    //        new object[] { "STK_MISCELLANEOUS", sJson3 });

                            HReturn = result.ToString() + "," + result2.ToString() + "," + result3.ToString();
                        }
                        else
                        {
                            HReturn = result.ToString();
                        }
                        if (HReturn.Contains("\"IsSuccess\":false") == true)
                        {
                            sErrMsg = "其他入库单失败！" + HReturn + sJson;
                            oCn.RollBack();
                    //        HReturn = result.ToString() + "," + result2.ToString() + "," + result3.ToString();
                    //    }
                    //    else
                    //    {
                    //        HReturn = result.ToString();
                    //    }
                    //    if (HReturn.Contains("\"IsSuccess\":false") == true)
                    //    {
                    //        sErrMsg = "其他入库单失败！" + HReturn + sJson;
                    //        oCn.RollBack();
                            return false;
                        }
                        else
                        {
                            oCn.Commit();
                            return true;
                        }
                    }
                    else
                    {
                        sErrMsg = "其他入库单失败！登录失败！";
                        oCn.RollBack();
                        return false;
                    }
                        //}
                        //else
                        //{
                        //    oCn.Commit();
                        //    return true;
                        //}
                    //}
                    //else
                    //{
                    //    sErrMsg = "其他入库单失败！登录失败！";
                    //    oCn.RollBack();
                    //    return false;
                    //}
                }
            }
            catch (Exception e)
@@ -7767,5 +7930,89 @@
         }
        #endregion

        #region [获取打印模板]
        /// <summary>
        /// 打印模板列表
        /// </summary>
        /// <param name="sWhere"></param>
        /// <param name="sErr"></param>
        /// <returns></returns>
        public DataSet GetOpenTmpList(string sWhere, ref string sErr)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            DataSet ds = new DataSet();
            ds = oCn.RunProcReturn("select * from h_v_IF_OpenTmpList " + sWhere, "h_v_IF_OpenTmpList");
            return ds;
        }
        #endregion

        //返回条码临时表
        /// <summary>
        /// 返回条码临时表
        /// </summary>
        public DataSet GetBarCode_Temp(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)
        {
            DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View();
            return dal.GetBarCodeByID_View(HInterID, sBillType, HMaterID, HAuxPropID, HMTONo, HWhID, HSPID, HSCWhID, HSCSPID, HBatchNo, HSourceInterID, HSourceEntryID, sWhere);
        }

        //删除出入库条码临时表(根据条码)
        public bool set_DelPonderationBillMain_Temp_BarCode(long HInterID, string sBarCode, string sHBillType, ref string sErrMsg)
        {
            DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl();
            if (dal.DeleteByBarCode(HInterID, sBarCode, sHBillType))
            {
                sErrMsg = "删除成功！";
                return true;
            }
            else
            {
                sErrMsg = "删除失败！";
                return false;
            }
        }


        /// <summary>
        /// 返回扫码明细信息
        /// </summary>
        public DataSet GetBarcodeList(long HInterID, string HBillNo, string sBillType, ref string sMouldManagerCtl, ref string sFIFOCtl, ref string sErrMsg)
        {
            DAL.ClsKF_PonderationBillMain_Temp_View bll = new DAL.ClsKF_PonderationBillMain_Temp_View();
            return bll.GetBillEntry_TmpList(HInterID, HBillNo, sBillType, ref sMouldManagerCtl, ref sFIFOCtl, ref sErrMsg);
            //DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View();
            //return dal.GetInfoByID_View(HInterID, sBillType, sWhere);
        }

        //撤销缓存列表选中数据
        public bool RescindBillList(Int64 sHInterID, string sBillNo, string sBillType, ref string sErrMsg)
        {
            DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl();
            if (dal.DeleteICStockBillAndWMS(sHInterID, sBillNo, sBillType, ref sErrMsg))
            {
                sErrMsg = "删除成功！";
                return true;
            }
            else
            {
                sErrMsg = "删除失败！";
                return false;
            }
        }

        //返回缓存列表已上传列表信息
        public DataSet GetDisBillUpdateLoad_Json(string sHBillType, string HMaker, Int64 HOrgID)
        {
            DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View();
            return dal.GetKf_ICStockBillList(sHBillType, HMaker, HOrgID);
        }

        //返回缓存列表查询已上传列表信息
        public DataSet GetQueryBillUpdateLoad_Json(string BillType, string HBillNo, string HSourceBillNo)
        {
            DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View();
            return dal.GetKf_ICStockBillQueryList(BillType, HBillNo, HSourceBillNo);
        }

    }
}