public List <ParkCarType> QueryCardTypesByBaseCardType(string parkingId, BaseCarType baseCarType)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,CarTypeID,CarTypeName,PKID,BaseTypeID,RepeatIn,RepeatOut");
strSql.Append(",AffirmIn,AffirmOut,InBeginTime,InEdnTime,MaxUseMoney,AllowLose,LpDistinguish,InOutEditCar");
strSql.Append(",InOutTime,CarNoLike,LastUpdateTime,HaveUpdate,IsAllowOnlIne,Amount,MaxMonth,MaxValue,DataStatus");
strSql.Append(",OverdueToTemp,LotOccupy,Deposit,MonthCardExpiredEnterDay,AffirmBegin,AffirmEnd,IsNeedCapturePaper,IsNeedAuthentication,IsDispatch,OnlineUnit,IsIgnoreHZ FROM ParkCarType");
strSql.Append(" WHERE PKID =@PKID AND DataStatus!=@DataStatus and BaseTypeID=@BaseTypeID");
using (DbOperator dbOperator = ConnectionManager.CreateReadConnection())
{
dbOperator.ClearParameters();
dbOperator.AddParameter("BaseTypeID", (int)baseCarType);
dbOperator.AddParameter("DataStatus", (int)DataStatus.Delete);
dbOperator.AddParameter("PKID", parkingId);
using (DbDataReader reader = dbOperator.ExecuteReader(strSql.ToString()))
{
List <ParkCarType> lists = new List <ParkCarType>();
while (reader.Read())
{
lists.Add(DataReaderToModel <ParkCarType> .ToModel(reader));
}
return(lists);
}
}
}
public int GetAreaCarNum(string areaID, BaseCarType carType, out string ErrorMessage)
{
ErrorMessage = "";
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT COUNT(*) from ParkTimeseries t LEFT JOIN parkiorecord i on t.IORecordID=i.RecordID left JOIN parkcartype c on i.CarTypeID=c.CarTypeID
LEFT JOIN parkgate g on t.EnterGateID = g.GateID LEFT JOIN parkbox b on b.BoxID = g.BoxID where c.BaseTypeID =@BaseTypeID
and b.AreaID =@AreaID and t.IsExit = 0 and t.DataStatus != @DataStatus ");
using (DbOperator dbOperator = ConnectionManager.CreateReadConnection())
{
dbOperator.ClearParameters();
dbOperator.AddParameter("BaseTypeID", (int)carType);
dbOperator.AddParameter("AreaID", areaID);
dbOperator.AddParameter("DataStatus", (int)DataStatus.Delete);
using (DbDataReader reader = dbOperator.ExecuteReader(strSql.ToString()))
{
if (reader.Read())
{
return(reader[0].ToString().ToInt());
}
}
}
}
catch (Exception e)
{
ErrorMessage = e.Message;
}
return(0);
}
public List <ParkGrant> Query(List <string> parkingIds, string plateNumber, BaseCarType carType)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT P.* FROM PARKGRANT P INNER JOIN EmployeePlate E ON P.PlateID=E.PlateID");
strSql.Append(" inner join ParkCarType t on t.CarTypeID=P.CarTypeID");
strSql.AppendFormat(" WHERE P.PKID in('{0}') AND t.BaseTypeID=@BaseTypeID", string.Join("','", parkingIds));
strSql.Append(" AND E.PlateNo=@PlateNo AND E.DataStatus!=@DataStatus AND P.DataStatus!=@DataStatus AND t.DataStatus!=@DataStatus");
using (DbOperator dbOperator = ConnectionManager.CreateReadConnection())
{
dbOperator.ClearParameters();
dbOperator.AddParameter("BaseTypeID", (int)carType);
dbOperator.AddParameter("PlateNo", plateNumber);
dbOperator.AddParameter("DataStatus", (int)DataStatus.Delete);
using (DbDataReader reader = dbOperator.ExecuteReader(strSql.ToString()))
{
List <ParkGrant> models = new List <ParkGrant>();
while (reader.Read())
{
models.Add(DataReaderToModel <ParkGrant> .ToModel(reader));
}
return(models);
}
}
}
public static int GetAreaCarNum(string areaID, BaseCarType cartype, out string ErrorMessage)
{
if (areaID.IsEmpty())
{
throw new ArgumentNullException("areaID");
}
IParkIORecord factory = ParkIORecordFactory.GetFactory();
return(factory.GetAreaCarNum(areaID, cartype, out ErrorMessage));
}
public static int GetAreaCarNum(string areaID, BaseCarType carType, out string ErrorMessage)
{
if (string.IsNullOrWhiteSpace(areaID))
{
throw new ArgumentNullException("areaID");
}
IParkTimeseries factory = ParkTimeseriesFactory.GetFactory();
return(factory.GetAreaCarNum(areaID, carType, out ErrorMessage));
}
public static List <ParkGrant> QueryHasLotByParkingId(string parkingId, BaseCarType carType)
{
if (parkingId.IsEmpty())
{
throw new ArgumentNullException("parkingId");
}
IParkGrant factory = ParkGrantFactory.GetFactory();
return(factory.QueryHasLotByParkingId(parkingId, carType));
}
public List <ParkCarType> QueryCardTypesByBaseCardType(string parkingId, BaseCarType baseCarType)
{
string strSql = "select * FROM ParkCarType WHERE PKID =@PKID AND DataStatus!=@DataStatus and BaseTypeID=@BaseTypeID";
using (DbOperator dbOperator = ConnectionManager.CreateReadConnection())
{
dbOperator.ClearParameters();
dbOperator.AddParameter("BaseTypeID", (int)baseCarType);
dbOperator.AddParameter("DataStatus", (int)DataStatus.Delete);
dbOperator.AddParameter("PKID", parkingId);
using (DbDataReader reader = dbOperator.ExecuteReader(strSql))
{
List <ParkCarType> lists = new List <ParkCarType>();
while (reader.Read())
{
lists.Add(DataReaderToModel <ParkCarType> .ToModel(reader));
}
return(lists);
}
}
}
public List <ParkGrant> QueryHasLotByParkingId(string parkingId, BaseCarType carType)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT P.* FROM PARKGRANT P inner join ParkCarType t on t.CarTypeID=P.CarTypeID");
strSql.Append(" WHERE t.BaseTypeID=@BaseTypeID and P.PKID=@PKID AND t.DataStatus!=@DataStatus AND P.DataStatus!=@DataStatus");
using (DbOperator dbOperator = ConnectionManager.CreateReadConnection())
{
dbOperator.ClearParameters();
dbOperator.AddParameter("BaseTypeID", (int)carType);
dbOperator.AddParameter("PKID", parkingId);
dbOperator.AddParameter("DataStatus", (int)DataStatus.Delete);
using (DbDataReader reader = dbOperator.ExecuteReader(strSql.ToString()))
{
List <ParkGrant> models = new List <ParkGrant>();
while (reader.Read())
{
models.Add(DataReaderToModel <ParkGrant> .ToModel(reader));
}
return(models);
}
}
}
public static List <ParkCarType> QueryCardTypesByBaseCardType(string parkingId, BaseCarType baseCarType)
{
if (string.IsNullOrWhiteSpace(parkingId))
{
throw new ArgumentNullException("parkingId");
}
IParkCarType factory = ParkCarTypeFactory.GetFactory();
return(factory.QueryCardTypesByBaseCardType(parkingId, baseCarType));
}
public static List <ParkGrant> Query(List <string> parkingIds, string plateNumber, BaseCarType carType)
{
if (parkingIds.Count == 0)
{
throw new ArgumentNullException("parkingIds");
}
if (plateNumber.IsEmpty())
{
throw new ArgumentNullException("plateNumber");
}
IParkGrant factory = ParkGrantFactory.GetFactory();
return(factory.Query(parkingIds, plateNumber, carType));
}
public static List <ParkGrant> QueryByParkingAndLotAndCarType(string parkingId, string lots, BaseCarType carType, string excludeGrantId)
{
if (parkingId.IsEmpty())
{
throw new ArgumentNullException("parkingId");
}
if (lots.IsEmpty())
{
throw new ArgumentNullException("lots");
}
IParkGrant factory = ParkGrantFactory.GetFactory();
return(factory.QueryByParkingAndLotAndCarType(parkingId, lots, carType, excludeGrantId));
}
public List <ParkGrant> QueryByParkingAndLotAndCarType(string parkingId, string lots, BaseCarType carType, string excludeGrantId)
{
List <ParkGrant> models = new List <ParkGrant>();
using (DbOperator dbOperator = ConnectionManager.CreateReadConnection())
{
string[] strLots = lots.TrimEnd(',').Split(',');
for (int i = 0; i < strLots.Length; i++)
{
dbOperator.ClearParameters();
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT G.* FROM ParkGrant G INNER JOIN ParkCarType P");
strSql.AppendFormat(" ON G.CarTypeID=P.CarTypeID WHERE g.GID!='{0}' AND G.PKID='{1}'", excludeGrantId, parkingId);
strSql.AppendFormat(" AND ','+G.PKLot+',' like '%,{0},%' AND P.BaseTypeID={1}", strLots[i], (int)carType);
strSql.AppendFormat(" AND G.DataStatus!={0} AND P.DataStatus!={0}", (int)DataStatus.Delete);
using (DbDataReader reader = dbOperator.ExecuteReader(strSql.ToString()))
{
while (reader.Read())
{
ParkGrant model = DataReaderToModel <ParkGrant> .ToModel(reader);
if (models.FirstOrDefault(p => p.GID == model.GID) == null)
{
models.Add(model);
}
}
}
}
return(models);
}
}
