| | |
|---|
| | | { |
|---|
| | | if (sWhere == null || sWhere.Equals("")) |
|---|
| | | { |
|---|
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_SellOutBillList order by 制单日期 desc", "h_v_IF_SellOutBillList"); |
|---|
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_SellOutBillList order by 制单日期 desc,单据号 desc", "h_v_IF_SellOutBillList"); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_SellOutBillList where 1=1 " + sWhere + " order by 制单日期 desc", "h_v_IF_SellOutBillList"); |
|---|
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_SellOutBillList where 1=1 " + sWhere + " order by 制单日期 desc,单据号 desc", "h_v_IF_SellOutBillList"); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | #endregion |
|---|
