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