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