public List <Rcpk1> Get_Rcpk_List(Rcpk request) { List <Rcpk1> Result = null; try { using (var db = DbConnectionFactory.OpenDbConnection("WMS")) { string strSQL = " Select ISNULL(PackType,'') AS PackType,ISNULL(PackTypeCode,'') AS PackTypeCode From Rcpk1 Where PackType !='' "; Result = db.Select <Rcpk1>(strSQL); } } catch { throw; } return(Result); }
public void TS_Rcpk(Auth auth, Rcpk request, rcpk_loigc rcpk_Logic, CommonResponse ecr, string[] token, string uri) { if (auth.AuthResult(token, uri)) { if (uri.IndexOf("/wms/Rcpk") > 0) { ecr.data.results = rcpk_Logic.Get_Rcpk_List(request); } ecr.meta.code = 200; ecr.meta.message = "OK"; } else { ecr.meta.code = 401; ecr.meta.message = "Unauthorized"; } }