/// <summary> /// 增加一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool SetCompanySetting(Eyousoft_yhq.Model.MCompanySetting model) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat(SqlBcthSetSeting, "CompanyIntroduce", model.CompanyIntroduce); strSql.AppendFormat(SqlBcthSetSeting, "About", model.About); strSql.AppendFormat(SqlBcthSetSeting, "Contact", model.Contact); strSql.AppendFormat(SqlBcthSetSeting, "Join", model.Join); strSql.AppendFormat(SqlBcthSetSeting, "LegalNotices", model.LegalNotices); strSql.AppendFormat(SqlBcthSetSeting, "Copyright", model.Copyright); strSql.AppendFormat(SqlBcthSetSeting, "Code", model.Code); strSql.AppendFormat(SqlBcthSetSeting, "Description", model.Description); strSql.AppendFormat(SqlBcthSetSeting, "Keywords", model.Keywords); strSql.AppendFormat(SqlBcthSetSeting, "Title", model.Title); strSql.AppendFormat(SqlBcthSetSeting, "Logo", model.Logo); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); return(DbHelper.ExecuteSqlTrans(cmd, this._db) == 0 ? false : true); }
/// <summary> /// 获取公司配置信息 /// </summary> public Eyousoft_yhq.Model.MCompanySetting GetCompanySetting() { var strSql = new StringBuilder(); strSql.Append(" select * from tbl_KV "); DbCommand dc = _db.GetSqlStringCommand(strSql.ToString()); var model = new Eyousoft_yhq.Model.MCompanySetting(); using (IDataReader dr = DbHelper.ExecuteReader(dc, _db)) { while (dr.Read()) { if (!dr.IsDBNull(dr.GetOrdinal("K")) && !string.IsNullOrEmpty(dr.GetString(dr.GetOrdinal("K")))) { switch (dr.GetString(dr.GetOrdinal("K"))) { case "CompanyIntroduce": model.CompanyIntroduce = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "About": model.About = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Contact": model.Contact = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Join": model.Join = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "LegalNotices": model.LegalNotices = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Copyright": model.Copyright = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Code": model.Code = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Description": model.Description = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Keywords": model.Keywords = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Title": model.Title = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Logo": model.Logo = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "MsgNumber": model.MsgNumber = dr.IsDBNull(dr.GetOrdinal("V")) ? 0 : Utils.GetInt(dr.GetString(dr.GetOrdinal("V"))); break; } } } } return(model); }
/// <summary> /// 获取公司配置信息 /// </summary> public Eyousoft_yhq.Model.MCompanySetting GetCompanySetting() { var strSql = new StringBuilder(); strSql.Append(" select * from tbl_KV "); DbCommand dc = _db.GetSqlStringCommand(strSql.ToString()); var model = new Eyousoft_yhq.Model.MCompanySetting(); using (IDataReader dr = DbHelper.ExecuteReader(dc, _db)) { while (dr.Read()) { if (!dr.IsDBNull(dr.GetOrdinal("K")) && !string.IsNullOrEmpty(dr.GetString(dr.GetOrdinal("K")))) { switch (dr.GetString(dr.GetOrdinal("K"))) { case "CompanyIntroduce": model.CompanyIntroduce = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "About": model.About = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Contact": model.Contact = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Join": model.Join = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "LegalNotices": model.LegalNotices = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Copyright": model.Copyright = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Code": model.Code = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Description": model.Description = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Keywords": model.Keywords = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Title": model.Title = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "Logo": model.Logo = dr.IsDBNull(dr.GetOrdinal("V")) ? string.Empty : dr.GetString(dr.GetOrdinal("V")); break; case "MsgNumber": model.MsgNumber = dr.IsDBNull(dr.GetOrdinal("V")) ? 0 : Utils.GetInt(dr.GetString(dr.GetOrdinal("V"))); break; } } } } return model; }