| | |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | if (sqlWhere == null || sqlWhere.Equals("")) |
|---|
| | | { |
|---|
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_QC_PatrolProcCheckBillList where 关闭人='' order by hmainid desc ", "h_v_QC_PatrolProcCheckBillList"); |
|---|
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_QC_PatrolProcCheckBillMainList where 关闭人='' order by hmainid desc ", "h_v_QC_PatrolProcCheckBillMainList"); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | string sql1 = "select * from h_v_QC_PatrolProcCheckBillList where 关闭人='' "; |
|---|
| | | string sql1 = "select * from h_v_QC_PatrolProcCheckBillMainList where 关闭人='' "; |
|---|
| | | string sql = sql1 + sqlWhere+ " order by 制单日期 desc "; |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_QC_PatrolProcCheckBillList"); |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_QC_PatrolProcCheckBillMainList"); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
