public static int Save(SE_DictionaryConfigModel entity)
{
if (entity.Id <= 0)
{//添加
if (DALSE_DictionaryConfig.Exist(entity))
{
return(-1);
}
else
{
if (DALSE_DictionaryConfig.Add(entity))
{
return(1);
}
else
{
return(0);
}
}
}
else
{
if (DALSE_DictionaryConfig.Update(entity))
{
return(1);
}
else
{
return(0);
}
}
}
public static bool Insert(SE_GiftManageConfigModel model, SE_DictionaryConfigModel log)
{
try
{
var result = SE_GiftManageConfigDAL.Insert(ProcessConnection.OpenConfiguration, model);
var giftFlag = true;
log.ParentId = result;
//var reGiftP = SE_GiftManageConfigDAL.DeleteGiftProductConfig(result);
var giftProductModels = JsonConvert.DeserializeObject <List <GiftStockModel2> >(model.GiftProducts);
foreach (var g in giftProductModels)
{
g.RuleId = result;
g.IsGiveAway = model.GiveAway;
giftFlag = giftFlag && SE_GiftManageConfigDAL.MergeIntoGiftProductStock(g.Pid, g.Stock, result) > 0;
giftFlag = giftFlag && SE_GiftManageConfigDAL.InsertGiftProductConfig(g) > 0;
}
// 按PID配置赠品后刷新牛皮癣缓存
RefreshGiftPicture(model);
return(result > 0 && SE_GiftManageConfigDAL.InsertLog(ProcessConnection.OpenConfiguration, log) && giftFlag);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Update(SE_DictionaryConfigModel model)
{
try
{
return(SE_DictionaryConfigDAL.Update(ProcessConnection.OpenConfiguration, model));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 判断是否存在
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public static bool Exist(SE_DictionaryConfigModel entity)
{
string sql = " SELECT COUNT(1) FROM Configuration.dbo.SE_DictionaryConfig WHERE [Key]=@Key ";
using (var db = DbHelper.CreateDefaultDbHelper())
{
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@Key", entity.Key);
int n = (int)db.ExecuteScalar(cmd);
return(n > 0);
}
}
public static bool InsertLog(SqlConnection connection, SE_DictionaryConfigModel model)
{
try
{
using (IDbConnection conn = connection)
{
string sql = @"
INSERT INTO Configuration.dbo.SE_DictionaryConfig
(
ParentId,
[Key],
[Value],
Describe,
Sort,
State,
Url,
Images,
CreateTime,
UpdateTime,
Extend1,
Extend2,
Extend3,
Extend4,
Extend5
)
VALUES
(
@ParentId,
@Key,
@Value,
@Describe,
@Sort,
@State,
@Url,
@Images,
@CreateTime,
@UpdateTime,
@Extend1,
@Extend2,
@Extend3,
@Extend4,
@Extend5
)" ;
return(conn.Execute(sql, model) > 0);
}
}
catch (Exception ex)
{
//Logger.Log(Level.Info, $"赠品sql执行错误{ex}-{ex.InnerException}-{ex.StackTrace}");
//Logger.Log(Level.Error, $"赠品sql执行错误{ex}-{ex.InnerException}-{ex.StackTrace}");
throw ex;
}
}
public ActionResult Edit(int?id = 0)
{
if (id.Value == 0)
{
return(View(new SE_DictionaryConfigModel()));
}
else
{
SE_DictionaryConfigModel model = SE_DictionaryConfigManager.GetEntity(id.Value.ToString());
return(View(model));
}
}
public static bool Insert(SE_DictionaryConfigModel model)
{
try
{
return(SE_DictionaryConfigDAL.Insert(ProcessConnection.OpenConfiguration, model));
}
catch (Exception ex)
{
Logger.Info($"赠品插入失败日志=>{ex}-{ex.InnerException}-{ex.StackTrace}");
throw ex;
}
}
public static bool Insert(SE_GiftManageConfigModel model, SE_DictionaryConfigModel log)
{
try
{
var result = DiscountManageConfigDal.Insert(ProcessConnection.OpenConfiguration, model);
log.ParentId = result;
//var reGiftP = SE_GiftManageConfigDAL.DeleteGiftProductConfig(result);
return(SE_GiftManageConfigDAL.InsertLog(ProcessConnection.OpenConfiguration, log));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Save(SE_DictionaryConfigModel entity)
{
JObject json = new JObject();
try
{
int status = SE_DictionaryConfigManager.Save(entity);
json.Add("Code", 1);
json.Add("Status", status);
}
catch
{
json.Add("Code", 0);
json.Add("Status", 0);
}
return(Json(json.ToString()));
}
public static bool Add(SE_DictionaryConfigModel entity)
{
StringBuilder sql = new StringBuilder(@"INSERT INTO Configuration.dbo.SE_DictionaryConfig
( ParentId ,
[Key] ,
Value ,
Describe ,
Sort ,
[State] ,
Url ,
Images ,
CreateTime ,
UpdateTime ,
Extend1 ,
Extend2 ,
Extend3 ,
Extend4 ,
Extend5
)" );
sql.Append("VALUES(@ParentId,@Key,@Value,@Describe,@Sort,@State,@Url,@Images,GETDATE(),GETDATE(),@Extend1,@Extend2,@Extend3,@Extend4,@Extend5)");
using (var db = DbHelper.CreateDefaultDbHelper())
{
SqlCommand cmd = new SqlCommand(sql.ToString());
cmd.Parameters.AddWithValue("@ParentId", entity.ParentId);
cmd.Parameters.AddWithValue("@Key", entity.Key);
cmd.Parameters.AddWithValue("@Value", entity.Value);
cmd.Parameters.AddWithValue("@Describe", entity.Describe);
cmd.Parameters.AddWithValue("@Sort", entity.Sort);
cmd.Parameters.AddWithValue("@State", entity.State);
cmd.Parameters.AddWithValue("@Url", entity.Url);
cmd.Parameters.AddWithValue("@Images", entity.Images);
cmd.Parameters.AddWithValue("@Extend1", entity.Extend1);
cmd.Parameters.AddWithValue("@Extend2", entity.Extend2);
cmd.Parameters.AddWithValue("@Extend3", entity.Extend3);
cmd.Parameters.AddWithValue("@Extend4", entity.Extend4);
cmd.Parameters.AddWithValue("@Extend5", entity.Extend5);
return(db.ExecuteNonQuery(cmd) > 0);
}
}
public static bool Update(SE_DictionaryConfigModel entity)
{
string sql = @" UPDATE Configuration.dbo.SE_DictionaryConfig SET ParentId=@ParentId ,
[Key]=@Key ,
Value=@Value ,
Describe=@Describe ,
Sort=@Sort ,
[State]=@State ,
Url=@Url ,
Images=@Images ,
UpdateTime=GETDATE() ,
Extend1=@Extend1 ,
Extend2 =@Extend2,
Extend3=@Extend3 ,
Extend4=@Extend4,
Extend5=@Extend5
WHERE Id=@Id ";
using (var db = DbHelper.CreateDefaultDbHelper())
{
SqlCommand cmd = new SqlCommand(sql.ToString());
cmd.Parameters.AddWithValue("@ParentId", entity.ParentId);
cmd.Parameters.AddWithValue("@Key", entity.Key);
cmd.Parameters.AddWithValue("@Value", entity.Value);
cmd.Parameters.AddWithValue("@Describe", entity.Describe);
cmd.Parameters.AddWithValue("@Sort", entity.Sort);
cmd.Parameters.AddWithValue("@State", entity.State);
cmd.Parameters.AddWithValue("@Url", entity.Url);
cmd.Parameters.AddWithValue("@Images", entity.Images);
cmd.Parameters.AddWithValue("@Extend1", entity.Extend1);
cmd.Parameters.AddWithValue("@Extend2", entity.Extend2);
cmd.Parameters.AddWithValue("@Extend3", entity.Extend3);
cmd.Parameters.AddWithValue("@Extend4", entity.Extend4);
cmd.Parameters.AddWithValue("@Extend5", entity.Extend5);
cmd.Parameters.AddWithValue("@Id", entity.Id);
return(db.ExecuteNonQuery(cmd) > 0);
}
}
public static bool Update(SqlConnection connection, SE_DictionaryConfigModel model)
{
using (IDbConnection conn = connection)
{
string sql = @" UPDATE Configuration.dbo.SE_DictionaryConfig
SET ParentId = @ParentId,
[Key] = @Key,
[Value] = @Value,
Describe = @Describe,
Sort = @Sort,
State = @State,
Url = @Url,
Images = @Images,
CreateTime = @CreateTime,
UpdateTime = @UpdateTime,
Extend1 = @Extend1,
Extend2 = @Extend2,
Extend3 = @Extend3,
Extend4 = @Extend4,
Extend5 = @Extend5
WHERE Id = @Id " ;
return(conn.Execute(sql, model) > 0);
}
}
