/// <summary>
/// 修改系统配置信息
/// </summary>
/// <param name="baseconfig">系统配置实体</param>
public void UpdateBaseConfig(BaseConfig baseconfig)
{
try
{
string sql = "UPDATE usta_BaseConfig SET systemName=@systemName,systemVersion=@systemVersion, systemCopyRight=@systemCopyRight,fileServerAddress=@fileServerAddress";
SqlParameter[] parameters = {
new SqlParameter("@systemName", SqlDbType.NVarChar,100),
new SqlParameter("@systemVersion", SqlDbType.NChar,20),
new SqlParameter("@systemCopyRight", SqlDbType.NVarChar,500),
new SqlParameter("@fileServerAddress", SqlDbType.NChar,50)};
parameters[0].Value = baseconfig.systemName;
parameters[1].Value = baseconfig.systemVersion;
parameters[2].Value = baseconfig.systemCopyRight;
parameters[3].Value = baseconfig.fileServerAddress;
SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters);
}
catch (Exception ex)
{
MongoDBLog.LogRecord(ex);
CommonUtility.RedirectUrl();
}
finally
{
conn.Close();
}
}
/// <summary>
/// 获取系统配置信息
/// </summary>
/// <returns>系统配置实体</returns>
public BaseConfig FindBaseConfig()
{
BaseConfig baseconfig = null;
string sql = "SELECT [systemName],[systemVersion],[systemCopyRight],[fileServerAddress] FROM [USTA].[dbo].[usta_BaseConfig]";
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql);
while (dr.Read())
{
baseconfig = new BaseConfig();
baseconfig.systemName = dr["systemName"].ToString().Trim();
baseconfig.systemVersion = dr["systemVersion"].ToString().Trim();
baseconfig.systemCopyRight = dr["systemCopyRight"].ToString().Trim();
baseconfig.fileServerAddress = dr["fileServerAddress"].ToString().Trim();
}
dr.Close();
conn.Close();
return baseconfig;
}
