public RawMatitemView searchRawScan(RawMatScanSerchView model) { using (var ctx = new ConXContext()) { String[] strlist = model.qr.Split('|'); string vdoc_no = strlist[0]; string vprod_code = strlist[1]; string sqlp = "select prod_tname from product where prod_code = :p_prod_code"; string vprod_name = ctx.Database.SqlQuery <string>(sqlp, new OracleParameter("p_prod_code", vprod_code)) .FirstOrDefault(); if (vprod_name == null) { throw new Exception("ข้อมูลไม่ถูกต้อง"); } RawMatitemView view = new ModelViews.RawMatitemView() { process_tag_no = model.process_tag_no, doc_no = vdoc_no, prod_code = vprod_code, prod_name = vprod_name }; return(view); } }
public HttpResponseMessage searchRawScan(RawMatScanSerchView model) { try { var result = tagSvc.searchRawScan(model); return(Request.CreateResponse(HttpStatusCode.OK, result)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.ToString())); } }