public ActionResult GetTrackNumLevel2(string shipID, TrackNumQueryArg arg) { try { V_INQ_TRACKNUM_BLL tBLL = new V_INQ_TRACKNUM_BLL(); var result = tBLL.GetTrackNumLevel2(shipID, arg); return(Json(new RequestResult(result))); } catch (Exception ex) { LogHelper.WriteLog("GetTrackNumLevel2", ex); return(Json(new RequestResult(false, ex.Message))); } }
public List <TrackNumLevel2> GetTrackNumLevel2(string shipID, TrackNumQueryArg arg) { string sql = string.Format(@"select LODNUM , ORDNUM , ORDLIN , UNTQTY , ORDTYP , SALES_ORDNUM , VC_CPONUM , PRTNUM , CSTPRT , BTCUST , VC_DLRPONUM , MOD_USR_ID , NOTE1 , NOTE2 From V_INQ_TRACKNUM where SHIP_ID='{0}'", shipID); if (!string.IsNullOrEmpty(arg.SalesOrdNum)) { sql += string.Format(" and SALES_ORDNUM ='{0}' ", arg.SalesOrdNum); } if (!string.IsNullOrEmpty(arg.VCCpoNum)) { sql += string.Format(" and VC_CPONUM ='{0}' ", arg.VCCpoNum); } if (!string.IsNullOrEmpty(arg.PRTNum)) { sql += string.Format(" and PRTNUM ='{0}' ", arg.PRTNum); } if (!string.IsNullOrEmpty(arg.CSTPRT)) { sql += string.Format(" and CSTPRT ='{0}' ", arg.CSTPRT); } if (!string.IsNullOrEmpty(arg.LodNum)) { sql += string.Format(" and LODNUM ='{0}' ", arg.LodNum); } if (!string.IsNullOrEmpty(arg.OrdNum)) { sql += string.Format(" and ORDNUM like '%{0}%' ", arg.OrdNum); } var result = db.Database.SqlQuery <TrackNumLevel2>(sql); return(result.OrderByDescending(a => a.LODNUM).ToList()); }
public ActionResult GetTrackNumLevel1(TrackNumQueryArg arg) { if (arg == null || string.IsNullOrEmpty(arg.WHID)) { return(Json(new RequestResult(false, "Invalid arg data"))); } try { V_INQ_TRACKNUM_BLL tBLL = new V_INQ_TRACKNUM_BLL(); var result = tBLL.GetTrackNumLevel1(arg); return(Json(new RequestResult(result))); } catch (Exception ex) { LogHelper.WriteLog("GetTrackNumLevel1", ex); return(Json(new RequestResult(false, ex.Message))); } }
public List <TrackNumLevel1> GetTrackNumLevel1(TrackNumQueryArg arg) { string sql = string.Format(@"select distinct TRACK_TAB , TRACK_NUM, SHIP_ID , WH_ID , SHPSTS_DESC , CARCOD , CARNAM_SHORT , ADRNAM , ADRLN1 , ADRLN2 , PHNNUM , LAST_NAME, STGDTE , LODDTE, ENTDTE From V_INQ_TRACKNUM where WH_ID='{0}' ", arg.WHID); if (!string.IsNullOrEmpty(arg.SalesOrdNum)) { sql += string.Format(" and SALES_ORDNUM ='{0}' ", arg.SalesOrdNum); } if (!string.IsNullOrEmpty(arg.VCCpoNum)) { sql += string.Format(" and VC_CPONUM ='{0}' ", arg.VCCpoNum); } if (!string.IsNullOrEmpty(arg.TrackNum)) { sql += string.Format(" and TRACK_NUM ='{0}' ", arg.TrackNum); } if (!string.IsNullOrEmpty(arg.ShipID)) { sql += string.Format(" and SHIP_ID ='{0}' ", arg.ShipID); } if (!string.IsNullOrEmpty(arg.PRTNum)) { sql += string.Format(" and PRTNUM ='{0}' ", arg.PRTNum); } if (!string.IsNullOrEmpty(arg.CSTPRT)) { sql += string.Format(" and CSTPRT ='{0}' ", arg.CSTPRT); } if (!string.IsNullOrEmpty(arg.LodNum)) { sql += string.Format(" and LODNUM ='{0}' ", arg.LodNum); } if (!string.IsNullOrEmpty(arg.OrdNum)) { sql += string.Format(" and ORDNUM like '%{0}%' ", arg.OrdNum); } if (!string.IsNullOrEmpty(arg.ADRNam)) { sql += string.Format(" and ADRNAM like '%{0}%' ", arg.ADRNam); } if (!string.IsNullOrEmpty(arg.ADRLN1)) { sql += string.Format(" and ADRLN1 like '%{0}%' ", arg.ADRLN1); } if (!string.IsNullOrEmpty(arg.ADRLN2)) { sql += string.Format(" and ADRLN2 like '%{0}%' ", arg.ADRLN2); } var result = db.Database.SqlQuery <TrackNumLevel1>(sql); return(result.OrderByDescending(a => a.LODDTE).ToList()); }
public List <TrackNumLevel2> GetTrackNumLevel2(string shipID, TrackNumQueryArg arg) { return(dal.GetTrackNumLevel2(shipID, arg)); }
public List <TrackNumLevel1> GetTrackNumLevel1(TrackNumQueryArg arg) { return(dal.GetTrackNumLevel1(arg)); }