private static ChargingBaseEntity TranslateChargingBaseInfo(ChargingBaseInfo chargeBaseInfo)
{
ChargingBaseEntity chargingBaseEntity = new ChargingBaseEntity();
if (chargeBaseInfo != null)
{
chargingBaseEntity.ChargeBaseID = chargeBaseInfo.ChargeBaseID;
chargingBaseEntity.Name = chargeBaseInfo.Name;
chargingBaseEntity.Code = chargeBaseInfo.Code;
chargingBaseEntity.ChargeFee = chargeBaseInfo.ChargeFee;
chargingBaseEntity.ServerFee = chargeBaseInfo.ServerFee;
chargingBaseEntity.ParkFee = chargeBaseInfo.ParkFee;
chargingBaseEntity.ChargeNum = chargeBaseInfo.ChargeNum;
chargingBaseEntity.PayType = chargeBaseInfo.PayType;
chargingBaseEntity.Address = chargeBaseInfo.Address;
chargingBaseEntity.Coordinate = chargeBaseInfo.Coordinate;
chargingBaseEntity.StartTime = chargeBaseInfo.StartTime;
chargingBaseEntity.EndTime = chargeBaseInfo.EndTime;
chargingBaseEntity.IsUse = chargeBaseInfo.IsUse;
chargingBaseEntity.CityID = chargeBaseInfo.CityID;
if (!string.IsNullOrEmpty(chargingBaseEntity.PayType))
{
chargingBaseEntity.PayTypeName = GetPayTypeNames(chargingBaseEntity.PayType);
}
if (chargingBaseEntity.CityID > 0)
{
City city = BaseDataService.GetAllCity().FirstOrDefault(t => t.CityID == chargingBaseEntity.CityID);
chargingBaseEntity.CityInfo = city;
}
}
return(chargingBaseEntity);
}
public static bool ModifyChargingBase(ChargingBaseEntity entity)
{
int result = 0;
if (entity != null)
{
ChargeRepository mr = new ChargeRepository();
ChargingBaseInfo info = TranslateChargingBaseEntity(entity);
if (entity.ChargeBaseID > 0)
{
result = mr.ModifyChargingBase(info);
}
else
{
info.CreateDate = DateTime.Now;
result = mr.CreateNewChargingBase(info);
}
List <ChargingBaseInfo> miList = mr.GetAllChargingBaseInfo();//刷新缓存
Cache.Add("ChargingBaseALL", miList);
}
return(result > 0);
}
public static bool ModifyChargingPile(ChargingPileEntity entity)
{
int result = 0;
if (entity != null)
{
ChargeRepository mr = new ChargeRepository();
ChargingPileInfo info = TranslateChargingPileEntity(entity);
if (entity.ID > 0)
{
result = mr.ModifyChargingPile(info);
}
else
{
info.CreateDate = DateTime.Now;
result = mr.CreateNewChargingPile(info);
if (result > 0)
{
ChargingBaseInfo cb = mr.GetChargingBaseById(info.ChargingBaseID);
if (cb != null)
{
int num = cb.ChargeNum + 1;
mr.ModifyPileNum(num, info.ChargingBaseID);
}
}
}
List <ChargingPileInfo> miList = mr.GetAllChargingPileInfo();//刷新缓存
Cache.Add("ChargingPileALL", miList);
}
return(result > 0);
}
public ChargingBaseInfo GetChargingBaseById(int id)
{
ChargingBaseInfo chbase = new ChargingBaseInfo();
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(ChargeStatement.GetChargingBaseByKey, "Text"));
command.AddInputParameter("@ChargeBaseID", DbType.Int32, id);
chbase = command.ExecuteEntity <ChargingBaseInfo>();
return(chbase);
}
public static ChargingBaseEntity TransChargeBase(ChargingBaseInfo info, bool isShowPile = false)
{
ChargingBaseEntity entity = new ChargingBaseEntity();
entity.ChargeBaseID = info.ChargeBaseID;
entity.Name = info.Name;
entity.Code = info.Code;
entity.ChargeFee = info.ChargeFee;
entity.ParkFee = info.ParkFee;
entity.ChargeNum = info.ChargeNum;
entity.PayType = info.PayType;
entity.StartTime = info.StartTime;
entity.EndTime = info.EndTime;
entity.IsUse = info.IsUse;
Random rd = new Random();
int R = rd.Next(1, 8);
entity.imageUrl = FileUrl + "/Images/Charging/" + R + ".jpg";;
if (isShowPile)
{
entity.chargingPile = new List <ChargingPileEntity>();
List <ChargingPileInfo> lstCharging = Cache.Get <List <ChargingPileInfo> >("GetChargingPileInfo" + info.ChargeBaseID);
if (lstCharging.IsEmpty())
{
lstCharging = ChargeRepository.GetChargingPileInfo(info.ChargeBaseID.ToString());;
Cache.Add("GetChargingPileInfo" + info.ChargeBaseID, lstCharging);
}
if (lstCharging != null && lstCharging.Count > 0)
{
foreach (ChargingPileInfo info1 in lstCharging)
{
ChargingPileEntity entityP = new ChargingPileEntity();
entityP.ID = info1.ID;
entityP.Code = info1.Code;
entityP.ChargingBaseID = info1.ChargingBaseID;
entityP.Standard = info1.Standard;
entityP.SOC = info1.SOC;
entityP.Power = info1.Power + "KW";
entityP.Electric = info1.Electric;
entityP.CElectric = info1.CElectric;
entityP.Voltage = info1.Voltage + "V";
entityP.CVoltage = info1.CVoltage + "V";
R = rd.Next(1, 6);
entityP.imageUrl = FileUrl + "/Images/Charging/p" + R + ".jpg";;
entity.chargingPile.Add(entityP);
}
}
}
return(entity);
}
public int CreateNewChargingBase(ChargingBaseInfo baseInfo)
{
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(ChargeStatement.CreateChargingBase, "Text"));
command.AddInputParameter("@Name", DbType.String, baseInfo.Name);
command.AddInputParameter("@Code", DbType.String, baseInfo.Code);
command.AddInputParameter("@ChargeFee", DbType.Decimal, baseInfo.ChargeFee);
command.AddInputParameter("@ServerFee", DbType.Decimal, baseInfo.ServerFee);
command.AddInputParameter("@ParkFee", DbType.Decimal, baseInfo.ParkFee);
command.AddInputParameter("@ChargeNum", DbType.Int32, baseInfo.ChargeNum);
command.AddInputParameter("@PayType", DbType.String, baseInfo.PayType);
command.AddInputParameter("@Address", DbType.String, baseInfo.Address);
command.AddInputParameter("@Coordinate", DbType.String, baseInfo.Coordinate);
command.AddInputParameter("@StartTime", DbType.String, baseInfo.StartTime);
command.AddInputParameter("@EndTime", DbType.String, baseInfo.EndTime);
command.AddInputParameter("@IsUse", DbType.Int32, baseInfo.IsUse);
command.AddInputParameter("@CreateDate", DbType.DateTime, baseInfo.CreateDate);
return(command.ExecuteNonQuery());
}
private static ChargingBaseInfo TranslateChargingBaseEntity(ChargingBaseEntity chargingBaseEntity)
{
ChargingBaseInfo chargeBaseInfo = new ChargingBaseInfo();
if (chargingBaseEntity != null)
{
chargeBaseInfo.ChargeBaseID = chargingBaseEntity.ChargeBaseID;
chargeBaseInfo.Name = chargingBaseEntity.Name;
chargeBaseInfo.Code = chargingBaseEntity.Code;
chargeBaseInfo.ChargeFee = chargingBaseEntity.ChargeFee;
chargeBaseInfo.ServerFee = chargingBaseEntity.ServerFee;
chargeBaseInfo.ParkFee = chargingBaseEntity.ParkFee;
chargeBaseInfo.ChargeNum = chargingBaseEntity.ChargeNum;
chargeBaseInfo.PayType = chargingBaseEntity.PayType;
chargeBaseInfo.Address = chargingBaseEntity.Address;
chargeBaseInfo.Coordinate = chargingBaseEntity.Coordinate;
chargeBaseInfo.StartTime = chargingBaseEntity.StartTime;
chargeBaseInfo.EndTime = chargingBaseEntity.EndTime;
chargeBaseInfo.IsUse = chargingBaseEntity.IsUse;
chargeBaseInfo.CityID = chargingBaseEntity.CityID;
}
return(chargeBaseInfo);
}
