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