zzr99
2022-02-10 dac1d793ad118eebf9048588a356ae0ea8a3aa95
WebAPI/Controllers/GZGL/Gy_WorkTypeBillController.cs
@@ -44,12 +44,12 @@
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Gy_WorkTypeList " + sWhere, "h_v_Gy_WorkTypeList");
                    ds = oCN.RunProcReturn("select * from h_v_Gy_WorkTypeList  order by 工种代码", "h_v_Gy_WorkTypeList");
                }
                else
                {
                    string sql1 = "select * from h_v_Gy_WorkTypeList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    string sql = sql1 + sWhere+ " order by 工种代码";
                    ds = oCN.RunProcReturn(sql, "h_v_Gy_WorkTypeList");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)