From bc2b79aed4957e8d31ac82df5107c259cc5f4d9c Mon Sep 17 00:00:00 2001
From: yxj <yxj@hz-kingdee.com>
Date: 星期五, 12 九月 2025 14:42:20 +0800
Subject: [PATCH] 全部上传生成金蝶云单据相关方法中金蝶云账号获取方式修改

---
 CLOUDWEB/WebService1.asmx.cs |  412 +++++++++++++++++++++++++++++++++++++++++-----------------
 1 files changed, 288 insertions(+), 124 deletions(-)

diff --git a/CLOUDWEB/WebService1.asmx.cs b/CLOUDWEB/WebService1.asmx.cs
index 9165c44..2da50d5 100644
--- a/CLOUDWEB/WebService1.asmx.cs
+++ b/CLOUDWEB/WebService1.asmx.cs
@@ -4464,6 +4464,7 @@
         /// <returns></returns>
         public bool SaveICMOReportBill_ICMO_CLD(Model.ClsSc_ICMOReportBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -4475,7 +4476,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -4489,7 +4492,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -5229,7 +5231,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -6417,7 +6421,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -6487,6 +6493,7 @@
         //鍙戣揣璋冩嫧
         private bool SaveMoveSellOut_CLD(Model.ClsKf_MoveStockBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -6498,7 +6505,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -6512,7 +6521,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -7048,7 +7056,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -7335,6 +7345,7 @@
         /// <returns></returns>
         private bool SaveMoveOut_CLD_PD(Model.ClsKf_MoveStockBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -7346,7 +7357,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -7360,7 +7373,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -8771,6 +8783,7 @@
         /// <returns></returns>
         private bool SaveMoveStockBill_PPBom_CLD(Model.ClsKf_MoveStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -8782,7 +8795,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -8796,7 +8811,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -9248,6 +9262,7 @@
         /// <returns></returns>
         private bool SaveMoveStockBill_WWPPBom_CLD(Model.ClsKf_MoveStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -9259,7 +9274,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -9273,7 +9290,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -9711,6 +9727,7 @@
         /// <returns></returns>
         private bool SaveMoveStockBill_SeOutStock_CLD(Model.ClsKf_MoveStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -9722,7 +9739,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -9736,7 +9755,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -10200,6 +10218,7 @@
         /// <returns></returns>
         private bool SaveMoveStockBill_MoveStockRequest_CLD(Model.ClsKf_MoveStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -10211,7 +10230,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -10225,7 +10246,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -10683,6 +10703,7 @@
         /// <returns></returns>
         private bool SaveMoveStockBill_StockOutRequest_CLD(Model.ClsKf_MoveStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -10694,7 +10715,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -10708,7 +10731,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -11149,6 +11171,7 @@
         /// <returns></returns>
         private bool SaveMoveStockBill_MateOutRequest_CLD(Model.ClsKf_MoveStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -11160,7 +11183,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -11174,7 +11199,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -11615,6 +11639,7 @@
         /// <returns></returns>
         private bool SaveMoveStockBill_PrepareMTRL_CLD(Model.ClsKf_MoveStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -11626,7 +11651,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -11640,7 +11667,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -12086,6 +12112,7 @@
         /// <returns></returns>
         private bool SaveMoveOut_CLD(Model.ClsKf_MoveStockBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -12097,7 +12124,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -12111,7 +12140,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -12778,7 +12806,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -12998,7 +13028,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -13218,6 +13250,7 @@
         /// <returns></returns>
         public bool SaveMoveStockStepOutBill_MoveStockRequest_CLD_New(Model.ClsKf_MoveStockStepOutBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -13229,7 +13262,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -13243,7 +13278,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -13670,6 +13704,7 @@
         /// <returns></returns>
         public bool SaveMoveStockStepOutBill_SeOutStock_CLD_New(Model.ClsKf_MoveStockStepOutBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -13681,7 +13716,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -13695,7 +13732,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -14155,6 +14191,7 @@
         /// <returns></returns>
         public bool SaveMoveStockStepOutBill_CLD_New(Model.ClsKf_MoveStockStepOutBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -14166,7 +14203,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -14180,7 +14219,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -14691,6 +14729,7 @@
         /// <returns></returns>
         public bool SaveMoveStockStepInBill_MoveStockStepOut_CLD_New(Model.ClsKf_MoveStockStepInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -14702,7 +14741,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -14716,7 +14757,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -16240,6 +16280,7 @@
         /// <returns></returns>
         private bool SaveSellOutBackBill_SeOutStockBack_CLD_New(Model.ClsKf_ICStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -16251,7 +16292,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -16265,7 +16308,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -16733,6 +16775,7 @@
         /// <returns></returns>
         private bool SaveSellOutBackBill_SeOrder_CLD(Model.ClsKf_ICStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -16744,7 +16787,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -16758,7 +16803,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -17551,7 +17595,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -18491,6 +18537,7 @@
         /// <returns></returns>
         private bool SaveSellOutBill_SeOrder_CLD(Model.ClsKf_SellOutBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -18502,7 +18549,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -18516,7 +18565,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -18998,6 +19046,7 @@
         /// <returns></returns>
         private bool SaveSellOutBill_SeOutStock_CLD(Model.ClsKf_SellOutBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -19009,7 +19058,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -19023,7 +19074,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -19653,6 +19703,7 @@
 
         private bool SaveSellOutBill_CLD(Model.ClsKf_SellOutBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -19664,7 +19715,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -19678,7 +19731,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -20222,7 +20274,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -20439,7 +20493,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -20760,7 +20816,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -21165,6 +21223,7 @@
         /// <returns></returns>
         public bool SaveMateOutBackBill_PPBom_CLD(Model.ClsKf_ICStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -21176,7 +21235,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -21190,7 +21251,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -22156,6 +22216,7 @@
         /// <returns></returns>
         public bool SaveMateOutBill_PPBom_CLD(Model.ClsKf_MateOutBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -22167,7 +22228,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -22181,7 +22244,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -22613,6 +22675,7 @@
         /// <returns></returns>
         public bool SaveMateOutBill_MateOutRequest_CLD(Model.ClsKf_MateOutBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -22624,7 +22687,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -22638,7 +22703,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -23065,6 +23129,7 @@
         /// <returns></returns>
         public bool SaveMateOutBill_PrepareMTRL_CLD(Model.ClsKf_MateOutBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -23076,7 +23141,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -23090,7 +23157,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -23698,7 +23764,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -23889,7 +23957,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -24108,7 +24178,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -24299,6 +24371,7 @@
         /// <returns></returns>
         public bool SaveMateReplenishOutBill_PPBom_CLD(Model.ClsKf_MateReplenishOutBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -24310,7 +24383,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -24324,7 +24399,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -24873,7 +24947,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -25092,7 +25168,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -25319,7 +25397,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -25530,7 +25610,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -25822,7 +25904,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -26230,6 +26314,7 @@
         /// <returns></returns>
         public bool SaveEntrustOutBackBill_WWPPBom_CLD(Model.ClsKf_ICStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -26241,7 +26326,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -26255,7 +26342,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -27152,6 +27238,7 @@
         /// <returns></returns>
         private bool SaveEntrustOutBill_WWPPBom_CLD(Model.ClsKf_EntrustOutBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -27163,7 +27250,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -27177,7 +27266,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -27806,7 +27894,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -27990,7 +28080,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -28201,7 +28293,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -29107,6 +29201,7 @@
         /// <returns></returns>
         public bool SaveOtherOutBill_StockOutRequest_CLD(Model.ClsKf_OtherOutBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -29118,7 +29213,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -29132,7 +29229,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -29512,6 +29608,7 @@
         /// <returns></returns>
         public bool SaveOtherOutBill_CLD(Model.ClsKf_OtherOutBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -29523,7 +29620,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -29537,7 +29636,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -30069,6 +30167,7 @@
         /// <returns></returns>
         public bool SaveOtherOutBill_CLD(Model.ClsKf_OtherOutBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -30080,7 +30179,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -30094,7 +30195,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -30546,7 +30646,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -30765,7 +30867,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -31266,6 +31370,7 @@
         /// <returns></returns>
         public bool SavePOStockInBackBill_POOrder_CLD_New(Model.ClsKf_ICStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -31277,7 +31382,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -31291,7 +31398,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -31760,6 +31866,7 @@
         /// <returns></returns>
         public bool SavePOStockInBackBill_POInStockBack_CLD_New(Model.ClsKf_ICStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -31771,7 +31878,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -31785,7 +31894,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -32533,7 +32641,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -33284,6 +33394,7 @@
         /// <returns></returns>
         public bool SavePOStockInBill_POInStock_CLD(Model.ClsKf_POStockInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -33295,7 +33406,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -33309,7 +33422,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -33773,6 +33885,7 @@
         /// <returns></returns>
         public bool SavePOStockInBill_POOrder_CLD(Model.ClsKf_POStockInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -33784,7 +33897,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -33798,7 +33913,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -34238,6 +34352,7 @@
         /// <returns></returns>
         public bool SavePOStockInBill_POInStock_CLD_Merge(Model.ClsKf_POStockInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -34249,7 +34364,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -34263,7 +34380,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -34918,7 +35034,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -35183,7 +35301,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -35373,7 +35493,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -35592,7 +35714,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -35940,7 +36064,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -36126,7 +36252,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -37062,6 +37190,7 @@
         /// <returns></returns>
         public bool SaveProductInBill_ICMO_CLD(Model.ClsKf_ProductInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -37073,7 +37202,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -37087,7 +37218,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -37494,6 +37624,7 @@
         /// <returns></returns>
         public bool SaveProductInBill_ICMOReport_CLD(Model.ClsKf_ProductInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -37505,7 +37636,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -37519,7 +37652,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -37939,6 +38071,7 @@
         /// <returns></returns>
         public bool SaveProductInBill_ProcessReport_CLD(Model.ClsKf_ProductInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -37950,7 +38083,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -37964,7 +38099,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -38574,7 +38708,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -38764,7 +38900,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -38983,7 +39121,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -39909,6 +40049,7 @@
         /// <returns></returns>
         public bool SaveEntrustInBill_POInStock_CLD(Model.ClsKf_EntrustInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -39920,7 +40061,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -39934,7 +40077,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -40603,7 +40745,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -41463,6 +41607,7 @@
         /// <returns></returns>
         public bool SaveOtherInBill_CLD(Model.ClsKf_OtherInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -41474,7 +41619,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -41488,7 +41635,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -41889,6 +42035,7 @@
         /// <returns></returns>
         public bool SaveOtherInBill_StockInRequest_CLD_SenKai(Model.ClsKf_OtherInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -41900,7 +42047,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -41914,7 +42063,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -42227,6 +42375,7 @@
         /// <returns></returns>
         public bool SaveOtherInBill_StockInRequest_CLD_Merge_SenKai(Model.ClsKf_OtherInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
         {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
             string sRemark = "";
             //浠庨厤缃枃浠惰幏鍙� CLOUD缃戝潃銆佽处濂椾俊鎭�佺櫥褰曠敤鎴枫�佺櫥褰曞瘑鐮�
             if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
@@ -42238,7 +42387,9 @@
             //鑾峰彇CLOUD璐﹀彿瀵嗙爜
             string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
             string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-            DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+            //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+            DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
             if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
             {
             }
@@ -42252,7 +42403,6 @@
             ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
             string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
             bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);
-            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
 
             sRemark = sRemark + " 锛涜幏鍙栭獙璇丆LOUD璐﹀彿瀵嗙爜" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
 
@@ -42853,7 +43003,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -43070,7 +43222,9 @@
                 //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                 string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                 string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                 if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                 {
                 }
@@ -43480,7 +43634,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -43832,7 +43988,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -44115,7 +44273,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -44466,7 +44626,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }
@@ -44760,7 +44922,9 @@
                     //鑾峰彇CLOUD璐﹀彿瀵嗙爜
                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
-                    DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID);
+
+                    //浠庣敤鎴疯〃鑾峰彇鐢ㄦ埛缁戝畾閲戣澏璐﹀彿
+                    DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0)
                     {
                     }

--
Gitblit v1.9.1