| | |
| | | string sql = "select * from h_v_Sb_EquipRepairSendWorkBillList where 1=1 "; |
| | | if (sWhere == "" || sWhere == null) |
| | | { |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipRepairSendWorkBillList"); |
| | | ds = oCN.RunProcReturn(sql+ " order by hmainid desc ", "h_v_Sb_EquipRepairSendWorkBillList"); |
| | | } |
| | | else |
| | | { |
| | | ds = oCN.RunProcReturn(sql + sWhere, "h_v_Sb_EquipRepairSendWorkBillList"); |
| | | ds = oCN.RunProcReturn(sql + sWhere+ " order by hmainid desc ", "h_v_Sb_EquipRepairSendWorkBillList"); |
| | | } |
| | | |
| | | if (ds.Tables[0].Rows.Count == 0 || ds == null) |