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)