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