/// <summary> /// Adds new config value or updates exist config value. /// </summary> /// <param name="config"></param> /// <returns></returns> public bool AddOrUpdateConfigValue(PublicConfig config) { var conn = DBHelper.GetSqlConnection(); bool result = false; try { config.CheckNullObject("参数"); config.ConfigValue.CheckEmptyString("参数值"); config.CreatedTime = DateTime.Now; config.LastUpdatedTime = DateTime.Now; conn.Open(); result = configDao.AddOrUpdateConfigValue(conn, config); } catch (Exception e) { LogService.Log("添加或更新Config失败--" + e.Message, e.ToString()); } finally { conn.Close(); } return result; }
/// <summary> /// Adds new public config or updates exist config value. /// </summary> /// <param name="conn"></param> /// <param name="config"></param> /// <returns></returns> public bool AddOrUpdateConfigValue(SqlConnection conn, PublicConfig config) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ConfigId", config.ConfigId), new SqlParameter("@ConfigName", config.ConfigName), new SqlParameter("@ConfigValue", config.ConfigValue), new SqlParameter ("CreatedTime", config.CreatedTime), new SqlParameter("LastUpdatedTime", config.LastUpdatedTime) }; return DBHelper.RunNonQueryProcedure(conn, SP_AddOrUpdatePublicConfigValue, parameters) > 0; }
public ActionResult AddTradeBankInfo(string bankName, string bankAccount, string bankUserName, string bankAddress) { string result = "添加中介手续费线下支付银行帐号失败"; bool isSuccess = false; try { if (string.IsNullOrEmpty(bankName) || string.IsNullOrEmpty(bankAccount) || string.IsNullOrEmpty(bankUserName) || string.IsNullOrEmpty(bankAddress)) { result = "银行信息不能为空"; } else { PublicConfig config = config = new PublicConfig(); config.ConfigName = Constant.TradeBankInfoConfig; config.ConfigValue = bankName + Constant.TradeBankInfoConfigSeperator + bankAccount + Constant.TradeBankInfoConfigSeperator + bankUserName + Constant.TradeBankInfoConfigSeperator + bankAddress; config.CreatedTime = DateTime.Now; config.LastUpdatedTime = DateTime.Now; isSuccess = publicConfigManager.AddConfigValueIgnoreExists(config); if (isSuccess) { result = "success"; } else { result = "添加中介手续费线下支付银行帐号失败"; } } } catch (Exception ex) { LogService.Log("添加中介手续费线下支付银行帐号失败", ex.ToString()); result = "添加中介手续费线下支付银行帐号失败"; } return Content(result); }
public ActionResult UpdatePaymentServiceConfig(string serviceName, bool isEnabled, string merchantId, string merchantKey) { string result = "更新失败"; try { if (string.Equals(serviceName, PaymentService.ALIPAYSERVICE, StringComparison.CurrentCultureIgnoreCase) || string.Equals(serviceName, PaymentService.CHINABANKSERVICE, StringComparison.CurrentCultureIgnoreCase) || string.Equals(serviceName, PaymentService.TENPAYSERVICE, StringComparison.CurrentCultureIgnoreCase)) { if (isEnabled && (string.IsNullOrWhiteSpace(merchantId) || string.IsNullOrWhiteSpace(merchantKey))) { throw new ArgumentException("商户ID和密钥不能为空"); } string configValue = isEnabled.ToString() + "^" + merchantId + "^" + merchantKey; PublicConfig config = new PublicConfig { ConfigName = serviceName, ConfigValue = configValue, CreatedTime = DateTime.Now, LastUpdatedTime = DateTime.Now }; if (publicConfigService.AddOrUpdateConfigValue(config)) { Caching.Set(serviceName, configValue); result = "success"; } } } catch (Exception ex) { LogService.Log("更新在线支付配置失败", ex.ToString()); result = "更新失败——" + ex.Message; } return Content(result); }
/// <summary> /// Adds new config or updates exist config. /// </summary> /// <param name="config"></param> /// <returns></returns> public bool AddOrUpdateConfigValue(PublicConfig config) { return configService.AddOrUpdateConfigValue(config); }
public bool AddConfigValueIgnoreExists(PublicConfig config) { return configService.AddConfigValueIgnoreExists(config); }
/// <summary> /// Gets public config value by config name. /// </summary> /// <param name="configName">Config name.</param> /// <returns>Returns config value.</returns> public PublicConfig GetConfigValue(string configName) { PublicConfig config = new PublicConfig(); var conn = DBHelper.GetSqlConnection(); try { conn.Open(); config = configDao.GetConfigValue(conn, configName); if (config == null) { config = new PublicConfig() { ConfigName = configName, ConfigValue = string.Empty, CreatedTime = DateTime.Now, LastUpdatedTime = DateTime.Now }; configDao.AddOrUpdateConfigValue(conn, config); // Retrieves config with id. config = configDao.GetConfigValue(conn, configName); } } catch (Exception e) { LogService.Log("查询Config失败--" + e.Message, e.ToString()); } finally { conn.Close(); } return config; }
/// <summary> /// Gets public config value by config id. /// </summary> /// <param name="configId">Config id.</param> /// <returns>Returns config value.</returns> public PublicConfig GetConfigValue(int configId) { PublicConfig config = new PublicConfig(); var conn = DBHelper.GetSqlConnection(); try { conn.Open(); config = configDao.GetConfigValue(conn, configId); } catch (Exception e) { LogService.Log("查询Config失败--" + e.Message, e.ToString()); } finally { conn.Close(); } return config; }
public ActionResult UpdateTradeReminding(string configId, string tradeReminding) { string result = "中介交易提醒更新失败"; bool isSuccess = false; try { if (string.IsNullOrWhiteSpace(tradeReminding)) { result = "中介交易提醒内容不能为空"; } else { PublicConfig config = new PublicConfig(); config.ConfigId = int.Parse(configId); config.ConfigName = "TradeReminding"; config.ConfigValue = tradeReminding; config.CreatedTime = DateTime.Now; config.LastUpdatedTime = DateTime.Now; isSuccess = publicConfigManager.AddOrUpdateConfigValue(config); if (isSuccess) { result = "success"; } else { result = "中介交易提醒更新失败"; } } } catch (Exception ex) { LogService.Log("更新中介交易提醒失败", ex.ToString()); result = "更新中介交易提醒失败"; } return Content(result); }
public ActionResult UpdatePayCommissionPercent(string configId, string paycommissonpercent) { string result = "中介手续费更新失败"; bool isSuccess = false; try { int percent = -1; if (string.IsNullOrWhiteSpace(paycommissonpercent) || !int.TryParse(paycommissonpercent, out percent) || percent < 0 || percent >= 100) { result = "中介手续费应为0到100之间的整数,包括0"; } else { PublicConfig config = config = new PublicConfig(); config.ConfigId = int.Parse(configId); config.ConfigName = "PayCommissionPercent"; config.ConfigValue = paycommissonpercent; config.CreatedTime = DateTime.Now; config.LastUpdatedTime = DateTime.Now; isSuccess = publicConfigManager.AddOrUpdateConfigValue(config); if (isSuccess) { result = "success"; } else { result = "中介手续费更新失败"; } } } catch (Exception ex) { LogService.Log("中介手续费更新失败", ex.ToString()); result = "中介手续费更新失败"; } return Content(result); }
private PublicConfig ConvertToUserObject(SqlDataReader reader) { PublicConfig config = new PublicConfig(); config.ConfigId = reader["ConfigId"].DBToInt32(); config.ConfigName = reader["ConfigName"].DBToString(); config.ConfigValue = reader["ConfigValue"].DBToString(); config.CreatedTime = reader["CreatedTime"].DBToDateTime().Value; config.LastUpdatedTime = reader["LastUpdatedTime"].DBToDateTime().Value; return config; }
private void UpdateConfig(PublicConfig serachConfig) { FileConfigService fileConfigService = new FileConfigService(); fileConfigService.SaveConfig("SiteSerach.json",serachConfig.ToJson()); }
private PublicConfig GetConfig() { PublicConfig serachConfig = null; FileConfigService fileConfigService = new FileConfigService(); var SMSConfig = fileConfigService.GetConfig("SiteSerach.json"); if (!string.IsNullOrEmpty(SMSConfig)) { serachConfig = JsonConvert.DeserializeObject<PublicConfig>(SMSConfig); } else { serachConfig = new PublicConfig(); serachConfig.ConfigName = "站内搜索配置"; serachConfig.ConfigValue = "0"; serachConfig.CreatedTime = DateTime.Now; serachConfig.LastUpdatedTime = new DateTime(2014,1,1); } return serachConfig; }