| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_QCCheckProjectList_Main order by 日期 desc ", "h_v_Gy_QCCheckProjectList_Main"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_QCCheckProjectList_Main order by 日期 desc,单据号 DESC ", "h_v_Gy_QCCheckProjectList_Main"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_QCCheckProjectList_Main where 1=1"; |
| | | string sql = sql1 + sWhere + " order by 日期 desc "; |
| | | string sql = sql1 + sWhere + " order by 日期 desc,单据号 DESC "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_QCCheckProjectList_Main"); |
| | | } |
| | | } |