zzr99
2021-11-01 8bab165c338cb9aeaa64080210ea2f9f0d747cee
nothing
1个文件已修改
6 ■■■■ 已修改文件
WebAPI/Controllers/PublicPageMethodController.cs 6 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/PublicPageMethodController.cs
@@ -1442,13 +1442,13 @@
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("Select HItemID,HParentID,HNumber,HName from Gy_EquipMent where HStopflag=0 Order by HItemID", "Gy_EquipMent");
                    ds = oCN.RunProcReturn("Select HInterID,HEquipFileNumber,HName from Gy_EquipFileBillMain Order by HInterID", "Gy_EquipFileBillMain");
                }
                else
                {
                    string sql1 = "Select HItemID,HParentID,HNumber,HName from Gy_EquipMent where 1 = 1 ";
                    string sql1 = "Select HInterID,HEquipFileNumber,HName from Gy_EquipFileBillMain where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "Gy_EquipMent");
                    ds = oCN.RunProcReturn(sql, "HEquipFileNumber");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {