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()));
}
}
