public static bool AddByGateid(ParkCarlineInfo model)
{
if (model == null)
{
throw new ArgumentNullException("model");
}
IParkCarlineInfo factory = ParkCarlineInfoFactory.GetFactory();
var tempmode = factory.QueryByGate(model.Gateid);
bool result = false;
if (tempmode == null)
{
result = factory.Add(model);
if (result)
{
OperateLogServices.AddOperateLog <ParkCarlineInfo>(model, OperateType.Add);
}
}
else
{
result = factory.Update(model);
if (result)
{
OperateLogServices.AddOperateLog <ParkCarlineInfo>(model, OperateType.Update);
}
}
return(result);
}
public static bool Update(ParkCarlineInfo mode)
{
if (mode == null)
{
throw new ArgumentNullException("mode");
}
IParkCarlineInfo factory = ParkCarlineInfoFactory.GetFactory();
return(factory.Update(mode));
}
public ParkCarlineInfo QueryByGate(string gateId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from ParkCarlineInfo where GateId= @GateId");
using (DbOperator dbOperator = ConnectionManager.CreateReadConnection())
{
dbOperator.ClearParameters();
dbOperator.AddParameter("GateId", gateId);
using (DbDataReader reader = dbOperator.ExecuteReader(strSql.ToString()))
{
if (reader.Read())
{
ParkCarlineInfo model = DataReaderToModel <ParkCarlineInfo> .ToModel(reader);
return(model);
}
return(null);
}
}
}
public ParkCarlineInfo QueryMinTargetTimeInfo(string parkingID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT * from ParkCarlineInfo WHERE TargetTime = (SELECT min(TargetTime) FROM ParkCarlineInfo WHERE DataStatus!=@DataStatus and PKID=@PKID) and DataStatus!=@DataStatus and PKID=@PKID");
using (DbOperator dbOperator = ConnectionManager.CreateReadConnection())
{
dbOperator.ClearParameters();
dbOperator.AddParameter("DataStatus", (int)DataStatus.Delete);
dbOperator.AddParameter("PKID", parkingID);
using (DbDataReader reader = dbOperator.ExecuteReader(strSql.ToString()))
{
if (reader.Read())
{
ParkCarlineInfo model = DataReaderToModel <ParkCarlineInfo> .ToModel(reader);
return(model);
}
return(null);
}
}
}
public bool Update(ParkCarlineInfo model)
{
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
model.DataStatus = DataStatus.Normal;
model.LastUpdateTime = DateTime.Now;
model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag;
StringBuilder strSql = new StringBuilder();
strSql.Append("update ParkCarlineInfo set PKID=@PKID,PlateNumber=@PlateNumber,TargetTime=@TargetTime,Remark=@Remark");
strSql.Append(",LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate,DataStatus=@DataStatus where Gateid=@Gateid");
dbOperator.ClearParameters();
dbOperator.AddParameter("Gateid", model.Gateid);
dbOperator.AddParameter("PKID", model.PKID);
dbOperator.AddParameter("PlateNumber", model.PlateNumber);
dbOperator.AddParameter("TargetTime", model.TargetTime);
dbOperator.AddParameter("Remark", model.Remark);
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("HaveUpdate", model.HaveUpdate);
dbOperator.AddParameter("DataStatus", (int)model.DataStatus);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
}
public bool Add(ParkCarlineInfo model)
{
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
model.DataStatus = DataStatus.Normal;
model.LastUpdateTime = DateTime.Now;
model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ParkCarlineInfo(Gateid,PKID,PlateNumber,TargetTime,Remark,DataStatus,HaveUpdate,LastUpdateTime)");
strSql.Append(" values(@Gateid,@PKID,@PlateNumber,@TargetTime,@Remark,@DataStatus,@HaveUpdate,@LastUpdateTime)");
dbOperator.ClearParameters();
dbOperator.AddParameter("Gateid", model.Gateid);
dbOperator.AddParameter("PKID", model.PKID);
dbOperator.AddParameter("PlateNumber", model.PlateNumber);
dbOperator.AddParameter("TargetTime", model.TargetTime);
dbOperator.AddParameter("Remark", model.Remark);
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("HaveUpdate", model.HaveUpdate);
dbOperator.AddParameter("DataStatus", (int)model.DataStatus);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
}
