private SqlParamInfo[] GetHisServerCfgPars(HisServerCfgData hisServerData)
{
return(new SqlParamInfo[] {
new SqlParamInfo("HIS服务ID", DbType.String, hisServerData.HIS服务ID),
new SqlParamInfo("服务名称", DbType.String, hisServerData.务名称),
new SqlParamInfo("服务配置", DbType.String, hisServerData.务配置.ToString())
});
}
/// <summary>
/// 更新HIS服务配置
/// </summary>
/// <param name="hisServerData"></param>
public void UpdateHisServerCfg(HisServerCfgData hisServerData)
{
string sql = "Update HIS服务配置 " +
" Set 服务名称=:服务名称, 服务配置=:服务配置 where HIS服务ID=:HIS服务ID";
sql = SqlHelper.GetSqlBiz().GetSqlContext("更新HIS服务配置", sql);
SqlParamInfo[] sqlPars = new SqlParamInfo[] { new SqlParamInfo("服务名称", DbType.String, hisServerData.务名称),
new SqlParamInfo("服务配置", DbType.String, hisServerData.务配置.ToString()),
new SqlParamInfo("HIS服务ID", DbType.String, hisServerData.HIS服务ID) };
_dbHelper.ExecuteSQL(sql, sqlPars);
}
/// <summary>
/// 新增HIS服务配置
/// </summary>
/// <param name="hisServerData"></param>
/// <returns></returns>
public bool NewHisServerCfg(HisServerCfgData hisServerData)
{
string sql = "insert into " +
" HIS服务配置(HIS服务ID, 服务名称, 服务配置) " +
" values " +
" (:HIS服务ID,:服务名称,:服务配置)";
sql = SqlHelper.GetSqlBiz().GetSqlContext("插入HIS服务配置", sql);
SqlParamInfo[] sqlPars = GetHisServerCfgPars(hisServerData);
DataTable dtResult = _dbHelper.ExecuteSQL(sql, sqlPars);
return(true);
}