From 2a123c42eab1784b04d6bb50f56aef76c2d27377 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期四, 18 七月 2024 09:41:16 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/品质管理/巡检单/QC_PatrolProcCheckOtherBillController.cs | 2 +- WebAPI/Controllers/品质管理/首件检验单/QC_FirstPieceCheckBillController.cs | 4 ++-- WebAPI/Controllers/品质管理/工序检验单/QC_ProcessCheckBillController.cs | 2 +- 3 files changed, 4 insertions(+), 4 deletions(-) diff --git "a/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\345\267\241\346\243\200\345\215\225/QC_PatrolProcCheckOtherBillController.cs" "b/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\345\267\241\346\243\200\345\215\225/QC_PatrolProcCheckOtherBillController.cs" index 6263785..52e6cd7 100644 --- "a/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\345\267\241\346\243\200\345\215\225/QC_PatrolProcCheckOtherBillController.cs" +++ "b/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\345\267\241\346\243\200\345\215\225/QC_PatrolProcCheckOtherBillController.cs" @@ -34,7 +34,7 @@ List<object> columnNameList = new List<object>(); string sql1 = "select * from h_v_QC_PatrolProcCheckOtherBill where 1 = 1 "; - string sql = sql1 + sWhere + " order by hmainid "; + string sql = sql1 + sWhere + " order by 鍒跺崟鏃ユ湡 desc "; ds = oCN.RunProcReturn(sql, "h_v_QC_PatrolProcCheckOtherBill"); //娣诲姞鍒楀悕 diff --git "a/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\345\267\245\345\272\217\346\243\200\351\252\214\345\215\225/QC_ProcessCheckBillController.cs" "b/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\345\267\245\345\272\217\346\243\200\351\252\214\345\215\225/QC_ProcessCheckBillController.cs" index 05ae380..924a72a 100644 --- "a/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\345\267\245\345\272\217\346\243\200\351\252\214\345\215\225/QC_ProcessCheckBillController.cs" +++ "b/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\345\267\245\345\272\217\346\243\200\351\252\214\345\215\225/QC_ProcessCheckBillController.cs" @@ -136,7 +136,7 @@ List<object> columnNameList = new List<object>(); string sql1 = "select * from h_v_QC_ProcessCheckBillMainList where 1 = 1 "; - string sql = sql1 + sWhere + " order by hmainid desc"; + string sql = sql1 + sWhere + " order by 鍒跺崟鏃ユ湡 desc"; ds = oCN.RunProcReturn(sql, "h_v_QC_ProcessCheckBillMainList"); //娣诲姞鍒楀悕 diff --git "a/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\351\246\226\344\273\266\346\243\200\351\252\214\345\215\225/QC_FirstPieceCheckBillController.cs" "b/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\351\246\226\344\273\266\346\243\200\351\252\214\345\215\225/QC_FirstPieceCheckBillController.cs" index 1ad168a..e3124e8 100644 --- "a/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\351\246\226\344\273\266\346\243\200\351\252\214\345\215\225/QC_FirstPieceCheckBillController.cs" +++ "b/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\351\246\226\344\273\266\346\243\200\351\252\214\345\215\225/QC_FirstPieceCheckBillController.cs" @@ -34,7 +34,7 @@ List<object> columnNameList = new List<object>(); string sql1 = "select * from h_v_QC_FirstPieceCheckBill where 1 = 1 "; - string sql = sql1 + sWhere + " order by hmainid desc"; + string sql = sql1 + sWhere + " order by 鍒跺崟鏃ユ湡 desc"; ds = oCN.RunProcReturn(sql, "h_v_QC_FirstPieceCheckBill"); //娣诲姞鍒楀悕 @@ -85,7 +85,7 @@ List<object> columnNameList = new List<object>(); string sql1 = "select * from h_v_QC_FirstPieceCheckBillMainList where 1 = 1 "; - string sql = sql1 + sWhere + " order by 鍒跺崟鏃ユ湡 desc"; + string sql = sql1 + sWhere + " "; ds = oCN.RunProcReturn(sql, "h_v_QC_FirstPieceCheckBillMainList"); //娣诲姞鍒楀悕 -- Gitblit v1.9.1