/// <summary>
/// 是否存在重复配置
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public static bool IsExistVehicleArticle(SqlConnection conn, VehicleArticleModel model)
{
#region Sql
var sql = @"SELECT COUNT(1)
FROM Configuration..VehicleArticle AS s WITH ( NOLOCK )
WHERE s.VehicleId = @VehicleId
AND ( ( @PaiLiang IS NULL
AND s.PaiLiang IS NULL
)
OR s.PaiLiang = @PaiLiang
)
AND ( ( @Nian IS NULL
AND s.Nian IS NULL
)
OR s.Nian = @Nian
)
AND s.PKID <> @PKID;";
#endregion
var parameters = new[]
{
new SqlParameter("@VehicleId", model.VehicleId),
new SqlParameter("@PaiLiang", model.PaiLiang),
new SqlParameter("@Nian", model.Nian),
new SqlParameter("@PKID", model.PKID)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, parameters)) > 0);
}
/// <summary>
/// 添加选车攻略配置
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public static int AddVehicleArticle(SqlConnection conn, VehicleArticleModel model)
{
#region SQL
var sql = @"INSERT INTO Configuration..VehicleArticle
( VehicleId ,
PaiLiang ,
Nian ,
ArticleUrl
)
VALUES ( @VehicleId ,
@PaiLiang ,
@Nian ,
@ArticleUrl
);
SELECT SCOPE_IDENTITY();";
#endregion
var parameters = new[]
{
new SqlParameter("@VehicleId", model.VehicleId),
new SqlParameter("@PaiLiang", model.PaiLiang),
new SqlParameter("@Nian", model.Nian),
new SqlParameter("@ArticleUrl", model.ArticleUrl)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, parameters)));
}
/// <summary>
/// 获取单个配置
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public static VehicleArticleModel GetVehicleArticle(SqlConnection conn, VehicleArticleModel model)
{
#region Sql
var sql = @"SELECT s.PKID ,
s.VehicleId ,
s.PaiLiang ,
s.Nian ,
s.ArticleUrl ,
s.CreateDateTime ,
s.LastUpdateDateTime
FROM Configuration..VehicleArticle AS s WITH ( NOLOCK )
WHERE s.VehicleId = @VehicleId
AND ( ( @PaiLiang IS NULL
AND s.PaiLiang IS NULL
)
OR s.PaiLiang = @PaiLiang
)
AND ( ( @Nian IS NULL
AND s.Nian IS NULL
)
OR s.Nian = @Nian
);";
#endregion
var parameters = new[]
{
new SqlParameter("@VehicleId", model.VehicleId),
new SqlParameter("@PaiLiang", model.PaiLiang),
new SqlParameter("@Nian", model.Nian)
};
return(SqlHelper.ExecuteDataTable(conn, CommandType.Text, sql, parameters).ConvertTo <VehicleArticleModel>().FirstOrDefault());
}
/// <summary>
/// 添加或更新选车攻略配置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpSertVehicleArticle(VehicleArticleModel model)
{
var result = false;
try
{
var oldValue = dbScopeManagerConfigurationRead.Execute(conn =>
DalVehicleArticle.GetVehicleArticle(conn, model));
if (oldValue == null)
{
model.CreateDateTime = DateTime.Now;
var pkid = dbScopeManagerConfiguration.Execute
(conn => DalVehicleArticle.AddVehicleArticle(conn, model));
result = pkid > 0;
if (result)
{
model.PKID = pkid;
model.LastUpdateDateTime = DateTime.Now;
var log = new VehicleArticleOprLogModel
{
LogType = "VehicleArticle",
IdentityId = $"{model.VehicleId}_{model.PaiLiang}_{model.Nian}",
OperationType = "Add",
OldValue = null,
NewValue = JsonConvert.SerializeObject(model),
Remarks = $"添加选车攻略:{model.VehicleId}_{model.PaiLiang}_{model.Nian}的配置",
Operator = _user,
};
LoggerManager.InsertLog("VehicleArticleOprLog", log);
}
}
else
{
model.CreateDateTime = oldValue.CreateDateTime;
model.LastUpdateDateTime = DateTime.Now;
result = dbScopeManagerConfiguration.Execute(conn =>
DalVehicleArticle.UpdateVehicleArticle(conn, model));
if (result)
{
var log = new VehicleArticleOprLogModel
{
LogType = "VehicleArticle",
IdentityId = $"{model.VehicleId}_{model.PaiLiang}_{model.Nian}",
OperationType = "Update",
OldValue = JsonConvert.SerializeObject(oldValue),
NewValue = JsonConvert.SerializeObject(model),
Remarks = $"更新选车攻略:{ model.VehicleId }_{ model.PaiLiang }_{ model.Nian }的配置",
Operator = _user,
};
LoggerManager.InsertLog("VehicleArticleOprLog", log);
}
}
}
catch (Exception ex)
{
Logger.Error("UpSertVehicleArticle", ex);
}
return(result);
}
public ActionResult DeleteVehicleArticle(VehicleArticleModel model)
{
if (string.IsNullOrWhiteSpace(model?.VehicleId))
{
return(Json(new { Status = false, Msg = "未知的删除对象" }, JsonRequestBehavior.AllowGet));
}
var manager = new VehicleArticleManager(User.Identity.Name);
var result = manager.DeleteVehicleArticle(model);
return(Json(new { Status = result, Msg = $"删除{(result ? "成功" : "失败")}" }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 选车攻略配置是否重复
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool IsExistVehicleArticle(VehicleArticleModel model)
{
var result = true;
try
{
result = dbScopeManagerConfigurationRead.Execute(conn =>
DalVehicleArticle.IsExistVehicleArticle(conn, model));
}
catch (Exception ex)
{
Logger.Error("IsExistVehicleArticle", ex);
}
return(result);
}
public ActionResult UpSertVehicleArticle(VehicleArticleModel model)
{
if (string.IsNullOrWhiteSpace(model?.VehicleId))
{
return(Json(new { Status = false, Msg = "未知的对象" }, JsonRequestBehavior.AllowGet));
}
if (string.IsNullOrWhiteSpace(model.ArticleUrl))
{
return(Json(new { Status = false, Msg = "请填写文章链接" }, JsonRequestBehavior.AllowGet));
}
var manager = new VehicleArticleManager(User.Identity.Name);
var isExist = manager.IsExistVehicleArticle(model);
if (isExist)
{
return(Json(new { Status = false, Msg = "已存在重复的数据，不能重复添加" }, JsonRequestBehavior.AllowGet));
}
var result = manager.UpSertVehicleArticle(model);
return(Json(new { Status = result, Msg = $"添加{(result ? "成功" : "失败")}" }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 更新选车攻略配置
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateVehicleArticle(SqlConnection conn, VehicleArticleModel model)
{
#region Sql
var sql = @"UPDATE Configuration..VehicleArticle
SET VehicleId = @VehicleId ,
PaiLiang = @PaiLiang ,
Nian = @Nian ,
ArticleUrl = @ArticleUrl ,
LastUpdateDateTime = GETDATE()
WHERE PKID = @PKID;";
#endregion
var parameters = new[]
{
new SqlParameter("@VehicleId", model.VehicleId),
new SqlParameter("@PaiLiang", model.PaiLiang),
new SqlParameter("@Nian", model.Nian),
new SqlParameter("@ArticleUrl", model.ArticleUrl),
new SqlParameter("@PKID", model.PKID)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters) > 0);
}
/// <summary>
/// 删除选车攻略配置
/// </summary>
/// <param name="model"></param>
/// <param name="user"></param>
/// <returns></returns>
public bool DeleteVehicleArticle(VehicleArticleModel model)
{
var result = false;
try
{
var oldValue = dbScopeManagerConfigurationRead.Execute(conn =>
DalVehicleArticle.GetVehicleArticleByPkid(conn, model.PKID));
if (oldValue != null)
{
result = dbScopeManagerConfiguration.Execute(conn =>
DalVehicleArticle.DeleteVehicleArticle(conn, oldValue.PKID));
var log = new VehicleArticleOprLogModel
{
LogType = "VehicleArticle",
IdentityId = $"{model.VehicleId}_{model.PaiLiang}_{model.Nian}",
OperationType = "Delete",
OldValue = JsonConvert.SerializeObject(oldValue),
NewValue = null,
Remarks = $"删除选车攻略：{ model.VehicleId }_{ model.PaiLiang }_{ model.Nian }的配置",
Operator = _user
};
LoggerManager.InsertLog("VehicleArticleOprLog", log);
}
else
{
result = true;
}
}
catch (Exception ex)
{
result = false;
Logger.Error("DeleteVehicleArticle", ex);
}
return(result);
}
