| | |
|---|
| | | |
|---|
| | | public Dt_LocationInfo? GetLocationInfoSC(string v) |
|---|
| | | { |
|---|
| | | Dt_LocationInfo dt_Location = BaseDal.QueryFirst(x=>x.LocationStatus == (int)LocationStatusEnum.Free&& x.RoadwayNo == v&&x.EnableStatus == (int)EnableStatusEnum.Normal); |
|---|
| | | return dt_Location; |
|---|
| | | //Dt_LocationInfo dt_Location = BaseDal.QueryFirst(x => x.LocationStatus == (int)LocationStatusEnum.Free&& x.RoadwayNo == v &&x.EnableStatus == (int)EnableStatusEnum.Normal); |
|---|
| | | Dt_LocationInfo dt_LocationInfo = BaseDal.Db.Queryable<Dt_LocationInfo>() |
|---|
| | | .Where(x => x.LocationStatus == (int)LocationStatusEnum.Free |
|---|
| | | && x.RoadwayNo == v |
|---|
| | | && x.EnableStatus == (int)EnableStatusEnum.Normal) |
|---|
| | | .OrderBy("Layer DESC, CASE WHEN Row = 1 THEN 1 WHEN Row = 4 THEN 2 WHEN Row = 2 THEN 3 ELSE 4 END ASC") |
|---|
| | | .First(); |
|---|
| | | |
|---|
| | | return dt_LocationInfo; |
|---|
| | | } |
|---|
| | | |
|---|
| | | public Dt_LocationInfo? GetLocationInfoSC2(string v) |
|---|
| | | { |
|---|
| | | Dt_LocationInfo dt_LocationInfo = Db.Queryable<Dt_LocationInfo>() |
|---|
| | | .Where(x => x.LocationStatus == (int)LocationStatusEnum.Free |
|---|
| | | && x.RoadwayNo == v |
|---|
| | | && x.EnableStatus == (int)EnableStatusEnum.Normal) |
|---|
| | | .OrderBy("Layer DESC") |
|---|
| | | .First();// Layer浠庡ぇ鍒板皬鎺掑簭 |
|---|
| | | |
|---|
| | | return dt_LocationInfo; |
|---|
| | | } |
|---|
| | | |
|---|
| | | public class LocationCache |
|---|
