Merge branch 'master' of http://101.37.171.70:10101/r/MESWMS-API
| | |
| | | /// <returns></returns> |
| | | [Route("Web/GetMaterialList_Json")] |
| | | [HttpGet] |
| | | public object GetMaterialList_Json(string Material) |
| | | public object GetMaterialList_Json(string sWhere) |
| | | { |
| | | sWhere = " Where HStopFlag=0 and HEndFlag=1"; |
| | | //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); |
| | | if (Material != "") |
| | | { |
| | | sWhere = sWhere + " and ( HNumber like '%" + Material + "%' or HName like '%" + Material + "%' ) "; |
| | | } |
| | | try |
| | | { |
| | | ds = webserver.GetMaterialList(sWhere, ref DBUtility.ClsPub.sErrInfo); |