| | |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | if (sWhere == null || sWhere.Equals("")) |
|---|
| | | { |
|---|
| | | 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"); |
|---|
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_Sc_ProcessExchangeBillList where 1=1 order by 单据号 desc,hsubid", "h_v_Sc_ProcessExchangeBillList"); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | |
|---|
| | | res.count = CountConstant.FAIL; |
|---|
| | | res.Message = "Exception！" + e.ToString(); |
|---|
| | | res.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | return res; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | |
|---|
| | | if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") |
|---|
| | | { |
|---|
| | | objjson.code = "0"; |
|---|
| | | objjson.count = 1; |
|---|
| | | objjson.count = 0; |
|---|
| | | objjson.Message = "该设备有多个计划单或点检规程,手动选着" ; |
|---|
| | | objjson.data = null; |
|---|
| | | return objjson; |
|---|
