public ScanSendFinView SerachCanPcs(ScanSendFinSearchView model) { using (var ctx = new ConXContext()) { //define model view ScanSendFinView view = new ModelViews.ScanSendFinView() { pageIndex = model.pageIndex - 1, itemPerPage = model.itemPerPage, totalItem = 0, datas = new List <ModelViews.ScanSendDataView>() }; string sql = "select a.PCS_BARCODE , a.PROD_CODE ,a.PROD_NAME , a.MODEL_NAME model_desc"; sql += " from MPS_DET_WC a , PDMODEL_MASt b "; sql += " where a.pddsgn_code = b.pdmodel_code"; sql += " and a.mps_st = 'N'"; sql += " and a.fin_by = :p_user_id"; sql += " and trunc(a.fin_date) = trunc(SYSDATE)"; sql += " and a.entity = :p_entity"; sql += " and a.wc_code = :p_wc_code"; sql += " and a.pdsize_code = :p_pdsize_code"; sql += " and b.spring_type = :p_springtype_code"; List <ScanSendDataView> scan = ctx.Database.SqlQuery <ScanSendDataView>(sql, new OracleParameter("p_user_id", model.user_id), new OracleParameter("p_entity", model.entity), new OracleParameter("p_wc_code", model.wc_code), new OracleParameter("p_pdsize_code", model.pdsize_code), new OracleParameter("p_springtype_code", model.springtype_code)).ToList(); view.totalItem = scan.Count; scan = scan.Skip(view.pageIndex * view.itemPerPage) .Take(view.itemPerPage) .ToList(); ////prepare model to modelView foreach (var i in scan) { view.datas.Add(new ModelViews.ScanSendDataView() { pcs_barcode = i.pcs_barcode, model_desc = i.model_desc, prod_code = i.prod_code, prod_name = i.prod_name }); } //return data to contoller return(view); } }
public HttpResponseMessage postSerachCanPcs(ScanSendFinSearchView model) { try { var result = sendSvc.SerachCanPcs(model); return(Request.CreateResponse(HttpStatusCode.OK, result)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.ToString())); } }