/// <summary> /// 删除配置项 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int DelNotifySetting(NotifySettingEntity entity) { const string sql = @"DELETE FROM NotifySetting WHERE SettingKey=@SettingKey"; using (IDbConnection conn = ConnectionFactory.JinRiNotify_CMD) { return(conn.Execute(sql, entity)); } }
public int SaveNotifySetting(NotifySettingEntity entity) { const string sql = @"INSERT INTO NotifySetting(SettingKey, SettingValue, Remark, Memo, ClassName, CreateTime, LastModifyTime) VALUES(@SettingKey, @SettingValue, @Remark ,@Memo, @ClassName, CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP())"; using (IDbConnection conn = ConnectionFactory.JinRiNotify_CMD) { int ret = conn.Execute(sql, entity); return(ret); } }
public int EditNotifySetting(NotifySettingEntity entity) { const string sql = @"UPDATE NotifySetting SET LastModifyTime = CURRENT_TIMESTAMP(), {0} WHERE NotifyId = @NotifyId"; List <string> list = new List <string>(); if (!Null.IsNull(entity.SettingKey)) { list.Add("SettingKey"); } if (!Null.IsNull(entity.SettingValue)) { list.Add("SettingValue"); } if (!Null.IsNull(entity.Remark)) { list.Add("Remark"); } if (!Null.IsNull(entity.Memo)) { list.Add("Memo"); } if (!Null.IsNull(entity.ClassName)) { list.Add("ClassName"); } List <string> cmdList = new List <string>(); foreach (string s in list) { if (s.Equals("Memo", StringComparison.OrdinalIgnoreCase)) { cmdList.Add(string.Format("{0} = CONCAT({0}, @{0})", s)); } else { cmdList.Add(string.Format("{0} = @{0}", s)); } } using (IDbConnection conn = ConnectionFactory.JinRiNotify_CMD) { return(conn.Execute(string.Format(sql, string.Join(", ", cmdList)), entity)); } }
/// <summary> /// 删除配置项 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int DelNotifySetting(NotifySettingEntity entity) { return(JinRiNotifyCMD.Instance.DelNotifySetting(entity)); }