public ActionResult AddOrEditOilViscosityPriorityConfig(BaoYangOilViscosityPriorityConfigModel model)
{
if (model == null || string.IsNullOrWhiteSpace(model.OriginViscosity))
{
return(Json(new { Status = false, Msg = "未知的编辑对象" }, JsonRequestBehavior.AllowGet));
}
if (string.IsNullOrWhiteSpace(model.ConfigType) || !Enum.IsDefined(typeof(BaoYangOilViscosityPriorityConfigType), model.ConfigType))
{
return(Json(new { Status = false, Msg = "未知的类型" }, JsonRequestBehavior.AllowGet));
}
if (string.IsNullOrWhiteSpace(model.ViscosityPriority) || !model.ViscosityPriorities.Any())
{
return(Json(new { Status = false, Msg = "优先级不能为空" }, JsonRequestBehavior.AllowGet));
}
var distinctCount = model.ViscosityPriority.Split(',').Count();
if (model.ViscosityPriorities.Count != distinctCount)
{
return(Json(new { Status = false, Msg = $"粘度重复,请重新选择" }, JsonRequestBehavior.AllowGet));
}
var manager = new BaoYangOilViscosityPriorityConfigManager();
var result = manager.AddOrEditBaoYangOilViscosityPriorityConfig(model, User.Identity.Name);
return(Json(new { Status = result, Msg = $"编辑{(result ? "成功" : "失败")}" }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 添加机油粘度优先级配置
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public static int AddBaoYangOilViscosityPriorityConfig(SqlConnection conn, BaoYangOilViscosityPriorityConfigModel model)
{
var sql = @"INSERT BaoYang..BaoYangOilViscosityPriorityConfig
( OriginViscosity ,
ViscosityPriority ,
ConfigType
)
VALUES ( @OriginViscosity ,
@ViscosityPriority ,
@ConfigType
);
SELECT SCOPE_IDENTITY();";
var parameters = new[]
{
new SqlParameter("@OriginViscosity", model.OriginViscosity),
new SqlParameter("@ViscosityPriority", model.ViscosityPriority),
new SqlParameter("@ConfigType", model.ConfigType)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, parameters)));
}
/// <summary>
/// 更新机油粘度优先级配置
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateBaoYangOilViscosityPriorityConfig(SqlConnection conn, BaoYangOilViscosityPriorityConfigModel model)
{
var sql = @"UPDATE BaoYang..BaoYangOilViscosityPriorityConfig
SET ViscosityPriority = @ViscosityPriority ,
IsDeleted = 0
WHERE OriginViscosity = @OriginViscosity
AND ConfigType = @ConfigType;";
var parameters = new[]
{
new SqlParameter("@OriginViscosity", model.OriginViscosity),
new SqlParameter("@ViscosityPriority", model.ViscosityPriority),
new SqlParameter("@ConfigType", model.ConfigType)
};
return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters)) > 0);
}
/// <summary>
/// 添加或编辑机油粘度优先级配置
/// </summary>
/// <param name="model"></param>
/// <param name="user"></param>
/// <returns></returns>
public bool AddOrEditBaoYangOilViscosityPriorityConfig(BaoYangOilViscosityPriorityConfigModel model, string user)
{
var result = false;
var log = null as BaoYangOprLog;
try
{
var oldValue = dbScopeManagerGungnirRead.Execute(conn => DalBaoYangOilViscosityPriorityConfig.GetBaoYangOilViscosityPriorityConfig(conn, model.OriginViscosity, model.ConfigType));
#region 添加 判断是否存在该原厂粘度被逻辑删除的记录 存在则更新 不存在则插入
if (oldValue == null)
{
#region 插入记录
var pkid = dbScopeManagerGungnir.Execute(conn => DalBaoYangOilViscosityPriorityConfig.AddBaoYangOilViscosityPriorityConfig(conn, model));
if (pkid > 0)
{
result = true;
model.PKID = pkid;
log = new BaoYangOprLog
{
LogType = "BaoYangOilViscosityPriorityConfig",
IdentityID = model.OriginViscosity,
OldValue = null,
NewValue = JsonConvert.SerializeObject(model),
Remarks = $"添加{model.ConfigType}类原厂机油粘度{model.OriginViscosity}推荐优先级:{model.ViscosityPriority}",
OperateUser = user,
};
}
#endregion
}
else if (oldValue.IsDeleted)
{
#region 更新逻辑删除的记录
result = dbScopeManagerGungnir.Execute(conn => DalBaoYangOilViscosityPriorityConfig.UpdateBaoYangOilViscosityPriorityConfig(conn, model));
log = new BaoYangOprLog
{
LogType = "BaoYangOilViscosityPriorityConfig",
IdentityID = model.OriginViscosity,
OldValue = null,
NewValue = JsonConvert.SerializeObject(model),
Remarks = $"添加{model.ConfigType}类原厂机油粘度{model.OriginViscosity}推荐优先级:{model.ViscosityPriority}",
OperateUser = user,
};
#endregion
}
#endregion
#region 更新
else
{
result = dbScopeManagerGungnir.Execute(conn => DalBaoYangOilViscosityPriorityConfig.UpdateBaoYangOilViscosityPriorityConfig(conn, model));
log = new BaoYangOprLog
{
LogType = "BaoYangOilViscosityPriorityConfig",
IdentityID = model.OriginViscosity,
OldValue = JsonConvert.SerializeObject(oldValue),
NewValue = JsonConvert.SerializeObject(model),
Remarks = $"更新{model.ConfigType}类原厂机油粘度{model.OriginViscosity}推荐优先级:{model.ViscosityPriority}",
OperateUser = user,
};
}
#endregion
if (result && log != null)
{
LoggerManager.InsertLog("BYOprLog", log);
}
}
catch (Exception ex)
{
Logger.Error("AddOrEditBaoYangOilViscosityPriorityConfig", ex);
}
return(result);
}