| | |
|---|
| | | [HttpGet] |
|---|
| | | public object GetSc_ProcessExchangeBillListView(string ICMOBill, int OrganizationID) |
|---|
| | | { |
|---|
| | | if (ICMOBill != "") |
|---|
| | | if (ICMOBill != "" & ICMOBill != null) |
|---|
| | | { |
|---|
| | | sWhere = " where 1=1 and 单据号 like '%" + ICMOBill + "%' "; |
|---|
| | | } |
|---|
| | |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | if (sWhere == null || sWhere.Equals("")) |
|---|
| | | { |
|---|
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillList where 1=1 order by 单据号 desc,hsubid ", "h_v_Sc_ProcessExchangeBillList"); |
|---|
| | | ds = oCN.RunProcReturn(" select * from h_v_Sc_ProcessExchangeBillList where 1=1 and 日期>=DATEADD(MONTH,-2,GETDATE()) order by 单据号 desc,hsubid", "h_v_Sc_ProcessExchangeBillList"); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
