/// <summary> /// 设置公司短信配置信息 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="info">配置信息</param> /// <returns></returns> public bool SetComSmsConfig(string companyId, EyouSoft.Model.ComStructure.MSmsConfigInfo info) { if (string.IsNullOrEmpty(companyId)) { return(false); } var setting = GetModel(companyId); if (setting != null && setting.SmsConfig != null && setting.SmsConfig.IsEnabled) { return(true); } if (info == null || !info.IsEnabled) { info = new EyouSoft.BLL.SmsStructure.BSmsAccount().CreateSmsAccount(); } if (info == null) { return(false); } bool dalRetCode = dal.SetComSmsConfig(companyId, info); string cachekey = string.Format(EyouSoft.Cache.Tag.TagName.ComSetting, companyId); EyouSoft.Cache.Facade.EyouSoftCache.Remove(cachekey); return(dalRetCode); }
///// <summary> ///// 根据键名获取值 ///// </summary> ///// <param name="CompanyId"></param> ///// <param name="SettingType"></param> ///// <returns></returns> //public string GetSettingByType(string CompanyId, SysConfiguration SettingType) //{ // string sql = "SELECT CompanyId,[Key],[Value] FROM tbl_ComSetting WHERE CompanyId = @CompanyId and [Key]=@Key"; // DbCommand comm = this._db.GetSqlStringCommand(sql); // this._db.AddInParameter(comm, "CompanyId", DbType.AnsiStringFixedLength, CompanyId); // this._db.AddInParameter(comm, "Key", DbType.String, (int)SettingType); // string value = string.Empty; // using (IDataReader reader = DbHelper.ExecuteReader(comm, this._db)) // { // if (reader.Read()) // { // value = reader.IsDBNull(reader.GetOrdinal("Value")) ? "0" : reader.GetString(reader.GetOrdinal("Value")); // } // } // return value; //} /// <summary> /// 设置公司短信配置信息 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="info">配置信息</param> /// <returns></returns> public bool SetComSmsConfig(string companyId, EyouSoft.Model.ComStructure.MSmsConfigInfo info) { #region create xml //xml格式<item><val id="key">value</val></item> StringBuilder xml = new StringBuilder(); xml.Append("<item>"); xml.AppendFormat("<val id='{0}'>{1}</val>", "SmsAccount", info.Account); xml.AppendFormat("<val id='{0}'>{1}</val>", "SmsAppKey", info.AppKey); xml.AppendFormat("<val id='{0}'>{1}</val>", "SmsAppSecret", info.AppSecret); xml.Append("</item>"); #endregion DbCommand cmd = this._db.GetStoredProcCommand(SQL_PROC_SetSettings); _db.AddInParameter(cmd, "@CompanyId", DbType.AnsiStringFixedLength, companyId); _db.AddInParameter(cmd, "@xml", DbType.Xml, xml.ToString()); _db.AddOutParameter(cmd, "@RetCode", DbType.Int32, 4); int sqlExceptionCode = 0; try { DbHelper.RunProcedure(cmd, _db); } catch (System.Data.SqlClient.SqlException e) { sqlExceptionCode = 0 - e.Number; } if (sqlExceptionCode < 0) { return(false); } else { return(Convert.ToInt32(_db.GetParameterValue(cmd, "RetCode")) == 1); } }