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); } }