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 ChargingPileInfo GetChargingPileById(long id)
{
ChargingPileInfo chpile = new ChargingPileInfo();
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(ChargeStatement.GetChargingPileByKey, "Text"));
command.AddInputParameter("@ID", DbType.Int64, id);
chpile = command.ExecuteEntity <ChargingPileInfo>();
return(chpile);
}
public int ModifyChargingPile(ChargingPileInfo piple)
{
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(ChargeStatement.ModifyChargingPile, "Text"));
command.AddInputParameter("@ID", DbType.Int64, piple.ID);
command.AddInputParameter("@Code", DbType.String, piple.Code);
command.AddInputParameter("@Standard", DbType.String, piple.Standard);
command.AddInputParameter("@SOC", DbType.String, piple.SOC);
command.AddInputParameter("@Power", DbType.String, piple.Power);
command.AddInputParameter("@Electric", DbType.String, piple.Electric);
command.AddInputParameter("@CElectric", DbType.String, piple.CElectric);
command.AddInputParameter("@Voltage", DbType.String, piple.Voltage);
command.AddInputParameter("@CVoltage", DbType.String, piple.CVoltage);
command.AddInputParameter("@ChargingBaseID", DbType.Int32, piple.ChargingBaseID);
command.AddInputParameter("@IsUse", DbType.Int32, piple.IsUse);
return(command.ExecuteNonQuery());
}
private static ChargingPileInfo TranslateChargingPileEntity(ChargingPileEntity chargingPileEntity)
{
ChargingPileInfo chargingPileInfo = new ChargingPileInfo();
if (chargingPileEntity != null)
{
chargingPileInfo.ID = chargingPileEntity.ID;
chargingPileInfo.Code = chargingPileEntity.Code;
chargingPileInfo.Standard = chargingPileEntity.Standard;
chargingPileInfo.SOC = chargingPileEntity.SOC;
chargingPileInfo.Power = chargingPileEntity.Power;
chargingPileInfo.Electric = chargingPileEntity.Electric;
chargingPileInfo.CElectric = chargingPileEntity.CElectric;
chargingPileInfo.Voltage = chargingPileEntity.Voltage;
chargingPileInfo.CVoltage = chargingPileEntity.CVoltage;
chargingPileInfo.ChargingBaseID = chargingPileEntity.ChargingBaseID;
chargingPileInfo.IsUse = chargingPileEntity.IsUse;
}
return(chargingPileInfo);
}
private static ChargingPileEntity TranslateChargingPileInfo(ChargingPileInfo chargingPileInfo)
{
ChargingPileEntity chargingPileEntity = new ChargingPileEntity();
if (chargingPileInfo != null)
{
chargingPileEntity.ID = chargingPileInfo.ID;
chargingPileEntity.Code = chargingPileInfo.Code;
chargingPileEntity.Standard = chargingPileInfo.Standard;
chargingPileEntity.SOC = chargingPileInfo.SOC;
chargingPileEntity.Power = chargingPileInfo.Power;
chargingPileEntity.Electric = chargingPileInfo.Electric;
chargingPileEntity.CElectric = chargingPileInfo.CElectric;
chargingPileEntity.Voltage = chargingPileInfo.Voltage;
chargingPileEntity.CVoltage = chargingPileInfo.CVoltage;
chargingPileEntity.ChargingBaseID = chargingPileInfo.ChargingBaseID;
chargingPileEntity.IsUse = chargingPileInfo.IsUse;
ChargingBaseEntity chargeBase = GetAllChargingBaseEntity().FirstOrDefault(t => t.IsUse == 1 && t.ChargeBaseID == chargingPileEntity.ChargingBaseID) ?? new ChargingBaseEntity();
chargingPileEntity.ChargingBase = chargeBase;
}
return(chargingPileEntity);
}