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