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