/// <summary>
/// 修改配置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public BaoYangResultEntity <bool> UpdateBatteryLevelUp(BatteryLevelUpEntity model, string name)
{
var result = new BaoYangResultEntity <bool>();
try
{
result = SaveCheckBatteryLevelUp(model);
if (result.Status)
{
var oldbatteryLevelUp = GetBatteryLevelUpEntity(model.PKID).Data;
if (oldbatteryLevelUp != null)
{
result = dbScopeManagerBaoYang.Execute(conn =>
{
result.Data = DALBatteryLevelUp.UpdateBatteryLevelUp(conn, model);
return(result);
});
}
if (result.Data)
{
SaveBatteryLevelUpLog(oldbatteryLevelUp, model, name);
}
}
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
result = new BaoYangResultEntity <bool>()
{
Status = false, Msg = "修改失败"
};
}
return(result);
}
/// <summary>
/// 保存时检查
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public BaoYangResultEntity <bool> SaveCheckBatteryLevelUp(BatteryLevelUpEntity model)
{
var result = new BaoYangResultEntity <bool>()
{
Status = true
};
try
{
result = dbScopeManagerBaoYangRead.Execute(conn =>
{
var entity = DALBatteryLevelUp.GetBatteryLevelUpEntityByOriginalPid(conn, model.OriginalPID);
//重复原始ID 查询
if (entity != null && entity.PKID != model.PKID)
{
result.Status = false;
result.Msg = "该原始产品已经配置了升级购";
return(result);
}
entity = DALBatteryLevelUp.GetBatteryLevelUpEntityByNewPID(conn, model.NewPID);
if (entity != null && entity.PKID != model.PKID)
{
result.Status = false;
result.Msg = "该升级产品已经配置了升级购";
return(result);
}
entity = DALBatteryLevelUp.GetBatteryLevelUpEntity(conn, model.OriginalPID, model.NewPID);
if (entity != null)
{
result.Status = false;
result.Msg = "升级链不能循环升级";
return(result);
}
return(result);
});
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
result = new BaoYangResultEntity <bool>()
{
Status = false, Msg = "修改失败"
};
}
return(result);
}
/// <summary>
/// 添加日志
/// </summary>
/// <param name="model"></param>
/// <param name="name"></param>
/// <returns></returns>
public BaoYangResultEntity <bool> SaveBatteryLevelUpLog(BatteryLevelUpEntity oldbatteryLevelUp, BatteryLevelUpEntity newbatteryLevelUp, string name)
{
BaoYangResultEntity <bool> result = new BaoYangResultEntity <bool>()
{
Status = true
};
var log = new BaoYangOprLog()
{
CreateTime = DateTime.Now,
LogType = "BaoYangProductBatteryLevelUpSetting",
Remarks = oldbatteryLevelUp == null ? "添加" : (newbatteryLevelUp == null ? "删除" : "修改"),
IdentityID = newbatteryLevelUp == null ? oldbatteryLevelUp.OriginalPID : newbatteryLevelUp.OriginalPID,
NewValue = JsonConvert.SerializeObject(newbatteryLevelUp ?? new BatteryLevelUpEntity()),
OldValue = JsonConvert.SerializeObject(oldbatteryLevelUp ?? new BatteryLevelUpEntity()),
OperateUser = name
};
LoggerManager.InsertLog("BYOprLog", log);
return(result);
}
/// <summary>
///修改蓄电池升级购实体
/// </summary>
/// <param name="entity"></param>
/// <param name="connection"></param>
/// <returns></returns>
public static bool UpdateBatteryLevelUp(SqlConnection connection, BatteryLevelUpEntity entity)
{
var sql = @"UPDATE BaoYang..BatteryLevelUp
SET OriginalPID = @OriginalPID,
NewPID = @NewPID,
Copywriting = @Copywriting,
IsEnabled = @IsEnabled,
LastUpdateDateTime = GETDATE()
WHERE PKID = @PKID;";
var parameters = new
{
entity.OriginalPID,
entity.NewPID,
entity.Copywriting,
entity.IsEnabled,
entity.PKID
};
var result = connection.Execute(sql, param: parameters, commandType: CommandType.Text);
return(result > 0);
}
/// <summary>
/// 添加蓄电池升级购实体
/// </summary>
/// <returns></returns>
public static bool InsertBatteryLevelUp(SqlConnection connection, BatteryLevelUpEntity entity)
{
var sql = @"INSERT BaoYang..BatteryLevelUp
(
OriginalPID,
NewPID,
Copywriting,
IsEnabled
)
VALUES
(@OriginalPID, @NewPID, @Copywriting, @IsEnabled);";
var parameters = new
{
entity.OriginalPID,
entity.NewPID,
entity.Copywriting,
entity.IsEnabled
};
var result = connection.Execute(sql, param: parameters, commandType: CommandType.Text);
return(result > 0);
}
