From a83c7a2548d482f283f7d52f99e0c28f23a32b16 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期五, 25 六月 2021 13:36:40 +0800
Subject: [PATCH] nothing

---
 WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs |   28 ++++++++++++++--------------
 1 files changed, 14 insertions(+), 14 deletions(-)

diff --git a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs
index 0bb2bce..a8f4959 100644
--- a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs
+++ b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs
@@ -22,13 +22,13 @@
         DataSet ds;
         DataSet ds1;
         string fileip = System.Configuration.ConfigurationManager.AppSettings["FileIP"];
-      
-    /// <summary>
-    /// 鏂板鍗曟嵁-淇濆瓨鎸夐挳
-    ///鍙傛暟锛歴tring sql銆�
-    ///杩斿洖鍊硷細object銆�
-    /// </summary>
-    [Route("Cj_StationOutBill/AddBill")]
+
+        /// <summary>
+        /// 鏂板鍗曟嵁-淇濆瓨鎸夐挳
+        ///鍙傛暟锛歴tring sql銆�
+        ///杩斿洖鍊硷細object銆�
+        /// </summary>
+        [Route("Cj_StationOutBill/AddBill")]
         [HttpPost]
         public object AddBill([FromBody] JObject oMain)
         {
@@ -540,7 +540,7 @@
                 {
                     File.Delete(fileurl);      //鍒犻櫎鎸囧畾鏂囦欢
                     files.SaveAs(fileurl);
-                    string StrPath = "/Files/"+ HBillNo+"/"+ filename;
+                    string StrPath = "/files/"+ HBillNo+"/"+ filename;
                     if (File.Exists(fileurl)) 
                     {
                         //杩欓噷鍙互鎵ц涓�浜涘叾瀹冪殑鎿嶄綔锛屾瘮濡傛洿鏂版暟鎹簱
@@ -563,7 +563,7 @@
                 {
                     Directory.CreateDirectory(fileSavePath); //娣诲姞鏂囦欢澶�
                     files.SaveAs(fileurl);
-                    string StrPath = "/Files/" + HBillNo + "/" + filename;
+                    string StrPath = "/files/" + HBillNo + "/" + filename;
                     if (File.Exists(fileurl))
                     {
                         //杩欓噷鍙互鎵ц涓�浜涘叾瀹冪殑鎿嶄綔锛屾瘮濡傛洿鏂版暟鎹簱
@@ -613,10 +613,11 @@
         [HttpGet]
         public object Filelist(string HBillNo)
         {
-            var url = fileip + "/Files/" + HBillNo+"/";
+            var url = fileip + "/files/" + HBillNo+"/";
+            //@"C:\\files\\"
             try
             {
-                ds = oCN.RunProcReturn("select *,'" + url + "'+CAST(HFileName as varchar(200))as url  from MES_AccessoriesList where HSourceBillNo=" + HBillNo, "MES_AccessoriesList");
+                ds = oCN.RunProcReturn("select *,'" + url + "'+CAST(HFileName as varchar(200))as url  from MES_AccessoriesList where HSourceBillNo='" + HBillNo+"'", "MES_AccessoriesList");
                 objJsonResult.code = "1";
                 objJsonResult.count = 1;
                 objJsonResult.Message = "Sucess锛�";
@@ -645,8 +646,8 @@
         {
             try
             {
-               
-                ds = oCN.RunProcReturn("delete from MES_AccessoriesList where HItemID ='" + HItemID + "'", "MES_AccessoriesList");
+
+                oCN.RunProc("delete from MES_AccessoriesList where HItemID =" + HItemID);
                 string fileurl = Path.Combine(HttpContext.Current.Server.MapPath("~/../Files/" + HSourceBillNo), HFileName);
                 File.Delete(fileurl);      //鍒犻櫎鎸囧畾鏂囦欢
                 objJsonResult.code = "1";
@@ -654,7 +655,6 @@
                 objJsonResult.Message = "鍒犻櫎鎴愬姛锛�";
                 objJsonResult.data = null;
                 return objJsonResult;
-
             }
             catch (Exception e)
             {

--
Gitblit v1.9.1